|
The
Excel Interface
-
Workbooks and Worksheets
-
Columns, rows and Cells
-
Selecting a Cell
-
Fill Handle
-
Adding and Renaming Worksheets in a Workbook.
-
The Standard Toolbar
-
Formatting toolbar
-
Formula bar
Excel Basics
-
Moving Through Cells
-
Selecting Cells
-
Resizing Rows and Columns
-
Deleting Rows, Columns or Cells
-
Cutting, Copying and Pasting Cells
-
Clear Rows, Columns or Cells
-
Paste Special
Formatting
-
Format Cells Dialog Box
-
Number tab
-
Alignment tab
-
Font tab
-
Border
-
Pattern tabs
-
Protection Tab
-
Formatting Toolbar
Formulas and Functions
-
Formulas
-
Relative Functions
-
Absolute Functions.
-
Mixed referencing
-
Basic Functions
-
Math and Trig
-
Statistical
-
Logical
-
Conditional Formatting.
-
Goal Seek
|
|
Sorting
and Filling
-
Basic Ascending and Descending sorts
-
Complex Sorts
-
Fill Down and Fill Right
-
Autofill
-
Autofilling Functions
Graphics and Drawing
-
Adding Clip Art
-
Add An Image from a File
-
Drawing in EXCEL
-
Lines, Rectangles
-
Text Box
-
Autoshapes
-
Lines
-
Word Art
-
Drawing Dialog Box
Charts
-
The Chart Wizard
-
Chart Types
-
Chart Source Data; Data Series
-
Chart Options
-
Gridline formats
-
Y-axis formats and scale
-
X-axis formats and scale
-
Trendlines
-
Chart locations
-
Copy a chart to Microsoft Word
Page Properties and Printing
-
Page Breaks
-
Page Setup
-
Page Tab
-
Margins Tab
-
Sheet Tab
-
Print Preview
-
Print
-
Printer
-
Print Range
-
Print What
-
Copies
|