Advanced Excel Training

Advanced Excel 2016

“The Lookup & Pivot Table techniques I learned in Advanced Excel 2016 training have helped me in my work immensely. With automation using Macros,  manual steps have been reduced to a couple of keystrokes.

The Advanced formulas, ranges, and shortcut tips are well worth the time and money spent training at Intellisoft. The trainers are professional, patient, and the staff is very helpful. I’d definitely recommend it to all my colleagues to attend their Microsoft training at Intellisoft in Singapore. Absolutely must for every Excel warrior” –  Marina Bay Sands

We also have Advanced Excel training on older versions of Microsoft like:

Advanced Excel 2016 Training in Singapore

Course Duration:  Microsoft Excel 2016 Training is typically for 2 full days.

Advanced Excel 2016 Training at Intellisoft Singapore
Advanced Excel 2016 Training at Intellisoft Singapore

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

SkillsFuture credits ready for Singaporeans.

Course Objectives

Learn Advanced Excel 2016 @Intellisoft
Learn Advanced Excel 2016 @Intellisoft

 After Completing the Advanced Excel 2016 Training Course, Participants will be able to:

  • calculate with advanced functions & formulas
  • organize worksheet and table data using multiple techniques
  • summarize information quickly using Pivot Tables, and generate Management Reports
  • create and modify charts & graphs.
  • Use the Correct Recommended Chart Feature in Excel 2016
  • be able to create and use the New Charts in Excel 2016 like the Pareto chart
  • analyze data using Pivot Tables and Pivot Charts.
  • insert graphic objects.
  • customize and enhance workbooks and the Microsoft® Office Excel® 2016  environment.

They will learn to deploy Advanced Excel 2016 techniques to increase productivity and improve efficiency by streamlining the workflow.

  • collaborate with others using workbooks
  • audit worksheets
  • analyze data with Excel 2016
  • Work with multiple worksheets & workbooks using Microsoft Excel 2016
  • Import and export data in Excel
  • Use Advanced Filters in Excel 2016
  • How to use Pivot tables in Excel
  • Using the Quick Analysis Tools Within Excel 2016

Participants will learn to use advanced features and functions of Excel® 2016 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.

  •  They will apply visual elements and advanced formulas to a worksheet to display data in various formats with Pivot Tables, Conditional Formatting, Advanced Filtering, and Sorting options.
  • Participants will also learn how to 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 and streamline their day-to-day work.

Target Audience

Microsoft Advanced Excel 2016 Training program is most suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2016 software.

The course is designed for participants would want to learn how to quickly analyze data, sort and filter data, import and export data sets, and understand data using the rich features provided in Excel. It will impart the necessary skills to create simple macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

In addition, the course is also for participants desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Course Outline

Lesson 1: Using Custom & Conditional Formats

  • Reasons for Using Custom Format
  • Understanding Conditional Formatting
  • Managing the Conditional Format Rules
  • Changing the Conditional Formatting Rules
  • Locating Cells with Conditional Formatting
  • Working with Conditional Formatting

Lesson 2: Using Range Names

  • Assigning Names to Groups of Cells
  • Managing Named Range
  • Using Names in Formulas

Lesson 3: Using Formulas & Functions

  • Understanding Formulas & Functions
  • Quick Way to Insert a Function
  • Viewing the Formulas (and not the results)
  • How to Delete Values and not Formulas
  • Create a Relative & Absolute Reference
  • Working with Logical Functions
  • Using SUMIF and COUNTIF Functions
  • Working with Text Functions
  • Working with Date and Time Functions
  • Working with Lookup Functions
  • Understanding VLOOKUP Function

 Lesson 4: Managing, Sorting & Filtering Tables

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First/Last Column
  • Outline a List of Data
  • Validating Data During Entry
  • Working with Database Functions
  • Using Advanced Filters in Excel 2016
  • Quick Analysis With New Features of Excel 2016

