TITLE: EXCEL SKILLS FOR PROFESSIONALS: Expert Level

DATE: 27th-28th August 2018

VENUE: Shangri-La Tanjung Aru Resort & Spa

INTRODUCTION

This course introduces Microsoft Excel users to the expert features of the software application

Master business intelligence modelling and analysis techniques with Microsoft Excel and transform data into bottom-line results. This hands-on, scenario-focused workshop shows you how to use the latest Excel tools to integrate data from multiple tables and how to effectively build a relational data source inside an Excel Workbook.

We will also show you how you can turn Excel into your own personal Business Intelligence tool. With a few fundamentals and some of the new BI functionality Microsoft has included in the latest versions of Excel, you can go from reporting data with simple tables, to creating meaningful dashboards that are sure to WOW everyone.

COURSE OBJECTIVES

At the end of this training, participants will be able to:

  • Use Power Pivot to create powerful reporting mechanisms
  • Get better visibility into data from different perspectives
  • Use excel functions to analyze large amounts of data
  • Use Interactive Controls within spreadsheets
  • Create eye-catching visualizations and dashboards
  • Use excel pivot tables to access and analyze data
  • Automate repetitive tasks and processes
  • Gain insight and analytical power with Data Mining Tools
  • Publish dashboards and reports

For more information on this course, kindly contact Annette at 088-731409 or email at annette@cfrontier.com

Price Based Country test mode enabled for testing Brunei. You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari