Dph final Curriculum Day 1

DPH Final Curriculum

Day 1

First Half (3 Hours)

• 
  Intro to the Interface
  
• 
  Keyboard Shortcuts
  
• 
  Single & Multi-Level Sorting
  
• 
  Filter & Range Filtering
  
• 
  IF Functions
  
• 
  AND/OR Functions
  
• 
  Intro to Nesting Functions
  
• 
  Building Complex (Multi-Layered) Nested Functions
  
• 
  Calculating eGFR Flags
  
  • 
    Convert Text to Columns
    
  • 
    AA Check IF Function
    
  • 
    eGFR Flags
    

Second Half (3 Hours)

• 
  Overview of Lists/Formatting Lists as Tables
  
• 
  Calculate Nurse Visit Eligibility Function
  
• 
  Intro to PivotTable
  
• 
  Intro to VLOOKUP
  
• 
  Building Outreach Tracker for Nurse, Pharmacist, Food Bank Visits
  
• 
  Data Validation
  
• 
  Add More Data
  
  • 
    Move or Copy
    
  • 
    Copy & Paste
    
  • 
    Review ‘Text to Columns’
    
  • 
    Intro to Conditional Formatting
    
  • 
    Remove Duplicates
    

Day 2

First Half (3 Hours)

• 
  IF/ISNA Function
  
• 
  Conditional Formatting
  
• 
  Creating Pivot Tables from Lists & Tables
  
• 
  Filtering & Sorting Pivot Tables
  
• 
  Pivot Table Slicers
  
• 
  Generating Pivot Table Drill Down (Double Click) Reports
  
• 
  Grouping Pivot Table Data
  
• 
  Refreshing/Changing Pivot Table Data
  
• 
  Show Values As (Calculating %)
  

Second Half (3 Hours)

• 
  Building Charts
  
• 
  Formatting & Managing Charts/Data
  
• 
  Inter-Workbook VLOOKUP
  
  • 
    Pull ‘Screening Status’ from Cervical, Breast, & Colorectal
    
• 
  Check Due for Cervical using VLOOKUP
  
• 
  Check Due tor Breast using VLOOKUP
  
• 
  Check Due for Colorectal using VLOOKUP
  
• 
  Review of IF, AND, OR Functions for Check Due Analysis
  
• 
  Text to Date Functions
  
• 
  CONCATENATE