Subscribe e-Newsletter
    Member Login
    Course Information
    Forget password? Click here
    Event Profile
    Date Feb 27 - 28, 2018
    Time 9:00am to 5:00pm
    Venue Mandarin Orchard Singapore
    333 Orchard Road
    Singapore 238867
    7% GST will apply
    SGD 700.00
    For Member
    SGD 665
    NoteBreakfast, two tea breaks and buffet lunch will be served; complimentary car parking coupon will be provided upon request
    Other Date(s)1) Jun 28 - 29, 2018
    2) Sep 20 - 21, 2018
    3) Dec 10 - 11, 2018
    You may reach us via
    T: (65) 9879 6267
    To register via fax, fill in This Form and fax to (65) 6310 5430.
    Data analysis is a process of inspecting, cleaning, transforming, and modelling data with the goal of discovering useful information, suggesting conclusions, and supporting decision making. The use of powerful Excel data analysis tools allow you to speed up your day-to-day work as well as assist the decision makers in making sound decision.

    This course will be conducted using Microsoft Excel 2013 software, participants are required to bring long a laptop installed with Microsoft Excel 2010 or Microsoft Excel 2013 software.
    This 2-days course will train participants how to import external data using Microsoft Query, prepare source data for the use of data analysis, convert dates and perform date calculations, create dynamic tables and charts that can be updated automatically using a button, lookup and extract data from a table, consolidate multiple set of data into a summary worksheet as well as perform What-if Analysis with Scenario Manager, Goal Seek and Data Table.
    1. Defining names for a range or a cell and create user-friendly formulas using the names.
    2. Implementing Data Validation to prevent invalid data entry and create drop-down lists.
    3. Learning magic tricks to highlight important values with Conditional Formatting.
    4. Using Advanced Filter to copy specific records into another worksheet or workbook.
    5. Importing External Data Sources with Microsoft Query to create Excel Table and PivotTable.
    6. Delete duplicate rows using Remove Duplicates command and separate the contents of one cell into different columns using Text To Column command.
    7. Cleaning up data using TEXT functions such as LEFT, RIGHT, MID, FIND, SEARCH & LEN; using DATE functions such as MONTH, DAY, YEAR, DATE, DATEDIF.
    8. Using advanced functions in data analysis =>SUMIFS, COUNTIFS, AVERAGEIFS, DSUM, DAVERAGE, DCOUNTA, DMIN, DMAX, VLOOKUP, INDEX, MATCH.
    9. Combine values from multiple worksheets and workbooks into one new range using 3D-Reference functions and Data Consolidate command.
    10. Creating a Slicer Dashboard with PivotTable and Pivot Charts.
    11. Using What-If Analysis =>Scenario Manager, Goal Seek and Data Table.
    Who should attend

    • This is a fast pace advanced level course and is not suitable for beginners who use Excel occasionally.

    • This course is for frequent Excel users who wish to learn how to increase their productivity with effective and time saving data analysis skills.
    • Participants must have an intermediate level Excel knowledge and a few years working experience using Excel.
    The workshop was well-planned and designed. Well-versed in the subject taught.
    National Healthcare Group Pte Ltd

    One of the most useful course I have attended; my teammates and I will try to sign up for similar courses conducted by Ms Valene. She is an excellent trainer, She is patient, explains concepts well and paces the class well. Excellent facilitator.
    Ministry of Trade and Industry

    Trainer's teaching is excellent.
    National Environment Agency

    The workshop is very good, practical examples and exercises. One of the best Excel courses I've ever attended thus far. The trainer is very knowledgeable and have very good rapport with the group.
    Health Promotion Board
    Valene Ang's Profile
    Valene Ang is a Microsoft Certified Trainer (MCT) with a degree in Business
    Computing. Her Professional qualifications including Advanced Certificate in Training and Assessment (ACTA) and Master Instructor for Microsoft Office Specialist (MOS).
    She has more than 19 years of experience in corporate IT training and course
    materials development.

    Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outlines and course materials, assisting corporate clients in business data analysis and providing dynamic report solutions. Her training focuses on providing practical solutions to real life Excel problems.

    Valene conducted many Microsoft Office training in Singapore, Malaysia and China. Her corporate clients include NOL, PSA, IRAS, DFS, CPF, PUB, MOM, MOE, NEA, DHL, SingTel, Singapore Expo, Changi Airport Group, SPRING Singapore, Nanyang Polytechnic, Singapore Polytechnic, Republic Polytechnic,
    Denza (ShenZhen) and etc.
    Privacy Policy  |  Terms of Use
    Copyright © 2018 CCISG Pte Ltd  |  ACRA Reg No: 201207591D