The Microsoft Advanced Excel Certification course empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, and pivot tables.

Also, data linking, data consolidation, outlining and summarizing are covered along with PivotTables, Lookup Functions and some key automation features such as macros. Participants can learn how to import and export data, create Data Tables and Scenarios for What If analysis, techniques to validate data, and create form controls like List and Combo Boxes to make data entry easier. 

• Professionals, Data Analysts, Business Analysts, Managers, Supervisors, Staff of any department who handle large data and make decisions or support decision making.

• Automating common tasks
• Colloborating, Merging and Tracking workbooks
• Analyzing data using advanced techniques
• Summarizing data using powerful excel tools
• Creating Power views
• Protecting the worksheets from unauthorized changes
• Leverage continued after-course support with one-on-one instructor coaching

• Proficiently navigating & manipulating worksheets and workbooks.
• Implement advanced and complicated formulas and functions
• Design a reusable data entry template that protects formulas.
• Linking the workbook to various files and other workbooks and sheets
• Connect, prepare, and validate data employing editing tools, formulas, and Flash Fill.
• Identify, sort, and select detailed data with tables and slicers.
• Visualizing and interpreting the data through Charts and Sparklines
• Present and analyze data with conditional formatting and printing parameters.
• Construct IF functions that make decisions - present results visually.
• Combine data with 3-D formulas.
• Analyze summary data with PivotTables and implement a quick dashboard.
• Searching and using the data through lookups