Excel Advanced – Full Course

1. Database

Advanced Excel Outline

Lesson #1

Insert live Date Function

Format Live Date

Type Multiple Lines in one cell

Use Fill Handle

Change Row Height & Column Width

Rotate Text

Use Conditional Formatting

Use Statistical Function

Use Financial Function

Introduce Range

Use IF Function

Lesson #2

Use Future Value function

Entering Formulas

Create Payroll

Change Page Layout

Format Worksheet

Calculate Percentage

Calculate pay Rate

Use Auto Sum

Use Format Painter

Use IF Function

Lesson #3

Copy formulas

Relative Cell Addressing

Absolute Cell Addressing

Move Worksheet

Insert Worksheet

Rename Worksheet

Create Multiple Employee Payroll

Use Formulas to Reference Other Sheets

Lesson #4

Introduce Database

Create Table

Convert Existing Spreadsheet to Database

Create Database from scratch

Sort Data in a table

Filter Data in a Table

Introduce Data Entry form

Create New Tab for Data Entry

Use Data Entry Form

Introduce VLOOKUP

Use VLOOKUP to Query Database

Lesson #5
Introduce Pivot Tables

Create Pivot Tables

Duplicate Worksheets

Introduce Pivot Chats

Create Pivot Charts

Format Pivot Charts

Answer Questions about Data

Filter Data

Summarize Data

Sort Data

Introduce Dashboard

Use Dashboard