4 Weekends Advanced Microsoft Excel training is a 4 weekends long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per weekend, 2 hours per session.

• The medium of instruction is English.
• All Published Ticket Prices are in US Dollars.

4 Weekends Advanced Microsoft Excel Training Schedule

• May 23, 2020 - June 14, 2020 US Pacific time
• 4 Weekends | 2 hours on Saturdays, 2 hours on Sundays every week | US Pacific Time
• 8:30 AM - 10:30 AM US Pacific time each of those days
• Please click here to add your location and find your local date and time for the 1st session to be held on May 23, 2020 at 8:30 AM US Pacific Time.

Features and Benefits

• 4 weeks, 8 sessions, 16 hours of total Instructor-led and guided training
• Training material, instructor handouts and access to useful resources on the cloud provided
• Practical Hands-on Lab exercises provided
• Actual code and scripts provided
• Real-life Scenarios

What you will learn?

• Basic Excel
• Intermediate Excel
• Advanced Excel

Who should attend

• Anyone who is interested in learning Advanced Microsoft Excel.
• Accountants

Course Outline

1. Basic Excel

• Introduction

• Basic Calculations

• Microsoft Office Button

• Using worksheets effectively

• Formatting text and numbers

• Saving Excel 2007 files

• Saving an Excel file as a PDF file

• Inbuilt Functions

• Sort Function

• More on sort data

• Formatting data as tables

• Absolute and relative cell reference

• Page layout and print preview

• Printing: display grid lines

• Conditional Formatting

• Charts

• Text to columns

• Auto-filter

2. Intermediate Excel

• Library functions use

• How to avoid auto hyperlinks

• Fill data across worksheets

• How to use comments

• How to remove duplicates

• Template based workbook

• Themes and smartart diagrams

• ‘IF’ function

• Countif

• Nested IF functions

• Advanced filter

• Named ranges

• Subtotals

• Formatting in-cell graphs(conditional format)

• Data validation

• Custom Data Validation

3. Advanced Excel

• Pivot Tables

• Vlookup/Hlookup

• Absolute range calculations

• Goal Seek

• Get external data – text files

• Import data from databases

• Import data from an Excel file

• Array Formulas

• Calculations in Word

• Data tables and sensitivity analysis

• Printing: Repeat specific rows

• Excel Help – Vlookup