Excel 2019/365 Resources

Updated 2019-09-15

Spreadsheet objectives

Database objectives

Spreadsheet Design Guidelines

Web

Videos Watch videos in full screen and HD (1040)

1. Basics

Changing Excel's defaults

Changing Excel's Defaults

Cursor movement

Cursor Movement

Cursor Movement & Shapes 

Data entry and editing

Data Entry         Editing

Data Entry and Editing 

Font formatting

Formatting Fonts

Formatting Fonts 

Alignment

Formatting Alignment

Formatting Alignment 

Formatting numbers

Formatting Numbers

Formatting Numbers 

File commands

File/Print/Layout Commands

File/Print/Layout Commands 

2. Relative Cell References and Auto-fill

Autofill

Autofill 

Toolbar functions:

Toolbar functions

Toolbar functions 

Relative cell references

Relative references

Relative cell references

3. Absolute and Mixed Cell References

Absolute cell references

Absolute cell references

Absolute cell references 

Mixed cell references

Mixed cell references

Mixed cell references

4. Database 1: Sorting and Auto-filtering

Tables

Tables

Creating a table

Sorting

Sorting

Single-key sort 

Multiple-key sort 

AutoFiltering

Autofiltering

Filtering on text fields 

Filtering on numeric fields 

5. Charts

Bad Examples

Bad chart examples

Bad examples 

Good Examples

Good chart examples

Good examples 

Creating a chart

Charts overview

Creating a column chart 

Formatting a chart

Formatting a chart 

Line charts

Creating a line chart 

Pie charts

Creating a pie chart 

XY (Scatter) charts

XY charts 

Sparklines

Sparklines

6. Making Decisions, part 1: Logical Tests and Logical Functions

Logical tests

Logical Tests 

IF

IF

IF, part 1     IF, part 2

AND

AND

AND 

OR

OR

OR 

Nested IF

IFS

IFS Nested IF 

7. Database 2: Pivot Tables

Pivot Tables

Pivot Tables

Lists

Lists 

Tables

Tables 

Sorting

Sorting 

Filtering

Filtering 

Field settings

Field Settings 

Grouping

 

Grouping by Intervals

Charts

 

Charts

8. 3D Workbooks

3D workbooks

3D Workbooks

Formatting 3D workbooks

Formatting 3D workbooks 

3D formulas

3D Formulas 

Footers

 

Footers

9. Making Decisions, part 2: VLOOKUP and Conditional Formatting

Conditional formatting

Conditional formatting

Conditional formatting 

VLOOKUP

VLOOKUP

VLOOKUP, Part 1 

VLOOKUP, Part 2 

COUNTIF, SUMIF, Nested IF

10. Database 3: Advanced Filters and Functions

Advanced Filters

Advanced filters

Advanced Filters, part 1 

Advanced Filters, part 2 

Database functions

Database functions

DSUM

DSUM 

DAVERAGE

DAVERAGE  

DCOUNT, DCOUNTA

DCOUNT and DCOUNTA 

DMIN

DMIN 

DMAX

 

DMAX

11. Dates and Times

Dates

Date Serial Numbers 

Date functions

Date functions

Date Functions: TODAY, NOW 

MONTH, DAY, YEAR, WEEKDAY, DATE

DATEDIF

Time functions

Time Functions

Time Serial Numbers 

12. Financial Functions

Overview

Overview

Future Value (FV)

Future Value (FV)

FV 

Loan Payment

Loan Payment (PMT)

PMT (Loan) 

Savings Payment

Savings Payment (PMT)

PMT (Savings) 

Loan PV

Loan PV

PV (Loan) 

Savings PV

Savings PV

PV (Savings) 

Lottery PV

Lottery PV

PV (Lottery) 

Loan Rate

Loan Rate (RATE)

Rate (Loan) 

Savings Rate

Savings Rate (RATE)

Rate (Savings)

Loan NPER

Loan time to pay off (NPER)

NPER (Loan) 

Savings NPER

Savings time to goal (NPER)

NPER (Savings)

13. Macros and Visual Basic

Customizing Excel

Customizing Excel

 

Macros

Macros

 

Visual Basic

Visual Basic

 

 

Miscellaneous

·        Solver

·  Office Home Page: starting place for info about Excel

·  Microsoft Office Specialist (MOS) Home Page: get your Excel skills certified