MO-211: Microsoft Excel Expert (Microsoft 365 Apps)
Loại khoá học: Tin học văn phòng
Learn the skills for the new MO-211 Excel certification. Create PivotTables, simple macros, advanced charts and formulas
Mô tả
The MO-211 certification is the new Expert certification for Excel, launched in April 2023. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification.
This course has been created using Udemy's Accessibility guidelines. It follows on from your preparations for the MO-210 Excel certification. This content is available in "MO-210: Microsoft Excel (from beginner to intermediate)", which is published on Udemy.
In this MO-211 course:
We’ll start with managing workbook options and settings. We’ll reference data in other workbooks, manage workbook versions, and prepare workbooks for collaboration by protecting their content and structure. We'll also format and valid data, including creating custom number formats.
We’ll then manage advanced charts and tables. We’ll create PivotTables, configuring value field settings and adding slicers, with create and modify PivotCharts, and create and modify advanced charts, including Box & Whisker, Funnel, Histogram, Sunburst and Waterfall charts.
We’ll then create advanced formulas and macros. We’ll use functions for performing logical operations, looking up data, use advanced date and time functions, perform data analysis and troubleshoot formulas. This will also include newer Excel functions, such as XLOOKUP, LET, FILTER and SORTBY.
Finally, we’ll look at other Excel Expert topics. We’ll fill cells based on existing data, we'll create custom conditional formatting rules, and create and manage simple VBA macros.
No prior knowledge is required. And there are 10 Practice Activities, 10 quizzes and a Practice Test to help you remember the information, so you can be sure that you are learning.
Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-211 exam, which gives you the "Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)" certificate. This would look good on your CV or resume.
It is also the first stage to you getting the "Microsoft Office Specialist: Expert (Microsoft 365 Apps)" certification.
Bạn sẽ học được gì
Manage workbook options and settings, including preparing workbooks for collaboration
Manage and format data
Fill cells based on existing data, format and validate data and apply advanced conditional formatting
Create advanced formulas and macros
Logical functions include IFS, SWITCH, SUMIF, SUMIFS, AND, OR, NOT and LET
Lookup functions are XLOOKUP, VLOOKUP, HLOOKUP, MATCH and INDEX
Other functions include WEEKDAY, WORKDAY, NPER, PMT, FILTER and SORTBY
Manage PivotTables, PivotCharts and advanced charts, including g Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts
Yêu cầu
- Before beginning, you will need to know how to use a Windows computer, including a mouse.
- You also need to have all of the skills covered by the MO-210 Excel exam.
- You should have MS Excel (or Office) from 2022 or later installed on your PC computer. This program is also known as a Microsoft 365 App.
Nội dung khoá học
Viết Bình Luận
Khoá học liên quan
Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!
Get khoá học giá rẻ ngay trước khi bị fix.
Đánh giá của học viên
Bình luận khách hàng