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
Get trained by industry Experts
Project Based Learning
Learn while you Work
State of the Art Infrastructure
24/7 Lab access
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
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)