Microsoft Excel Masterclass

Microsoft Excel Masterclass training is designed for those delegates who desire to understand about the ins and outs of Excel to increase productivity and enhance their skills. Microsoft Excel is a powerful application which makes calculating, displaying, and sharing data easier. Microsoft Excel Masterclass training provides a complete understanding of beginners to advanced level of Excel.  At the end of the training, the delegates will be able to understand how to create and modify spreadsheet, and maintain their records effectively.

Microsoft Excel Masterclass training provides a complete understanding of how to create spreadsheets and workbooks. With the help of this training, the delegates will able to understand the basics as well as advanced features of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs. The training course will introduce the delegates to some of Excel's more powerful features. Throughout the training, the delegates will able to understand how to use advanced functions and calculations in spreadsheet and workbooks.

Overview of Microsoft Office Excel

• Introduction to Microsoft Excel
• Navigate the Excel User Interface
• Use Excel Commands
• Enter Cell Data
• Use Excel Help

Performing Calculations

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

Formatting a Worksheet

• Apply Text Formats and Number Formats
• Align Cell Contents
• Apply Themes and Styles
• How to create and Use Templates
• How to apply basic conditional formatting

Modifying a Worksheet

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

Printing Workbooks

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

Managing Workbooks

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

Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Working with Functions

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Analyzing Data

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

Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

Working with Multiple Worksheets and Workbooks

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

Using Lookup Functions and Formula Auditing

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

Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Automating Workbook Functionality

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