MO-210 prep: Microsoft Excel (from beginner to intermediate)
>_ What You'll Learn
- Create, configure and save Excel worksheets and workbooks.
- Navigate through and format worksheets and workbooks.
- Customise options and views for worksheets and workbooks.
- Configure Excel worksheets and workbooks to print (e.g. page setup).
- Insert data into and format cells and ranges, and create and modify tables.
- Highlight, filter, sort and group cells, ranges and tables.
- Create and format Excel charts.
- Create formulas in Excel, including using conditional logic and modifying text.
>_ Requirements
- Before beginning, you will need to know how to use a Windows computer, including a mouse.
- It would be good if you have used Microsoft Excel before, but this is not essential.
- You should have MS Excel (or Office) 2021 or later installed on your PC computer. This program is also known as a Microsoft 365 App.
/ Course Details & Curriculum
- We’ll start with create and manage worksheets and workbooks. We’ll import data into workbooks, navigate and format workbooks, and prepare them for collaboration and distribution.
- We’ll then look at managing data cells and ranges and create tables. We’ll insert data into and format workbooks, summarise and organize data, manage table styles and options, and filter and sort table data.
- We’ll then perform operations with Excel formulas and functions. We’ll use functions for summarising data, performing conditional operations, formatting and modifying text, sorting and generating numeric data.
- Finally, we’ll look at creating charts and sparklines. We’ll use different chart types, such as line, bar, area and pie charts, we’ll add legends and apply layouts and styles, and insert sparklines.
Author and Instructor
Phillip Burton, I Do Data Limited
Expert at Udemy
With years of hands-on experience in IT & Software, Phillip Burton, I Do Data Limited has dedicated thousands of hours to teaching and mentorship. This course is the culmination of industry best practices and a proven curriculum that has helped thousands of students transition into professional roles.
Community Feedback
Michael Chen
Verified Enrollment
"This MO-210 prep: Microsoft Excel (from beginner to intermediate) course was exactly what I needed. The instructor explains complex IT & Software concepts clearly. Highly recommended!"
Sarah Johnson
Verified Enrollment
"I've taken many Udemy courses on advanced data analysis & Excel automation, but this one stands out. The practical examples helped me land a job."
David Smith
Verified Enrollment
"Great value for money. The section on IT Certifications was particularly helpful."
Emily Davis
Verified Enrollment
"Excellent structure and pacing. I went from zero to hero in IT & Software thanks to this course. Lifetime access is a huge plus."
Common Questions
Is the "MO-210 prep: Microsoft Excel (from beginner to intermediate)" course truly discounted?
Do I qualify for a certificate upon completion?
What happens if the coupon code expires?
Verified Discount Code
Claim Your Discount Code
REVEAL & COPY
