Subscribe e-Newsletter
    Member Login
    Course Information
    Email
    Pass
    Forget password? Click here
    Event Profile
    Class/
    Online
    Classroom
    Date June 07 - 08, 2018
    Time 9:00am to 5:00pm
    Venue Mandarin Orchard Singapore
    333 Orchard Road
    Singapore 238867
    Fee
    7% GST will apply
    SGD 700.00
    For Member
    SGD 665
    NoteTwo tea breaks and set lunch or buffet will be served. Limited complimentary car parking coupons are available upon request.

    Participants should bring a laptop with Microsoft Excel 2010/2013/2016
    Trainer
    Activity
    Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. In this course, you will learn how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. You will also learn how to fine-tune your chart's color and style, add titles, labels, legends, changing the chart layout, pull data from multiple sources and interact with the chart.
    Objective
    This is a two days course and is divided into four sections:
    • Chart Basic - learn the basic foundation of chart, how to create, format and changing the options of the chart.
    • Excel Functions - learn functions that are used to create dynamic and interactive chart.
    • Form Controls - learn form controls to create interactive chart.
    • Dynamic and Interactive Charts - put together the three components you've learned to create dynamic and interactive chart.
    Outline
    Chart Essential
    • Introduction
    • Chart Type
    • Inserting a Chart
      - Use F11
      - Use Alt F1
      - Using Quick Analysis Tool
      - Using Recommanded Chart
      - Using Chart Group
    • Resizing and Repositioning Chart
      - Resizing Chart
      - Moving within the same Worksheet
      - Moving to new Worksheet
    • Changing Source Data
      - Switching Row and Column
      - Reselecting Data Range
      - Using Select Data Source dialog
      - Selecting Source Data from different worksheets
    • Changing Chart Layout
      - Using Quick Layout
      - Inserting Chart Title
      - Inserting Axis Title
        1) Horizontal Title
        2) Vertical Title
      - Inserting Data Labels
      - Inserting Data Table
      - Inserting Gridlines
        1) Major Gridlines
        2) Minor Gridlines
      - Changing the Scale of the values
      - Legend
    • Chart Formatting
      - Using Chart Style Gallery
      - Change Theme Colour
      - Changing Colour
        1) Theme Colour
        2) Series Colour
        3) Chart Area Colour
        4) Plot Area Colour
      - Formatting Labels
        1) Changing Font
        2) Changing Size
        3) Changing Colour
        4) Changing Gridlines Colour
      - Changing Chart Type
      - Save the Formatting as a Chart Template
    • Deleting Chart

    Functions for Creating Dynamic and Interactive Chart
    • Date Functions
      - MONTH
      - YEAR
    • Math and Statistic Functions
      - COUNTIFS
      - SUMIFS
    • Logical Functions
      - IF
      - OR
      - AND
    • Information Functions
      - ISBLANK
      - NA
    • Lookup and Reference Functions
      - VLOOKUP
      - CHOOSE
      - OFFSET
      - MATCH
      - INDEX

    Form Controls
    • The Developer Tab
    • Introduction to Excel Form Controls
    • List Box Form Control
    • Modifying a Control
    • Combo Box Form Control
    • Scroll Bar Form Control
    • Spin Button Form Control
    • Group Box and Option Button Form Controls
    • Check Box Form Control
    • Label Form Control
    • Button Form Control

    Creating Dynamic and Interactive Chart
    Who should attend
    • People who wants to learn how to create basic chart
    • People who wants to go beyond the basic charting like creating dynamic and interactive chart
    • People who wants to learn more about Excel power lookup functions to create dynamic data list
    • People who wants to learn Excel form controls to add interactivity into the chart or data list

    Prerequisite
    • Must have attended Excel Advanced or has been using Excel for the past four years continuously
    • Must know how to use Excel basic functions and also nested functions
    • Chart experience is not required
    Methodology
    This is a two days’ hands-on course. The trainer will explain on the topic and then guide you through with step-by-step practice. You will be provided with real life scenario for individual topics so that you can apply what is being taught. After the hands-on practice on every topic, you’ll have a short Q & A session.
    Testimonial
    Functions and sills taught are relevant and useful. Very friendly and helpful. Willing to share useful tips and information which is not included in the textbook/course material. The trainer is excellent!
    Maritime and Port Authority of Singapore (MPA)

    Trainer is very good, fun & I always look forward to learn from him. Enjoyed these two days, would join again next time.
    Singapore Police Force

    Very good & engaging. Trainer is knowledgeable and is patient in teaching to ensure that we understand every step.
    Singapore Police Force

    Concepts learnt are applicable at workplace, good pacing, clear explanation. Trainer is observant towards participants who are in doubt.
    National Institute of Education

    Overall is good. Thank you. Very clear steps.
    Tan Tock Seng Hospital Pte Ltd

    Pace is good. Presentation is clear. I will lookout for other courses by Mr Alaster.
    JTC

    Very useful to help improve data management productivity . A lot of tips to make our live easier when dealing with numbers!
    SIT
    Alaster Leong's Profile
    Mr. Alaster Leong is an IT Trainer who possesses a strong passion in IT Training. He has more than 25 years of IT experience. He has been providing IT training in government, private institutions and organizations since 1992. He specializes in creative courses such as Adobe Photoshop, Adobe Dreamweaver, Adobe Flash, Adobe Acrobat, Access and Excel VBA, Microsoft Office Applications, etc. He is a certified Microsoft Office Specialist Expert (MOS) in Excel.
    Privacy Policy  |  Terms of Use
    Copyright © 2024 CCISG Pte Ltd  |  ACRA Reg No: 201207591D  |  GST Reg No: 201207591D