Create, organize, and leverage data across all contexts, from personal finance and household budgets to professional scheduling and business analytics. The foundational Level 1 class equips you with essential tools for creating, modifying, and managing spreadsheets and workbooks while performing fundamental mathematical operations. This course uses Excel 2019 as the instructional platform but remains current with multi-version installations and Office 365 subscribers.
Prerequisite Knowledge: Basic familiarity with Windows operating systems and fundamental computer skills
Program Overview: Microsoft Excel serves as a powerful platform for organizing, calculating, analyzing, updating, refining, and presenting organizational data. Excel dramatically streamlines these critical tasks and reduces the time investment required. This course establishes the foundational Excel competencies and capabilities necessary to begin leveraging this powerful tool for data management and analysis.
Program Goals: Successfully completing this course enables you to confidently create and develop comprehensive Excel worksheets and workbooks to manage, organize, and analyze the crucial data that drives organizational success and decision-making.
Intended Audience: This course serves professionals seeking fundamental proficiency with Microsoft Office Excel 2019, equipping them to create and manage electronic spreadsheets for professional and personal purposes.
Upon Completion You Will; Begin working effectively with Microsoft Office Excel. Execute mathematical calculations. Modify and restructure worksheet content. Apply professional formatting to worksheets. Prepare and print workbook output. Organize and manage multiple workbooks.
Complete Course Content
Lesson 1: Getting Started with Microsoft Office Excel 2019
Topic A: Master the Excel User Interface Navigation
Topic B: Use Excel Commands and Features
Topic C: Create and Save Workbooks
Topic D: Add and Input Cell Data
Topic E: Use Excel Help and Support
Lesson 2: Performing Calculations
Topic A: Build and Create Worksheet Formulas
Topic B: Add and Use Functions
Topic C: Copy and Reuse Formulas
Lesson 3: Modifying a Worksheet
Topic A: Add, Remove, and Resize Cells, Columns, and Rows
Topic B: Search, Find, and Replace Data
Topic C: Use Proofreading and Research Resources
Lesson 4: Formatting a Worksheet
Topic A: Apply Text and Font Formatting
Topic B: Apply Number and Data Formatting
Topic C: Position and Align Cell Contents
Topic D: Use Styles and Apply Themes
Topic E: Use Conditional Formatting for Data Highlighting
Topic F: Create and Apply Custom Templates
Lesson 5; Printing Workbooks
Topic A: Preview Workbooks and Configure Print Settings
Topic B: Configure Page Setup and Layout Options
Topic C: Create and Edit Headers and Footers
Lesson 6; Managing Workbooks
Topic A: Create and Manage Worksheet Tabs
Topic B: Manage Workbook Display Options and Worksheet Views
Topic C: Edit and Manage Workbook Details and Properties
