Data Analysis using Excel 7 DEC

Specialties Management courses

EGP 4000

Description

Course Objectives
•   Build a solid understanding on the Basics of Microsoft Excel
•   Learn the most common Excel functions used in the Office
•   Harness the full power of Microsoft Excel by automating your day to day tasks
•   Maintain large sets of Excel data in a list or table
•   Create dynamic reports by mastering one of the most popular tools, PivotTables
•   Wow your boss with powerful insights
•   Connect & Load your data from different extension sources
•   Transform data using power query
•   Modeling data
•   Visualize your data using Power Bi

Course Language
• Arabic but most terminology is in English.
• Training can be presented in English only based on request.

Course Methodology
Training methods and techniques are almost infinite in their variety. They can be used on their own or in creative combination. However, they should be chosen carefully to fit the activity, the nature of participants, the cultural milieu and the facilities available for using them. We use different methodologies in training to ensure good communication of information to all trainees - but not limited to the following:

•   Lectures and PowerPoint Presentation
•   Case Studies, Self-Questioner and Real-World Scenarios
•   Visual Aid (Videos Simulation)
•   Brainstorming (Perception Activity)
•   Gamification (Puzzles)

Course Prerequisites
• Laptops should provide with each participants

Course Assessment & Certification
• This course is assessed by Three main project (Power Query+ Power pivot+ power Bi)
• Trainees will receive A4 Certificate and course transcript from ita.co (R.N: 12909)

Courses Video

section 1: Lec 1 : Dynmaic Dashboard & Print Layout
- Working File Locked
  
  60 minute
- Assignment Locked
  
  60 minute
- Recorded Lecture-Part1 Locked
  
  60 minute
- Recorded Lecture-part2 Locked
  
  60 minute

section 2: Lec 2: Power Query
- Working File Locked
  
  60 minute
- Recorded Lecture Locked
  
  60 minute

section 3: Lec 3 :Merge Quries
- Working File Locked
  
  60 minute
- Working File-2 Locked
  
  60 minute
- Working File-3 Locked
  
  60 minute
- Recorded Lecture Locked
  
  60 minute

section 4: Lec 4 : Connect Excel
- Working File Locked
  
  60 minute

FAQ's

Are there discounts?

Yes, in the case of friends, relatives and sisters
Do you have online and offline courses?

Yes, we have online and offline courses
Is there hall rental?

Yes, we have multiple systems for renting halls
Are there installment systems?

Yes, we have it
What are installment systems?

If the course amount is more than one thousand Egyptian pounds
-    30% of the course/course/workshop price is paid as an advance payment for the reservation.
-    Then 30% after the third lecture
-    Then 30% in the fifth lecture
If the course is less than a thousand pounds
-    50% is paid for the reservation
-    50% maximum for the second lecture

FAQ's

sections: 4
Feature: Yes
Duration: 20 Hours
Specialties: Management courses
Quizzes: Yes
Language: English
Certificate: Yes

Data Analysis using Excel 7 DEC

Data Analysis using Excel 7 DEC

Description

Course Language
• Arabic but most terminology is in English.
• Training can be presented in English only based on request.

•   Lectures and PowerPoint Presentation
•   Case Studies, Self-Questioner and Real-World Scenarios
•   Visual Aid (Videos Simulation)
•   Brainstorming (Perception Activity)
•   Gamification (Puzzles)

Course Prerequisites
• Laptops should provide with each participants

Course Assessment & Certification
• This course is assessed by Three main project (Power Query+ Power pivot+ power Bi)
• Trainees will receive A4 Certificate and course transcript from ita.co (R.N: 12909)

Courses Video

FAQ's

Course Syllabus

Register now

Data Analysis using Excel 7 DEC

Data Analysis using Excel 7 DEC

Description

Course Language • Arabic but most terminology is in English. • Training can be presented in English only based on request.

• Lectures and PowerPoint Presentation • Case Studies, Self-Questioner and Real-World Scenarios • Visual Aid (Videos Simulation) • Brainstorming (Perception Activity) • Gamification (Puzzles)

Course Prerequisites • Laptops should provide with each participants

Course Assessment & Certification • This course is assessed by Three main project (Power Query+ Power pivot+ power Bi) • Trainees will receive A4 Certificate and course transcript from ita.co (R.N: 12909)

Courses Video

Related Courses

Data Analysis using Excel & Power Bi course

Electronic marketing course

Accounting course

Advanced Excel

Digital marketing 28 November

FAQ's

Course Syllabus

Register now

Course Language
• Arabic but most terminology is in English.
• Training can be presented in English only based on request.

• Lectures and PowerPoint Presentation
• Case Studies, Self-Questioner and Real-World Scenarios
• Visual Aid (Videos Simulation)
• Brainstorming (Perception Activity)
• Gamification (Puzzles)

Course Prerequisites
• Laptops should provide with each participants

Course Assessment & Certification
• This course is assessed by Three main project (Power Query+ Power pivot+ power Bi)
• Trainees will receive A4 Certificate and course transcript from ita.co (R.N: 12909)