Compuhigh
Download
1 / 35

Microsoft Excel - PowerPoint PPT Presentation


  • 88 Views
  • Uploaded on

CompuHigh. Microsoft Excel. Fasten Your Seatbelts!. What is MS Excel. Is a spreadsheet program designed to create, organize and analyze data. Things you can do with MS Excel. Design Business Form Create Chart Sort List Prepare monthly sales and expense reports Prepare product inventory

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Microsoft Excel' - mckile


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Compuhigh

CompuHigh

Microsoft Excel



What is ms excel
What is MS Excel

  • Is a spreadsheet program designed to create, organize and analyze data.


Things you can do with ms excel
Things you can do with MS Excel

  • Design Business Form

  • Create Chart

  • Sort List

  • Prepare monthly sales and expense reports

  • Prepare product inventory

  • Make loan payments schedules

  • Statement of accounts for tuition fees

  • Computation of Grades


Question 1 3
Question #1-3

  • Give at least 3 things you can do with MS Excel.


The ms excel window at a glance
The MS Excel Window at a Glance

ROW HEADINGS

FORMULA BAR

COLUMN HEADINGS

STATUS BAR

WORKSHEET TABS


Defn of parts
Defn of parts

COLUMN HEADINGS – are usually letters.

ROW HEADINGS – are usually numbers.

FORMULA BAR – one of two places where you can enter or edit a cell’s contents

STATUS BAR – where informative messages about the cells y0u’re working with appear.

WORKSHEET TABS – help you switch between different sheets in a workbook.


Other definitions
Other Definitions

Workbook – the file in which you work and store your data. It is a collection of worksheets.

Worksheet – is a storage of data you’ve entered having grid columns and rows.

- it contains 256 columns and 65,536 rows.


Keyboard shortcuts
Keyboard Shortcuts

  • Up, down, left, right

  • Tab – one cell to the right

  • Shift + Tab – one cell to the left.

  • PageUp – One screen up

  • PageDown – One screen down

  • Alt + PageUp – One screen to the left

  • Alt + PageDown – One screen to the right

  • Ctrl + PageUp – To the active cell in the previous worksheet

  • Ctrl + PageDown – To the active cell in the next worksheet

  • Home – Column A of current row.


Keyboard shortcuts1
Keyboard Shortcuts

  • Ctrl + Home – To cell A1.

  • F5 or CTRL + G – To a specific cell address in a worksheet (type the cell address)


To rename a worksheet
To Rename a Worksheet

  • Right click on the sheet tab you want to rename

  • Click Rename

  • Type the new name.


Inserting new worksheet
Inserting new Worksheet

  • Right click on the sheet tab where you want to insert a new work sheet and then click.

  • From the dialog box, select General tab then Worksheet.

  • Click OK.



Selecting a row column
Selecting a Row/Column

  • To select an entire column/row, click the Column/Row heading.

  • To select a non-adjacent column/row, click the heading while holding down CTRL.

  • To select adjacent rows/columns, click heading while holding down SHIFT key and click the last row.

  • To copy column width/row height

    • Select the column/row heading you want the height to copy.

    • Click Format Painter and drag to select the column/row headings you want to copy to.


Change row height or column width
Change Row Height or Column Width

  • Place your mouse at the top boundary of the row heading until the mouse pointer turns into double headed arrow, then drag to resize your row height.


Change column width row height with the use of column width row height command
Change column width/row height with the use of Column Width/Row height command.

  • Select the row.

  • Click Format menu, then Row.

  • Select Height.

  • Type the row height number and click OK. Do the same with your column

  • Click OK.


Formatting worksheets

Formatting Worksheets Width/Row height command.


Formatting toolbar
Formatting toolbar Width/Row height command.

  • Tool bar used to format a text.

  • Formatting involves making changes to all contents to make it stand out.


Simple formatting
Simple formatting Width/Row height command.

  • Changing Font and Font Size

  • Bold, Italicize or Underline Data

  • Text Alignments

  • Changing Font Color

  • Changing Color Fill


Adding borders
Adding Borders Width/Row height command.

  • Select the cells you want to add borders.

  • Click the arrow on the border button and select available options

    OR

  • Select the cell(s).

  • Click Format Menu then cells.

  • Select available options at the border tab.


Using auto format
Using Auto Format Width/Row height command.

  • Select the cell you want to format

  • Click Format menu then click Autoformat

  • Select from different formats to be applied

  • Click on Options for more modifications

  • Click OK.


Inserting blank cells
Inserting Blank Cells Width/Row height command.

  • Select a range of existing cell where you want to insert the new blank cells.

  • Click insert menu then cells.

  • Select any available options

  • Click OK.


Deleting cells
Deleting cells Width/Row height command.

  • Right Click on the cell and then click delete.

  • Select shift cells up then click OK.


Move cell data
Move cell Data Width/Row height command.

  • Select the cells containing the data you want to move.

  • Move your mouse pointer near the Cell border, when it turns into a four headed arrow, click and drag the cell to its new location. Release the button.


Formulas and functions

Formulas and Functions Width/Row height command.


Formula
Formula Width/Row height command.

  • Formula is an equation that performs mathematical operations on worksheet data.

  • It can perform mathematical operations such as Addition, Subtraction, Multiplication, Division.


Rules for using formula in excel
Rules for using Formula in Excel Width/Row height command.

  • A formula always begins with an equal sign(=)

  • Mathematical Operators:


Rules for using mathematical operations
Rules for using Mathematical Operations Width/Row height command.

  • To control the order of calculation, use Parenthesis.

  • Excel follows the MDAS rule, so

    = 3 + 4*5 is 23, while

    = (3 + 4)*5 is 35.


Entering a formula
Entering a Formula Width/Row height command.

  • Click the cell you want a formula to be entered

  • Type = (equal sign)

  • Enter (type) a formula and press Enter on your keyboard.


Functions
FUNCTIONS Width/Row height command.

  • The biggest asset of excel is its collection of mathematical, financial, statistical and logical functions.

  • Format:

    • FUNCTION NAME(ARGUMENT)


Common functions
COMMON FUNCTIONS Width/Row height command.

  • SUM(num1,num2,…)

    • Calculates total of all values in parenthesis

  • AVERAGE(num1,num2,…)

    • Calculates average of a group of values

  • MAX(num1,num2,…)

    • Finds highest value within list

  • MIN(num1,num2,…)

    • Returns smallest number in a set

  • IF(logical_test,value_if_true,value_if_false)

    • Returns one value if a specified condition evaluates to TRUE, and another value if it evaluates to FALSE.


Autosum
Autosum Width/Row height command.

  • You’ll use this function more than an other.

  • Used to add cell instantly.

  • How to use:

    • Select the range of cells you want to add plus one blank column or row where excel will place the sum of the highlighted column or row

    • Click the AUTOSUM button.


Charts

Charts Width/Row height command.


What is a chart
What is a chart? Width/Row height command.

  • Chart is a visual representation of a selected data on a worksheet. It is a very useful tool to show trends in data, comparison and patterns.

  • It helps you take numbers and turn them into pictures that definitely answer questions.


Chart toolbar buttons
Chart Toolbar Buttons Width/Row height command.

Format Chart Area – formats the selected chart item

Chart type – changes the chart type for an individual data series.

Legend- adds legend to the right of the plot area.

Legend- adds legend to the right of the plot area.


ad