DATA ANALYSIS WITH MICROSOFT EXCEL FOR ACTIONABLE INSIGHT & STRATEGY

 

 

OUR PROGRAM GOAL

We want to help you achieve the “True Analyst” status. You might have gone through similar trainings before and yet you still cannot analyze any data to achieve actionable insight that drives business strategy and performance. Well, there is a difference between being a guru in Microsoft Excel and being the Analyst. It’s all about mindset and that is what this program is all about, giving you that mind reset to become that Analyst.

Are you someone with zero knowledge about Data Analysis and want to really learn and master it to become that Analyst organizations are looking for? This training is perfect for you because you do not need to know anything to join; we will take you through baby steps to maturity; we are talking from scratch to advance level!

 

PROGRAM / PLAN:

PRE-TRAINING (to be completed before training date)

At the point of registration all participants are given the link to download our XcelQuickStart video. This is a MUST watch for ALL participants before the life ZOOM training and especially if you know nothing about Microsoft Excel, Data/Business Analytics.

 

The lessons in the videos (though snippets of our XcelQuickStart free training) provides participants with the foundation needed to venture into the more advanced topics in the life training. It is important ALL participants watched this video before we go life.

 

Pre-Training Video Coverage: (Teaching and Activities)

(Participants will be connected to the pre-training videos via email once registered)

1.   1.  Introduction to Data/Business Analytics

2.    2. Your tools

3.    3. In-depth Introduction to Microsoft Excel (No knowledge is required), Named ranges etc.

4.  4. Formulas and Functions covering the first nineteen functions:  9 Aggregate functions and 10 Text functions.

5.    5. Introduction to Visualization

 

LIFE TRAINING ( ZOOM CLASS)

Starting 26^th November 2022, 10am Nigerian Time

Week on Week summary.

WK. 1:  DESCRIPTIVE ANALYTICS

·        Aggregate and Text Functions recap

·        Cell Referencing key concept

·    IF(AND(OR logical, IFERROR /IFNA funct., Conditional formatting, Visualization (Data Layout), Array Function I, % Contribution, Excel Table

·        Data Analysis I (Functions/Formulas – Sing. & Mult. / with Named Ranges):

SUMIF/IFS, AVERAGEIF/IFS, COUNTIF/IFS, %Contr.

·        Data Validation [Dynamic reporting]

 

WK. 2:  DESCRIPTIVE ANALYTICS

·        Data Analysis 2 (PVT)

·        LOOKUP FUNCT. (V-LOOKUP, H-LOOKUP) ---simple to complex

·        INDEX&MATCH

·  Inventory Project -- - -Creating Logic driven scenarios using Conditional Formatting, Summary calculation etc.)  

WK. 3: DATE & TIME CALCULATION, DESCRIPTIVE /PREDICTIVE ANALYTICS & DASHBOARD

·        Date and Time calculation

·        Visual Analytics

·        Forecasting

·        Management Solution (Dashboard / Dynamic reporting)

 

WK. 4: PRESCRIPTIVE ANALYTICS: PROBLEM CASE PROJECT (You the Consultant: Creating Strategic Focus from Analysis of Data

·        Customer/ Channel Analytics and Brand Strategy

·        Pareto principle, Percentile etc.

 

 

Register here!

                                                  Download Outline here

         Download Pre-Training here before the life class

For more inquiry, send mail to career.initiative7@gmail.com 

or

Click WhatsApp Icon to send a WhatsApp message now!

Signup for the Challenge!