Basic Data Analytics with Excel for Beginners

Hands On

Basic Data Analytics with Excel for Beginners: Overview

Microsoft Excel commonly used in almost every field, it is extremely easy to learn and it improves your productivity & efficiency.

You can learn the simple tips and tricks in Basic-Intermediate Excel 2019 Workshop, which make simple to complex tasks easy, with our Step-by-step, Practical, and Hands-on training.

View the video for a quick overview of this Excel 2019 / Office 365 training in Singapore to improve your Excel Basic Skills.

Basic Excel Training: Course Objectives

The Basic Excel Skills Hands-on training teaches you how to use Microsoft Excel 2019 / Microsoft Office 365 extremely well for day to day use in the office, and at home.

You will learn how to create Spreadsheets with multiple sheets, rows, columns, formatting, as well as some key functions and formulas.  You will gain confidence in Creating Excel Files, copy, move, use formulas, summarize, tabulate, create charts, use images, and do all kinds of formatting & printing options.

At the end of the Basic Excel Training, You will Learn to Write Formulas, Functions, Create Tables to Summarize Information, Charts to Tabulate Data and Work with Multiple Worksheets easily. 

We will cover the following topics in the Excel Certification workshop:

  • GET familiar with Excel Ribbon.
  • IMPROVE your Productivity by Learning Many Shortcuts.
  • LEARN Basic Formulas & Functions to Save Time.
  • WORK with different types of Charts & Graphs to Produce Accurate & Presentable Data.
  • COMPILE & Summarize Data from Multiple Worksheets & Workbooks.
  • HIGHLY Recommended for People who want to Upgrade themselves & Move to the Next Level.

Need a Course Brochure?
We'll send you one!

Course Outline

Basic Data Analytics with Excel for Beginners

Module 1: Using Excel Application

  • Get Familiar With Excel Ribbon
  • Opening & Working with Multiple Spreadsheets, Workbooks
  • Enhancing Productivity
  • How to Use Help
  • How to Set Preferences

Module 2: Opening & Closing Workbooks

  • Opening Multiple Workbooks
  • Adding, Moving, Renaming Worksheets
  • Copy, Move, Delete Sheets & Workbooks

Module 3: Formulas and Functions

  • Arithmetic Formulas
  • Functions
  • Brackets
  • Auto Functions
  • Checking for Errors
  • IF Function
  • Count, Average, Round, Min, Max
  • Absolute Referencing
  • Relative Referencing

Module 4: Editing Cells, Sheets

  • Editing Cells,
  • Using Undo, Redo
  • Copying
  • Moving
  • Replacing Text
  • Find & Replace
  • Sorting
  • Filtering

Module 5: Formatting the Data

  • Numbers/ Dates
  • Contents
  • Alignment, Border Effects
  • Freezing Panes

Module 6: Creating Charts in Excel

  • Creating Charts
  • Editing Charts
  • Moving, Resizing
  • Printing Charts

Module 7: Prepare Beautiful Outputs

  • Setup
  • Check and Print

Target Audience

Basic Excel Skills Training in Singapore: Logistics

Course Duration:  2 Days full days (Weekdays or Weekends)

Course Timings: 8.45 am – 5.45 pm

Target Audience: For beginner and professional who in need of basic Excel knowledge in order to produce charts and data analysis.

Prerequisites: Need to possess the knowledge of basic PC skills.

Certification: Successful trainees of the Basic Excel Skills Training will receive the internationally recognized certificate upon completion of the course. Students must take a 45-minute online assessment at the end of the course and pass it.

Learners’ Profile for Basic Excel Training in Singapore:

      1. Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Core Spreadsheet Skills.
      2. We look for participants with Secondary education as a per-requisite
      3. Participants should have completed the Basic PC Skills training.

Training Course Fees

The full course fees for this training is S$485, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$339.50 Funding by SSG
Pay $145.50
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$242.50 Funding by SSG
Pay $242.50
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

What Our Happy Participants Say

See how I helped my friend Mark in improving his Excel productivity – reduce errors, and come back on time for our jog…

Do You Have Any Questions

on Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.

Course Dates

Learn With Intellisoft & Boost Your Career

How to Register for Basic Excel Certification in Microsoft 2019 Workshop?

Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.

You can call at at +65 6252-5033 or 9066-9991 (Whatsapp now) if you have any questions.
Register Now

Get in Touch

Intellisoft Training Pte Ltd

190 Middle Road, #10-08 Fortune Centre,
Singapore 188979

(65) 6252-5033 (Call)

(65) 9066-9991 (Whatsapp now)