Overview
Earn a microcredential with our online Microsoft Excel – Analyzing and Visualizing Data program
Six out of ten Canadian job postings place Microsoft Excel as one of the top skills employers seek. Companies are hiring employees with experience in data analysis and visualization to transform complex data into solutions to help make better business decisions.
- Teaches you how to consume, transform, model, and visualize data in Microsoft Excel
- Developed in collaboration with McGraw Hill and Devant
- The course uses SIMnet, an online training program that identifies skill gaps so you learn the skills you need, from beginner to intermediate
Information Box Group
Program highlights Learn More
- Online – self-paced – start at any time
- Taught via SIMnet Online Training and assessment platform with expert instructor support
- Earn a microcredential in as little as 12 weeks
- Open enrolment program
Microsoft Excel – Analyzing and Visualizing Data program features:
- Access to SIMnet platform for life
- Expert instructor available for questions and support
- Virtual Excel interface (no need to purchase an Excel license)
- Unlimited practice with real-life business cases
- Approximately 21 hours of course work
- Configure and manipulate data in PowerPivot, Pivot Tables and Pivot Charts
What you'll learn Learn More
- Consume and transform data
- Manage data relationships
- Optimize models for reporting
- Group, summarize and visualize data
Through our Microsoft Excel – Analyzing and Visualizing Data program, you’ll learn to:
Consume and Transform Data
- Import from data sources, other Excel workbooks and supported file types
- Connect and import from databases, files and folders, Microsoft SQL, Azure, Big Data, SQL, Server Analysis Services (SSAS) and Power Query
- Link data from other sources
Perform Data Transformations
- Design and implement basic and advanced transformations, apply business rules, change data format to support visualization, cleanse, filter and format data
- Manage incomplete data and data received as a report
- Remove data, repeating headers, rows and columns
- Create and optimize data models, manage data relationships, manually enter data
- Perform Get & Transform
- Create automatic and manual relationships
- Create calculated columns, measures and tables
- Create Excel formulas and performance KPIs
- Calculate the actual value, target value and actual to target values
- Create hierarchies, date and business hierarchies and resolve hierarchy issues
- Describe DAX queries and formulas
Visualize Data
- Create and manage Pivot Tables and Pivot Charts
- Format Pivot Table and Pivot Table Charts
- Format calculated measures, filter groups and summarize data
- Use slicers
- Describe interaction with PowerBI: import and manipulate Excel data*
*PowerBI topic is not included in SiMnet course modules and course evaluation. Instructor shares supplemental resources.
Learn more about the Microsoft Excel program
- Professionals interested in advancing their skills in Microsoft Excel
- Professionals in finance, healthcare, marketing, government, logistics, transportation, information systems, media/entertainment or other sectors
- Anyone interested in re-skilling, up-skilling or making a career change
Earning a Microcredential in Microsoft Excel opens doors to a wide range of rewarding careers that require Excel, including:
- Accountants and auditors
- Management and market analysts
- Cost Estimators
- Market research analysts and digital marketers
- Administrative assistants, information staff
- Project coordinators, project managers and construction managers
- Sales, marketing, training and administrative managers
- Remote Excel jobs
Upon successful completion of this program, students will be able to:
- Consume and transform data
- Manage data relationships
- Optimize models for reporting
- Select a chart type, format calculated measures, filter data
- Group, summarize, and visualize data
Check out our latest Program Preview webinar recording to learn more about the Microsoft Excel – Analyzing and Visualizing Data program
What our recent graduates say
Adam
Business Administration graduate
I feel very strongly that McMaster Continuing Education can really help you reinvent your career.
I feel very strongly that McMaster Continuing Education can really help you reinvent your career. I found that the Business Administration program was really the best fit for me, because the learning that I was able to take in through this program was really cutting edge and current to the labour market. The learning that I took on is something I use every day.
Adam
Business Administration graduate
The MCE program on sustainability studies has introduced me to a different phase of continuous learning of self-development especially in a world dominated by a centric mindset of over-consumption.
What is sustainability?
The MCE program on sustainability studies has introduced me to a different phase of continuous learning of self-development especially in a world dominated by a centric mindset of over-consumption.
The importance of sustainability is structured on understanding the dangers of how anthropocentrism and consumerism is taking over the world and combating this.
This program was well drafted and taught, and has enabled me become more aware of my environment and better ways of not only protecting it, but creating a better society using different methodologies based on a circular economy.
Sustainability is not a curve process but a journey which we all must embrace.
This microcredential was very informative, interesting and engaging. The instructors were well knowledgeable of the subject matter.
I encourage everyone to take this program.
Anthony Ogborogu
Sustainability graduate
It is important to understand the interconnectedness of these and other issues so that the implications of our everyday household and business decisions are understood in the right context.
Sustainability seems to be a buzz word these days. I hear it mentioned on the news, in advertisements, in general conversations, and in other unexpected facets of life. I would argue that the concept of Sustainability is vital in today’s world and to our future happiness. As a Global community we are dealing with big social and environmental issues. It is important to understand the interconnectedness of these and other issues so that the implications of our everyday household and business decisions are understood in the right context. What we do and don’t do matters.
Enrolling in the McMaster Continuing Education Sustainability program has been a wonderful way to develop an understanding of the practices of Sustainability, and what we can do to support real change. I encourage everyone to look into this program and to join the conversations being held all around you. Even if you don’t decide to take this program, look into the UN Sustainable Development Goals to start understanding the interconnectedness of things and how we as individuals and businesses can make a difference.
I look forward to hearing your thoughts and ideas in a future class!
Daniel
Sustainability graduate
I feel very strongly that McMaster Continuing Education can really help you reinvent your career.
I feel very strongly that McMaster Continuing Education can really help you reinvent your career. I found that the Business Administration program was really the best fit for me, because the learning that I was able to take in through this program was really cutting edge and current to the labour market. The learning that I took on is something I use every day.
Adam
Business Administration graduate
The MCE program on sustainability studies has introduced me to a different phase of continuous learning of self-development especially in a world dominated by a centric mindset of over-consumption.
What is sustainability?
The MCE program on sustainability studies has introduced me to a different phase of continuous learning of self-development especially in a world dominated by a centric mindset of over-consumption.
The importance of sustainability is structured on understanding the dangers of how anthropocentrism and consumerism is taking over the world and combating this.
This program was well drafted and taught, and has enabled me become more aware of my environment and better ways of not only protecting it, but creating a better society using different methodologies based on a circular economy.
Sustainability is not a curve process but a journey which we all must embrace.
This microcredential was very informative, interesting and engaging. The instructors were well knowledgeable of the subject matter.
I encourage everyone to take this program.
Anthony Ogborogu
Sustainability graduate
It is important to understand the interconnectedness of these and other issues so that the implications of our everyday household and business decisions are understood in the right context.
Sustainability seems to be a buzz word these days. I hear it mentioned on the news, in advertisements, in general conversations, and in other unexpected facets of life. I would argue that the concept of Sustainability is vital in today’s world and to our future happiness. As a Global community we are dealing with big social and environmental issues. It is important to understand the interconnectedness of these and other issues so that the implications of our everyday household and business decisions are understood in the right context. What we do and don’t do matters.
Enrolling in the McMaster Continuing Education Sustainability program has been a wonderful way to develop an understanding of the practices of Sustainability, and what we can do to support real change. I encourage everyone to look into this program and to join the conversations being held all around you. Even if you don’t decide to take this program, look into the UN Sustainable Development Goals to start understanding the interconnectedness of things and how we as individuals and businesses can make a difference.
I look forward to hearing your thoughts and ideas in a future class!
Daniel
Sustainability graduate
Other programs you may be interested in
- Home
- Find Programs & Courses
- Business Programs
- Microsoft Excel – Analyzing and Visualizing Data Program
Microcredential in Microsoft Excel
Microsoft Excel – Analyzing and Visualizing Data Course
Earn a Microcredential in Microsoft Excel – Analyzing and Visualizing Data with McMaster Continuing Education
Upon successfully completing this course, you will receive a microcredential recognizing your learning achievement. Complete with details of the skills and specialized knowledge you have acquired, the microcredential is digitally shareable, making it easy to add to your resume, LinkedIn profile and to share with current or prospective employers.
Explore the requirements below and register today!
Information Box Group
Microcredential in Microsoft Excel – Analyzing and Visualizing Data Learn More
To earn a microcredential you will need to pass the final capstone exam. A final grade of 60% or better on the final assessment is equivalent to a Pass.
Microcredential in Microsoft Excel – Analyzing and Visualizing Data Requirements
Note: You will have 12 weeks from your start date to complete the course.
Course
*Students may begin this course any time between September 9th and December 17th, 2024, and will be given 12 weeks to complete the course.
Please note: Tuition price does not include HST
- Home
- Find Programs & Courses
- Business Programs
- Microsoft Excel – Analyzing and Visualizing Data Program
Microsoft Excel – Analyzing and Visualizing Data Course
Microsoft Excel – Analyzing and Visualizing Data Courses
Advance your career with the online Microsoft Excel – Analyzing and Visualizing Data course
Explore the course below and register today!
Information Box Group
*Students may begin this course any time between September 9th and December 17th, 2024, and will be given 12 weeks to complete the course.
Please note: Tuition price does not include HST. This will be added at checkout.
Admission Requirements
Admission Requirements
This program is open enrolment, which means there is no formal application or admission procedure. To enrol in a course, simply register online. Our courses can be taken as part of a program or individually.
To enrol in McMaster Continuing Education programs, you must:
- Have an Ontario Secondary School Diploma or equivalent
- Be a mature student as defined in the Undergraduate Calendar of McMaster University or
- Be deemed an exceptional case
To ensure you are successful in your online courses, you are required to have knowledge and skills with general computer applications, such as keyboarding, file management, video conferencing and word processing.
Language Requirements
If your first language is not English, you must meet the University’s English language proficiency requirements. Completion of TOEFL exam with a minimum acceptable score of 20 on each of the four components (reading, writing, speaking and listening), valid for 2 years.
Expandable List
- Visit continuing.mcmaster.ca/programs to find your program of choice
- Click on each tab on the program page to learn about credential options and requirements, schedule and fees, and a list of all courses in the program
- Select a course and then select an available offering, noting important information such as cost, delivery format, and start/end dates; then click ‘add to cart’
- Once you have added your courses, click the shopping cart icon at the top right-hand corner of the page (bottom of the browser screen on mobile)
- Review your cart and, once you’re ready to proceed with enrolment, click ‘proceed to checkout’
- As the next step, you will be redirected to Mosaic – McMaster’s Administrative Information and Enrolment system
- Once you are in Mosaic, select ‘new to McMaster’ or log in with your existing MacID and password (if applicable)
- Complete all required fields and select a program of study when prompted (i.e., a specific program or open studies for standalone courses)
- Finally, payment is required in full to secure a spot in your course(s)
A payment receipt email will be issued to you immediately after registering, and a course confirmation email will be sent to you overnight. Within approximately 24 hours of registering, you will also receive an important email containing credentials used to activate your MacID, which you must do before you can access courses in Avenue to Learn. Please review our Getting Started page to learn more about the next steps for beginning your studies after registration, and our Help Centre for our Refund Policy and other frequently asked questions. Please note that on average, each course requires 6-8 hours of study per week, per course (sometimes more) and some courses may have listed prerequisites. Please plan your schedule accordingly. Most students take 1-2 courses per term across a few different terms and a full-time equivalent course load is typically 3-4 courses per term.
For more information and a walkthrough on how to register, please check out this video.
- Payment must be made in full at the time of enrolment
- Online credit card or debit payments are preferred
- Accepted credit cards: Visa, MasterCard and American Express
- Accepted debit cards: Visa Debit and Debit Mastercard
- Google Pay is available for faster checkout
- Payments can be made from a Canadian Financial Institution and can take 2 to 4 business days to arrive in your McMaster student account. Once payment has arrived, you can register for your course. Please note that if the amount of the course fees owing is more than what was transferred to your student account, you will be dropped from the course.
- Problem processing your payment? Please reach out to your credit card company if your payment was declined. Otherwise, wait two hours before attempting your registration again.
Ready to get started?
Visit the Schedule tab to select your course and proceed with the registration steps.