1. INTRODUCTION
What is Excel
But how big is it?
2. MICROSOFT EXCEL START
To start Microsoft Excel
Windows mode
3 CREATING, OPENING AND SAVING FILES
Screen Appearance
To activate another cell
To scroll through the spreadsheet
To save a document
To quit Microsoft Excel
Find File
4 DATA INPUT TECHNIQUES
Entering data into a cell
Entering data into a selection
Canceling an Invoice
Entering Numbers
Text
Select and move within a workbook.
5 FORMULA CREATION
Entering formulas
The formula bar
Automatic Sum
Follow the hierarchy
Error in formula
Copy formula
|
|
6 MODIFICATION OF DATA OF A WORKING LEAF
Changing
the content of a cell
Delete
or delete cells, rows, or columns
Elimination of cells
Cell Clearance
Cancel errors
Repeat the last
operation
Copying and
Moving Cells
Effects
of Copying and Moving Cells.
Using
the Copy, Cut, and Paste commands.
Moving cells.
Inserting
cells between existing cells.
Paste multiple copies.
Dragging cells.
Spell
check and correction of typing errors.
7 FORMATING WORK LEAVES
Application of
formats.
Fonts.
Numbers.
Alignment.
Applying
Borders, Shadings and Background Patterns.
Entering dates or
hours.
Enter
dates or hours in formulas.
Automatic
formatting.
8 PRINT
To
preview a print job.
Selecting
print with the command: Print Area.
Change print
options.
To
center the spreadsheet data on the page
To
hide the grid while printing
To
print black and white color formatting
Think about margins
Header and
footer.
Editing
header and footer.
Printing the Sheets.
|
|
9 USING GRAPHICS
What is a Graph
Creating a chart
Editing a chart
Edit text
10 CREATING DRAWINGS
Graphic objects in worksheets and graphs
Notes on creating shapes, lines, freehand figures and other objects
11 MORE ON THE FORMULA
Automatic filling.
Autocomposition Function
12 MICROSOFT EXCEL PERSONALIZATION
ACCORDING TO THE REQUIREMENTS OF THE USER
Toolbar
Creating Custom Toolbars
Add or delete a button from the Toolbar
|