fbnoscript

Microsoft Excel 2019 – Basic

Nett Course Fee
$392.40

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

Course Outline

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

  • Overview of Formulas and Cell Reference
  • Entering Formulas
  • Absolute and Relative References
  • Formulas with Multiple Operators
  • Using Functions
  • Referencing External Data

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

  • Navigating a Worksheet
  • Entering Labels and Values
  • Editing Cell Contents
  • Selecting Cells and Ranges
  • Entering Data in a Selected Range
  • Entering Content Automatically

Editing a Worksheet

  • Copying and Moving Cells
  • Controlling How Cells Are Pasted
  • Collecting Items to Move or Copy
  • Checking Spelling
  • Using and Customizing AutoCorrect
  • Insert &Delete Cells, Rows, and Columns
  • Finding and Replacing Content & Formats
  • Cell Comments

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

Related Courses

WSQ Microsoft Excel Essentials (Up to 70% SkillsFuture Funding)

The ‘WSQ Microsoft Excel Essentials’ course focuses on using Microsoft Excel, the widely used spreadsheet tool, for tasks related to data analytics, business, and research. It covers foundational concepts in applying business statistics, analytical skills, and quantitative techniques within the Excel environment as well as practical hands-on skills in manipulating data for your needs.

Course Duration:
2 Days (9.00am – 6.00pm)

View course details here

Microsoft Excel 2019 – Intermediate

The ‘Microsoft Excel 2019 – Intermediate’ 2-day course enhances your Excel proficiency by covering data management, protection, table and chart creation, formula usage, error tracing, name management, sorting, filtering, as well as introducing VLOOKUP, IF functions, and basic Pivot Tables for impactful data reporting.

Course Duration:
2 Days (9.00am – 5.00pm)

View course details here

Microsoft Excel 2019 – Advanced

The ‘Microsoft Excel 2019 – Advanced’ 2-day course delves into advanced functions including text, date, and lookup formulas, addressing formula errors, name management, data consolidation and analysis, pivot table creation, and macro recording for automating repetitive formatting tasks in spreadsheets.

Course Duration:
2 Days (9.00am – 5.00pm)

View course details here

Microsoft Excel 2019 – Basic

Course Duration:

2 Days (9.00am – 5.00pm)

Course Fee Details:

$392.40 (incl. of 9% GST)

SkillsFuture Credits & UTAP claimable

SDF grant entitled, $2/hr x 14hrs = $28
Eligible for Singaporeans, and PR employees

Course Code: TGS-2020502871

Course Schedule

Course CodeVenueOctober 2024November 2024December 2024January 2025February 2025March 2025
Microsoft Excel 2019 BasicTGS-2020502871International Plaza02-03
TGS-2020502871JTC Summit03-0411-1202-0306-07
TGS-2020502871Mountbatten Square10-1114-1512-1313-1413-1403-04