Microsoft Excel - Introduction هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

This course is designed for busy people who need to know how to get the best from their applications from the outset. If you are new to Excel or have not used Excel in its proper capacity for creating spreadsheets, then this Introduction course will get you started.

The course will identify and describe the component features that make up Microsoft Excel and introduce you to working with them. Participants will be taught how to plan and construct basic Excel spreadsheets for forecasting and general numeric work. Delegates will be able to create formulae and work with a selection of functions. Users will progress on to produce simple charts from the spreadsheet data they have created.

Introduction to Microsoft Excel

• What Is Excel?
• Excel File Types
• Excel Environment
• Toolbars
• Office Assistant

Workbooks and Worksheets

• Creating And Opening Workbooks
• Working With Workbooks
• Working With Worksheets
• Working With Cells
• Navigating Within A Worksheet
• Navigating The Workbook

Spreadsheet Data

• Entering Data
• Using Time Saving Features
• Checking The Spelling

Formatting and Customising Data

• Selecting Items In Excel
• Formatting Text
• Formatting Numbers
• Manipulating Data
• Formatting Columns And Rows
• Formatting With Colours And Patterns
• Adding And Editing Borders
• Using Auto Format

Editing Spreadsheets

• Cutting, Copying, And Pasting
• Inserting And Deleting
• Using Find And Replace
• Using Undo And Redo

Formulas and Functions

• Entering Formulae
• Entering Functions
• Using Named Cells and Ranges In Formulae

Printing

• Using Page Setup
• Margins
• Headers and Footers
• Printing a Spreadsheet