Microsoft Excel
VOCABULARY
Chapter 1: Getting Started with Microsoft Excel 2016
- Lesson 1: Touring Excel
- Lesson 2: Worksheet and Workbook Basics
- Lesson 3: Adding Worksheet Contents
- Lesson 4: Worksheet Formatting
- Lesson 5: More on Cell Entries and Formatting
- Lesson 6: Working with Ranges
- Lesson 7: Creating Formulas
- Lesson 8: Copying and Pasting
- Lesson 9: Techniques for Moving Data
- Lesson 10: Sheet, Display, and Print Operations
Chapter 2: Working with Formulas and Functions
- Lesson 11: Getting Started with Functions
- Lesson 12: Using Excel Tables
- Lesson 13: Working with the NOW Function and Named Ranges
- Lesson 14: Working with IF Functions
- Lesson 15: Working with Text Functions
- Lesson 16: Using Frozen Labels and Panes
- Lesson 17: Using Conditional Formatting and Find and Replace
- Lesson 18: Rotating Entries and Resolving #### Errors
- Lesson 19: Managing Worksheets and Performing Multi-Worksheet Operations
- Lesson 20: Modifying Print Options
Chapter 3: Charting Data
- Lesson 21: Building Basic Charts
- Lesson 22: Showing Percentages with a Pie Chart (No vocabulary)
- Lesson 23: Enhancing a Pie Chart
- Lesson 24: Adding Special Elements to a Chart or Sheet and Updating a Chart
- Lesson 25: Completing Chart Formatting and Lesson 26: Comparing and Analyzing Data
- Lesson 27: Chart Printing and Publishing
- Lesson 28: Using Charts in Other Files
- Lesson 29: Making Special Purpose Charts
Chapter 4: Advanced Functions, PivotCharts, and PivotTables
- Lesson 30: Working with Hyperlinks
- Lesson 31: Using Advanced Sort
- Lesson 32: Using Advanced Filtering
- Lesson 33: Using Advanced Functions to Predict Trends
- Lesson 34: Using Advanced Functions for Data Analysis
- Lesson 35: Using Lookup Functions
- Lesson 36. Working with PivotTables and PivotCharts
- Lesson 37: Working with Data Models
- Lesson 38: Working with Excel Online
SLIDE PRESENTATION
Chapter 1: Getting started with Microsoft Excel 2016
- Lesson 1: Touring Excel
- Lesson 2: Worksheet and Workbook Basics
- Lesson 3: Adding Worksheet Contents
- Lesson 4: Worksheet Formatting
- Lesson 5: More on Cell Entries and Formatting
- Lesson 6: Working with Ranges
- Lesson 7: Creating Formulas
- Lesson 8: Copying and Pasting
- Lesson 9: Techniques for Moving Data
- Lesson 10: Sheet Display and Print Operations
Chapter 2: Working with Formulas and Functions
- Lesson 11: Getting Started with Functions
- Lesson 12: Using Excel Tables
- Lesson 13: Working with the NOW Function and Named Ranges
- Lesson 14: Working with IF Functions
- Lesson 15: Working with Text Functions
- Lesson 16: Using Frozen Labels and Panes
- Lesson 17: Using Conditional Formatting and Find and Replace
- Lesson 18: Rotating Entries and Resolving #### Errors
- Lesson 19: Managing Worksheets and Performing Multi-Worksheet Operations
- Lesson 20: Modifying Print Options
Chapter 3: Charting Data
- Lesson 21: Building Basic Charts
- Lesson 22: Showing Percentages with a Pie Chart
- Lesson 23: Enhancing a Pie Chart
- Lesson 24: Adding Special Elements to a Chart or Sheet and Updating a Chart
- Lesson 25: Completing Chart Formatting
- Lesson 26: Comparing and Analyzing Data
- Lesson 27: Chart Printing and Publishing
- Lesson 28: Using Charts in Other Files
- Lesson 29: Making Special Purpose Charts
Chapter 4: Advanced Functions PivotCharts and PivotTables
- Lesson 30: Working with Hyperlinks
- Lesson 31: Advanced Sort
- Lesson 32 : Using Advanced Filtering
- Lesson 33: Using Advanced Functions to Predict Trends
- Lesson 34: Using Advanced Functions for Data Analysis
- Lesson 35: Using Lookup Functions
- Lesson 36: Working with PivotTables and PivotCharts
- Lesson 37: Working with Data Models
- Lesson 38: Working with Excel Online
ILLUSTRATED:
SLIDE PRESENTATION
Getting Started with Excel 2016
Working with Formulas and Functions
Analyzing Data with PivotTables
Exchanging Data with Other Programs
Sharing Excel Files and Incorporating Web Information
Customizing Excel and Advanced Worksheet Management
VIDEOS
(Video library courtesy of Lynda.com)
01 Getting Started With Excel 2016
02 Entering Data
03 Creating Formulas and Functions
04 Formatting
05 Adjusting Worksheet Layout and Data
06 Printing
07 Introduction to Charting
08 Adjusting Worksheet Views
09 Multiple Worksheets and Workbooks
10 IF, VLOOKUP, and Power Functions
11 Security and Sharing
12 Database Features
13 PivotTables
14 Data Analysis Tools
15 Introduction to Macros