Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS Excel - Additional Content
Introduction
Additional Tips for success
Introduction to Excel Basics
Additional Material
1. Interface (45:05)
2. Formula Basics (31:24)
3. Keyboard Shortcuts
4. Rounding (8:55)
Formatting and Data Entry
Additional Material
1. Data manipulation and formatting (10:49)
Functions and Formulas
Additional Material
1. Number formatting (11:03)
2. Finance calculations (17:02)
3. More formulas (7:37)
4. More complex formulas (59:31)
5. Ranges and forecast functions (5:56)
6. Transforming numbers to text
7. SUMIFS function
8. SUMIF function
Sorting, Filtering, and Tables
Additional Material
1. Table basics (4:59)
2. Tables, filters, charts and graphs (11:55)
Charts and Graphs
Additional Material
1. Chart Basics
2. Dynamic Chart Range
3. Info Charts with Icons
4. Comparison Charts
5. Interactive Chart with Dynamic Arrays
Conditional Formatting and Data Validation
Additional Material
1. User actions that triggers #REF! errors
2. How to fix Spill error
3. How to fix other common excel errors
PivotTables and PivotCharts
Additional Material
1. Pivot slices and charts (8:00)
2. Adding fields to blank pivot table
3. Filtering data within pivot tables
4. Removing data from a pivot table report
5. Ideal data for analysis with Excel’s PivotTable feature
6. Pivot table to transform lists of data into on-screen reports
7. Refresh commands in Excel update
Data Analysis with Functions
Additional Material
1. VLOOKUP (8:13)
2. INDEX and MATCH combination to VLOOKUP OR HLOOKUP
3. VLOOKUP function to look up date
4. VLOOKUP to perform approximate matches
5. Hlookup Function
6. Vlookup returns #N/A instead of a value
7. IFERROR Function
8. XLOOKUP function
9. MATCH function
10. Dual lookups
11. IFNA function
12. How to use wildcards
Data Validation and Protection
Additional Material
1. Hyperlinks, grouping and protecting (12:39)
Advanced Charting Techniques
Additional Material
1. Interactive dashboards
Working with Multiple Worksheets and Workbooks
Additional Material
1. Delimited files, consolidations and Web queries (6:47)
2. Intergrating data on web pages into your workbooks
Acknowledgement of Training Completed
Acknowledgement of Training Completed
2. INDEX and MATCH combination to VLOOKUP OR HLOOKUP
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock