حضوري
Works Academy248,000 IQD
رسوم الدورة124,000 IQD248,000 IQDسجّل في هذه الدورة
تُعقد في مركزنا
تُعقد هذه الدورة حضورياً في مركزنا بدهوك. سجّل هنا أو اتصل بنا لمعرفة المواعيد القادمة.
عن هذه الدورة
Target Audience: Beginners in Microsoft Excel Daily Session Duration: 2 hours Total Duration: 10 hours Day 1: Introduction to Excel and Navigating the Interface Objectives: • - Understand what Excel is and its uses - Familiarize with the main interface of Excel Content: - What is Excel and why use it? - Opening and saving files - Exploring the Excel interface (Ribbon, Columns, Rows, Cells, Worksheet) - Navigating…
اقرأ المخطط كاملاًعن هذه الدورة
Target Audience: Beginners in Microsoft Excel Daily Session Duration: 2 hours Total Duration: 10 hours
Day 1: Introduction to Excel and Navigating the Interface
Objectives:
•
- Understand what Excel is and its uses - Familiarize with the main interface of Excel
Content:
- What is Excel and why use it? - Opening and saving files - Exploring the Excel interface (Ribbon, Columns, Rows, Cells, Worksheet) - Navigating between cells - Entering and editing data - Basic cell formatting (font color, size, type, alignment)
Practical Exercise: Create a simple student or sales table and apply formatting.
Day 2: Formatting and Sorting Data
Objectives:
•
- Improve the presentation and organization of data
Content:
- Number formatting (Currency, Percentage, Dates) - Borders and cell shading - Using Conditional Formatting - Sorting data (Ascending and Descending)
- Filtering data (AutoFilter)
Practical Exercise: Create a sales table with conditional formatting to highlight sales over 1000.
Day 3: Basic Formulas and Functions
Objectives:
•
- Enter basic mathematical formulas - Use simple functions
Content:
- Difference between formulas and functions - Basic arithmetic operations (+ - * /) - SUM function - AVERAGE function - MIN and MAX functions - COUNT function
Practical Exercise: Calculate the total and average grades or product prices.
Day 4: Managing Tables and Merging Data
Objectives:
•
- Organize data effectively within tables
Content:
- Creating tables (Insert Table) - Table formatting - Sorting data within tables - Merging cells - Freezing panes (Freeze Panes) - Auto Fill using the fill handle
Practical Exercise: Create an employee salary table with sorting and freeze the top row.
Day 5: Charts and Printing Preparation
Objectives:
•
- Visually present data - Prepare the file for printing
Content:
- Types of charts (Column, Pie, Line) - Creating and formatting charts - Print settings (Margins, Orientation, Preview) - Inserting Header/Footer - Saving as PDF
Practical Exercise: Create a chart from a sales table and prepare it for printing.
Final Notes:
- Reserve the last 15 minutes of each session for Q&A or quick review. - Consider a simple test or mini-project on Day 5.
Day 1: Introduction to Excel and Navigating the Interface
Objectives:
•
- Understand what Excel is and its uses - Familiarize with the main interface of Excel
Content:
- What is Excel and why use it? - Opening and saving files - Exploring the Excel interface (Ribbon, Columns, Rows, Cells, Worksheet) - Navigating between cells - Entering and editing data - Basic cell formatting (font color, size, type, alignment)
Practical Exercise: Create a simple student or sales table and apply formatting.
Day 2: Formatting and Sorting Data
Objectives:
•
- Improve the presentation and organization of data
Content:
- Number formatting (Currency, Percentage, Dates) - Borders and cell shading - Using Conditional Formatting - Sorting data (Ascending and Descending)
- Filtering data (AutoFilter)
Practical Exercise: Create a sales table with conditional formatting to highlight sales over 1000.
Day 3: Basic Formulas and Functions
Objectives:
•
- Enter basic mathematical formulas - Use simple functions
Content:
- Difference between formulas and functions - Basic arithmetic operations (+ - * /) - SUM function - AVERAGE function - MIN and MAX functions - COUNT function
Practical Exercise: Calculate the total and average grades or product prices.
Day 4: Managing Tables and Merging Data
Objectives:
•
- Organize data effectively within tables
Content:
- Creating tables (Insert Table) - Table formatting - Sorting data within tables - Merging cells - Freezing panes (Freeze Panes) - Auto Fill using the fill handle
Practical Exercise: Create an employee salary table with sorting and freeze the top row.
Day 5: Charts and Printing Preparation
Objectives:
•
- Visually present data - Prepare the file for printing
Content:
- Types of charts (Column, Pie, Line) - Creating and formatting charts - Print settings (Margins, Orientation, Preview) - Inserting Header/Footer - Saving as PDF
Practical Exercise: Create a chart from a sales table and prepare it for printing.
Final Notes:
- Reserve the last 15 minutes of each session for Q&A or quick review. - Consider a simple test or mini-project on Day 5.
لا توجد تقييمات بعد.
دورات ذات صلة
حضوريWorks Academy
حضوريWorks Academy330,000 IQD
حضوريWorks Academy165,000 IQD
حضوريWorks Academy825,000 IQD
وظائف ذات صلة
وظائف على Works Jobs تتطلب ما تتعلمه في هذه الدورة.
