Overview of Excel-Course Introduction
Welcome to Problem Solving with Excel
()
Course Overview and Syllabus
Meet the PwC Content Developers
Overview of Excel-Guiding Principles for Using Excel
Tao of Excel
()
Guiding Principles for Using Excel
Overview of Excel-Excel Basics & Navigation
Week 1 Welcome
()
Excel Basics Workbook
Excel Basics and Navigation Part 1
()
Excel Basics and Navigation Part 2
()
Excel Basics and Navigation Handout
A Message from our Chief People Officer at PwC
()
Overview of Excel-Basic functionality
Basic Functionality Workbook
Paste Special - Part 1
()
Paste Special - Part 2
()
Cell Locking - Part 1
()
Cell Locking - Part 2
()
Named Ranges
()
Basic Functionality Handout
Overview of Excel-Subtotal
Subtotal Excel Workbook
Subtotal - Part 1
()
Subtotal - Part 2
()
Subtotal Handout
Overview of Excel-Cumulative Exercise Week 1
Week 1 Project
vLookups and Data Cleansing-vLookup
Welcome to Week 2
()
VLookup Workbook
VLookup
()
Use VLOOKUP, data validation and multiple VLOOKUPs together
()
HLOOKUP
()
Nesting
()
VLookup Handout
vLookups and Data Cleansing-Data Cleansing - Values
Data Cleansing: Values Workbook
Data Cleansing: Values - CLEAN- 1a
()
Data Cleansing: Values - CLEAN -1b
()
Data Cleansing: Values - TRIM
()
Data Cleansing: Values - SUBSTITUTE -3a
()
Data Cleansing: Values - SUBSTITUTE - 3b
()
Data Cleansing: Values - STORED AS TEXT
()
Data Cleansing: Values - De-DUPLICATING
()
Data Cleansing: Values Handout
vLookups and Data Cleansing-Data Cleansing - Text Functions
Data Cleansing: Text Workbook
Data Cleansing: Text Functions
()
Text - LEN & FIND
()
Text - CONCATENATE
()
Text - Data Validation
()
Data Cleansing: Text Handout
vLookups and Data Cleansing-Week 2 Project
Hints for Week 2 Project
Week 2 Project
Logical Functions & Pivot Tables-Logic Statements
Welcome to Week 3
()
Logical Functions Workbook
Logical Functions: Introduction
()
Logical Functions - COUNTIFS
()
Logical Functions - COUNTIFS Part 2
()
Logical Functions - SUMIFS
()
Logical Functions - SUMIFS Part 2
()
Logical Functions - IF + THEN
()
Logical Functions - IF + AND
()
Logical Functions - IF + OR
()
Logical Functions - Nesting
()
Logical Functions Handout
Logical Functions & Pivot Tables-PwC's Perspective
Bringing Value with Excel
()
Logical Functions & Pivot Tables-Pivot Tables
Pivot Tables Workbook
Pivot Tables
()
Navigate a Pivot Table
()
Sort a Pivot Table
()
Advanced Filtering
()
Calculated Fields
()
Slicers
()
Pivot Tables Handout
Logical Functions & Pivot Tables-Week 3 Project
Week 3 Project
More Advanced Formulas-Statistical Forecasting
Welcome to Week 4
()
Statistical Forecasting Workbook
Intro to Statistical Forecasting
()
Statistical Forecasting - Part 1
()
Statistical Forecasting - Part 2
()
Statistical Forecasting Handout
More Advanced Formulas-Index Match
Index Match Workbook
Index Match
()
Index Match: MATCH Formula
()
x and y Variables
()
2 Variable Lookup
()
Index Match Handout
More Advanced Formulas-Financial Formulas
Financial Function Workbook
Financial Function - NPV and IRR
()
Financial Function - Calculating Payment Schedule
()
Financial Function - Calculating Payment Period
()
Financial Function Handout
More Advanced Formulas-Cumulative Exercise Week 4
Week 4 Project
More Advanced Formulas-Course recap and closing
Course Wrap-up
()
Learn more about PwC and our career opportunities