Designed for supervisors, managers or team members who need to summarize, report and analyze data, this course will present helpful tools to evaluate investments and financial decisions, ensure accurate data entry by creating a list of values, summarize data using histograms and PivotTables, estimate business variables using trend curves and present the data.

ADVANCED FUNCTIONS

• Name Manager, Naming Ranges and Using them in Formulas
• Formula Auditing
• SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
• INDEX & MATCH Lookup functions

 USING FORMULAS 

• Apply functions in formulas
• Functions Wizard
• Absolute vs Relative Referencing
• Using SUM, COUNT, SUBTOTAL
• Using nested functions
• Using the IF, AND, and OR functions
• Using the VLOOKUP function
• Using the NOW and TODAY functions
• Using text manipulation functions like LEFT, RIGHT, MID, TRIM, CONCATENATE

WHAT-IF

• Scenarios and Scenario management
• Goal Seek

 TREND ANALYSIS

• Using Scatter Charts and Trend Analysis

 ADVANCED DATA ANALYSIS & PRESENTATION

• Using Sparklines
• Create and manage PivotTables
• Filters in PivotTables
• Creating and managing Slicers
• Create and manage PivotCharts
• Manipulating options in existing PivotCharts
• Multiple PivotTables on the same WorkSheet
• Grouping Data to analyse data by Year/Quarter/Month
• Building a BI Dashboard

 AUTOMATING PROCESSES WITH MACROS

• Recording and Running Basic Macros
• Saving Work with Macros