Microsoft Office Excel

Microsoft Office Excel Beginner

Pre-requisites: None

Microsoft Office Excel - Beginner Objectives:

• Overview of the Program
• Start a new workbook
• Adding information to a worksheet and adding new worksheets
• Adding and Deleting Rows
• Use Auto-Sum feature
• Create a Chart
• Add Illustrations
• Sort & Filter
• Add Header & Footers
• Hyperlink a content
• Save, Print and Close Workbook

Microsoft Office Excel Advanced

Pre-requisites: None

Microsoft Office Excel - Advanced Objectives:

• Format Tables
• Get External Data
• Adding controls
• Protect Worksheet
• Add and Delete Comments
• Familiarize with Excel Formulas.For example, SUM, AVERAGE, PMT, IF, VLOOKUP, HLOOKUP