At the end of this course, the participants are expected to be able to:
Understand the use of Excel’s advanced Functions
Gain Insights from vast array of data with ease
Make powerful dashboards
Analyse data like a professional
Understand shortcut techniques for faster and efficient use of Excel

• Working with Formulae and Functions:-
• Introducing Formulae and Functions
• Creating formulae that manipulate text
• Working with Dates and Times
• Creating Formulae that Count and Sum
• Creating Formulae that Look Up Values
• Creating Formulae for Financial Applications
• Introducing Array Formulae
• Performing advanced tasks with Array Formulae
• Using advanced Excel features:-
• Customizing the Excel User Interface
• Using Custom Number Format
• Using Data Validation and Text to Columns
• Creating and Using Worksheet Outlines
• Linking and Consolidating Worksheets
• Excel and the Internet
• Sharing Data with Other Office Applications
• Using Excel in a Workgroup
• Protecting Your Work
• Making Your Worksheets Error-Free
• Creating Charts, Graphics and Dashboards:-
• Getting Started Making Charts
• Learning Advanced Charts
• Visualizing Data Using Conditional Formatting
• Creating Sparkline Graphics
• Enhancing Your Work with Pictures and Drawings
• Maintaining and creating advanced dashboards
• Analyzing data with Excel:-
• Getting Data from External Database Files
• What-if Analysis
• Data Validation - advanced
• Introducing Pivot Tables
• Analyzing Data with Pivot Tables
• Analyzing Data Using Vlookup
• Analyzing Data Using Hlookup
• Maintaining and creating Dashboards
• MACROS:-
• Basics of Macros Project procurement management
• Project stakeholder management

Course Type:

Certified Training Course

Study Mode:

Classroom

Location:

Dubai Knowledge Village

Fees:

$385

Certification:

Certificate in Advanced MS Excel

Date:

31/07/17