Self-Paced, Live Online, Classroom Enterprise Training
The aim of this course is to equip learners with an extensive comprehension of the sophisticated Excel concepts, formulas, and functions. This will enable them to view Excel not just as a simple spreadsheet, but as a potent analytical tool.
inperson:
3 days
online:
18 hours
Certified Corporate Trainer
Lifetime Access
Quiz & Assignments
24x7 Support
Real Time Projects
Cost Effective Programs
Objective
Upon completion of the Advanced Excel training, you will possess the following abilities:
Articulate the definitions of Excel functions
Elucidate charts
Clarify Pivot Tables
Target Audience
Individuals possessing fundamental Excel skills
Prerequisites
Fundamental Excel proficiencies.
Detailed Outline
Chapter 1: Formatting Techniques
Using formatting tools
Advanced conditional formatting
The format painter
Hiding and displaying cells
Chapter 2: Analyzing Data
Applying conditional formatting
Sorting data in a spreadsheet
Filtering data in a spreadsheet
Applying a formula
Data validation
Goal seek
Chapter 3: Working with Charts
Why are charts used?
Types of charts
Steps to create charts
Design tab and customizing charts
Organizational charts
Sparkline
Advanced charts
Chapter 4: Functions
Date and time function
Logic functions
VLOOKUP
HLOOKUP
MATCH function
INDEX function
OFFSET function
XLOOKUP function
Chapter 5: Data Validation, What-If Analysis, and Workbook Security
What is data validation?
Steps to set data validation in Excel
What-If analysis
Goal seek
Workbook security
Chapter 6: A First Look at Pivot Tables
Define pivot table
Steps to create a pivot table
Steps to sort and group a pivot table
Slicers
Calculated fields and item
Pivot charts
Chapter 7: Power Query, Power Pivot, and DAX
Define Power Pivot
Define Power Query
Data model
Data transformation using Power Query
Analyzing data using Power Pivot
DAX
Chapter 8: Introduction to Excel Macros
Excel macros
Use of macros
VBA in layman's language
Macros basics
Steps to record macros in Excel
Related Courses
Do you want to learn more about this training?
Edustreak
Edustreak is one of the fastest growing professionally managed company in Technology, Learning & Consulting. The core team comprises of highly qualified and skilled professionals with global exposure in diverse areas. We offer high quality, cost-effective professional training with delivery par excellence in cutting edge technologies.
