At Last

At last,

We're finished ..

Thank you for reading ..

And Thanks also to Sir Tomas ...

Goodbye !! :D :D

Macros

Hmm..

Macros are used to format a cell using specific keys.

Just record it.. Then, when you pressed the key you assigned,

The selected cell will change the format to what you have recorded..

That's all..

Charts

There are diff. types of charts.
Some of them are :

Column Chart - useful for showing data
changes over a period of time or
for illustrating comparisons among
items.

Pie Chart - show the size of items in one
data series, proportional to the
sum of the items.

Line Chart - display continuous data over time.
Bar Chart - illustrate comparisons among individual items.

Area Chart - emphasize the magnitude of
change over time.


To use charts, go to the Insert option ..

Next : Macros

Conditional Formatting

This applies unique cell formatting based on a certain condition by using a rule.

Adding a new rule means adding a formula that contains a condition and add new formatting.

For example : =A1="FAILED"
          The formula will result to TRUE or FALSE.

If that formula is true or false, the format to be set will be applied to the cell.

Next up : Charts

IF Function

The function IF

          -returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

This is the syntax :

          IF(logical_test, [value_if_true], [value_if_false])

For example :
          =IF(K9>=75,"PASSED","FAILED")


That's all ..



Next : Conditional Formatting

Logical Operations

There are 3 logical operators..

AND,OR and NOT 

Function :

=AND( logical1, logical2, … )
=OR( logical1, logical2, … )

=NOT( logical)

Only that :)

Next : The IF

Cell Reference

Cell Reference

A9 – single cell
A9,A15 – cell A9 and cell A15
A9:A15 – range from A9 to A15 (same column)
A9:Z9 – range from A9 to Z9 (same row)
A9:Z19 – range from columns A to Z and rows 10 through 20

There are also reference types..

Relative - automatically changes when the
formula is copied down a column or
across a row

Absolute - cell reference is fixed, doesn’t
change when copied to other cells.
Uses $ sign like: $A$2

Mixed - has either an absolute column and
a relative row, or an absolute row and a
relative column.
Like A$4 or $A4 


You can refer to another sheet or workbook, too

Same file

– Manual selection
– Use a formula
          Ex: Sheet2!A1

Different file
– Manual selection
– Use a formula
          Ex: [File2.xlsx]Sheet1!$A$1


Next up : Logical Operations

Functions and Formulas

Hello....
Functions and Formulas/Formulae ... Hmmm..


Let's start..

Formula
          * an expression used to perform calculations
          * always begin with an equal ( = ) sign
          * it may contain constants, cell references, ranges,etc.

For example :
         =A1+A2
         =A4*A5

Next,

Function
          * predefined formula
          * may require arguments as inputs

Example :
          =SUM(A1,A2)
          =PRODUCT(10,5)

There are some errors sometimes you will notice,
Some are :
          ####
          #NAME?
          #NULL!


Next : Cell Reference

Spreadsheet for Data Analysis

Hi .. Everyone ..

We are now about to discuss how MS Excel is used..

~~Tendeden!!~~

Okay ..

What is MS Excel ?

It is a spreadsheet app which is used to organize some data..

An Excel file is called a workbook.

Worksheet is the page where you work.

The cells are the places which you put the data ..

It is arranged in rows and columns

The Column/Row Heading is used to identify a cell's position on the worksheet.

The name box holds a cell's selected reference number.

In Excel, there are some shortcuts like :

Alt + Enter

Alt + ;

Alt + :

Data type is a standardized representation for a particular kind of data.

Some examples are :

893,392,458,155,717.6808

June 14,2001

True

False

Finished ...

Next : Discussion about Functions and Formulas :)

Introduction

Hi.. Guys

I'm here to introduce you to the topics in the 3rd quarter...

Starting from Spreadsheet for Data Analysis.

Then, Functions and Formula.

Then, Cell Reference.

Then, Logical Operation.

Then, the IF.

Then, Conditional Formatting.

Then, Charts.

And finally, Macros.

Next : Discussion on Spreadsheet for Data Analysis..