Microsoft MS Excel 2013, 2016, 2019 and 365 

(Intermediate to Advanced)

Very Valuable Course!

Really Really Helpful, Become More Confident and Efficient!

You Should Come!

Gained a lot of skills and knowledge!

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