Advanced Excel

Advanced Excel

  • 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 by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

5
EGP 1200
image

Description

Target Audience 

All employees and Managers/Directors (All Disciplines)

Course Language

Arabic but most terminology is in English.

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.

EDUCATION ita- TRAINING ENGINEERING 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)

image

FAQ's

  • sections: 0
  • Feature: Yes
  • Duration: 21 Hours
  • Specialties: Management courses
  • Quizzes: Yes
  • Language: Arabic
  • Certificate: Yes

Course Syllabus

  • Data Quality
  • Excel interface
  • Types of References
  • Handle Fill
  • Formatting 
  • Filter – find – replace – Conditional Formats
  • Shortcuts
  • Basic Formulas
  • Most Common used Functions
  • Counts 
  • Logical test & Functions
  • Define Names & drop List
  • Look up Formulas
  • Goal Seek
  • Sum Ifs – Counts Ifs

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