MICROSOFT EXCEL WORKSHOPS

Due to its extreme versatility and power, Microsoft Excel has undoubtedly become one of the most used applications in business. Excel is an application that allows users to organize, format and calculate data with formulas using a spreadsheet system broken up by rows and columns. When applied effectively it is a powerful tool, allowing participants to manipulate huge amounts of data, automate tasks and present complex information in a variety of ways. Learning the countless Excel features available to participants can be a daunting task, but what we know is that Excel provides a wide range of data analysis tools that allows users to work with data like never before.

To cater for different skills level, Datalyst Africa has categorised the Excel workshops into Basic, Intermediate and Advanced. Whether you use Excel for work or study, these workshops will start you on your journey to becoming an Excel Expert. Our professional Excel workshops will give you the skills and confidence you need to make full use of this essential spreadsheet application. What are you waiting for, get yourself started and see immediate results with any or all of our Excel workshops.

Purpose of the Excel Workshops

Our Excel workshops will teach participants most of the basic, intermediate and advanced features Excel offers. The purpose is to build participants’ Excel skills by providing them with a core understanding of how to effectively operate and use the Excel spreadsheet software. We will facilitate an increase in participants’ knowledge and confidence in using this vital application.

BASIC EXCEL WORKSHOP

Choose this Basic Excel Workshop if you want to build a strong foundation in Excel. It covers the essential applications of Excel used frequently by business professionals. Look at the topics below and make a decision whether to register for the basic, intermediate or advanced.

Topics to be covered (Basic Excel )

  1. Introduction to Excel
  2. Excel basics
  3. Formulas and Functions 
  4. Excel Charts
  5. Conditional Formatting in Excel  
  6. Data Validation
  7. Linking data in Excel

This 3 Day Basic Excel training will definitely extend how much you can do with Excel and increase the effectiveness of the reports and presentations that you use Excel to prepare. Get in touch with us and enjoy a world of data in your hands.

WHO SHOULD ATTEND?
  1. Persons who are new to excel.
  2. All persons using Excel spreadsheets and would like to sharpen their excel skills in preparation of the intermediate and advanced training.
  3. Anyone who want to become productive.
Workshop BASIC EXCEL
Dates TO BE ADVISED
Venue TO BE ADVISED
Times 8am - 4.30pm
Fee TO BE ADVISED
Registration for Basic Excel is currently closed. If you need to be notified once it opens please send us a message "Basic Excel" on WhatsApp +263773806868 or email info@datalystafrica.com

INTERMEDIATE EXCEL WORKSHOP

Choose this Intermediate Excel workshop if you are comfortable doing basic tasks in spreadsheets and want to learn to create more powerful and dynamic spreadsheets. This Intermediate Excel Workshop introduces participants to more challenging excel features.

Topics to be covered (Intermediate Excel )

  1. Excel Fundamentals
  2. Excel References
  3. VLOOKUP, MATCH & INDEX
  4. String Functions
  5. Transforming data sets using advanced filter
  6. Pivot Tables & Pivot Charts
  7. What-if Analysis tools

Are you ready to go beyond the basics in Excel? However good you are, there's probably something more you could learn from us. This 3 day workshop gives you a deep understanding of how to use some of the the intermediate level features in Microsoft Excel.

WHO SHOULD ATTEND?
This workshop assumes that you have basic knowledge in Excel and are familiar with the fundamentals and have some experience creating workbooks, worksheets, cells, ranges and using a variety of basic functions and formulas. 

Workshop INTERMEDIATE EXCEL
Dates TO BE ADVISED
Venue  TO BE ADVISED
Times 8am - 4.30pm
Fee TO BE ADVISED
Registration for Intermediate Excel is currently closed. If you need to be notified once it opens please send us a message "Intermediate Excel" on WhatsApp +263773806868 or email info@datalystafrica.com

ADVANCED EXCEL WORKSHOP

Choose this Advanced Excel workshop if you are already comfortable using Excel. Take your skills to the next level. We will share Excel’s most powerful and advanced tools, including PowerPivot, DAX formulas, Power Query, Dashboards, Power BI Desktop, Macros, VBA and more.

Topics to be covered (Advanced Excel )

  1. Introduction to Advanced Excel
  2. Array Formulas
  3. Power Query
  4. Power Pivot & DAX formulas
  5. Introduction to Power (BI) Desktop
  6. Macros & VBA Programming in Excel
  7. Introduction to Financial Modelling Using Excel

Discover the real power of Excel through PowerPivot. PowerPivot is a powerful data exploration tool based on in-memory computing technologies providing unmatched analytical performance to process billions of rows instantaneously.

WHO SHOULD ATTEND?
This training has been designed for Excel users who’re ready to tap into the advanced features for increased efficiency & productivity, and for greater capability to analyze data. Participants should have Intermediate Excel knowledge.

Workshop ADVANCED EXCEL
Dates TO BE ADVISED
Venue  TO BE ADVISED
Times 8am - 4.30pm
Fee TO BE ADVISED

Registration for Advanced Excel is currently closed. If you need to be notified once it opens please send us a message "Advanced Excel" on WhatsApp +263773806868 or email info@datalystafrica.com

WHAT WILL YOU GET FROM THESE WORKSHOPS?

  1. Confidence and familiarity in analysing data using Excel.
  2. Increase in analytical and critical thinking skills.
  3. New knowledge, new skills and new ways of doing things.
  4. Certificate of attendance
  5. Learning material
  6. Networks
  7. Workshop package

WHAT SHOULD I BRING TO THIS WORKSHOP?

 

A laptop with Microsoft Excel (Preferably Excel 2016, 2019, 2021 or Office 365)

 

Cancellations

Cancellation notices must be received in writing 10 days before the workshop to receive a full refund. Due to workshop capacity, we regret that we are unable to refund fees for cancellations after this date. Please email your cancellation notice to info@datalystafrica.com

Home

HOME

Workshops

WORKSHOPS

Research

RESEARCH

Who we are

ABOUT US

Get in touch

CONTACT US