Description
Microsoft Excel Course: Level 1 & 2 – Introduction & Intermediate Classes
Classes are available every Monday, Wednesday and Saturdays.
3 full day classes or 6 half days
Class Times: 9:00 am to 5:30 pm -or- 9:00 am to 1 pm -or- 1:30 pm to 5:30 pm
Break: 11:50 am for 20 minutes
Lunch: 1:00 pm to 1:30 pm
Break: 3:30 pm to 20 minutes
Syllabus
Level 1 – Introduction
Creating Worksheets
Moving Around in a Worksheet using shortcut keys
Aligning Data in the Worksheet
Erase Part of Worksheet
Entering Formulas in the Cells
Addition, Subtraction, Multiplication And Division
Automatic Summation
Center Across Many Columns
Borders And Shading
Gridlines
Making Changes In The Worksheet
Changing Column Width
Inserting & Deleting Rows & Columns
Moving & Copying Ranges
Copying Formulas
Formatting numbers for commas, dollar sign, decimal places, etc.
Fonts
Headers and Footers
Freezing And Un-Freezing Headings
Margins
Landscape and Portrait
Multiple Worksheets
Level 2 – Intermediate
Naming Worksheets
Linking Worksheet Data
Creating Different Types of Charts, Column, Line, Pie and so on.
Labeling Charts, Adding Legends
Formatting Charts
Adding Arrows and Text to a Chart
Embedding a Chart in A Worksheet
Creating and Using Templates
Creating a Database
Sorting and Alphabetizing
Searching a Database
Automatic Record Numbering
Finding Records in a Database
Hiding and Un-Hiding Columns
Create and Run Macros
Edit Macros
Create and Apply Filters