Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

WSQ Data Analytics with Excel
Loading...

WSQ - Data Analytics with Excel

Unleash the power of Excel in data analytics with our comprehensive, WSQ-endorsed course. From basic data manipulation and formulas to advanced techniques like pivot tables and data visualization, this course offers a full spectrum of skills. Practical exercises and real-world case studies ensure that your learning is rooted in applicability, equipping you with the tools to analyze large datasets and generate actionable insights.

By the end of this course, you’ll be proficient in using Excel for various data analytics tasks. You'll know how to clean, analyze, and visualize data, and you'll be adept at using Excel's advanced features to streamline your analytics process. Whether you're a business analyst, a data enthusiast, or someone aiming to make better data-driven decisions, this course prepares you for the challenges of today’s data-centric world.

Learning Outcomes

By the end of the course, learners will be able to 

    • LO1: Extract and validate data using Excel and Power Query
    • LO2: Apply basic data analytical techniques using Excel
    • LO3: Generate reports to identify trend and risk using Excel
    • LO4: Apply advanced data analytical tools available in Excel
    • LO5: Perform hypothesis testing using Excel

    Skills Framework

    This course follows the guideline of Data Analytics ACC-ICT-3003-1.1 TSC under Accountacny Skills Framework

    Course Brochure

    Download WSQ - Data Analytics with Excel Brochure

    Certification

    • Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.

    • OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

    WSQ Funding

    WSQ funding is only applicable to Singaporeans and PR. Subject to eligibility, the funding support is subjected to funding caps.

    Effective for courses starting from 1 Jan 2024
    Full Fee GST Nett Fee after Funding (Incl. GST)
    Baseline MCES / SME
    $720 $64.80 $424.80 $280.80

    Baseline: Singaporean/PR age 21 and above
    MCES(Mid-Career Enhanced Subsidy): S'porean age 40 & above

    Upon registration, we will advise further on how to tap on the WSQ Training Subsidy.


    You can pay the nett fee (after the WSQ training subsidy) by the following :

    SkillsFuture Enterprise Credit (SFEC)

    Eligible Singapore-registered companies can tap on $10000 SFEC to cover up out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

    SkillsFuture Credit (SFC)

    Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

    UTAP

    Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

    PSEA

    To check for Post-Secondary Education Account (PSEA) eligibility for this course, Visit SkillsFuture (course code: TGS-2022014978)

    • Scroll down to “Keyword Tags” to verify for PSEA eligibility.
    • If there is “PSEA” under keyword tags, the course is eligible for PSEA.
      Course Code: TGS-2022014978

      Course Booking

      The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

      $720.00 (GST-exclusive)
      $784.80 (GST-inclusive)

      Course Date

      * Required Fields

      Post-Course Support

      • We provide free consultation related to the subject matter after the course.
      • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

      Course Cancellation/Reschedule Policy

      • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
      • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
      • Note the venue of the training is subject to changes due to availability of the classroom

      Course Details

      Topic 1: Getting Started with Excel

      • Explore Excel user interface
      • Enter and validate data for analysis using Excel Power Query
      • Data management with Excel
      • Use formulas and functions

      Topic 2: Basic Data Analysis using Excel

      • Use LOOKUP and REFERENCE functions to integrate information
      • Use IF functions to analyse data
      • Basic statistics and use statistical functions

      Topic 3: Basic Data Visualisation using Excel

      • Create chart and reports to identify trends in data
      • What is regression? 
      • Create reports on regression and risk analysis 

      Topic 4: Advanced Data Analysis using Excel

      • Use PivotTables and PivotCharts to identify patterns across multiple datasets
      • Perform what-if analysis using Scenario Manager, Goal Seek and Data Table
      • Data governance and security with Excel

      Topic 5: Hypothesis Testing with Excel

      • What is hypothesis testing? 
      • Apply hypothesis testing techniques in Excel 

      Final Assessment

      • Written Assessment - Short Answer Questions (WA-SAQ)
      • Practical Performance (PP)

      You May Be Interested In These Courses