CERTIFICATES
Analyzing Data with Excel
OVERVIEW
This course is to familiarize participants with the use of advanced techniques in excel which enhances the use of excel in summarizing or performing data calculations. In this course, students will learn the implementation of functions in Excel. The basic functions will be covered as a part of the introduction and then calculations and expressions will be studied in detail. Advance functions will be explored in depth. The course will also include solver, regressions and what if analysis. By the end of the course, students are able to create pivot tables, pivot charts and create macros as well as execute them. This course also prepares professionals for official Microsoft certifications.
- Instructor led
- 32 hours*
- 13th June 2022
- Talk to an
ADVISOR
Class Schedule: Tuesday and Thursday (6:00pm - 9:00pm EST)
KEY FEATURES
Get trained by industry Experts
Project Based Learning
Learn while you Work
State of the Art Infrastructure
24/7 Lab access
COURSE OUTLINE
Analyzing Data with Excel
Creating and Formating worksheets, workbooks
Customizing options and views for worksheets and workbooks
Configuring worksheets and workbooks for distribution
Inserting and format data in cells and ranges
Summarizing and organising data
Creating and managing tables
Managing table styles and options
Filtering and sorting table
Summarizing data by using functions
Performing conditional operations by using functions
Formating and modifying text by using functions
Creating and formating charts
Using graphic elements in chart
Inserting and formating objects
Creating pivot table and charts
Pivoting data and slicers
Two dimensional pivot table
Creating and formatting pivot chat with external data
Create macro using VBA
In built functions and sub procedures
Loops, conditional statements and regression analysis
Mapping data, discover insights and share stories in power map
Power pivot implementation
SKILLS ACQUIRED
WHO SHOULD APPLY?
While we encourage all interested applicants to apply, to gain acceptance into our Bootcamp you must:
Have a High School Diploma or equivalent, Complete an interview with a member of our Admissions Team, Commit to program and job search requirements.
Upon success full completion receive an industry-recognized certificate from MCIT
Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
INSTRUCTOR SPOTLIGHT
Aimable Karangwa
With a masters in IT management and Certified Business Analyst Professional (CBAP) certification, Aimable is a Industry standard Business Analysis expert. A PMI-Agile Certified Practitioner (PMI-ACP), with PRINCE2 Foundation certification. Over the last 17 Years he has risen to be a senior business analyst consultant.
