CSS DropDown Menu


 

Course Program EXEL

 

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