Microsoft Excel: Advanced

A Training Course by VTeach.


    In-House sessions are available upon request.


    Course Objective:

    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.


    Target Audience:

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


    Course Content:

    Custom & Conditional Formats

    Create custom number format
    Apply Conditional Formatting

    Using Advanced Formulas & Functions

    The Excel Date Function
    Truncate Text Data in Excel with the LEFT Function
    LEFT Function
    RIGHT Function
    Using Logical Functions

    Working with Range Names

    Assign a Range Name
    Edit a Range Name
    Consolidating Data

    Working or Managing Tables

    Create a Table
    Delete a table without losing the data or table formatting
    Create a Data List in Excel
    Removing the Duplicate Record

    Data Sorting and Filtering

    Perform a Quick Sort
    Perform a Custom Sort
    Filter Data
    Creating a Custom AutoFilter
    Advanced Filter

    Fetch result from your data 

    Create Subtotals
    Using Automatic Outline
    Grouping Data Manually
    Data Validation Rule

    Getting Master with Charts

    Create a Chart
    Change the Chart Type
    Change the Chart Style
    Change the Chart Location
    Add Axis Titles

    Pivot Tables

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

    Sharing Workbook

    Shared a Workbook with other users
    Tracking Changes
    Accept/Reject Changes
    Turn off change tracking for a Workbook
    Resolve conflicting changes in a Shared Workbook
    End the sharing of a Workbook
    Stop sharing the Workbook

    Worksheet Protection

    Protect a Worksheet
    Protect a Workbook
    Protecting Cell with a Password
    Protect your Excel Files

    Hands-on with Macros

    Display the Developer Tab
    Record a macro
    Changing Macro Security Setting
    Creating a Macro Button
    Assign a Macro
    Running and Deleting a Macro
    Run a Existing Macro

    Course Curriculum

    Microsoft Excel: Advanced 14:00:00

    Course Reviews


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

    No Reviews found for this course.

    • SGD 285
    • 2 days
    • 1 Units
    • 840 Minutes
    • Wishlist

    Enrol With Confidence

    PayPal Acceptance Mark

    Registration Support

    If you require further assistance on registration matters, email to

    In-House Enquiry

    Achieve higher ROI with your training budget with In-House trainings, email to
    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. We offer a wide variety of programs from Information Technology courses, Finance Courses to Business and Professional Development courses. We also provide in-house lunch time seminars such as Time Management, Stress Management, Motivational Talk, etc. We also have our own team of in-house course developers who liaise directly with our clients to develop training courses which meet their specific needs. Our Training - Regular scheduled public classes - Corporate Training that can be conducted in-house and at the comfort of your own location and time - Customized Training tailored to the organization’s needs and objective.
    More Courses by VTeach Pte Ltd