Course Description

Do you often work with data at work or frequently extract data to create reports to update your leaders? Microsoft Excel is a powerful spreadsheet program that allows you to make quick and accurate numerical calculations. You will appear more professional when you present formulated spreadsheets to highlight your key data narratives. ‘Microsoft Excel 2019 – Basic’ is a course that is suitable for you if you are new to this application. The structured training will help you to increase your productivity while working with data.

Why is it so important to learn Excel? It is because almost every organization across all industries is using Excel to boost their employees’ productivity and quality of work. Many different job roles require some form of Excel knowledge. It is one of the most indispensable data processing tools in the working world now.

So what are some applications of Excel? For example, businesses use Excel for the creation of financial reports. Manufacturing plants use Excel for statistical analysis on their inventory. Families use Excel to help manage their family expenses, investment portfolios, and retirement savings projections. As you can see, Excel is an essential skill needed by everyone not only for work but also for their personal projects.

In our 2-day ‘Microsoft Excel 2019 – Basic’ course, you will gain the essential skills needed to create, edit and use basic formulas to extract data insights. In addition, you will learn page layout and format your spreadsheets for printing.

Course Objectives

At the end of this course, you should be able to:

Create simple formulas and recognize when to use absolute and relative references

Use autofill option and functions such as Sum, Average, Min, Max and Count

Find and replace content and formats and add cell comments

Format text and values into different decimal places, currencies and percentages etc.

Apply protection and print out your worksheets and workbook

View large databases effectively by sorting and filtering records, freezing panes, and splitting and arranging windows

Create simple formulas and recognize when to use absolute and relative references

Use autofill option and functions such as Sum, Average, Min, Max and Count

Find and replace content and formats and add cell comments

Format text and values into different decimal places, currencies and percentages etc.

Apply protection and print out your worksheets and workbook

View large databases effectively by sorting and filtering records, freezing panes, and splitting and arranging windows

Course Outline

You will be learning the following:

Application Fundamentals

Understanding the Excel Application Screen
Giving Commands
Customizing the Quick Access Toolbar
Using Command Shortcuts
Create, Open, Save and Close a Workbook
Using Help
Exiting Excel

Introduction to Formulas Functions

Formatting a Worksheet

Formatting Text & Values
Adjusting Row Height and Column Width
Cell Alignment, Borders & Colors
Copying Formatting
Apply, Remove, Create & Modify Cell Styles
Using Document Themes
Applying Conditional Formatting

Managing Page Setup and Printing

Previewing and Printing a Worksheet
Setting the Print Area
Adjusting Page Margins, Orientation, Page Size and Print Scale
Adding Print Titles, Gridlines and Headings
Creating Headers and Footers
Printing a Selection, Multiple Worksheets and Workbooks

Introduction to Charts

Choosing and Selecting the Source Data
Choosing the Right Chart
Inserting, Moving, Resizing and Deleting Charts
Changing Chart Layout and Style
Changing Chart Type

Getting Started with Worksheets

Editing a Worksheet

Managing Workbooks

Using Workbooks View
Selecting and Switching between Worksheets
Inserting, Renaming and Deleting Worksheets
Moving and Copying Worksheets
Changing Worksheet Tab Color
Spliting and Freezing a Window
Working with Multiple Workbook Windows
Hiding and Unhiding Rows, Columns and Worksheets
Creating a Template
Protecting a Workbook and Worksheets

Working with Data Ranges

Sorting by One Column
Sorting by Multiple Columns
Filtering Data

DOWNLOAD COURSE PDF

Course Fees And Grants

S$388.80 per participant (Incl. 8% GST)

Click here for UTAP Fundings

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour.

Applicants may use SkillsFuture Credit for this course

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