Lesson 5: Working with Charts in Excel 2016

  • Summarizing Data Visually Using Charts
  • Creating a Chart Quickly
  • Changing the Chart Type
  • Customizing Chart Data
  • Show or Hide Chart Gridlines
  • Creating a Pie Chart
  • Saving the Chart as a Template
  • Creating Combination Charts
  • Using The New Pareto Chart Functionality
  • Using Recommended Charts Effectively
Lesson 6: Working with Pivot Tables

  • What is a Pivot Table
  • Anatomy of a Pivot Table
  • How does a Pivot Table Works
  • Create a Basic Pivot Table Report
  • Rearranging a Pivot Table Report
  • Customizing a Pivot Table
  • Changing Summary Calculations
  • Adding and Removing Subtotals
  • Sorting in a Pivot Table
  • Filtering in a Pivot Table
  • Create Report Filter Pages
  • Using Slicers in Pivot Table
  • Working with Pivot Chart

Lesson 7: Working with Shared Workbooks

  • Working in a Group Environment
  • Sharing Workbooks in Excel
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Accepting or Rejecting Changes
  • Keeping a Backup of your Changes

Lesson 8: Working with Multiple Workbooks

  • Linking to Other Workbook
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets

Lesson 9: Protecting Your Worksheet and Workbook

  • Protecting Your Worksheet
  • Protecting Your Formulas
  • Protecting Your Workbook
  • Save Your Workbook with Password
  • Encrypting your Workbook

Lesson 10: Working with Excel Macros

  • Recording & Testing a Macro
  • Using the Developer Tab
  • Create a Macro
  • Relative and Absolute Recording
  • Testing the Macro
  • Running and Deleting Macros
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • Short Introduction to Macro Programming in
    Excel 2016

 

Pre-Requisites

Basic knowledge of Microsoft Excel is sufficient for this 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.

Advanced Functions and features of Excel would be taught in this  workshop. A laptop with Excel version pre-loaded is provided for use in the training class.

Course Objectives

Learn Advanced Excel 2016 @Intellisoft
Learn Advanced Excel 2016 @Intellisoft

 After Completing the Advanced Excel 2016 Training Course, Participants will be able to:

  • calculate with advanced functions & formulas
  • organize worksheet and table data using multiple techniques
  • summarize information quickly using Pivot Tables, and generate Management Reports
  • create and modify charts & graphs.
  • Use the Correct Recommended Chart Feature in Excel 2016
  • be able to create and use the New Charts in Excel 2016 like the Pareto chart
  • analyze data using Pivot Tables and Pivot Charts.
  • insert graphic objects.
  • customize and enhance workbooks and the Microsoft® Office Excel® 2016  environment.

They will learn to deploy Advanced Excel 2016 techniques to increase productivity and improve efficiency by streamlining the workflow.

  • collaborate with others using workbooks
  • audit worksheets
  • analyze data with Excel 2016
  • Work with multiple worksheets & workbooks using Microsoft Excel 2016
  • Import and export data in Excel
  • Use Advanced Filters in Excel 2016
  • How to use Pivot tables in Excel
  • Using the Quick Analysis Tools Within Excel 2016

Participants will learn to use advanced features and functions of Excel® 2016 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.

  •  They will apply visual elements and advanced formulas to a worksheet to display data in various formats with Pivot Tables, Conditional Formatting, Advanced Filtering, and Sorting options.
  • Participants will also learn how to 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 and streamline their day-to-day work.

Go To Top

Target Audience

Microsoft Advanced Excel 2016 Training program is most suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2016 software.

The course is designed for participants would want to learn how to quickly analyze data, sort and filter data, import and export data sets, and understand data using the rich features provided in Excel. It will impart the necessary skills to create simple macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

In addition, the course is also for participants desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Go To Top

Course Outline

