Data Analysis using Excel 7 DEC

Home
Courses

Data Analysis using Excel 7 DEC

Data Analysis using Excel 7 DEC

Specialties Management courses

10

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

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

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

Register now