Handouts
Handout Topics
Computer Basics
Microsoft Word
2016
Microsoft Excel
2016
- Part 1: Opening and Creating Workbooks & Introduction to Cells, Rows, Columns
- ExcelPart1.xlsx
- Part 2: Modifying and Formatting Cells & Basics on Worksheets
- ExcelPart2.xlsx
- WorksheetPractice.xlsx
- Part 3: Setting Up Workbooks And Intro to Excel Formulas
- ExcelPart3.xlsx
- Part 4: View Option, Introduction to Excel Functions And Naming Cells
- Grocery Lists Practice.xlsx
- Excel Part4 Functions.xlsx
- Part 5: Naming Cells, Creating a Drop-down List, Conditional Formatting, Sort/Filter/Divide Data
- ExcelPart5.xlsx
- Part 6: Create List, Fill command, Table, Bar and Pie Chart, Sparklines
- ExcelPart6.xlsx
- Part 7: Comments, Reviews, Protect Workbook/Worksheet
- ExcelPart7.xlsx
- DataforExcelPart7Exercise.xlsx
- Finished Exercise for ExelPart7.xlsx
- Consolidate Data & Analyze with Pivot Table 2016
- Consolidation.xlsx
- Source Data for Salespersons.xls
- Multiple Consolidation Examples.xlsx
- Commonly Used Excel Formulas 2016
- LookUps.xlsx
- ConditionalFormulas.xlsx
- WhatIfAnalysis.xlsx
