Subscribe e-Newsletter
    Member Login
    Course Information
    Forget password? Click here
    Event Profile
    Date Sep 18 - 19, 2017
    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

    Perfect pace. I have learnt a lot - Everything is useful. Enjoyed your lessons, Valene. Thank you.
    Lion Global Investors Limited

    Learnt an in depth with regards to excel as my works uses a lot of excel. Overall is good. Trainer is very knowledgeable and experience.
    Ministry of Law

    Pace is fast, but I am able to follow and I have achieved outcome of the course! The workshop is good for managing excessive data! Trainer is very knowledgeable and experience. Able to address all questions posed.
    National healthcare Group
    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 19 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, Komatsu Asia Pte. Ltd., 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