Microsoft Excel
Learn how to create and format workbooks, enter and rearrange data, apply table and cell styles, use functions, create charts, apply conditional formatting, and analyze trends in Microsoft Excel.
Why It Matters: Microsoft Excel
Creating a New Workbook
Entering Data
Table Styles
Cell Styles
Cell Format
Comma Styles
Rearranging Tables
Changing Width of Columns and Rows
Flash Fill
SUM Data
Assignment: Organize Sales Data
Introduction to Creating Complex Workbooks
Creating a Workbook with Multiple Worksheets
Sorting Data
Filtering Data
Functions
Clustered Column Charts
Chart Styles
Sparklines
Conditional Formatting
Viewing a Worksheet
Assignment: Analyze Yearly Trends
Final Summary: Microsoft Excel