Learn Advance Excel- Instructor Led online Training.

Learn Advance Excel in weekday/weekend online classes.

Duration - 14 Hours.

Advance Excel training in Excel 2019

Assignments will be given for practice.

Excel notes will be given for reference.

Advance Excel Course Outline

 Excel Essentials

• Navigating Workbooks and Worksheets
• Setting up Excel for Easy and Speedy Navigation
• Entering and Formatting Data Using Advanced Excel Features
• Cut, Copy, Paste, and Paste Special
• Data Validation
• Conditional Formatting

Cell and Column Calculations

• Math Functions
• Statistical Function Review
• Logical Functions and Operations
• Absolute vs. Relative References
• Naming Cells and Ranges for More Robust Referencing
• Error Handling with IFERROR

String and Date Manipulation

• String Joining and Manipulation
• Date and Time Functions
• Lookups Functions to Cross Reference Data: VLOOKUP, HLOOKUP, MATCH, INDEX
• Formatting Functions

Excel Charts, Protection & Advance Filtering.

• Create a Pie chart Bar chart,
• Create a Column chart & Line Charts.
• Formatting Charts.
• Protecting a sheet.
• Protecting a work book with password.
• Excel file Backup.
• Filtering
• Advance Filtering.

 PivotTable and PivotChart Techniques

• Understanding What Data is Relevant for a Pivot
• Learning How to Use Row, Column, and Data Fields Effectively
• Presenting the Data in the Most Efficient and Effective Way
• Pivot Table and Pivot Chart Review
• Multiple Pivots on the Same Data
• Connecting to Databases from Excel
• Writing a SQL Query
• Pulling SQL Data into Pivot Tables
• Refreshing the Data
• Handling Empty Cells
• Filtering Data and Using Slicer
• Formatting Tables and Charts for Printing.