Course Overview
Microsoft Excel is a very widely used tool with many organizations and departments and being able to produce a quick analysis is an asset. This course provides participants with the knowledge and skills to work with and analyze data and work with business cases using Microsoft Excel. The objective is to familiarize the participants with the fundamentals of how to manage, transform and analyze data using the various functions in Excel. In this course, you’ll develop employable data analyst skills, starting with the Excel basics, what it can do, and the data analysis steps you should follow.
Duration
5 Days
Who Should Attend
This course should be attended by those who want to learn data storytelling using excel as a platform
Course Level:
Course Objectives
- An understanding of how to apply most commonly used statistical and lookup functions.
- The ability to gather data and organize the data for analysis in business.
- Knowledge in chart generation and interpretation.
- The ability to build dashboards using PivotTables and Pivot Charts.
- Skills in using Excel What-If Analysis and Data Analysis tools for generating different scenarios of business environment and aiding decision making.
Course Outline
Module 1: Basic Excel Functions and Formatting
-
Excel Interface & Navigation
- Ribbon bar
- Keyboard shortcuts
-
Cell Operations & Formatting
- Working with cells and named ranges
- Formatting cells
- Freezing panes
- Conditional formatting
-
Built-in Functions
- Text, date, time, logical, and math functions
- IF functions
Module 2: Data Analysis Techniques
-
Data Analysis Tools
- Instant data analysis
- Quick analysis toolbar
-
Sorting & Highlighting
- Sorting data
- Conditional sorting
- Highlighting cells and values
- Removing duplicates
-
Flash Fill
- Using flash fill for data entry
Module 3: Data Referencing & Transformation
-
Referencing Data
- Cross-referencing in worksheets
- VLOOKUP, HLOOKUP, and XLOOKUP functions
-
Text-to-Column
- Splitting cell values
- Correct date formatting
Module 4: Data Visualization & Pivot Tables
-
Excel Tables
- Creating and styling tables
- Sorting and filtering
-
Charts
- Creating and customizing charts
- Using combo charts and dashboards
-
Pivot Tables
- Creating and formatting pivot tables
- Creating pivot charts
Module 5: Automation & Power Query
-
Power Query & ETL
- Extracting, transforming, and loading data
-
Automation
- Setting up data pipelines
- Integrating data from APIs
Related Courses
Course Administration Details:
METHODOLOGY
The instructor-led trainings are delivered using a blended learning approach and comprise presentations, guided sessions of practical exercise, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
ACCREDITATION
Upon successful completion of this training, participants will be issued an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).
TRAINING VENUE
The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.
ACCOMMODATION AND AIRPORT PICKUP
Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.
- Email: [email protected]
- Phone: +254715 077 817
TAILOR-MADE
This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location. For further inquiries, please contact us on:
- Email: [email protected]
- Phone: +254715 077 817
PAYMENT
Payment should be transferred to the IRES account through a bank on or before the start of the course. Send proof of payment to [email protected]
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Do you need more information on our courses? Talk to us.
