FORGOT YOUR DETAILS?

CREATE ACCOUNT

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

Course Content - Day 1 (Basic)

Lesson 1: Introduction

  • Topic A: Using the menus
  • Topic B: Versions

Lesson 2: Data Entry

  • Topic A: Formula Bar
  • Topic B: Working with dates and times
  • Topic C: Format Cells/ Data Formatting
  • Topic D: Flash Fill Series

Lesson 3: Creating formulas

  • Topic A: AutoSum/Average
  • Topic B: Days Formula
  • Topic C: Formula Wizard
  • Topic D: Audit Formulas (Trace precedent/dependent)

Lesson 4: Formatting

  • 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

Lesson 5: Inserts

  • Topic A: Clipping Screens
  • Topic B: Images/ Shapes
  • Topic C: Recommended Charts
  • Topic D: Linking Charts in PowerPoint
  • Topic E: Advanced Charts / Combo Charts

Lesson 6: Print

  • Topic A: Print Area
  • Topic B: Repeat Titles on print
  • Topic C: Page Layout / Page Break

Lesson 7: Security

  • 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)

Course Content - Day 2 (Advanced)

Lesson 1: Formulas in Depth

  • Topic A: IF Function
  • Topic B: 3D Formulas
  • Topic C: CHOOSE/MATCH/INDEX
  • Topic D: VLookup / H Lookup

Lesson 2: Define Names

  • Topic A: Create your own names
  • Topic 2: Define Names in formulas and references

Lesson 3: PivotTables

  • Topic A: Using PivotTables and Filters
  • Topic B: PivotCharts
  • Topic C: Creating extended charts / business charts
  • Topic D: Gantt Charts

Lesson 4: Goal Seek

  • Topic A: PMT Formula (Loan Calculator)
  • Topic B: Goal Seek

Lesson 5: Scenario Manager

  • Topic A: Create various scenarios
  • Topic B: Using Scenarios

Lesson 6: Macro, Record and Play

  • Topic A: Record repeated tasks with Macro
  • Topic B: Add new buttons to your Excel to playback Macros
  • Topic C: VBA and Macro

Lesson 7: Microsoft Office Specialist (77-420) Overview

Microsoft Excel Training Brochure

TOP