• No products in the cart.

Gain knowledge to use advanced functions of Excel 2010 and hence increase productivity, augment data in spreadsheets using templates, charts, graphics, and formulas and be work efficient.

 Eligible for SkillsFuture Credit, SDF and PIC grant  

  About the course

New and Advanced features of Excel 2010. Participant will get in-depth knowledge to manage, filter and generate reports from Excel database. You will gain knowledge to use advanced functions of Excel 2010 and hence increase productivity, augment data in spreadsheets using templates, charts, graphics, and formulas and be work efficient.

  Who should attend

For those who have attended Microsoft Excel 2010 Basic course or for users with fair knowledge in Microsoft Excel.


Day 1

Lesson 1: How to do Custom & Conditional Formats

  • Working with Custom Format
  • Create a Conditional Formatting Rule
  • Conditional Formatting Presets
  • Remove Conditional Formatting Rules
  • Create a custom number format
  • Templates

Lesson 2: How to use Advanced Formulas & Functions

  • The Excel Date Function
  • Truncate Text Data in Excel with the LEFT Function
  • Using Logical Functions
  • Using the Vlookup
  • Lookup functions – HLOOKUP

Lesson 3: Working with Range Names

  • Using Range Names
  • Define Range Names
  • Create Range Names
  • Editing and Deleting Range Names
  • Consolidating Data

Lesson 4: Working or Managing Tables

  • Create a Table
  • Delete a table without losing the data or table formatting
  • To Format Information as a Table
  • Modifying Tables
  • Create a Data List in Excel
  • Filter data in an Excel table
  • Removing the Duplicate Record

Lesson 5: How to do data Sorting and Filtering

  • Using Advanced Filter
  • Using Database function
  • How to Sort Data
  • How to AutoFilter
  • Creating a Custom AutoFilter
  • Advanced Filter

Lesson 6: Fetch result from your data

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

Day 2

Lesson 7: Getting master with Charts

  • Types of Charts
  • Create a Chart
  • To Change the Chart Layout T
  • o Change the Chart Style
  • Changing the Chart Location
  • Adding Labels

Lesson 8: Pivot Tables

  • Insert a Pivot Table
  • Change Summary Calculation
  • Two-dimensional Pivot Table
  • Updating a PivotTable Report
  • Change Data Source
  • Using Report Filters
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Hiding PivotTable Report Items
  • Introducing Slicers
  • Refine the Pivot Table style
  • Formatting the values in the pivot table

Lesson 9: Sharing Workbook

  • Opening and Editing a Shared Workbook
  • Tracking Changes
  • View tracked changes
  • Accept/Reject Changes
  • View the history worksheet
  • Turn off change tracking for a workbook
  • Resolve conflicting changes in a shared workbook
  • Stop sharing the workbook

Lesson 10: Worksheet Protection

  • How to Protect Your Worksheet
  • Consolidate Worksheets
  • Protecting Cell with a Password
  • How to protect your Workbook
  • How to protect your Excel Files

Lesson 11: Hands-on with Macros

  • Display the Developer Tab
  • Record a macro
  • Changing Macro Security Setting
  • Using a Macro Button
  • Running and Deleting a Macro

  About Instructor 


VTeach Pte Ltd is a Training Organisation providing high quality and interactive hands-on training delivered by an enviable team of qualified, expert and highly experienced trainers. VTeach has been established to address the training needs of both individuals and corporate companies. We believe good foundation is essential in today’s business world.

As a committed training provider, we strive to deliver effective training programmes for a lifelong learning experience to enhance your productivity.


Microsoft Office Trainers

Ms. Koh Bee Hoon graduated from University of Wolverhampton, United Kingdom with a first class honors degree in Computer Science. She is a Microsoft Certified Trainer (MCT) and ACTA Certified Trainer providing IT-related training such as Microsoft Office application leading to ICDL, MOS and MCAS certification. Bee Hoon is actively involved in the delivery of WSQ Program such as ESS Basic ICT and Workplace ICT classes for government bodies and corporate organizations. Her strength includes customizing and designing Microsoft Application training program and developing courseware to meet the needs of corporate client.

Ms Jeslani Asha is an ACTA certified Corporate Trainer having 12 years of experience in areas of IT and Soft skills Training, Lecturing and Software Development. She has provided training to more than 5000 professionals. Her great analyzing ability, presentation skills, enthusiasm and cheerfulness is always appreciated by her trainees. Asha shows empathy and patience with participants and go to their level to make them understand the concepts. Her trainees enjoy her training sessions as it has lots of interactions, hands on exercises and fun-filled activities, which also accelerate the learning process.

Ms. Priscilla Tan graduated in Computer Studies. She is an Associate Trainer with more than 25 years of experience in conducting IT training that includes the Microsoft Software Applications and other customized training delivery projects for the multinational companies and government sectors. Priscilla is an Approved Instructor by Ministry of Education and IT Trainer by National Computer Board in 1988. She is an ACTA Certified Trainer, Microsoft Certified Trainer, ITE Industry Trainer, ICDL Trainer and Accredited Tester.

Ms. Valene Ang graduated with a Bachelor Degree in Information Technology from the University of Southern Queensland, Australia. She is a Microsoft Certified Trainer (MCT), Microsoft Office Specialist (MOS) Certified Instructor and ACTA Certified Trainer. She facilitated IT training for education organizations in Malaysia such as Systematic Business School, Disted College and Stamford College from year 1993 to1998. She has conducted many Microsoft Office workshops for employees in local and multinational companies in Singapore for the past 16 years.

Mr. Zaid Ismail has been in the training industry for 20 years. He started out as a trainer specializing in Microsoft Office applications, then gradually upgraded to become a Microsoft Certified Trainer in the area of database administration, software and web development. His core interest is providing IT solutions to clients and training courses in programming and database administration. His speciality is training in Excel VBA programming and Access database development


Course Curriculum

No curriculum found !

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • $ 285
  • 48 Hours
  • Wishlist

    Corporate Learning Solutions

    • Blended learning model (self-paced e-learning and/or instructor-led options)
    • Course, category-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for teams
    • 24×7 teaching assistance

    Contact us