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
Week 4 project_Problem solving with Excel-h--WZ5iaEea9VA4aKWH1oA.zip
(37 KB)
Week 4_Financial function_Handout-pLLZOpkmEeamAQpBWUcqLA.pptx
(100 KB)
Weel 4_Index match_Handout-pi58rpkmEeaToA55AQb91A.pptx
(73 KB)
Problem Solving with Excel_Week 4_Financial Formulas_Student Version 06-06-19-P5SwNYieEem-xg4p7cmXwA.zip
(40 KB)
Problem Solving with Excel_Week 4_Index Match_Student Version 06072019-66Uu0YlUEemVeg5DpI4LqA.zip
(41 KB)
Week 4_Statistical forecasting_Handout-pK8H2JkmEeaagxL7xdFKxA.pptx
(167 KB)
Week 4_Statistical forcasting_Problem solving with Excel-kxZ-RpetEeaR7Qr3yid5Zg.zip
(63 KB)
Problem Solving with Excel_Week 3_Pivot tables_Student Version_06072019-sdYgUIlbEemBQwq9JgxBcA.zip
(238 KB)
Week 3_Pivot tables_Handout-pLrveJkmEealdA62Aswjhg.pptx
(73 KB)
Week-3_Logical-functions_Handout v2-LWWbL0TQEeigbgqkS_SCag.pptx
(152 KB)
Problem Solving with Excel_Week 3_Logic statements_Student Version_04-24-19-r6Jv1WbbEemYoA6JRCzeXg.zip
(133 KB)
Problem-Solving-With-Excel-_Week-3_Culminating-Exercise-v9-E3XeXHKBEemYoA6JRCzeXg.zip
(83 KB)
Week-2_Data-cleansing-text_Handout 05-01-19-rNIMMGxJEemYoA6JRCzeXg.pptx
(250 KB)
Problem Solving With Excel _Week 2_Culminating Exercise v6-dTnCO5sFEeaeDBLEFONRaA.zip
(74 KB)
Problem Solving with Excel_Week 2_Data cleansing text functions_Student Version 06-07-19-gymoRok4EemBQwq9JgxBcA.zip
(66 KB)
Week 1_Excel basics and navigation_Handout-pfeOKZkmEealdA62Aswjhg.pptx
(295 KB)
Week 1_Excel Basics and Navigation_Problem solving with Excel-g45UYJmyEealdA62Aswjhg.xlsx
(134 KB)
Week-1_Basic-Functionality_Handout (v2)-25x9VZw-Eea33w76dwnDIg.pptx
(135 KB)
Problem Solving with Excel_Week 1_Subtotal_Student Version_v2 06062019-EWwiN4huEem-xg4p7cmXwA.zip
(35 KB)
Problem Solving With Excel_Week 1_Basic Functionality_Student Version_04-29-19-9OhGhmxPEemYoA6JRCzeXg.zip
(66 KB)
Week-1_Subtotal_Handout 04-24-19-rF_VSWaWEemp_gr2ZL5kng.pptx
(74 KB)
Week 2_Vlookup_Handout-pgRepJkmEeazEQqJcB_rAg.pptx
(73 KB)
Week 2_Data cleansing values_Handout-pM86CZkmEeaagxL7xdFKxA.pptx
(149 KB)
Problem Solving with Excel_Week 2_Vlookup_Student Version_06-06-19-UwnE0IhuEemNChIBV74tfA.zip
(70 KB)
Problem-Solving-with-Excel_Week-2_Data-cleansing-values_Student-Version-06072019-NF5NmYk4Eem-xg4p7cmXwA.zip
(94 KB)
Problem-Solving-With-Excel-_Week-1_Culminating-Exercise-04-29-19-OjL3CWxREem7ixL_6m9HFg.zip
(33 KB)
