Section 1: Data Preparation
Lesson 1: Data & Corporate Strategy: Introduction to Microsoft Excel
- Understanding Organization’s product and services
- Current and emerging data analytics tools and technology trends
- The need for Microsoft Excel
Lesson 2: Introduction to Excel for Business
- Getting Started with Excel
- Using the Ribbon as the Excel User Interface
- Navigating within the Worksheet
- Selecting a Cell or Range of Cells
- Entering Data
- Cutting, Copying, and Pasting Cell Values
- Copy and Paste Special
- Saving & Opening your Workbook
Lesson 3: Managing Rows & Columns in Excel
- Inserting, Moving & Deleting Cells
- Managing Columns and Rows
- Hide and Unhide Rows & Columns
- Changing Column Width & Row Height
Lesson 4: Organize and Prepare Data
- Format Worksheet Tabs
- Insert and Delete Worksheet
- Move and Copy Worksheet
- Hide & Unhide Worksheet
Lesson 5: Formatting Cells in Excel
- Formatting the Cell
- Number and Date Formatting
- Finding and Replacing Text
- Spell Check
Section 2: Data Operations & Data Analysis in Excel
Lesson 6: Formulas & Functions of Microsoft Excel
- Excel Arithmetic Operators & Order of Operations
- Using Auto Fill Options
- Using Basic Functions
- Writing simple & practical Formulas on your own
- Absolute Referencing
Lesson 7: Basic Data Analysis With Tables, Sorting, Filtering, Summary Information
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Formatting a Table For Reporting
Lesson 8: Large Workbooks & Reporting
- Managing Large Workbooks
- Printing Worksheets
- Setting Page Setup Options
- Setting Page Breaks
***Section 3: Data Visualization***
Lesson 9: Creating Charts For Data Visualization
- Summarizing Data Visually Using Charts
- Customizing Chart Data
- Format Chart Legend and Titles
- Change the Chart Body
- Creating a Pie Chart
- Using Chart Titles & Placing Charts
Lesson 10: Evaluate Data Analysis Findings
- Tables
- Visualizations
- Reports
