Subscribe e-Newsletter
    Member Login
    Course Information
    Email
    Pass
    Forget password? Click here
    Event Profile
    Date Feb 06, 2018
    Time 9:00am to 5:00pm
    Venue Mandarin Orchard Singapore
    333 Orchard Road
    Singapore 238867
    Fee
    7% GST will apply
    SGD 395.00
    For Member
    SGD 375.25
    NoteBreakfast, two tea breaks and buffet lunch will be served; complimentary car parking coupon will be provided upon request
    Other Date(s)1) May 21, 2018
    2) Aug 29, 2018
    3) Nov 28, 2018
    Trainer
    Activity
    You may reach us via
    T: (65) 9879 6267
    E: info@ccisg.com
    To register via fax, fill in This Form and fax to (65) 6310 5430.
    Microsoft Excel 2013 introduces a few new features such as Recommended Chart Tool, Recommended PivotTable Tool, Quick Analysis Tool, Table Slicer Filter and Power View Report that offer you different options to create and format charts. This course will provide you useful knowledge and skills to create interactive charts for your professional reports. You will learn what each chart and graph represents and the additional functionality that you might not have heard about.

    Participants should bring a laptop with Microsoft Excel 2013
    Objective
    • Participants will be able to create professional-look charts and Pivot Charts to enhance the visualization of their reports.
    • Participants will master the skills to create dynamic charts using different form controls and advanced Excel functions.
    Outline
    1. Working with Excel Charts
      1.1. Using Recommended Chart Tool
      1.2. Creating Combo Chart
      1.3. Using New Chart Tools
      1.4. Modifying Excel Charts
      1.5. Using Dynamic Chart Titles and Data Labels
      1.6. Formatting Charts
      1.7. Adding Trendline to a Chart
    2. Creating Special Charts
      2.1. Creating Waterfall Chart
      2.2. Creating Pie of Pie Chart
      2.3. Creating Project Gantt Chart
      2.4. Creating Comparative Histogram
    3. Creating Interactive Chart using Excel Table
      3.1. Introducing Excel Table
      3.2. Creating Chart from Excel Table
      3.3. Filtering Table with Slicer
    4. Working with Interactive PivotChart
      4.1. Creating PivotChart
      4.2. Customizing PivotChart
      4.3. Filtering PivotTable and PivotChart with Slicer
      4.4. Connecting Multiple PivotTables with Slicer
    5. Formatting Data Using Quick Analysis Tools
      5.1. Using Quick Analysis Tool
      5.2. Using Conditional Formatting
      5.3. Using Sparklines to Show Data Trends
    6. Controlling Dynamic Charts using Drop-Down Lists
      6.1. Creating Data Validation Drop-Down List
      6.2. Calculating Chart Control Values using LOOKUP function
      6.3. Defining Dynamic Named Range using OFFSET function
      6.4. Creating Interactive Chart with Dynamic Named Ranges
      6.5. Introducing Form Controls
      6.6. Creating Combo Box Form Controls
      6.7. Creating Interactive Stacked Column Chart
    Who should attend
    Participants must have basic to intermediate level Excel knowledge and a few years working experience using Excel. This course is for those who wish to get the most out of Excel charting and graphics features.
    Testimonials
    Very comprehensive coverage on chart creation. Covers all the relevant topics that would be applicable to daily work. The trainer is cheerful and approchable, and willing to patiently spend time repeating difficult steps.
    Health Sciences Authority

    Ms Valene is very patient and detailed. The course was very will planned. It is full score!
    JTC Corporation

    Very useful and easily learnt and applied. Trainer engaged everyone and provided individual guidance when necessary.
    JTC Corporation

    Ms Valene had simplified training to simple and easy to understand steps for me. There were interesting sharing and short-cuts which we could use everyday. A very friendly and knowledgeable trainer.
    Care Corner Singapore Ltd

    Well-paced and patient trainer. Shared many useful tips and shortcuts. Things learn can be applied on my work very relevant.
    Ministry of Manpower
    Valene Ang's Profile
    Valene Ang is a Microsoft Certified Trainer, ACTA Certified Trainer and Master Instructor of Microsoft Office Specialist (MOS). She has over 17 years’ experience in corporate IT training and course material development. Her corporate clients include NOL, PSA, IRAS, DFS, CPF, PUB, MOM, MOE, NEA, SingTel, Canadian High Commission, British High Commission, Temasek Polytechnic, Republic Polytechnic and etc...
    Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and course material, assisting corporate clients in business data analysis and providing dynamic report solutions. She had conducted many Microsoft Office seminars and workshops in Singapore and Malaysia. Her training focuses on providing practical solutions to real life Excel problems.
    Privacy Policy  |  Terms of Use
    Copyright © 2018 CCISG Pte Ltd  |  ACRA Reg No: 201207591D