Microsoft Excel Training Course

Microsoft Excel Training Course For Beginners

Call Now

Enroll Now

Email Us

Microsoft Excel Training Course For Beginners Summary

Join us for a 16 hours Instructor-led Microsoft Excel training course to be taught over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.

  • All Published Ticket Prices are in US Dollars
  • The course will be taught in English language

Microsoft Excel Training Course For Beginners Schedule

Please choose from one of the dates in the table below to begin your enrollment :

Dates Weekly Schedule (US Pacific Time)* Price Add to Cart
Dec 6 to Dec 29 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Dec 7 to Dec 30 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Jan 8 to Jan 30 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Jan 10 to Feb 2 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Jan 11 to Feb 3 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Feb 5 to Feb 27 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Feb 7 to Mar 2 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Feb 8 to Mar 3 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Mar 14 to Apr 6 Mon/Wed 6:30 PM - 8:30 PM each day $394.00 Add to cart
Mar 15 to Apr 7 Tue/Thu 8:30 AM - 10:30 AM each day $394.00 Add to cart
Mar 19 to Apr 10 Wed/Sun 8:30 AM - 10:30 AM each day $394.00 Add to cart
*click on date/time hyperlink to add your location and find local date/time for first session
Dates and Weekly Schedule (US Pacific Time)* Price
Dec 6 to Dec 29
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Dec 7 to Dec 30
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Jan 8 to Jan 30
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Jan 10 to Feb 2
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Jan 11 to Feb 3
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Feb 5 to Feb 27
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Feb 7 to Mar 2
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Feb 8 to Mar 3
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Mar 14 to Apr 6
Mon/Wed 6:30 PM - 8:30 PM each day
$394.00
Enroll
Mar 15 to Apr 7
Tue/Thu 8:30 AM - 10:30 AM each day
$394.00
Enroll
Mar 19 to Apr 10
Wed/Sun 8:30 AM - 10:30 AM each day
$394.00
Enroll
*click on date/time hyperlink to add your location and find local date/time for first session

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

2. Basic Excel (Contd.)

  • Text to columns
  • Auto-filter

3. 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

4. Intermediate Excel (Contd.)

  • Formatting in-cell graphs(conditional format)
  • Data validation
  • Custom Data Validation

5. 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

Refund Policy

  • 100% refund can be applied if request is initiated 24 hours before the 1st course session.
  • If a class is rescheduled/cancelled by the organizer, registered students will be offered a credit towards any future course or a 100% refund