# 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!

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

TOP