MS Office Spreadsheet Application

The 3-module, 4-topic Excel course will assist you with understanding how to approach creating spreadsheets.

Module 1: Getting Started with Excel

1. Understanding the Excel InterfaceOverview of the Ribbon and its components
   Navigating the worksheet and workbook
   Using the Quick Access Toolbar
   

2. Creating and Saving WorkbooksStarting a new workbook
   Saving workbooks in different formats
   Understanding file management in Excel
   

3. Entering and Editing DataInputting text, numbers, and dates
   Editing cell contents
   Using AutoFill for series and patterns
   

4. Basic FormattingApplying number formats
   Changing font styles and cell colors
   Adjusting column widths and row heights
   

Module 2: Working with Data

1. Basic Formulas and FunctionsCreating simple formulas (addition, subtraction, etc.)
   Using basic functions (SUM, AVERAGE, MAX, MIN)
   Understanding relative and absolute cell references
   

2. Sorting and Filtering DataApplying basic sorts to data
   Using AutoFilter to analyze data
   Creating custom filters
   

3. Creating Basic ChartsInserting column, bar, and pie charts
   Modifying chart elements
   Changing chart types
   

4. Working with Multiple WorksheetsAdding, renaming, and deleting worksheets
   Moving and copying worksheets
   Linking data between worksheets
   

Module 3: Enhancing Spreadsheets

1. Conditional FormattingApplying basic conditional formatting rules
   Creating custom conditional formatting
   Using data bars and color scales
   

2. Tables and Named RangesConverting data ranges to tables
   Using structured references in tables
   Creating and using named ranges
   

3. Page Setup and PrintingSetting print area and page breaks
   Adjusting margins and orientation
   Adding headers and footers
   

4. Basic Data AnalysisUsing the Quick Analysis tool
   Creating PivotTables for data summarization
   Applying basic data validation rules