Subscribe e-Newsletter
    Member Login
    Course Information
    Email
    Pass
    Forget password? Click here
    Event Profile
    Date Dec 04 - 05, 2017
    Time 9:00am to 5:00pm
    Venue Mandarin Orchard Singapore
    333 Orchard Road
    Singapore 238867
    Fee 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) Mar 22 - 23, 2018
    2) Jun 28 - 29, 2018
    3) Sep 20 - 21, 2018
    4) Dec 10 - 11, 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.
    400% Tax Deduction or 40% Cash Payout of the course fee (net of government grant or subsidy) under PIC scheme for training of employees! For details, please refer to www.iras.gov.sg/irashome/PIcredit.aspx
    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.
    Objective
    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.
    Outline
    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.
    Testimonials
    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. Ms. Valene 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
    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 © 2017 CCISG Pte Ltd  |  ACRA Reg No: 201207591D