Microsoft Excel Basics
This course was developed for the beginning, or infrequent, user of Microsoft Excel who wants to get a better handle on how to perform basic formatting, calculation, and data sorting functions in one of the most powerful programs on the market.
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 Curriculum
Session 1: Understanding the Basics, February 4, 10 am to 12 pm PT
• 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, 10 am to 12 pm PT
• 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, 10 am to 12 pm PT
• 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, 10 am to 12 pm PT
• Controlling Page Layouts
• Inserting Images and Symbols
• Creating Simple Charts
• Editing Chart Display Options
• Working with Pivot Tables
