Subscribe e-Newsletter
    Member Login
    Course Information
    Email
    Pass
    Forget password? Click here
    Event Profile
    Class/
    Online
    Classroom
    Date December 13 - 14, 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 are required to bring a laptop installed with Microsoft Excel 2016/ 365/ 2019 for Windows. This course is not for Mac version Microsoft Excel.
    Other Date(s)1) Jun 27 - 28, 2024
    2) Nov 04 - 05, 2024
    Trainer
    Activity
    You may reach us via
    T: 6204 6214
    E: info@ccisg.com
    Alternatively, you may send below details to register
    Contact Person
    Company (optional), Name, Job Title, Mailing Address, Tel, Email

    Participant(s)
    Name, Job Title, Email
    Now a day, many jobs require advanced Excel skills. But 95% of Excel users use a mere 5% of the program’s power! Formulas make Excel smart. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, VLOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to audit and debug them, and how to use which formula for which occasion (and they also know few alternatives for any given formula problem).

    In Excel Advanced Formulas & Functions, participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use. The course will cover how to perform advanced searching and data retrieval with Lookup functions, creating statistic reports with criteria applied using Statistical functions, extracting required text from given string using Text functions, and many more. The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios.
    Objective
    1. Learn and understand how to use those functions in the following function categories:
      • IFs Functions
      • Information Functions
      • Statistical Functions
      • Math Functions
      • Date Functions
      • Text Functions
      • Lookup and Reference Functions
      • Database Functions
    2. Learn how to mix and match functions
    3. Learn how to solve real-life problem using functions
    4. Learn how to automate your work using functions
    5. Learn how to analyze problems and derive solutions
    6. Strengthen your Excel skills with formulas and functions
    7. Increase productivity by automating your work
    Outline
    Section 1: Revision of Functions

    Section 2: The IFs Functions

    Section 3: Information Functions

    Section 4: Statistical Functions

    Section 5: Math Functions

    Section 6: Date Functions

    Section 7: Text Functions

    Section 8: Lookup and Reference Functions

    Section 9: Database Functions (optional)
    Who should attend
    1. People who have attended the Excel Advanced course
    2. People who wants to advanced their skills in Excel
    3. People who wants to learn how to solve problems in Excel
    4. For Excel power users

    Prerequisite:
    1. Must have attended Excel Advanced course or has been using Excel for the past five years continuously
    2. Must know the basic of Excel formulas and functions
    3. Must know how to use Excel functions like IF, OR, AND, and nested functions

    Things to bring during the course:
    1. A laptop (preferable your personal laptop)
    2. Laptop power adaptor
    3. A USB mouse
    4. A USB thumb drive or hard-disk
    5. Software requirement: Microsoft Excel version 2010-2016
    Methodology
    This is a two-days hands-on course. The trainer will walk through the topic step-by-step. You will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.
    Testimonial
    - Very useful formulas and functions that can be applied to daily work ( Accounting and Corporate regulatory Authority )

    - Very informative and good notes that helps to cement the lesson

    - Many different functions that are very useful

    - Very good instructor who is very clear and teaches very well ( Ministry of Manpower )
    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