Lesson 1: Using Custom & Conditional Formats

  • Reasons for Using Custom Format
  • Understanding Conditional Formatting
  • Managing the Conditional Format Rules
  • Changing the Conditional Formatting Rules
  • Locating Cells with Conditional Formatting
  • Working with Conditional Formatting

Lesson 2: Using Range Names

  • Assigning Names to Groups of Cells
  • Managing Named Range
  • Using Names in Formulas

Lesson 3: Using Formulas & Functions

  • Understanding Formulas & Functions
  • Quick Way to Insert a Function
  • Viewing the Formulas (and not the results)
  • How to Delete Values and not Formulas
  • Create a Relative & Absolute Reference
  • Working with Logical Functions
  • Using SUMIF and COUNTIF Functions
  • Working with Text Functions
  • Working with Date and Time Functions
  • Working with Lookup Functions
  • Understanding VLOOKUP Function

 Lesson 4: Managing, Sorting & Filtering Tables

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First/Last Column
  • Outline a List of Data
  • Validating Data During Entry
  • Working with Database Functions
  • Using Advanced Filters in Excel 2016
  • Quick Analysis With New Features of Excel 2016

Lesson 5: Working with Charts in Excel 2016

  • Summarizing Data Visually Using Charts
  • Creating a Chart Quickly
  • Changing the Chart Type
  • Customizing Chart Data
  • Show or Hide Chart Gridlines
  • Creating a Pie Chart
  • Saving the Chart as a Template
  • Creating Combination Charts
  • Using The New Pareto Chart Functionality
  • Using Recommended Charts Effectively
Lesson 6: Working with Pivot Tables

  • What is a Pivot Table
  • Anatomy of a Pivot Table
  • How does a Pivot Table Works
  • Create a Basic Pivot Table Report
  • Rearranging a Pivot Table Report
  • Customizing a Pivot Table
  • Changing Summary Calculations
  • Adding and Removing Subtotals
  • Sorting in a Pivot Table
  • Filtering in a Pivot Table
  • Create Report Filter Pages
  • Using Slicers in Pivot Table
  • Working with Pivot Chart

Lesson 7: Working with Shared Workbooks

  • Working in a Group Environment
  • Sharing Workbooks in Excel
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Accepting or Rejecting Changes
  • Keeping a Backup of your Changes

Lesson 8: Working with Multiple Workbooks

  • Linking to Other Workbook
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets

Lesson 9: Protecting Your Worksheet and Workbook

  • Protecting Your Worksheet
  • Protecting Your Formulas
  • Protecting Your Workbook
  • Save Your Workbook with Password
  • Encrypting your Workbook

Lesson 10: Working with Excel Macros

  • Recording & Testing a Macro
  • Using the Developer Tab
  • Create a Macro
  • Relative and Absolute Recording
  • Testing the Macro
  • Running and Deleting Macros
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • Short Introduction to Macro Programming in
    Excel 2016

 

Go To Top

Pre-Requisites

Basic knowledge of Microsoft Excel is sufficient for this 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.

Advanced Functions and features of Excel would be taught in this  workshop. A laptop with Excel version pre-loaded is provided for use in the training class.

Go To Top

Microsoft Access 2010 Training at Intellisoft

Claim SDF & PIC Grant

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

Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.

skills-future-training

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!

computer-training-participants

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!

Do You Have a Question or Need a Quotation?

Simple. Just tell us what you need below. We'll be glad to help you!

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"
25388788904_72d2f5ec6f_z.jpg
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 !"
25497478040_140ce47f31_k.jpg
Michele Martin
Project Engineer

How To Register

Register for the 2 Days Advanced Excel 2016 today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at +65 6296-2995, SMS / WhatsApp: +65 9066-9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Excel Basic-Intermediate 2016 training.

We also offer Corporate Trainings for Advanced Excel 2016 version.

If you have a group of people, we can arrange to conduct the Advanced  Excel  2016 training at your office location too. Just contact us for logistics.

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!