Microsoft Excel Training

This course is intended for people who need to create and edit spreadsheets using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency.

Course Agenda

• Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets

• Demonstrate an understanding of the principles of spreadsheet

• Definition of a spreadsheet

• Function of a spreadsheet

• Spreadsheet features

• Types of spreadsheet

• Microsoft Excel Window, Features and Use

• Properties of a spreadsheet

• Creating, Opening and saving spreadsheets

• Cells, Values, Calculations, Real time updates

• Data Cells, Formula cells and label cells

• Producing spreadsheets from given specifications

• Formulae

• Excel Conditional Formatting Using Formulae

• Business Plans with Excel

• Personal Budgeting with Excel

• Compiling customer orders and data

• Editing Spreadsheets

• Formating Spreadsheets

• Checking Spelling and Grammer in Excel

• Printing a spreadsheet using features specific to spreadsheets.

• Excel hacks and shortcuts

Pre-requisite

• The user should understand the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and start menu.

Certification

• Delegates who successfully complete this course will recieve a certificate of completion.