Learn Advance Excel for Corporate Employees in Instructor led Online Training in 8 hours.

Learn Advance Excel online in weekday/weekend batches.

Duration - 8 hours

Assignment will be given for practice.

String and Date Manipulation

• String Joining and Manipulation
• Date and Time Functions
• Lookups Functions to Cross Reference Data: VLOOKUP, HLOOKUP, MATCH, INDEX
• Formatting Functions

Excel Charts, Protection & Advance Filtering.

• Create a Pie chart Bar chart,
• Create a Column chart & Line Charts.
• Formatting Charts.
• Protecting a sheet.
• Protecting a work book with password.
• Excel file Backup.
• Filtering
• Advance Filtering.

What is Excel,

Protecting a Sheet

Password Protection for Workbook

Goal seek

Filtering

Advance Filtering

Important Functions

Excel Essentials

• Navigating Workbooks and Worksheets
• Setting up Excel for Easy and Speedy Navigation
• Entering and Formatting Data Using Advanced Excel Features
• Cut, Copy, Paste, and Paste Special
• Data Validation
• Conditional Formatting

Cell and Column Calculations

• Math Functions
• Statistical Function Review
• Logical Functions and Operations
• Absolute vs. Relative References
• Naming Cells and Ranges for More Robust Referencing
• Error Handling with IFERROR