Advanced Excel 2010

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

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

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 2010 workshop” –  Carmen Leow, Pan Pacific Hotel, Singapore.

We also have Excel training on other versions:

Course Duration for Advanced Microsoft Excel 2010 Training : 2 days

Course Objectives

  • Learn Advanced Excel 2010 at Intellisoft
    Learn Advanced Excel 2010 at Intellisoft

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

They will know learn to deploy Advanced Excel 2010 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 2010.

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® 2010, 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 and Conditional Formats

  • Creating Your First Custom Format
  • Understanding the Date & Time Format Strings
  • Using Date & Time Custom Format
  • Understanding Conditional Formatting

Lesson 2: Using Range Names

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

Lesson 3: Using Formulas and Functions

  • Understanding Formulas & Functions
  • Create a Relative & Absolute Reference
  • Working with Logic Functions
  • Working with Text Functions
  • Using More Text Function
  • Working with Lookup Functions
  • Understanding VLOOKUP() Function
  • Understanding HLOOKUP() Function
  • Challenge 03: Using Formulas & Functions

Lesson 4: Managing, Sorting & Filtering Tables

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Build an Advanced Filter
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First or Last Column
  • Summing with Subtotals & Grand Totals
  • Validating Data During Entry
  • Working with Database Functions
  • Challenge 04: Organizing Worksheet & Table Data

Lesson 5: Working with Charts

  • Summarizing Data Visually Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Changing the Chart Body
  • Saving the Chart as a Template
  • Creating a Pie Chart
  • Creating Combination Charts
  • Challenge 05: Working with Chart

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
  • Filtering Using the Report Filter Area
  • Challenge 06: Working with Pivot Table
Lesson 7: Working with Shared Workbooks

  • Working in a Group Environment
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Turn on Track Changes
  • Accepting or Rejecting Changes
  • Review Changes
  • Keeping a Backup of your Changes
  • Create a Change History

Lesson 8: Working with Multiple Workbooks

  • Linking to Other Workbook
  • Create a Link to Other Workbooks
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets

Lesson 9: Protecting Your Worksheet and Workbook

  • Protecting Your Worksheet
  • Protect a Worksheet
  • Unprotect a Worksheet
  • Allowing Access to Parts of a Worksheet – I
  • Allowing Access to Parts of a Worksheet – II
  • 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 the Macro dialog box
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • Delete a Macro
  • Saving a Workbook with a Macro
  • Saving a Macro to the XLSM Workbook
  • Saving a Macro to the Personal Macro Workbook
  • Macro Security
  • Creating Practical Macros
  • Inserting a Header

Pre-Requisites

Basic 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.

Course Objectives

  • Learn Advanced Excel 2010 at Intellisoft
    Learn Advanced Excel 2010 at Intellisoft

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

They will know learn to deploy Advanced Excel 2010 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 2010.

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® 2010, 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 and Conditional Formats

  • Creating Your First Custom Format
  • Understanding the Date & Time Format Strings
  • Using Date & Time Custom Format
  • Understanding Conditional Formatting

Lesson 2: Using Range Names

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

Lesson 3: Using Formulas and Functions

  • Understanding Formulas & Functions
  • Create a Relative & Absolute Reference
  • Working with Logic Functions
  • Working with Text Functions
  • Using More Text Function
  • Working with Lookup Functions
  • Understanding VLOOKUP() Function
  • Understanding HLOOKUP() Function
  • Challenge 03: Using Formulas & Functions

Lesson 4: Managing, Sorting & Filtering Tables

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Build an Advanced Filter
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First or Last Column
  • Summing with Subtotals & Grand Totals
  • Validating Data During Entry
  • Working with Database Functions
  • Challenge 04: Organizing Worksheet & Table Data

Lesson 5: Working with Charts

  • Summarizing Data Visually Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Changing the Chart Body
  • Saving the Chart as a Template
  • Creating a Pie Chart
  • Creating Combination Charts
  • Challenge 05: Working with Chart

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
  • Filtering Using the Report Filter Area
  • Challenge 06: Working with Pivot Table
Lesson 7: Working with Shared Workbooks

  • Working in a Group Environment
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Turn on Track Changes
  • Accepting or Rejecting Changes
  • Review Changes
  • Keeping a Backup of your Changes
  • Create a Change History

Lesson 8: Working with Multiple Workbooks

  • Linking to Other Workbook
  • Create a Link to Other Workbooks
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets

Lesson 9: Protecting Your Worksheet and Workbook

  • Protecting Your Worksheet
  • Protect a Worksheet
  • Unprotect a Worksheet
  • Allowing Access to Parts of a Worksheet – I
  • Allowing Access to Parts of a Worksheet – II
  • 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 the Macro dialog box
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • Delete a Macro
  • Saving a Workbook with a Macro
  • Saving a Macro to the XLSM Workbook
  • Saving a Macro to the Personal Macro Workbook
  • Macro Security
  • Creating Practical Macros
  • Inserting a Header

Go To Top

Pre-Requisites

Basic 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

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!

Some of the companies that experienced our trainings

Do You Have a Question or Need a Quotation?

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

"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 2010 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 Advanced Excel 2010 training.

We also offer Corporate Training for Advanced Excel 2010 version.

If you have a group of people, we can arrange to conduct the Advanced  Excel  2010 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!