Data Analysis using Excel 7 DEC

Data Analysis using Excel 7 DEC

10
EGP 4000
image

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

image

FAQ's

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

Course Syllabus

  •  Fast revision on the basic of excel    
  • Pivot table & Dashboard
  • Power Query    
  •  Data Modeling
  •  DAX 
  •  Visualization using Excel & power bi

Register now

Country code*
  • Country code*
  • egypt 002
  • Saudi Arabia 0966
  • Iraq 0964
  • Libya 218
  • Palestine 0972
  • UAE 0971
  • Jordan 962
  • Kuwait 0965
  • qatar 974
  • Yemen 967
  • Morocco 212
  • Sultanate of Oman 968
  • Bahrain 973
  • Tunisia 216
  • Syria 963
  • Lebanon 961
  • other
the time
  • the time
  • from 10 to 12
  • from 12 to 2
  • from 2 to 4
  • from 4 to 6