Shafi Institute

Overview

This course is designed for learners with some experience using Microsoft Windows who want to enhance their presentation skills with Microsoft Excel. To succeed in this course, you should understand the basics of using a Windows-based computer. While experience with printing and using a web browser is beneficial, it is not required. Proficiency in Microsoft Office products is essential in any professional environment. Whether you aim to expand your expertise for a new role, start your own business, or simply develop a new personal skill, this course is for you. You will be introduced to Microsoft Excel, a powerful and user-friendly spreadsheet program equipped with tools for organizing, analyzing, presenting, and storing data. If you are already familiar with Excel’s basic features, you can elevate your skills. Beginners will have the opportunity to develop fundamental Excel skills.

Curriculam

In this course, you'll begin with Microsoft Excel basics, understanding its interface, features, and creating workbooks. You'll learn to modify, format, and prepare data for printing. Next, you'll delve into core Excel functions and formulas, sorting, filtering, and defining data sets with range names, along with specialized text and logical functions. You'll then explore organizing and visualizing data using tables, charts, and pivot tables, and manage large workbooks. Advanced features include customizing formulas, conditional formatting, and automating workbooks. Finally, you'll complete a hands-on project to apply your skills in analyzing and presenting sales data, including reviewing and commenting on the work.