Excel Advanced

Course length: 1 days (8 hours)

Overview: This course rounds out the Excel training with emphasis on more advanced functions and formulas, as well as charts and graphs, and pictures and shapes.

Prerequisites: Introductory and Intermediate classes or equivalent experience.

Training Module:

Working with Advanced Excel Formulas and Functions

Conditional Formatting

Securing Your Work Before Sharing It with Others

Creating Data Visualization using Excel Charts

Formatting a Chart with a Quick Style

Inserting Pictures

Adding Shapes

Adding Graphic Enhancements Using Picture Tools

Creating Opportunities for Management to take business decision using Reports and

Dashboards

Working with Name Manager

Data Validation

Advanced Data Validation with Examples

Pivot Tables and Pivot Charts

Formula Auditing

Using Interactive Controls

If you would like to register for a course, call (+91) 97406 17202 or you may register online.