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
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
- 40 hours *
- 14th February 2022
- Talk to an
ADVISOR
Class Schedule: Tuesday and Thursday (6:00pm - 9:00pm EST)
Sihame B
BI Developer
Rosana Neishabouri
Data Analyst at Lamour
Dwany H
Big Data Developer
Chloe D
STQA
SKILLS ACQUIRED
Excel basics
Use of worksheets and workbooks
Conditional formatting
Working with tables
Formatting tables
Using functions and formulas
Using charts
Graphical display of data
Format objects
Create pivot tables and charts
Working with external data
Macros, power map, and power pivot
COURSE OUTLINE
Analyzing Data with Excel
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
Earn MCIT Certification
Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
(Different versions of Excel are also available)
Why join MCIT?
- Taught by Industry Expert Instructors
- Real-Time, Hands-on Training
- Post Graduation Job Placement
- 24/7 Virtual Lab Access
- Flexible Schedule (Evening and Weekend Class Times)
- Vendor Authorized Trainings
INSTRUCTOR SPOTLIGHT
Aimable Karangwa
I hold a masters in IT management and am a Certified Business Analyst Professional (CBAP), a PMI-Agile Certified Practitioner (PMI-ACP), and have obtained a PRINCE2 Foundation certification. I have 17 Years of experience as a senior business analyst consultant.COMMUNITY TESTIMONIAL
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
CALENDAR
— F.A.Q —
To register for a course, you can either call us or enter your request online and our administrative staff will call you with steps to register.
Definitely. Please feel free to contact our office, we will be more than happy to work with you to meet your training needs.
You can find most of the scheduling and pricing information on our website, or you can call our office for assistance.
Montreal College offers a new session every four months, i.e., in October (fall session), February (winter session) and June (summer session). Students are encouraged to register at least 2 to 16 weeks in advance. Please note that many programs fill up before the registration deadline.