Course	Code	Venue	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23
Microsoft Excel 2019 - Basic	TGS-2020502871	JTC Summit	05-06	10-11	03-04	11-12	05-06	09-10	04-05
	TGS-2020502871	Mountbatten Square	12-13	03-04	14-15	04-05	19-20	02-03	11-12
	TGS-2020502871	JTC Summit (Weekend)	03 & 10	-	05 & 12	-	07 & 14	-	02 & 09
	TGS-2020502871	Mountbatten Square (Weekend)	-	22 & 29	-	02 & 09	-	04 & 11	-

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

DOWNLOAD REGISTRATION FORM

Our Corporate Partners

What Our Students Say

I attended a course with @ASK Training “Three Kingdoms' Leaderships In Today's context”. It's very interesting to learn about the past different leadership styles which are still applicable to Today's context. The focus on the different leadership qualities on the characters are useful and can be applied to my job. The trainer is also very knowledgeable in this topic.

This is the first time I attended home-based learning using zoom. Ms Zenn was attentive to my needs throughout those 2 days, making sure that I can see what the trainer was writing on the whiteboard and that I could hear the trainer clearly. When the instability of the hotel Wi-Fi led to connectivity issues throughout the course, Ms Zenn went the extra mile by using hotspot to stabilise the connections instead. Trainer, Kwan Liang was also attentive to my needs, making sure that I understood the topics. Even though I was the only participant doing home-based learning, they didn't let me feel that I'm being left out. I want to say a big thank you to ASK Training.

I attended this 2-day content marketing class over zoom, so it is hard enough to keep the lecture interesting, let alone the attention span of adults who have not studied in a long time. To my surprise, the class was engaging and fun with lots of activities to make you think on your toes and gives you great ideas for your own business. Highly recommended.

I have attended numerous training and seminars. I must say that @ASK Training is one of the few which really impressed me. Recently attended 2 ICDL courses with them. It’s team shows strong dedication towards bringing quality training and services to its learners. Quick response from admin staff and an exceptional trainer who went the extra mile to give me additional exercises & coaching in areas which I required further clarifications, all beyond the training hours. It is rare to find such a kind, patient, and passionate trainer.

I attended a full day leadership workshop based on the romance of the three-kingdom, on how we could apply the leadership style of each character in today’s context. I was impressed by how the trainer, Anson, was able to impart his deep understanding of the story to us in English. I highly recommend this course to all English speaking business leaders. This is the only chance to catch a glimpse of the story fully translated and spoken live in front of you. I’d say that ASK Training is not a conventional training company, but one who is innovative and genuinely wanting to impart knowledge.

COURSE FEES AND GRANTS

S$388.80 per participant (Incl. 8% GST)

Click here for UTAP Fundings

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour.

Applicants may use SkillsFuture Credit for this course

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

DOWNLOAD REGISTRATION FORM

Microsoft Excel 2019 – Basic

Course Description

Course Objectives

Create simple formulas and recognize when to use absolute and relative references

Use autofill option and functions such as Sum, Average, Min, Max and Count

Find and replace content and formats and add cell comments

Format text and values into different decimal places, currencies and percentages etc.

Apply protection and print out your worksheets and workbook

View large databases effectively by sorting and filtering records, freezing panes, and splitting and arranging windows

Create simple formulas and recognize when to use absolute and relative references

Use autofill option and functions such as Sum, Average, Min, Max and Count

Find and replace content and formats and add cell comments

Format text and values into different decimal places, currencies and percentages etc.

Apply protection and print out your worksheets and workbook

View large databases effectively by sorting and filtering records, freezing panes, and splitting and arranging windows

Course Outline

Course Fees And Grants

Course Schedule

Registration

Our Corporate Partners

What Our Students Say

Check Out Other Courses

Data Analysis with Microsoft Excel DASHBOARD Reporting for Management

Microsoft Access 2019 – Advanced

Microsoft PowerPoint 2019 – Basic and Intermediate

COURSE FEES AND GRANTS

REGISTRATION

Contact Us

Operating Hours

Courses

Sitemap