LDI 2022 Project Management Bootcamp Workshop
This is a space where we will share info re:Project Management Bootcamp Course LDI 2022
Slide deck
Production Schedule
Week at a glance intro
Budget template Pivot table
Mini Project
Contact info for instructor
Copy of How to use this course
What is Excel
Parts of Excel
Data entry for Excel
New document creation and saving
Special input in Excel
Excel Intro PIT STOP
EXCEL INTRO QUIZ
CHAPTER 2 DOWNLOADS
Formatting 101
Formatting Tables
Conditional Formatting
Name Ranges
Worksheet Adjustments
Adding Borders
Real World Formatting
Cell Styles
CHAPTER 2: EXCEL FORMATTING QUIZ
CHAPTER 3 DOWNLOADS
TABLES
Chapter 3 QUIZ: Excel Tables
Formula Basics
Cell Reference 101
How to show the formula used in a sheet
Fixing Errors
Putting it all together: Excel Formulas 1
Putting it all together: Excel Formulas 2
Chapter 4 Downloads
Chapter 4 Quiz FORMULAS
Functions 101
Functions 101 (part 2)
Functions 201
V LOOKUP (LONG)
V LOOKUP (SHORT)
YEARFRAC & COUNT
COUNTIF
HOW TO FIND OTHER FUNCTIONS
NESTED IF
ASSIGNMENT 5 FUNCTIONS
QUIZ 5: FUNCTIONS
PRINTING
QUIZ 6: PRINTING
GENERATING GRAPHS
GRAPHS AND PRESENTATION
GRAPHS PIT STOP (PUTTING IT TOGETHER)
QUIZ 7: GRAPHS