Excel 2019/365 Resources

Updated 2021-03-31

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. 3D Workbooks

3D workbooks	3D Workbooks
Formatting 3D workbooks		Formatting 3D workbooks
3D formulas		3D Formulas
Footers		Footers

8. 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

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

• Rounding numbers

· Solver

· Office Home Page: starting place for info about Excel

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