Info for MS Office TRAINING Classes

Intro to Excel

• Files: level 1 - dowload zip file
  • Absolute Reference
  • Charting My First Example
  • Editing and Proofing
  • Introduction to Functions
  • Modifying My First Example
  • Printing My First Example

Intermediate to Excel

• Files: level 2 - dowload zip file
  • Data Consolidation
  • Formatting a worksheet
  • Intermediate Functions
  • Intermediate Review
  • Monthly Expenses
  • Protection
  • Range Names
  • Sales Report
  • Proj4_StudentGrades.docx
  • Salary List Quiz.xlsx
  • ExcelIntermedRev.pdf
    StoreDataNov10_222Vlookup.xlsx
    StoreDataNov10_222Vlookup_done.xlsx
    StoreDataNov10_22_sumif.xlsx
    StoreDataNov10_22_sumif_done.xlsx
    
  • 
  • 
  • 
  • 

Advanced to Excel

• Files: level 3 - dowload zip file
  • CH 1 Intermediate Review
  • CH 2 Thumbs
  • CH 2 Database Review
  • CH 2 Database
  • CH 3 Sales Invoices
  • CH 3 Joe's Beverage Company
  • CH 3 Orders Download
  • CH 3 Sales Invoices for Data Model
  • CH 4 Advanced Functions_Review
  • CH 4 Advanced Functions
  • CH 5 What-if Analysis
  • CH 5 What-If Analysis Review
  • CH 6 Product Costs
  • CH 6 Sharing Data
  • CH 7 JOE'S MACROS

Excel Functions

• Files: Functions - dowload zip file
  • Using Financial Functions
  • Advanced Functions
  • Advanced Functions_Review
  • Protection

Excel PivotTables

• Files: Pivot Tables and Data Anyasis - dowload zip file
  • CH 1 Thumbs
  • CH 1 Database Review
  • CH 1 Database
  • CH 2 Sales Invoices
  • CH 2 Joe's Beverage Company
  • CH 2 Orders Download
  • CH 2 Sales Invoices for Data Model
  • CH 3 What-if Analysis
  • CH 3 What-If Analysis Review
  • Copy of GP Transect and Quadrat Data 2021.xlsx