Overheard on Wall Street Labs

1.2.1 Ribbon Overview

1.2.2 Home Tab

1.2.3 Insert Tab

1.2.4 Data Tab

1.2.5 Page Layout Tab

1.2.6 Formulas Tab

1.2.7 Review Tab

1.2.8 View Tab

1.3.1 Functions Overview

1.3.2 SUM Function

1.3.3 Average Function

1.3.4 IF Function

1.3.5 Absolute References

1.4.1 Basic Navigating

1.4.2 Navigating your Workbook

1.4.3 Ctrl Functions

1.5.1 Function Keys

1.5.2 Quick Access Toolbar

1.5.3 Opening and Closing Workbooks

1.5.4 Saving

1.5.5 Printing

1.5.6 Options Window

2.1 Setting Up Your Excel

2.2 Merging Cells

2.3 Basic Formatting

2.4 Border Tips

2.5 Color Coding

2.6 Rows & Column Sizing

2.7 Ctrl + 1 Number Formats

2.8 Additional Formatting Tips

2.9 Conditional Formatting

2.10 Text to Columns

2.11 Naming Cells

3.1.1 Paste Special

3.1.2 Nested Paste Specials

3.2.1 Basic Formulas

3.2.2 Subtotals

3.2.3 Remove Duplicates

3.2.4 SUMIFS and AVERAGEIFS

3.2.5 SUMIFS _ AVERAGEIFS with Multiple Criteria

3.2.6 Basic IFERRORS

3.2.7 Date Functions

3.2.8 Text Functions

3.2.9 Text Functions (Part 2)

3.2.10 Logical Statements

3.2.11 Setting up an Assumptions Tab

3.2.12 Lookups

3.2.13 Lookups (Part 2)

3.2.14 SUMPRODUCT Function

3.2.15 Sorting & Filtering

3.2.16 NPV, IRR and Goal Seek

3.2.17 Indirect Function

4.1 Ctrl + F

4.2 One-way Data Tables (Part 1)

4.3 One-way Data Tables (Part 2)

4.4 Two-way Data Tables

4.5 Data Table Formatting

4.6 Common Data Table Busts

5.1 Data Validation

5.2 Formatting Clean Up

5.3 Grouping Cells

5.4 Formula Evaluator

5.5 Tracing

5.6 Adding Arrows

5.7 Formula Text

5.8 Circular References

5.9 All Kinds of Errors

5.10 Avoiding a Pls Fix, Thx

5.11 Deleting and Moving Sheets

5.12 IF & IFERROR Checking

6.1 Introduction to Graphs

6.2 Introduction to Graph Formatting

6.3 Adding Data Labels

6.4 Remove Gridlines

6.5 Stacked Column Chart

6.6 Dual Axis Chart

6.7 Bridge Chart

6.8 Football Field