Excel Data Analysis

Excel Data Analysis Training focuses on the advance features of working with spreadsheets, using advance tabular functions, pivot analysis and dealing with Macros.

Excel Data Analysis corporate training and certification oriented remote program aims to upskill you with Lookup functions, Data Analysis, Pivot Tables, Macros.

Course Content:

• Introduction
• MS Excel Basic Features Overveiw
• Look Up values in Spreadsheets
• Organizing Data in a Worksheet
• Using Filters and Advance Functions
• Using Data Validation
• Working with Formulas
• Analyzing Data with Functions
• Statistical functions to aid analysis
• Basic financial functions
• Serial dates vs date presentations
• Calculating the number of working days
• Controlling calculations and nested formulas
• Data variations with the IF function
• Calculations with referencing
• Using Nested functions
• Using Lookup functions
• Troubleshooting nested calculations
• Using "What-If" Analysis
• Variables in worksheets
• Comparing various data sets
• Quantifying variables
• Goal Seek Feature
• Calculating the optimum variable values 
• Dealing with Multiple Workbooks and Links
• Consolidating Ranges
• Distilling Data Sets for Data Analysis
• Intrepreting Data with Pivot Tables
• Data Summaries
• Grouping and Aggregation
• Comparing Totals 
• Report Filters and Slicers
• Visualizing Data with Pivot Reports
• Using Pivot Table reports
• Using Pivot Charts
• Data patterns with Sparklines
• Using Power Pivots
• Presenting with Power View
• Macros for Repetitive Functions
• Simplifying complex tasks 
• Reducing errors
• Bulletproofing routine editing and formatting
• Invoking macros with Form controls
• Hands-On Exercises
• Prog360 Assessment
• Prog360 Certification