المدرب : مفيد سمارة
Introduction
This training program aims to equip participants with the knowledge and skills necessary to use intermediate features of Microsoft Excel, enhancing their efficiency and productivity in daily tasks.
General Objective
Enable participants to understand and utilize essential and advanced tools and functions in Microsoft Excel to complete tasks efficiently and accurately.
Detailed Objectives
- Understand the Excel interface and navigate its elements.
- Input, format, and manipulate data effectively.
- Use basic and advanced formulas and functions.
- Create charts and graphs for data analysis.
- Format worksheets and prepare them for printing.
- Use sorting and filtering tools to manage data efficiently.
Training Plan
Day 1: Introduction to Excel and Data Handling
Getting Started with Microsoft Excel
- What are Spreadsheets, Worksheets, and Workbooks?
- Understanding the Excel Interface.
- Navigation Options.
- Creating a New Workbook.
Modifying a Worksheet
Entering and editing data.
The Undo and Redo commands.
The AutoFill feature and its options.
The Clear button and working with comments.
Insert, Manipulate, and Delete Cells, Columns, and Rows
Insert and delete options.
Adjusting column width and row height.
Hide and unhide options.
Search for and Replace Data
The Find and Replace commands.
The Go To command.
Day 2: Data Formatting and Calculations
Formatting a Worksheet
Modifying fonts and colors.
The Format Cells dialog box.
Using the Format Painter.
Adding borders and backgrounds.
Aligning Cell Contents
Alignment options.
Indent commands and wrap text.
Orientation and merge & center options.
Applying Cell Styles
Using pre-defined styles.
The Style dialog box.
Performing Calculations
Creating formulas.
The Formula Bar and elements of an Excel formula.
Common mathematical operators and the order of operations.
Inserting and Using Functions
Introduction to Excel functions.
Function Library and common functions.
The Formula AutoComplete feature.
Reusing Formulas
Cut, copy, and paste commands.
Paste special options.
Relative, absolute, and mixed references.
Day 3: Charts and Printing Options
Creating Basic Charts
Selecting data for charts.
Changing chart types.
Working with chart labels.
Printing Workbook Contents
Page layout settings.
Print options in Backstage view.
Advanced printing settings.
Refining Page Layout and Print Options
Zoom options.
Page breaks and print areas.
Print titles and scaling options.
Managing Worksheets and Workbooks
Formatting worksheet tabs.
Changing tab colors.
Managing, repositioning, inserting, and deleting worksheets.
Hiding and unhiding worksheets.
Using worksheet references in formulas.
Managing the View of Worksheets and Workbooks
Split and freeze panes.
Arrange all and arrange windows commands.
View side by side and switch windows options.
Creating a new window for the same workbook.
Using Advanced Functions
Function categories.
Excel function reference and syntax.
Using nested functions.
Automatic workbook calculations.
Showing and hiding formulas.
Sorting and Filtering Data
Difference between sorting and filtering.
Advanced sorting and filtering techniques.
Filter operators.
Removing duplicate values.
| عدد الساعات | المدرب المقترح | تاريخ الانعقاد | الرسوم للاعضاء | الرسوم لغير الاعضاء |
| 21 | مفيد سمارة | 19/4 – 3/5/2025 | 160 | 180 |
