Module 1: Introduction to Microsoft Excel
- Working with cell ranges—navigating and selecting cells with the mouse and keyboard
- Entering and editing data and employing AutoFill to enter data
- Inserting and deleting rows, columns, or cells.
- Adjusting column width and row height
- Manipulating data with cut, copy, paste, with the clipboard, or dragging the mouse
- Leveraging multiple worksheets
Module 2: Formulas and Functions
- Writing simple formulas
- Exploring audit tools to examine and evaluate formulas
- Referencing cells in formulas using relative and absolute references
- Configuring cells for the number format and alignment
- Constructing common functions with the aid of the function wizard and the Formula tab
- Implementing names in formulas and functions
Module 3: Worksheet Formatting and Presentation
- Setting up initial cell formatting
- Drawing attention to data with formatting
- Working with templates – Protecting cell ranges and worksheets
- Analyzing data with conditional formatting
Module 4: Getting Data In and Out
- Importing data into Excel from various sources: text, web, Microsoft Access, SQL (Structured Query Language) Server
- Transforming data with global replace and data tools
- TEXT and DATE functions
- 2013 Flash Fill assistant
- Setting WISE (Written, Integrated, Synergistic, and Expansive) goals
Module 5: Sorting, Selecting and Subtotaling data
- Subtotaling a Filtered list with the subtotal command
- Implementing Tables and Table Formulas
- Subtotaling a table with the Total Row
- Filtering Tables with Slicers
Module 6: Present Data Visually
- Leveraging charts to create a visual presentation
- Creating charts using wizards
- Adjusting chart settings, including titles, labels, and chart types
- Working with Views of the spreadsheet
- Setting up your workbook for printing
Module 7: Introducing Advanced Features
- Implementing dates
- Summarizing data from other worksheets with 3-D formulas
- Designing IF functions and conditional formatting
- Analyzing summary data with Pivot tables and slicers