Loading Events

« All Events

  • This event has passed.

Advanced Ms. Excel Mastery Week – August 2019

August 27 @ 8:00 am - August 30 @ 5:00 pm

Advanced Ms.Excel Mastery Class

August 2019 Edition

Featuring: Data Modelling, Predictive Analytics, Data Visualization and Interactive KPI Reporting Dashboards

Data driven decision making have increasingly become a key competency requirement in every strategic function that seeks to influence an enterprise competitive market advantage. Organizations are now embracing data science, predictive analytics in their reporting.

Advanced Ms. Excel Mastery Class is a signature program  that seeks to enhance your professional worthworkplace productivity and career growth by developing your data and analytics competencies which are now every employer’s focus.

By the end of this program, we guarantee you a minimum 40% time savings on your daily data related tasks in your functional role.

Check more tips on how to story tell with data on https://www.inquestconsult.com/storytelling-with-data/

What you will learn in this Program:

  • Intermediate & Advanced Excel Functions, Formulas and Tools applied in practical enterprise Data modelling and handling large data sets
  • Master Data modelling techniques using the PowerPivot
  • Harness Data manipulation and transformations techniques using advanced Excel formulas and power functions
  • Problem solving and Decision Support tools such as What-if, Solver, Data Analysis toolpak etc
  • Design your own interactive visual reporting dashboards using advanced charting, slicers, Control Forms etc.
  • Explore the world of Business Intelligence using Power BI tool.
  • Excel automation for repetitive tasks using Macros and Basic VBA.

Practical application from this ICT productivity competency:

  • Transform and analyze the data in order to deduce key business insights
  • Analyze and trend the data to produce scenario patterns for prediction
  • Design Visual Data Intelligence through highly interactive dashboards and presentation.
  • Interpret and present data through insights and data storytelling that influence strategic decisions.

Program Details: (Click here to Download Course Brief)

  • Start Date: Tuesday 27th August 2019
  • End Date: Friday 30th August 2019
  • Duration – Four(4) consecutive days (8:15 am to 5:00 pm)
  • Group Offer: Register/Refer a group of five(5) delegates and get the 6th delegate for free.
  • Venue: InQuest Transformation Centre (ITC), Nairobi Kenya – Non Resident)
  • Certificate of Completion will be issued upon completion

Course Value proposition:

Productivity tools without productivity skills has no value to your function or enterprise. Below insights should be a compelling rationale why you should invest in ICT productivity enabling skills.

  • Kill non valuable monthly reports … Really! Yes If your performance KPIs can be made real-time and interactive, why not build an interactive dashboard instead?
  • Embed data storytelling in your role – Wow! You have beautiful and insightful stories you can use to influence your business and market but you need to know how to unpack it from your data.
  • Predict your future using scenario modelling – The end game!!  Learn how you can easily make use of your current enterprise information and embrace predictive analytics to forecast your future business performance trends.
  • Enhance your promotability in business leadership – You deserve it? – Our training experience has proved that most enterprises are hunting for leaders who can influence strategic decision using data.

Course Pre-Requisites:

  • A working laptop
  • Ms. Office 2016 (With Excel Application installed)
  • Complete for us your learning expectations via our google form https://goo.gl/gJq9n3
  • If you wish to assess your current Excel orientation, please complete an initial assessment and email us back to know your current orientation (Click here to download Level#1 Assessment test)
  • Identify a practical individual project you wish to undertake and which our trainer will guide you

Investment Details:

  • Normal Investment: Kes. 40,000 (Inclusive of VAT)
  • Super Early Bird Offer (20% Off): – Kes. 32,000 (For payments received before  29th July 2019)
  • Standard Early Bird Offer (10% Off): Kes. 36,800 (For payments received before  9th August 2019)

Payment Details:

  • LIPA NA MPESA Till No. 389330 (Kindly text the confirmation message to 0726 611805 for receipting)
  • Bank A/c Transfer (Deposit, EFT, Swift, RTGS) Kenya Commercial Bank, Kes Account No. 1164719025 – Village Market Branch
  • Bankers cheque in favour of Inquest Research and Consulting Company Limited.

Further Details

This program is part of our ICT Productivity Competency Programs (Read More).

For more details, kindly email info@inquestconsult.com or call office Cell +254 726 611805

Looking forward to on-boarding you or any of your team.

Our NITA Accreditation Reference number is: (Ref. NITA/TRN/1410).

Your transformation & growth partner.


August 27 @ 8:00 am
August 30 @ 5:00 pm
Event Category:
https://www.inquestconsult.com/event/advanced-ms-exce…week-august-2019/ ‎


InQuest Research & Consulting


InQuest Offices,Ngara
Nairobi, Nairobi Kenya + Google Map

Registrations are closed for this event. Check out our calendar/events section for the next intake (https://www.inquestconsult.com/events/) .