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.
Training / Course Outline:
1. Introduction To Spreadsheets
A brief outline and overview of what Excel is and its general capabilities in the
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
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