Topic 1 Introduction to Excel.
1. What is Microsoft Excel?
It is a software developed and manufactured by Microsoft Corporation that allows users to
organize, format, and calculate data with formulas using a spreadsheet system broken up by rows
A PivotTable lets you rearrange worksheet data so
you can analyze it in a variety of ways.
Allow for data aggregation and disaggregation
A PivotChart can be created to graphically display
The slicer includes column heading
Topic 3 Changing Cell Appearance
In this topic, we will learn to change cell appearance by use cell operation, hide and unhide cell, and use
reference from different work sheet to write simple function.
You can find cell operation in Home
What Are Functions? (1 of 2)
A function is a shorthand way to write an equation
that performs a calculation.
A formula with a function has three parts:
The equal sign identifies the cell contents as a
The function name identifies the operatio
A chart is a graphical representation of data.
The four most commonly used charts are a column
chart, a line chart, a pie chart, and a scatter chart.
These charts as well as several other types of charts
are available in the Charts group on
Excel offers powerful functions to count, sum, and
locate specific information.
To find the total number
of cells that have
numeric data, use th
Topic 4 Cell Manipulation
Highlight Cells Rules
To highlight cells that are greater than a value, execute the following steps.
1. Select the range A1:A10.
2. On the Home tab, click Conditional Formatting, High
Introduction (1 of 2)
Importing refers to bringing data from other programs
into an Excel workbook.
Exporting refers to taking Excel data from a
workbook and sending it to another program or to the
The Document Inspector can be used to find hidden
Introduction (1 of 2)
Excel has several features that enable you to work
efficiently and accurately with data.
Data Validation feature is used to set rules about how
data can be entered.
Circle Invalid Data feature places circles around any
Topic 2 Basic Formula in Excel
1. Excel AutoSize column
1. Position your mouse over the column line in the column heading so the white cross
a double arrow .
2. Double click on the column line to use the AutoSize feature
3. You can use t