Microsoft Excel – Basic

Nett Course Fee
$436

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 – 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.

Prerequisites

To enrol in this course, you should possess the following:

(≥ 16 years old); or
1 year working experience

Ideal for beginners with essential computer knowledge such as managing files (open, save, etc.) and familiarity with Microsoft Office would be advantageous.

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

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 – Intermediate

The ‘Microsoft Excel – 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 – Advanced

The ‘Microsoft Excel – 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