What Is an NFT? Your Guide to Non-Fungible Tokens in 2025
January 6, 2025
Article · 7 min read
This course is part of Microsoft Business Analyst Professional Certificate
Instructor: Microsoft
12,901 already enrolled
Included with
(147 reviews)
Recommended experience
Beginner level
This course is for anyone interested in business analysis, regardless of their prior experience.
(147 reviews)
Recommended experience
Beginner level
This course is for anyone interested in business analysis, regardless of their prior experience.
Gain insight into the steps involved in preparing data for analysis using Excel functions.
Learn to use formulas and functions in Excel for data analysis purposes.
Understand how Excel is applied in business scenarios for data analysis and apply these skills to real-world tasks.
Add to your LinkedIn profile
28 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.
Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Business Analyst. After completing this course, you’ll be able to: • Identify and explain the steps involved in preparing data for analysis using Excel functions. • Use formula and functions for Data Analysis • Describe how Excel is used in business scenarios for Data Analysis • Apply Excel skills to real-world data preparation tasks.
This module introduces essential Excel elements and techniques begininning with the creation and formatting of worksheets. It explores the Excel features that are useful when viewing large data blocks and explains how to create accurate calculations.
7 videos17 readings6 assignments2 discussion prompts
This module introduces formulas and functions in Excel. It explores how these are important to data analysis and how these are used in business scenarios.
6 videos9 readings5 assignments1 discussion prompt
The module introduces common functions that help prepare Excel data for analysis in tools such as PowerBI.
6 videos13 readings7 assignments1 discussion prompt
In this module, you will learn essential skills in Microsoft Excel to enhance data manipulation and reporting capabilities. You’ll discover how to create dynamic data blocks using tables, allowing for flexible data organization and analysis. Additionally, you’ll learn how to create PivotTables, a powerful feature for summarizing and analyzing large datasets efficiently. Furthermore, you'll explore how to leverage PivotTables and slicers to create dynamic reports, providing insights and visualizations that adapt to changing data inputs. These techniques will empower you to efficiently manage and analyze data, enhancing your productivity and decision-making abilities in Excel.
10 videos5 readings8 assignments1 discussion prompt
In this module, you will be assessed on the key skills covered in the Course.
2 videos4 readings2 assignments1 discussion prompt
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more. In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
Coursera Instructor Network
Course
Coursera Project Network
Course
University of Colorado Boulder
Course
Coursera Project Network
Course
147 reviews
72.10%
22.44%
2.72%
0%
2.72%
Showing 3 of 147
Reviewed on Aug 28, 2024
Learned a great deal of info and refreshed some old details.
Reviewed on Jul 3, 2024
I rated 4 star because Microsoft needs to enable the use of Slicers for Mac OS users
Reviewed on Dec 30, 2024
course was quite interesting and engaging throughout
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
This program is for you:
· If you want to start or switch to a career in the field of business analysis.
· If you are interested in the field of business analysis, just beginning to work with business analyst solutions and services. Earning a Microsoft Business Analyst certificate can help advance your career or help you address gaps in your knowledge, skills, and abilities.
You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.
Whether you’re looking to start a new career or change your current one, Professional Certificates help you become job ready. Apply your new skills on hands-on projects that showcase your expertise to potential employers and earn a career credential to kickstart your new career.
Business Analysts play a crucial role in guiding organizations through data-driven decision making. They analyze, interpret, and document business processes and data, providing insights to shape strategic decisions.
Prepare for a career in the high demand field of business analysis. The business analysis skills you learn in this program prepare you for an entry-level role as a business analyst. This program also prepares you for a variety of entry-level roles that require data-driven problem-solving and strategic planning.
This course is completely online. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.
Yes. We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses. The final course contains a practice exam that assesses your knowledge of the content covered in the previous courses. As such, it makes the most sense to take the courses in the order they are presented.
It typically takes 3 months to complete the 6 courses. But some learners may go through the content faster.
When you complete this Professional Certificate, you’ll have an understanding of the fundamental concepts of business analysis and how they apply to an enterprise environment including:
· Proficiency in identifying, analyzing, and documenting business issues with diverse techniques.
· Skills in business process modeling and data visualization using Microsoft Excel.
· Capability in conducting assessments and validating solutions against requirements.
· Effective communication and change management strategies.
You’ll also be prepared to take the Microsoft PL-900 exam: Microsoft Power Platform Fundamentals.
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.