Basic Excel Course

Basic Excel Course helps participants get a deeper understanding of the functions and features available.  It also elevates the participants’ Excel skills to a different level. This course is by professionals for professionals looking to improve their knowledge and hands-on practical applications of Microsoft Excel in the workplace.

Excel is a powerful application that can help in generating reports. This is exactly why we offer this training. To ensure that individuals are aware of the basics of Excel to help do tasks quickly and efficiently.  It will also help you understand how much you can do with Excel. Additionally, it will increase the effectiveness of the reports and presentations that you use Excel to prepare.

More often than not, you invest a great deal of effort into sorting out all your workbook data and calculations. It would 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 important decisions.

Course Objective

Microsoft Excel 2010/2013/2016 Basic Course:

At the end of this 1-day course participants are expected to 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 unhiding data
• Inserting and modifying images

Modules

To achieve these objectives, Advanced Learning Programs (ALPs) will use the below Lesson Plan:

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