Microsoft Excel ( Spreadsheets ) Daily Work / User

Applying Various Built – In Functions & Formatting Features in Gathering Information from Raw Data etc

Microsoft Excel For Daily User


Target Audience: Anyone who wants to have a grasp on what spreadsheets
have to offer and how they can apply some of the built-in
functions and formatting features of Microsoft Excel.

Learning Outcome: Equipping participants with the necessary knowledge to
understand the capabilities of spreadsheets and how best to
use them for reporting and simple data analysis.

Pre-requisite: Basic understanding of what Excel offers and is capable of
doing with some understanding of spreadsheets.

Training Benefits: Participants will have a better understanding on the
capabilities of using Microsoft Excel in their daily work and
how to apply the various built-in functions and features of it
to gather useful information from raw data.

Excel Daily User

Training / Course Outline:

1. Introduction To Spreadsheets

A brief outline and overview of what Excel is and its general capabilities in the
business world.

2. Understanding the Ribbon

Activating and deactivating the Ribbon.
Adding and removing Command buttons on the Quick Access Toolbar.
Understanding the list of options available to customize default settings.

3. Formatting Worksheets

Creating and Modifying a Worksheet.
Inserting and deleting cells, rows, and columns.
Changing cell formatting.
Applying numeric formats.
Changing data alignment.
Hiding and unhiding columns and rows.
Moving around a sheet using the double click approach.
Shortcut keys to accomplish tasks quickly.
Other techniques to enhance the appearance of a spreadsheet.

4. AutoComplete, AutoFit And AutoFill

Simplify your effort in filling various columns or rows with numbers or text using
the Fill Handle.
Learn to transpose a set of data from rows to columns and vice versa.
Fitting a column width automatically.

5. Working With Formulas

Basics of the SUM, MAX, MIN, AVERAGE and COUNT formulas.
Incorporating above formulas within different sheets and files.
Introducing the IF function for “what-if” analysis.

6. Creating Charts

All you need to know about charts in a simplified way and how it can help you
analyze data for better business decision making.
Understanding Pie Charts; Bar Charts; Column Charts; Line Charts
Modifying chart layouts.
Converting one type of chart to another.

7. Other features

Inserting Comments.
Sorting Data.
Applying Headers and Footers.
Modifying Page Properties.
Changing default options.

8. Analyzing raw data

Basic analysis of raw data using functions and features covered above