About the program

Foundation

Introduction of MS Excel environment

Basic Navigation and Editing

Orientation & efficiency

Editing

Viewing

Spreadsheet Structure

Cell References

Named Ranges

Design

Administration

Customising Excel

Housekeeping

Connecting Workbooks

Documentation

Protecting and Sharing

Google Docs

Excel Troubleshooting

Data Handling

Sorting and Filtering

Controlling User Input

Working with Dates & Times

Working with Text

Lookup and Reference

Logical Functions

Advanced Techniques

Functions and Superpowers

Array Formulae

Tables

Advanced Range Names

What If?

Problem Solving?

Form Controls

Spreadsheet Impact

Conditional Formatting

Charts that Inspire

Graphics Tricks and Techniques

Working with External Data

Data Analysis

Working with Numbers

Summarising Data

Formula Auditing

Turning Data into Decisions

PivotTables 1 - Simple Summaries

PivotTables 2 - Manipulating Data

PivotTables 3 - Interpreting Data

Advanced Uses of PivotTables

PowerPivot

Reporting with PowerPivot

Macros and VBA

Basic Macros

Visual Basic and Macros

Practical Interactivity with VBA

Presentation

Cell Formatting

Number Formatting

Conditional Formatting

Graphs and Charts

Page and print setup

Contact US

Call us : +1-800-543-5571
Mail us : training@infotek-solutions.com

Share this course

Course curriculum