Website

MS Office

Word

Powerpoint

Excel

Excel Adv

Japanese

3D Printing

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

© 2021 Intuition International

(brand name of Apps Pte Ltd)

52 Telok Blangah Road, #01-02

Singapore 098829

Tel : 6909-8722 / 9181-9499

Email: contact@intuitioninternational.com