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
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.
* Morning, evening, weekends
Professionals work in a wide array of companies, from startups to global organizations. The annual salary range for a business analyst is generally between $48,000 to $88,000.
IT professionals
Managers
Human resource specialists
Data entry specialists
Professionals performing business analytics
BI Developer
Java Developer
Big Data Developer
STQA
Using of worksheet and workbooks
Conditional formatting
Working with tables and formatting
Using functions and formulas in cells
Using charts to display data
Creating pivot tables and charts
Sort and Filter tables and charts
Format pivot chart with external data
Creating Macros
Using Power map and Power pivot
Business Analytics 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 pivot table and charts
Pivoting data and slicers
Two dimensional pivot table
Creating and formatting pivot chat with external data
Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
(Different versions of Excel are also available)
After completing my diploma in business intelligence at Montreal College, I was able to land my first job at Bell Canada, where I am currently working with the Intelligence & Analytics team.
Abdulla Alkhuzai — BI Student