Description
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert, Microsoft Excel Certification Exam Prep: MO-201 Excel Expert, is published by Udemy Academy. This course is specially designed to help you take the MO-201 Excel specialized course and obtain Microsoft’s specialized certificate for Excel 2019 or Office 365. With hands-on projects, complete practice tests, and a free downloadable study guide, this is the only course you need for the MO-201 Excel exam. Unlike other exam preparation courses, this course is a hands-on, 100 percent project-based course designed to test your skills with hands-on demos and unique business intelligence case studies.
You’ll work with real Airbnb data and use full Excel tools to analyze property details, rental rates, mortgage forecasts, and everything in between. By the end of the course, you’ll be able to use advanced formulas and functions, design custom images and templates, examine data with PivotTables, automate manual tasks with macros, collaborate with other users, and more. We’ve even included several custom practice tests designed to replicate the structure of the real MO-201 Excel exam and prepare you for the real exam.
What you will learn
- Analyze data with advanced formulas, including logical operators, searches, time functions, and more
- Automate laborious manual tasks without code with user-friendly VBA macros
- Visualize data with advanced charts such as histograms, treemaps, spatial maps, funnels, and combination charts.
Manage and format data with custom formats, autofill and flash, data validation, and conditional formatting
Review data on the fly with PivotTables, Pivot Charts, Pivots, and timelines. Customize office settings such as protection and encryption, calculation modes, comments, and language tools.
Who is this course suitable for?
- Excel users looking to pass the MO-201 exam and become a Microsoft Certified Professional
- Aspiring data professionals looking to earn valuable industry credentials
- Anyone looking to build a deep and good Excel skill set
- Students looking for an interactive and project-based approach to preparation
Microsoft Excel Certification Exam Prep Course Details: MO-201 Excel Expert
- Publisher: Udemy
- teacher : Enrique Ruiz , Maven Analytics
- English language
- Education level: all levels
- Number of courses: 98
- Training duration: 8 hours and 33 minutes
Head of the course chapters on 2022-12
Course prerequisites
-
Microsoft Excel 2019+ or Office 365
-
Familiarity with core Excel functionality recommended, but not required
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
3.63 GB
Be the first to comment