Transcript USING WORKSHEETS TO MAKE BUSINESS DECISSIONS

USING WORKSHEETS TO
MAKE BUSINESS
DECISIONS
BY
DR. ENNIS - COLE
OBJECTIVES:
• Start and Exit Excel
• Discover how Excel is used in Business
• Identify the major components of the Excel
Window
• Navigate an Excel workbook and worksheet
• Open, save, print, and close a worksheet
OBJECTIVES:
• Enter text, numbers, formulas, and
functions
• Correct mistakes
• Perform what-if analyses
• Clear contents of cells
• Use the Excel Help system
WHAT IS EXCEL?
• A computerized spreadsheet
• A calculating tool to analyze and evaluate
information
• The “document” you create is called a
Workbook
• Documents are made of worksheets or
sheets just like a spiral-bound notebook is
made up of sheets of paper.
EXCEL Basics
• Workbooks let you create, edit, & use
worksheets (sheets)
• Each sheet contains columns (A-IV 256)
and rows (1-65,536)
• Intersections of columns and rows are
called cells
• What is a cell reference, and to hat does the
term active cell refer ?
STARTING EXCEL
•
•
•
•
•
Work on windows desktop
Click Start, Programs
Click Microsoft Excel
Excel opens up
In order to fill the entire screen, click the
maximize button.
THE EXCEL WINDOW
• Toolbars
– Standard and Formatting
• Formula Bar - displays contents of active
cell
• Workbook Window
– Cell reference, active cell
Pointer and Sheet tabs
MOVING AROUND A
WORKSHEET
• Using the Mouse
• Using the Keyboard
• Refer to Figures 1-4 , 1-5, 1-6
and 1-7
OPENING A WORKBOOK
•
•
•
•
•
Click the Open button
Click the Look in list arrow
Click the disk drive
Double click the workbook name
To move to a particular worksheet, click the
Sheet tab (Sheet2, Sheet3, or renamed)
ENTERING TEXT &
VALUES
• Click any cell to make it active
• Type the text and then press the Enter key
• For repeated text, use the Auto complete
feature
• Click any cell and type the number (value),
then press the Enter key
• Refer to Figures 1-13 & 1-14 to enter
formulas (=)
FUNCTIONS
• A pre-defined or built-in programs that perform
calculations – a formula may or may not contain a
function
• A Range is a group of cells
• Type SUM and enter the range of cells you want
summed
• Press the AutoSum Key
• Click any cell and type =SUM(F11:F15).
• Click File, Save As to save a workbook.
What-if Analysis
• When a value is changed, Excel
automatically recalculates the worksheet
and displays the updated results
• This feature is an extremely useful decisionmaking tool
• What if I change the value assigned to this
factor?
• Refer to figures 1-20, 1-21 & 1-22
CORRECTING MISTAKES &
GETTING HELP
• Double-click the cell you want to edit
• Edit the cell’s contents either in the cell or
in the formula bar
• Press the Enter key when complete
• Click Help, Show the Office Assistant
• Refer to figures 1-23, 1-24, 1-225 & 1-26
for Help topics
TO CLEAR, PRINT AND
CLOSE THE WORKSHEET
• Click the cell or range of cells to clear and
then press the Delete key
• Click File, Print, adjust any settings in the
Print dialog box and click OK
• Click File, Close
• Click the “Yes” button.
The End