﻿ Excel 2013 & 2016>

Excel 2016 Resources

Updated 2017.10.15

# 1. Basics

 Changing Excel's defaults Cursor movement Data entry and editing Data Entry and Editing (6:22) Editing Font formatting Formatting Fonts (8:38) Alignment Formatting Alignment (7:48) Formatting numbers Formatting Numbers (6:22) File commands File/Print/Layout Commands (11:34)

# 2. Relative Cell References and Auto-fill

 Autofill Autofill (5:50) Toolbar functions: Relative cell references

# 3. Absolute and Mixed Cell References

 Absolute cell references Mixed cell references Mixed cell references (12.23)

# 4. Database 1: Sorting and Auto-filtering

 Tables Sorting Single-key sort (4:47) Multiple-key sort (5:40) AutoFiltering

# 5. Charts

 Bad Examples Bad examples (8:39) Good Examples Good examples (5:50) Creating a chart Creating a chart (6:18) Formatting a chart Formatting a chart (7:44) Line charts Line charts (6:57) Pie charts Pie charts, (6:08) XY (Scatter) charts XY charts (4:57) Sparklines Sparklines

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

 Logical tests Logical Tests (6:24) IF AND AND (9:15) OR OR (7:57) Nested IF

# 7. Database 2: Pivot Tables

 Pivot Tables Lists Lists (9:57) Tables Tables (4:57) Sorting Sorting (4:23) Filtering Field settings Field Settings (3:46)

# 8. 3D Workbooks

 3D workbooks Formatting 3D workbooks 3D formulas 3D Formulas (5:49)

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

 Conditional formatting Conditional formatting (6:47) VLOOKUP VLOOKUP, Part 1 (12:09) VLOOKUP, Part 2 (6:53) COUNTIF, SUMIF, Nested IF

# 10. Database 3: Advanced Filters and Functions

 Advanced Filters Database functions DSUM DSUM (11:48) DAVERAGE DAVERAGE (4:32) DCOUNT, DCOUNTA DCOUNT and DCOUNTA (5:22) DMIN DMIN (5:24) DMAX

# 11. Dates and Times

 Dates Date Serial Numbers (9:17) Date functions Time functions

# 12. Financial Functions

 Overview Future Value (FV) FV (7:29) Loan Payment PMT (Loan) (4:05) Savings Payment PMT (Savings) (3:38) Loan PV PV (Loan) (3:23) Savings PV PV (Savings) (4:06) Lottery PV PV (Lottery) (4:30)

# 13. Macros and Visual Basic

 Customizing Excel Macros Visual Basic

# Miscellaneous

• Rounding numbers

·         Solver