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

Download the course PDF now!

Download Course PDF

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.