Learn to effectively move and copy data within spreadsheets, write and create basic mathematical formulas, insert standard spreadsheet functions, insert rows and columns into your worksheets, apply number formatting to improve readability, and much more!
Course Content and Lesson Structure:
Lesson 1: Getting Started with Microsoft Excel
- Topic A: Navigate and Explore the Excel User Interface
- Topic B: Use Excel Commands and Menus Effectively
- Topic C: Create and Save a Basic Workbook for Your Data
- Topic D: Enter Data Accurately into Cells
- Topic E: Utilize Excel's Built-In Help System
Lesson 2: Performing Basic and Complex Calculations
- Topic A: Create Worksheet Formulas from Scratch
- Topic B: Insert and Utilize Excel Functions
- Topic C: Reuse and Modify Formulas and Functions Across Your Spreadsheet
Lesson 3: Modifying and Adjusting Your Worksheet
- Topic A: Insert, Delete, and Adjust Individual Cells, Columns, and Rows
- Topic B: Search Across Your Spreadsheet and Replace Data Efficiently
- Topic C: Use Proofing Tools and Research Resources
Lesson 4: Applying Professional Formatting to Your Worksheet
- Topic A: Apply Text Formatting for Better Readability
- Topic B: Apply Number Formats to Suit Your Data Type
- Topic C: Align Cell Contents for Professional Appearance
- Topic D: Apply Styles and Themes to Your Spreadsheet
- Topic E: Apply Conditional Formatting Based on Cell Values
- Topic F: Create and Use Spreadsheet Templates
Lesson 5: Printing and Sharing Your Workbooks
- Topic A: Preview and Print Your Workbook Professionally
- Topic B: Set Up the Page Layout for Printing
- Topic C: Configure Headers and Footers for Your Document
Lesson 6: Managing Multiple Workbooks and Worksheets
- Topic A: Manage Multiple Worksheets within a Workbook
- Topic B: Manage Workbook and Worksheet Views for Efficient Work
- Topic C: Manage Workbook Properties and Metadata
