Wedemic

Microsoft Excel: Advanced

A Training Course by VTeach.

0 STUDENTS ENROLLED

    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
    Templates

    Using Advanced Formulas & Functions

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

    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

    N.A

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

    No Reviews found for this course.

    TAKE THIS COURSE
    Clear
    • 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 registration@wedemic.com

    In-House Enquiry

    Achieve higher ROI with your training budget with In-House trainings, email to inhouse@wedemic.com
    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
    Wedemic

    Microsoft Excel: Advanced

    A Training Course by VTeach.

    0 STUDENTS ENROLLED

      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
      Templates

      Using Advanced Formulas & Functions

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

      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

      N.A

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

      No Reviews found for this course.

      TAKE THIS COURSE
      Clear
      • 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 registration@wedemic.com

      In-House Enquiry

      Achieve higher ROI with your training budget with In-House trainings, email to inhouse@wedemic.com
      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