Microsoft Excel – Advanced Excel Formulas & Functions

Microsoft Excel – Advanced Excel Formulas & Functions

This course will give you a deep understanding of the advanced formulas and functions that transform Microsoft Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, we teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. We will not train you to regurgitate functions and formula syntax; We will teach you how to THINK like Excel.

We’ll dive into a broad range of Microsoft Excel formulas & functions, including

Lookup/Reference functions
Statistical functions
Formula based formatting
Date & Time functions
Logical operators
Array formulas
Text functions
Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML

Advanced Excel Course

Course Content

Module-I – Excel Foundation

Getting Started with Excel
Data Entry, Data Editing, and Number Formatting
Data Formatting
Working with Cells and Ranges in Excel
Managing Worksheets
Using Sub-Total
Save Your Worksheets

Flexible Class Options

• Weekend Classes For Professionals  SAT | SUN
• Corporate Group Training Available
• Online Classes – Live Virtual Class (L.V.C), Online Training