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
Montreal College of Information Technology
Collège des technologies de l’information de Montréal
CERTIFICATES
Business Analytics with Excel
State of the Industry
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.
- English
- 40 hours *
- As per demand
- Talk to an
ADVISOR
* Morning, evening, weekends
Professional Benefits
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.
Who Should Apply
IT professionals
Managers
Human resource specialists
Data entry specialists
Professionals performing business analytics
Sihame B
BI Developer
Rosana N
Java Developer
Dwany H
Big Data Developer
Chloe D
STQA
Abilities acquired at course completion
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
WHAT YOU WILL LEARN COURSE OUTLINE
Business Analytics 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
SKILLS ACQUIRED
Excel basics
Use of worksheet 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
CERTIFICATION EXAMS
Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
(Different versions of Excel are also available)
TOP REASON
TO JOIN MCIT
- Industry-relevant, job-ready programs
- Internship possibilities
- Eligibility for off-campus work permit program [ocwpp]
- Eligibility for post-graduation work permit [pgwp]
- Eligibility for points under Quebec’s immigration policy
- Scholarships and financial aid
INSTRUCTOR SPOTLIGHT
Dhruv Gusain
Enterprise Java developer with a passion for sports. My Aim, to have a connection with the students and make them understand the crux of any concept.
Jiji Raghavan
I am a software QA instructor at MCIT where I help students focus on their vision by guiding them through each phase of their career. I have 6 years of experience as a QA engineer and 2 years in teaching. It motivates me as I can see myself as an agent of change in my students’ life. I want to inspire all of my students to be ambitious and make a difference in their life and career.
Ayda Ghasemi
I am a SQL instructor at MCIT and a member of the Data and BI team at Couche-Tard. I have expertise in Microsoft Azure stack on-premises and in Azure cloud. I hold a bachelors in Physics and an MBA. I also spent a year as a BI developer at MCIT.
Gregory Shinder
I love working with SQL Server, especially to solve performance problems. Have a poor-performing query? Challenge accepted! I also like to design and implement high availability and disaster recovery solutions. When I’m not trying to break another SQL server, you’ll find me teaching SQL.
Haythem Rehouma
I am a full-stack and mobile developer who works on native mobile (Android and iOS) and cross-platform (PhoneGap/Ionic/ReactNative/Angular) apps for both business and consumer customers. Examples of my apps included location-based services and sensors.
Kashyap Vedantam
With more than 6 years of industry experience, I’ve developed many applications in various programming languages. I hold a masters in applied computer science from Concordia and am a certified Microsoft SQL developer. I seek to create a classroom atmosphere that is stimulating and makes students feel valued. "Grow by learning something new every day."
Souleyman Sidibe
I am an experienced IT project manager with significant expertise in business intelligence (BI). I hold high-level degrees in IT networking, telecommunications, business intelligence, and programming. I’ve previously worked as a database specialist, an ETL developer, a BI analyst, and a business analyst. My main motivation in teaching is to transfer the knowledge that helps others fulfill themselves.
Toufik Lazri
I am a university graduate in computer engineering and have been developing and implementing computer applications for more than 25 years. I have been teaching Java technologies for more than 10 years. I enjoy passing on my knowledge in a clear and dynamic way in order for students to make a successful transition to the labor market.
Vimal Kapoor
I am a dynamic IT professional with experience in corporate IT systems, network support solutions, and Wipro technologies. I have the proven ability to provide creative and effective server and networking strategies for all Microsoft operating systems and server products.
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.
Iraj Hedayati
I'm leading the data team at Guavus, a major data analytics company, working with the Hadoop ecosystem. I hold a master's degree in computer science and one in software engineering. I was always eager to pursue teaching, an activity that I thoroughly enjoy.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
