Microsoft® Excel - Advanced

Microsoft® Excel - Advanced

About This Course

SMG will train the delegates to be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Career Advancement Areas

By attending either the intermediate or advanced courses, 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.

What You Will Learn

  • Excel Overview
  • Conditional Formatting & Spark lines
  • Summarizing a data based on single attribute
  • Lookups and Data Table
  • Pivot Tables & Slicer
  • Charts & Validation
  • Data Mining
  • Data Security in MS Excel
  • Formulas

Instructions

Prerequisites
None
Duration
2 days
Who Should Register?
  • Anyone interested in Advanced Excel

Overview

Specialised Management Group (SMG)
Course Type:
Training Course
Study Mode:
Classroom
Location:
Dubai Knowledge Park
Fees:
1,500 AED
Certification:
Course completion certificate
Date:
09/04/17


Your information is 100% Secure and will be delivered directly to the school.