Excel Intermediate Advanced Course Plan:

 

4hrs

• Working with Tables and Styles

• Working with Records and Fields (Forms)

• Data Validation

• Working with Tables and Filters 

 

• Creating Range Names 

• Modifying Range Names 

• Using Range Names in Formulas 

• Text functions TRIM, CONCATENATE, LEFT, RIGHT, LEN

• More complicated uses of Conditional functions IF, SUMIF and COUNTIF

 

• Calculate data across worksheets Advanced Functions 

• Using Text and Date Functions

• Financial Functions 

• Using Logical Functions 

• Using the VLOOKUP HLOOKUP, MATCH Functions 

• Using the CHOOSE, SWITCH Functions

 

4hrs

• Creating a Custom Format

• Create a custom number format       

• Using formula RAND, RANDBETWEEN

• Conditional Formatting

  • Creating Conditional Formatting

  • Modifying Rules

 

• Protecting Sheets

• Links

 

• Working with Charts

• Creating Charts 

• Modifying Charts 

• Working with Sparklines

 

• Forecast

• Goal Seek and Solver

• Scenarios

• Pivot Table