microsoft excel (crv)

MICROSOFT EXCEL ( Quickest Route to being a PRO in MS Excel Spreadsheet)

Ibiyemi Ademola Adedamola( www.angeldharmmy.blogspot.com)

TABLE OF CONTENTS

Ms Excel (An Introduction)

The 3C(s) of Ms Excel

The 3C(s) table

The MS Excel interface

The CR-V of Ms Excel

The CR-V table

Understanding the Mouse in MS Excel

The styles of editing

Alignment Exposed

Ibiyemi Ademola Adedamola ( www.angeldharmmy.blogspot.com)

Ms Excel (An Introduction)

MS Excel is a Spreadsheet Software that was developed my the Software giant

company Microsoft as an integral application in its Microsoft Office Suite

package.

It is prominently used for analysis and calculations in many a organization.

It has several file saving types such as .csv, .xls, .xlsx, .xlsb. .xlst and many more

Ibiyemi Ademola Adedamola

( www.angeldharmmy.blogspot.com)

The 3C(s) of Ms Excel

Comparism

Categorization

Calculation



The 3C(s) of MS Excel Table



S/N Comparism Categorization Calculations

1 Table Custom List In built Financial

Formulae

2 Diagrammatic Charts Conditional Formatting Customized Equations

3 Date and Time

Formulae

Sort and Filter In built Statistical

Formulae

4 Pictures Pivot charts Math and Trig Formula

How to Open MS Excel

There is a Different between Update and Upgrade. An Update is a change

in type while a Upgrade is a change in Form.

Upgrade example is a change from Windows XP to Windows 7 and a later

change to Windows 8

Update example is an addition of softwares or scripts on the same operating system or application.

In all the changes in Operating System what really changes is how people

“SEARCH”



How to Open MS Excel in windows 7



Click on the windows icon

Type “Excel” inside the pop up box

Press “Enter”

Step 1

Step 2

Step 3




Just Type “Excel”

and press Enter

Typing in MS Excel

The Excel interface is made up interlocking lines. The connection of two

interlocking lines Vertically (from up to down) and Horizontally( from Right to

left) forms what is known as a CELL.


The Syntax in MS Excel

Workbook

SheetSheets Sheets

CellsColumns(Vertically) Rows (Horizontally)

Cell

Cell Cell


DICTONOMY



COLUMN

( From top to bottom)

ROW

(RIGHT TO LEFT)

The CR-V of Ms Excel

All Text editing in Microsoft Excel can be summarised in two ways:

By Address i.e. Column-Row Nomenclature (CR)

By Value i.e. Text written in the Cell (V)

In order words CR - V

Ibiyemi Ademola Adedamola( www.angeldharmmy.blogspot.com)

The CR-V in MS Excel Interface


Address Box

olumn- ow Box

( -Box)

Formulae Bar

alue-Box

( -Box)

The CR-V tableolumn- ow (CR) alue (V)

Editing Type ON Cell IN Cell

Icons All Icons are available for

use

After Font Ribbon, Every other

Icon is grey(on available for Use)

Calculations Transient dependent on Cell

Changes

Static as it is dependent on

values in the Cell

Syntax C(in Letters), Rows ( in

Numbers) LOCKED (LN) ie

( A(letter) – 1(Number))

Value is either A- Alphabets, N-

Numbers, S- Symbols i.e.

(ANS) it is not strictly meant to follow

any SYNTAX

Highlighting It is based on Cell and

effected mostly with Borders

and icons after “FONT”

Text or Cell Content Based



After Font Ribbon, Every other Icon is

grey(not available for Use)



Value can be:

A:Alphabet

N:Number

S:Symbols

GREY:

Not Highlighted

BY ADRESS (CR)



All Icons were Highlighted:

meaning they affect more

than the Text inside the

Cell




• Yes Button

• Execute Button

• Do Button

• Click

On Laptop




• Yes ,but Button

• Options Button

• Maybe Button

• Check Others

On Laptop

The Right Click Button in Practical Usage



• Options Button

• Maybe Button

• Yes, But Button

• Maybe Button

The “READY” MOUSE ICON



The “EDIT” MOUSE ICON



Edit blink Icon shown there

The “RESIZE” MOUSE ICON



HOLD Left Click to Populate



TEXT ALIGNMENT



Coming soon: Microsoft Excel Pro

(CRV- 2)



www.angeldharmmy.blogspot.com

[email protected]


Ibiyemi Ademola Adedamola www.angeldharmmy.blogspot.com

mailto:[email protected]