Advanced Excel for Apple Mac

Learn Pivot Tables, Vlookup, Macros & More...
Pratical, Short, Step-by-Step &
To-The-Point Training.
Request For a Course Brochure
Training For Your Entire Department?
We offer Customized Solutions For Training at Your Office or Our Training Centre
Get Corporate Training Quote
One-to-One Training
Can't attend the whole day?
Get a 1-1 coaching for the topics you need.
Arrange a One-To-One Training

Please bring your Apple Mac device to attend the Advanced Excel 2011 or Excel 2016 training. Call +65 6296-2995 for Details.

Course duration for Microsoft Excel 2016 & Excel 2013 for Mac Training : 2 days

Course Objectives

  • Learn Advanced Excel for Apple Mac @Intellisoft
    Learn Advanced Excel for Apple Mac @Intellisoft

    Participants will learn to use advanced functions of Excel®  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.
  • Students 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.

 After Course Completion:

After the successful completion of the Intermediate to Advanced Excel 2011 or Excel 2016 Training program, students will be able to:

  • Calculate with advanced functions & formulas.
  • Organize worksheet and table data using multiple techniques.
  • Create and modify charts & graphs.
  • Analyze data using Pivot Tables and Pivot Charts.
  • Insert graphic objects.
  • Customize and enhance workbooks and the Microsoft® Office Excel® environment.

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

  • Collaborate with others using workbooks
  • Audit worksheets
  • Analyze data.
  • Work with multiple worksheets & workbooks
  • Import and export data in Excel

Target Audience

This program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2016.

The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create 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 students 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: Working with Custom & Conditional Formats in Excel 2016

  • 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 in Excel 2016

  • 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 in MS Excel 2016

  • 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 in Excel 2016

  • 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 using Excel 2016

  • 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 in Excel 2016

  • Sorting Data
  • Using AutoFilter
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Database Functions
Lesson 7: Getting Most from your Data using Microsoft Excel 2016

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

Lesson 8: Working with Charts in Excel

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

Lesson 9: Creating Pivot Tables in Excel 2016

  • Creating a PivotTable Report
  • Refreshing a PivotTable Report
  • Changing the Summary Function
  • Adding New Fields to a PivotTable Report
  • Using Expand and Collapse Buttons
  • Hiding/Unhiding PivotTable Report Items
  • Inserting Slicers
  • Creating Report Filter Pages
  • Creating a PivotChart Report
  • Exercise – Creating/Revising PivotTables

Lesson 10: Creating and Using Shared Workbooks using Excel 2016

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

Lesson 11: Working with Worksheet Protection

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

Lesson 12: Working with Multiple Workbooks in Excel 2016

  • Linking Workbooks
  • Editing the Link
  • Consolidating Workbook

Lesson 13: Working with Macros in Excel 2016

  • Display the Developers Tab
  • Changing Macro Security Setting
  • Running a Macro
  • Recording a Macro
  • Deleting a Macro

Pre-Requisites

You must have your own Apple Mac or Apple Air or iMac device. You must have the Microsoft Office for Mac pre-installed on your Apple Device. Bring your own device for this training.

Course Objectives

  • Learn Advanced Excel for Apple Mac @Intellisoft
    Learn Advanced Excel for Apple Mac @Intellisoft

    Participants will learn to use advanced functions of Excel®  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.
  • Students 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.

 After Course Completion:

After the successful completion of the Intermediate to Advanced Excel 2011 or Excel 2016 Training program, students will be able to:

  • Calculate with advanced functions & formulas.
  • Organize worksheet and table data using multiple techniques.
  • Create and modify charts & graphs.
  • Analyze data using Pivot Tables and Pivot Charts.
  • Insert graphic objects.
  • Customize and enhance workbooks and the Microsoft® Office Excel® environment.

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

  • Collaborate with others using workbooks
  • Audit worksheets
  • Analyze data.
  • Work with multiple worksheets & workbooks
  • Import and export data in Excel

Go To Top

Target Audience

This program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2016.

The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create 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 students 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: Working with Custom & Conditional Formats in Excel 2016

  • 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 in Excel 2016

  • 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 in MS Excel 2016

  • 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 in Excel 2016

  • 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 using Excel 2016

  • 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 in Excel 2016

  • Sorting Data
  • Using AutoFilter
  • Creating a Custom AutoFilter
  • Using Advanced Filter
  • Using Database Functions
Lesson 7: Getting Most from your Data using Microsoft Excel 2016

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

Lesson 8: Working with Charts in Excel

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

Lesson 9: Creating Pivot Tables in Excel 2016

  • Creating a PivotTable Report
  • Refreshing a PivotTable Report
  • Changing the Summary Function
  • Adding New Fields to a PivotTable Report
  • Using Expand and Collapse Buttons
  • Hiding/Unhiding PivotTable Report Items
  • Inserting Slicers
  • Creating Report Filter Pages
  • Creating a PivotChart Report
  • Exercise – Creating/Revising PivotTables

Lesson 10: Creating and Using Shared Workbooks using Excel 2016

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

Lesson 11: Working with Worksheet Protection

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

Lesson 12: Working with Multiple Workbooks in Excel 2016

  • Linking Workbooks
  • Editing the Link
  • Consolidating Workbook

Lesson 13: Working with Macros in Excel 2016

  • Display the Developers Tab
  • Changing Macro Security Setting
  • Running a Macro
  • Recording a Macro
  • Deleting a Macro

Go To Top

Pre-Requisites

You must have your own Apple Mac or Apple Air or iMac device. You must have the Microsoft Office for Mac pre-installed on your Apple Device. Bring your own device for this training.

Go To Top

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!

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!

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.

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

To Register for Mac Microsoft Excel 2016 Training, Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at +65 6296-2995
or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class of Advanced Excel 2011 or Excel 2016

We also offer Corporate Trainings for Advanced Excel for Mac 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 details.

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!