Introduction
What Excel looks like
Starting Excel from the desktop
Understanding the Excel start screen
The Status Bar
The workbook screen
The quick access toolbar
Shortcut menus
Adding commands to the QAT
Launching dialogue boxes
Performing Calculations
Create worksheet formulas
Insert functions
Reuse formulas and functions
Organising Worksheet Data
Apply basic sorting to a data range
Advanced sorting
Summarise data with subtotals
Working with Multiple Worksheets and Workbooks
Use links and external references
Use 3-D references
Consolidate data
Common Math Functions
Sum & average
Future value
Minimum, trigonometry, degrees, & exponentials
Logarithms, radians, square roots
Formatting a Worksheet
Apply text formats and number format
Align cell contents
Apply basic conditional formatting
Apply styles and themes
Create and use templates
Sharing and Protecting Workbooks
Sharing and protecting workbooks
Protect worksheets and workbooks
Working with Functions
Work with ranges
Work with logical functions
Work with text functions
Work with date & time functions
Use specialised functions
Working with Lists
Sort and filter data
Query data with database functions
Outline and subtotal data
Analyzing Data
Create and modify tables
Apply advanced conditional formatting
Apply intermediate conditional formatting
Visualizing Data with Charts
Create charts
Modify and format charts
Use advanced chart features
Using Data Tables, Slicers and Functions
Data tables and slicers
Analysis with Excel functions and data validation
Working with PivotTables
Introduction of PivotTables
Creating PivotTables from a list or a single table
Creating PivotTables using workbook relationships
Filtering, grouping and summarising data in a PivotTable
Creating PivotTables with external data model connections
Using sets, calculated fields and calculated items
Slicers and timelines in PivotTables
Power View Reports
Creating power view reports
Using tables, cards and matrices
Charting in power view reports
Mapping geo-data
Power view options
Large Data Functions
Correlate, count, GCD
If, Info, LCM, Median
Mode, slope, standard deviation
Random numbers, rounding up & down
Matrix Math Operations
Matrix math & complex calculations
PivotCharts
Create PivotCharts
Creating decoupled PivotCharts
Shaping and filtering the data using PivotCharts
Enquire Now 