Advanced Microsoft Excel Training

SDF Funding is available to Singapore Companies (company sponsored). Call +65 6296-2995 for Details.

“The Advanced Excel training will help me get my job done very quickly and easily. The things that I used to take many hours will now take only a few minutes with the use of formulas, macros and other tricks I learnt in the Excel 2007 workshop” –  Carmen Leow, Pan Pacific Hotel, Singapore.

We also have Excel training on other versions

Day 1 of Advanced Excel 2016

Lesson 1: Custom & Conditional Formats

  • Creating a Custom Format
  • Create a custom number format
  • Conditional Formatting
  • Creating Conditional Formatting
  • Editing Conditional Formatting
  • Adding Conditional Formatting
  • Deleting Conditional Formatting from the Selected Range

Lesson 2: Using Formulas & Functions

  • Relative Cell Reference
  • Absolute Cell Reference
  • Using Text Functions
  • Left Function
  • Upper Function
  • Concatenating the text values
  • Date Functions
  • Using Today Function
  • Calculating using Date Function
  • Using Sum Functions
  • Using CountA Functions

Lesson 3: Working with Range Names

  • Using Range Names
  • Creating Range Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Deleting Range Names
  • Creating 3-D Range Names

Lesson 4: Using Advanced Functions

  • Using If Functions
  • Using Nested If Functions
  • Using Sum If Functions
  • Using Count If Functions
  • Using Vlookup Functions
  • Using HLOOKUP Functions

Lesson 5: Managing Tables

  • Creating Tables
  • Naming the Table
  • Changing the Table Style
  • Creating a Total Row
  • Creating a calculated column
  • Using Filtering in Table
  • Removing the Duplicate Record

Lesson 6: Using Auto Filter

  • Sorting Data
  • Using AutoFilter
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Database Functions
Day 2 of Advanced Excel 2016

Lesson 7: Getting Most from your Data

  • Creating Subtotal
  • Using Automatic Outline
  • Grouping Data Manually
  • Using Data Validation

Lesson 8: Working with Charts

  • Creating a Chart
  • Formatting the Chart
  • Adding Labels
  • Changing the Chart Type, Data Source

Lesson 9: Working with Pivot Tables

  • Creating Pivot Tables
  • Adding Pivot Table Report Fields
  • Refreshing Pivot Table Report
  • Changing the summary function
  • Creating report filter pages
  • Creating Pivot Chart

Lesson 10: Using Shared Workbooks

  • Sharing a Workbook
  • Opening and Editing a Shared Workbook
  • Tracking Changes
  • Resolving Conflicts in a Shared Workbook

Lesson 11: Worksheet Protection

  • Protecting your Worksheets
  • Protecting range with password
  • Protecting your Workbook & Excel Files

Lesson 12: Multiple Workbooks

  • Linking Workbooks
  • Editing the Link
  • Consolidating Workbooks

Lesson 13: Working with Macros

  • Display the Developers Tab
  • Changing Macro Security Settings
  • Recording & Running a Macro

Learn Advanced Microsoft Excel at Intellisoft
Learn Advanced Microsoft Excel at Intellisoft

Understand how you can apply Advanced functions of Microsoft Excel 2016 to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.

Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.

Fundamental knowledge of Microsoft Excel is sufficient for this Advanced Excel training program.

You must know how to start Excel, key in numbers, text, and do simple formatting. You should know the basic functions like Sum, Count etc.

This course is not for Excel beginners. If you do not know how to copy information from one Excel worksheet cell to another, then this course is not for you… join our Excel for Beginners / Intermediate training program first.

Join the Advanced Microsoft Excel workshop only if you have been using Microsoft Excel for atleast 2-3 months, know the basics of Excel, and are ready to learn the more advanced functions, tricks and techniques of Microsoft Excel 2016.

Learn Advanced Microsoft Excel at Intellisoft
Learn Advanced Microsoft Excel at Intellisoft

Understand how you can apply Advanced functions of Microsoft Excel 2016 to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.

Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.

Go To Top

This course is not for Excel beginners. If you do not know how to copy information from one Excel worksheet cell to another, then this course is not for you… join our Excel for Beginners / Intermediate training program first.

Join the Advanced Microsoft Excel workshop only if you have been using Microsoft Excel for atleast 2-3 months, know the basics of Excel, and are ready to learn the more advanced functions, tricks and techniques of Microsoft Excel 2016.

Go To Top

Day 1 of Advanced Excel 2016

Lesson 1: Custom & Conditional Formats

  • Creating a Custom Format
  • Create a custom number format
  • Conditional Formatting
  • Creating Conditional Formatting
  • Editing Conditional Formatting
  • Adding Conditional Formatting
  • Deleting Conditional Formatting from the Selected Range

Lesson 2: Using Formulas & Functions

  • Relative Cell Reference
  • Absolute Cell Reference
  • Using Text Functions
  • Left Function
  • Upper Function
  • Concatenating the text values
  • Date Functions
  • Using Today Function
  • Calculating using Date Function
  • Using Sum Functions
  • Using CountA Functions

Lesson 3: Working with Range Names

  • Using Range Names
  • Creating Range Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Deleting Range Names
  • Creating 3-D Range Names

Lesson 4: Using Advanced Functions

  • Using If Functions
  • Using Nested If Functions
  • Using Sum If Functions
  • Using Count If Functions
  • Using Vlookup Functions
  • Using HLOOKUP Functions

Lesson 5: Managing Tables

  • Creating Tables
  • Naming the Table
  • Changing the Table Style
  • Creating a Total Row
  • Creating a calculated column
  • Using Filtering in Table
  • Removing the Duplicate Record

Lesson 6: Using Auto Filter

  • Sorting Data
  • Using AutoFilter
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Database Functions
Day 2 of Advanced Excel 2016

Lesson 7: Getting Most from your Data

  • Creating Subtotal
  • Using Automatic Outline
  • Grouping Data Manually
  • Using Data Validation

Lesson 8: Working with Charts

  • Creating a Chart
  • Formatting the Chart
  • Adding Labels
  • Changing the Chart Type, Data Source

Lesson 9: Working with Pivot Tables

  • Creating Pivot Tables
  • Adding Pivot Table Report Fields
  • Refreshing Pivot Table Report
  • Changing the summary function
  • Creating report filter pages
  • Creating Pivot Chart

Lesson 10: Using Shared Workbooks

  • Sharing a Workbook
  • Opening and Editing a Shared Workbook
  • Tracking Changes
  • Resolving Conflicts in a Shared Workbook

Lesson 11: Worksheet Protection

  • Protecting your Worksheets
  • Protecting range with password
  • Protecting your Workbook & Excel Files

Lesson 12: Multiple Workbooks

  • Linking Workbooks
  • Editing the Link
  • Consolidating Workbooks

Lesson 13: Working with Macros

  • Display the Developers Tab
  • Changing Macro Security Settings
  • Recording & Running a Macro

Go To Top

Fundamental knowledge of Microsoft Excel is sufficient for this Advanced Excel training program.

You must know how to start Excel, key in numbers, text, and do simple formatting. You should know the basic functions like Sum, Count etc.

Go To Top

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

How To Register

Register for the 2 Day Advanced Microsoft Excel Class Today.

To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals – only available if you apply through your company.

Call us at +65 6296-2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming Advanced Excel 2016 Training class.

We also offer Customized Corporate Training for Microsoft Excel 2016, 2013, 2007 & for Excel 2010 also. If you have a group of participants, we can conduct this training at your office too. Contact us for details.

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Joy Tan
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Michele Martin
Project Engineer

Accelerate your Career With the Most Effective Training!

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!