Microsoft Excel - Advanced Specialised Management Group (SMG)
Price: AED 950
  • Duration: 1 Day
  • Timings Full Time, 09:00am - 4:00pm

Course details

By attending this course, you will learn how to apply data analysis techniques to improve your operational and project based work. You will be able to review a range of tools and choose the right ones for the particular application and produce analyses and diagrams that make your reports and business cases easier to read and more effective.


Delegates will learn how to:-


  • Develop practical solutions to your business problems through superior spread sheet design.
  • Discover methods to dramatically reduce the time you spend on spread sheets.
  • Use macros more efficiently.
  • Consolidate worksheets from different sources into one workbook.
  • Develop efficient techniques for using charts

Course Outline   

  • Excel Overview
  • Conditional Formatting & Sparklines
  • Summarizing & Consolidating Data
  • Pivot Tables & Slicer
  • Lookups and Data Table
  • Charts & Validation
  • Data Mining
  • Macros
  • Data Security in MS Excel
  • Formulas 

About Specialised Management Group (SMG)

Founded in 2007, Specialised Management Group (SMG) is a leading provider of Specialised Consulting and Methodology, Six Sigma and professional Project and Process Management training. Based in Dubai (United Arab Emirates), their services extend across three continents, from the Middle East to North Africa and Asia.

With more than 60 years of intellectual capacity in Project and Process Management, the team recognises the need for quality and bespoke service within the unique markets encountered.

The company is a globally Registered Education Provider (REP®) through the Project Management Institute PMI®.

See all Specialised Management Group (SMG) courses

Contact information not available.

Are you from Specialised Management Group (SMG) ? Claim your course!
Courses you can instantly connect with... Advanced Excel and Basic MS Access Karama Language and Computer Centre MS Office and Advance Excel Jurassic Institute of Management and Technology Advanced Excel Ace it Training

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or