Workshop on Microsoft Excel Master-class

Program overview:

Microsoft Excel is a powerful and complex tool with a wide range of features; it is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using less than 10% of the features of this powerful productivity tool, making it is one of the most widely used programs that is currently not used to its full potentials by majority users.

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.

The Microsoft Excel Master-class training is a complete Excel learning road map from foundation to advance. This training is designed to really unlock the power of the Excel program and its advanced functionality.

Note: Participants should bring their laptops along with Excel software installed.

For whom:

The program is designed for everyone, covering beginner, intermediate and advanced lessons in Microsoft Excel.

Learning objectives:

At the end of this course, you will be able to:

• leverage the power spreadsheet from Foundation to Advance level;
• work with Excel to enter and manage data;
• calculate using Excel formulas;
• use collaboration tools effectively;
• analyze data with pivot tables;
• use Logical Functions, Financial and Statistical Functions;
• create Charts, Use What-If Tools · Protect Worksheets & Workbooks;
• use Lookup & Informational Functions;
• use the Analysis ToolPak to make complex data analysis;
• learn how to add power to your spreadsheets with Visual Basic for applications;
• learn Implementing VBA syntax; and
• set up tables, sort data and work with row and column totals.

Course outline:

Microsoft Excel Foundation Level: Day 1

Module 1: Getting Started with Microsoft Office Excel 2016

• Navigate the Microsoft Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

Module 2: Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Module 3: Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data

Module 4: Formatting a Worksheet

• Apply Text Formats, Apply Number Formats
• Align Cell Contents, Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Module 5: Managing Workbooks

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Module 6: Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Microsoft Excel Intermediate Level: Day 2 & 3

Module 1: Working with Lists

• Sort Data, Filter Data
• Outline and Subtotal Data
• Consolidate Data

Module 2:  Advanced Functions

• Work with Logical Functions
• Work with Date & Time Functions

Module 2: Analyzing Data

• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Module 3: Visualizing Data with Charts

• Create Charts
• Modify and Format Charts

Microsoft Excel Advanced Level – Day 4 & 5

Module 1: Ranges & Specialized Functions

• Work with Ranges
• Use Specialized Functions

Module 2: Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References

Module 3: Using Lookup Functions and Formula Auditing

• Use Lookup Functions, Trace Cells
• Watch and Evaluate Formulas

Module 4: Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Module 5: Using PivotTables and Pivot Charts

• Create a PivotTable, Analyze PivotTable Data
• Present Data with Pivot Charts
• Filter Data by Using Timelines and Slicers

Module 6: Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Training Methodology

This is a practical hands-on training using easy-to-follow step-by-step instructions.