Basic Excel Course

Basic Excel Course

Course Description

Basic Excel Training Course helps participants understand the commands and functions available. Participants will learn the basics while understanding the powerful tool that Excel offers. This course is by professionals for professionals looking to gain their knowledge and hands-on practical applications of Microsoft Excel in the workplace.

Excel is a powerful application that can help generate reports, computations, create tables, and others. Our facilitators will help you understand and learn Excel by applying easy to comprehend but practical exercises.

More often than not, you invest a great deal of effort into sorting out all your workbook data and calculations. It will be a real shame if some, or all, of this effort is wasted because the end product that you rely on or present to others isn’t as effective as it could be and doesn’t make the required impact. Some of Excel’s most powerful but least obvious features can help you turn an unremarkable set of figures into a graphical presentation that provides real insight and drives essential decisions.

Course Objectives

At the end of this one day course, participants will learn the following:

• Running Microsoft Excel
• Define Excel Components
• Using Worksheets
• Saving, Closing and Opening Worksheets
• Entering Values
• Using Autofill
• Using Formulas for Computations
• Adding Images
• Saving a Worksheet as a PDF file
• Adding Data and Computations
• Absolute References
• Insert and Delete Ranges
• Using Common Features in Computations
• Formatting
• Conditional Formatting
• Pagination
• Hiding and Unhinding Data
• Inserting and Modifying Data

Course Modules

Lesson 1 – Introduction

• Introduction
• Class Expectations
• Class Structure

Lesson 2 – Getting Started

• Worksheet Defined
• The Excel Screen
• Getting Help
• Worksheet Navigation

Lesson 3 – Entering and Editing Data

• Entering and Editing Values
• Entering and Editing Formulas
• Working with Images
• Saving and Updating Workbooks

Lesson 4 – Modifying a Worksheet

• Moving and Copying Data
• Moving and Copying Formulas
• Formulas: Absolute and Relative
• Inserting and Deleting Ranges.

Lesson 5 – Using Basic Formulas

• Entering Formulas
• Sum Formula
• Other Common Formulas

Lesson 6 – Using Formatting

• Text Formatting
• Row and Column Formatting
• Number Formatting
• Conditional Formatting
• Additional Formatting Options

Lesson 7 – Printing

• Preparing to Print
• Page Setup Options
• Printing Worksheets

Lesson 8 – Charts

• Chart Basics
• Formatting Charts

Lesson 9 – Managing Workbooks

• Viewing Worksheets
• Printing Worksheets
• Working with Multiple Worksheets

Lesson 10 – Graphics and Images

• Conditional Formatting
• SmartArt
• Images