Module 1: Foundations of Data Analysis in Excel

·       Understanding the data analysis process

·       Essential keyboard shortcuts for efficiency

·       Data types and cell formatting best practices

·       Using named ranges to simplify formulas

·       Practical session: Navigating a large dataset and applying basic data management techniques

Module 2: Data Cleaning, Preparation, and Transformation

·       Removing duplicates and managing blank cells

·       Using Text to Columns and Flash Fill

·       Combining data with functions like CONCAT and TEXTJOIN

·       Handling errors and inconsistencies in datasets

·       Practical session: Cleaning and standardizing a raw dataset for analysis

Module 3: Descriptive Statistics and Exploratory Data Analysis

·       Calculating measures of central tendency (mean, median, mode)

·       Computing measures of dispersion (variance, standard deviation, range)

·       Using the Analysis ToolPak for statistical summaries

·       Identifying outliers and anomalies in data

·       Practical session: Generating descriptive statistics for a sales dataset and interpreting the results

Module 4: Data Visualization for Insightful Reporting

·       Choosing the right chart type for your data

·       Creating dynamic charts and graphs

·       Using conditional formatting for visual alerts

·       Building simple, interactive dashboards

·       Practical session: Designing a sales performance dashboard using various chart types and conditional formatting

Module 5: Advanced Formulas and Logical Functions

·       Mastering VLOOKUP and HLOOKUP and their limitations

·       Introduction to INDEX and MATCH for more flexible lookups

·       Using IF, IFS, and nested logical functions

·       Combining functions for powerful data manipulation (e.g., SUMIFS, COUNTIFS)

·       Practical session: Solving a data retrieval challenge using INDEX and MATCH

Module 6: PivotTables and PivotCharts for Aggregation

·       Creating a PivotTable from a raw dataset

·       Summarizing data by different fields and functions

·       Filtering, sorting, and grouping data within a PivotTable

·       Generating PivotCharts to visualize aggregated data

·       Practical session: Building a dynamic report to analyze customer data by region and product category

Module 7: What-If Analysis and Scenario Planning

·       Introduction to Goal Seek and its applications

·       Using the Scenario Manager to compare different scenarios

·       Working with Data Tables to analyze multiple variables

·       Solving complex problems with Solver

·       Practical session: Using Solver to optimize a budget based on multiple constraints

Module 8: Regression Analysis and Forecasting

·       Introduction to linear regression and its purpose

·       Running a regression analysis using the Analysis ToolPak

·       Interpreting regression output and key metrics (R-squared, p-value)

·       Creating a simple forecast using historical data

·       Practical session: Performing a regression analysis to determine the relationship between advertising spend and sales revenue

Module 9: Introduction to Power Query and Power Pivot

·       Understanding the purpose of Power Query for data cleaning

·       Automating data import and transformation processes

·       Introduction to the Data Model and relationships in Power Pivot

·       Writing basic DAX formulas

·       Practical session: Consolidating data from multiple sources using Power Query and building a data model in Power Pivot

Module 10: Building an Evidence-based Decision-making Framework

·       Defining a business problem and identifying key questions

·       Structuring an analysis plan and gathering relevant data

·       Presenting findings and recommendations effectively

·       Avoiding common pitfalls and cognitive biases in decision-making

·       Practical session: Working on a capstone project to analyze a business problem, present findings, and make a data-driven recommendation

Requirements:

·       Participants should be reasonably proficient in English.

·       Applicants must live up to Armstrong Global Institute admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@armstrongglobalinstitute.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254725012095 / +254724452588

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Armstrong Global Training & Development Center Limited should be paid in advance, 5 days to the training.

2. Invoice: We can send a bill directly to you or your company.

3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

2. Participants may cancel attendance 14 days or more prior to the training commencement date.

3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588