Description

Microsoft Excel is the most useful, and most often misunderstood, program in the Office Suite. Many of us shy away because it seems so complex and overwhelming, but learning the tools that will help get your daily work done is simple . . . if you have the right instructor. 

This is a beginner-level course.

Course Objectives

Session 1: Understanding the Basics, February 4, 9 am to 11 am (AKT)  

• Understanding and Creating Worksheets • Working with Multiple Worksheets
• Understanding Cells and Columns • Formatting and Aligning Cells
• Understanding and Editing Data Types
• How to Format, Merge, and Control Cells 

Session 2: Fun with Functions and Formulas, February 11, 9 am to 11 am (AKT) 

• Controlling Worksheet Views
• Using Automatic Fill Features
• Understanding Formulas and the Formula Bar
• Using Common Functions and Formulas
• Using Formulas across Worksheets 

Session 3: Delving into Data, February 18, 9 am to 11 am (AKT)  

• Working with Data Filters
• Understanding Data Sorting
• Removing Duplicate Values
• How to merge and Split Data Cells
• Adding Data Validation 

Session 4: Summarizing Simplified, February 25, 9 am to 11 am (AKT) 

• Controlling Page Layouts
• Inserting Images and Symbols
• Creating Simple Charts
• Editing Chart Display Options
• Working with Pivot Tables