EXCEL BASICS

1
EXCEL BASICS

• Toolbars
• Formula Bar
• Document Window
• Worksheet Area
• Worksheet Tabs
• 65536 rows
• 283 columns

2
ENTER TEXT AND NUMBERS

• Cell Address A5 B7 C13 D98
• Intersection of a row and column
• F5 is GOTO key
• Ctrl-Home goes to Cell A1

3
ENTER FORMULAS, FUNCTIONS

• Math Operators - / ( )
• Automatic Recalculation
• Formulas A1A2
• B2F4
• (B7B3)A4
• Functions Function Wizard name(range)
• average(A1A25)
• sum(A1A25)
• min(A1A25)
• max(A1A25)
• now()
• today()

4
CORRECT DATA

• Undo on Toolbar
• Retype the contents of the cell
• Click on Edit, Delete
• Click Edit, Clear
• Double click on the cell

5
SAVE A WORKSHEET

• Click on File, Save As
• Select the correct drive and path
• Type the name of the file to save
• Click OK

6
PRINT A WORKSHEET

• Print Preview
• Click File, Print
• Page Setup
• Landscape vs portrait
• Margins
• Remove gridlines
• Add row and column headings
• Add header and footer

7
CLOSE A WORKSHEET

• Click on File, Close
• Close will close the Excel file
• Exit will close the file and exit
  the software

8
SELECT A RANGE

• MOUSE SYMBOLS
• Highlight (white cross)
• Move (white arrow)
• Fill (black cross)
• SELECT A RANGE
• Adjacent Select first cell, Hold Shift,
  Select last cell
• Non Adjacent Select cell, Hold Ctrl,
  Select next cell

9
CUT, COPY, PASTE

• Steps Highlight text to cut or copy
• Select cut or copy
• Place cursor at point where text should
  appear
• Select paste
• Ways Drag Drag and Drop to Move
• Autofill Fill handle to copy
• Menu Click Edit, Copy
• Toolbars Click Copy Icon
• Right mouse Right click the mouse, select
  copy
• Keystrokes Ctrl-C, Ctrl-X, Ctrl-V

10
INSERT AND DELETE COLUMNS AND ROWS

• Row Click Insert, Row
• Column Click Insert, Column
• Row Click Edit, Delete
• Column Click Edit, Delete

11
CHANGE COLUMN WIDTH

• Best Fit Double click on right border of
  column heading
• Drag and Drop Drag right border of column
  heading
• Menu Click column heading, Format, Column,
  Width
• Several columns Select three columns, use
  drag and drop on last column

12
FORMAT CELLS

• Steps Highlight text to format
• Then click on format feature
• Ways Menu Format, Cell
• Toolbars Click on icon
• Right mouse Right click, Format Cells
• Features Bold, Italics, Underline, Borders,
  Text Colors,
• Background Colors, Patterns, Font, Font
  Size, Bullets, Currency, Decimals
• Autoformat Highlight range or worksheet
• Click Format, Autoformat
• Select format you prefer

13
WORKSHEETS

• RENAME WORKSHEETSDouble click on Sheet 1Retype
  the name
• INSERT AND DELETE WORKSHEETSRight click on sheet
  to insert or deleteOR Click on Insert, Worksheet
• MOVE AND COPY WORKSHEETSClick mouse on Sheet
  nameDrag mouse with sheet icon to designated
  place and drop

14
CREATE CHARTS

• Keystrokes Use F11 to create Excel Default
  Chart
• Toolbars Use Chart Wizard to create charts
  Range Type of chart
  Display data (rows vs columns)
  Titles Display chart

15
EXCEL WINDOWS

• Click on Window
• Open documents in Excel will be displayed
• Click to see a different document
• FREEZE HEADINGS ON WINDOWS
• Click on Windows, Freeze Pane Freeze
  Rows Freeze Columns
  Freeze Rows and Columns

16
EXCEL DATABASE

• Fields (columns)
• Records (rows)
• Sort
• Filter

17

• THE END