VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Microsoft Excel: Basic & Intermediate

Course Duration

2 Days

Course Time

9am to 5pm

Course Fee

$285.00

(Group Discount of 10% for 3 or more participants)

Course Dates

15 - 16 Aug 2018
18 & 25 Aug 2018 (Weekend)
10 - 11 Sep 2018
1 - 2 Oct 2018

Course Objective:

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will also be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Training Methodologies

  • Training is hands-on using easy-to-follow step-by-step instructions.
  • Instructor-Led Training (ILT) on live exercises of each topic.

Trainer

Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.
 

 

Course Content

Getting Started with Excel

  • Explore the user interface and the ribbon
  • Navigate and select in Excel
  • Obtain help 
  • Enter Data and Save a workbook

Performing Calculation 

  • Create Basic Formulas 
  • Calculate with function 
  • Commonly used Function
  • Copy formula and function 
  • Auto fill 

Modifying a Worksheet 

  • Inserting, Renaming, Deleting, Hiding Worksheet
  • Inserting, Renaming, Deleting Rows and Columns
  • Moving and copying Worksheet 
  • Moving and copying Data’s 

Formatting a Worksheet (Appearance of Worksheet)

  • Modify Fonts
  • Add borders and colors cells
  • Change column width and row height 
  • Apply number formats 
  • Varying Decimal in Number Formats 
  • Cell Styles 
  • Find and Replace text and numbers on a worksheet 

Managing a Workbook 

  • Inserting Header and Footer 
  • Freeze, split options 
  • Arrange the windows 
  • Using Sorting, Custom AutoFill Lists

Printing Workbooks

  • Printing Workbook 
  • Set Page break
  • Print Area 

Calculating Data with Advanced Formulas

  • Using Range Names 
  • Creating & Define Range Names
  • Using Range Names in Formulas 
  • Consolidating data 
  • Using Text and Date Functions 
  • Using Logical Functions 
  • Using the Vlookup and Hlookup Functions 

Organizing Worksheet and Table Data

  • Format Tables 
  • Modify Tables 
  • Create a Data List in Excel 
  • Learn more about filtering 
  • Common filter 
  • Clear a filter 

Presenting Data Using Charts

  • Types of Charts 
  • Creating Charts and Modifying Charts

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list