Course Content

2 Days Microsoft Excel Training

This 2 Days Microsoft Excel Training aims to provide skills and knowledge from Microsoft Excel software which will allow the participant to increase the efficiency and also simplify your daily task.

In this training the participants will learn Excel extensively on the functions, formulas and advance features of Microsoft Excel.

2 Days Course Basic to Advanced

You can either choose 2 days course or choose 1 day only for basic or advanced course. But we recommend you to take the 2 days course as you’ll learn all of the basic and advanced items of Excel which you might’ve missed out.

Day 1 - Basic

This lesson is designed for the beginner to intermediate but if you're looking to freshen up on your skills, come on in!

Day 2 - Advanced

This lesson is suitable for users with a basic knowledge of Excel and wish to cover the advanced topics in Excel.

Done!

You will learn all the basic to advance excel skills, which will enable you to use Excel expertly within in a personal or commercial environment.

Day 1 (Basic)

  • Topic A: Using the menus
  • Topic B: Versions
  • Topic A: Formula Bar
  • Topic B: Working with dates and times
  • Topic C: Format Cells/ Data Formatting
  • Topic D: Flash Fill Series
  • Topic A: AutoSum/Average
  • Topic B: Days Formula
  • Topic C: Formula Wizard
  • Topic D: Audit Formulas (Trace precedent/dependent)
  • Topic A: Inserting shapes, arrows, and other graphics
  • Topic B: Adding and deleting rows and columns
  • Topic C: Hiding data
  • Topic D: Moving, copying, and pasting
  • Topic E: Sorting and filtering data
  • Topic F: Conditional Formatting / Data Bars / Data Icon Sets
  • Topic A: Clipping Screens
  • Topic B: Images/ Shapes
  • Topic C: Recommended Charts
  • Topic D: Linking Charts in PowerPoint
  • Topic E: Advanced Charts / Combo Charts
  • Topic A: Print Area
  • Topic B: Repeat Titles on print
  • Topic C: Page Layout / Page Break
  • Topic A: Allow people to edit selected cells only (Creating Forms)
  • Topic B: Protecting Worksheet & Workbook (Read Only)
  • Topic C: Workbook Encryption (Password to open)

Day 2 (Advanced)

  • Topic A: IF Function
  • Topic B: 3D Formulas
  • Topic C: CHOOSE/MATCH/INDEX
  • Topic D: VLookup / H Lookup
  • Topic A: Create your own names
  • Topic B: Define Names in formulas and references
  • Topic A: Using PivotTables and Filters
  • Topic B: PivotCharts
  • Topic C: Creating extended charts / business charts
  • Topic D: Gantt Charts
  • Topic A: PMT Formula (Loan Calculator)
  • Topic B: Goal Seek
  • Topic A: Create various scenarios
  • Topic B: Using Scenarios
  • Topic A: Record repeated tasks with Macro
  • Topic B: Add new buttons to your Excel to playback Macros
  • Topic C: VBA and Macro
  • Microsoft Office Specialist (77-420) Overview

Accreditations

Get A Quote Now / Request Brochure

Please fill out the inquiry form for official quotes and brochures. Check out our FAQ section.