LESSONS – SAGE EXCEL ON STEROIDS

Sage Excel On Steroids

LESSON STRUCTURE

Lesson 01 - Workshop: Data Analysis

Tell Me Text Box

Smart Lookup

Data Validation

What-If Data Analysis

Forecast Sheet

Makros

Lesson 02 - Workshop: Formulas & Functions

Data Consolidation

Conditional Formatting Worksheet Protection

Managing and Preparing Data

Using Cell References

Lookup, Text and Logical Functions

Statistical and Mathematical Functions

Date and Time Functions

Lesson 03 - Workshop: PivotTables and PivotCharts

PivotTable Basics

PivotTable Options

Formatting a PivotTable

Calculated Items and Fields

Sort & Filter a PivotTable

Consolidated PivotTable

PivotCharts and Sparklines

3D Maps

What you will cover - Lesson Outline Excel On Steroids PLUS

Design meaningful Dashboard Reports catering to your audience’s requirements and goals following Dashboard design best practice.

Create dynamic data models which will serve as the back-end of your Dashboard using advanced functions and formula.

Create PivotTables and PivotCharts.

Explore alternative visualisation techniques like sparklines and conditional formatting for at-a-glance analysis.

Create advanced and custom charts.

Create an interactive, macro-charged Dashboard.

s2Member®