CERTIFICATS
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*
- 13 Juin 2022
- Parler à un
conseiller
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
PLAN DE COURS
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
COMPÉTENCES ACQUISES
QUI DOIT POSTULER ?
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.
Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
(Different versions of Excel are also available)
INSTRUCTOR SPOTLIGHT
Aimable Karangwa
Titulaire d’une maîtrise en gestion des TI , j’ai obtenu les certifications suivantes : Certified Business Analyst Professional (CBAP), PMI-Agile Certified Practitioner (PMI-ACP) et PRINCE2 Foundation®. Je compte aussi plus de 17 années d’expérience comme analyste de processus d’affaires.
