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