Microsoft Excel Expert (Excel and Excel 2019) Video Course

MO-201: Microsoft Excel Expert (Excel and Excel 2019)

Your Microsoft MO-201 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the MO-201 certification test. Ace your Microsoft MO-201 at the first attempt and obtain the Microsoft Excel Expert (Excel and Excel 2019) credential with ease.

# of Students
145
# of Lectures
92
Course Length
8 h
Course Rating
5.0
Price $27.49
Today $24.99

Curriculum for MO-201 Video Course

About the MO-201 Exam

  Video Name Time
  1. Exam Structure 1:00
  2. Objective Domains & Skills Measured 2:00
  3. Exam Interface & Scheduling 2:00
  4. Helpful Resources 2:00
  Video Name Time
  1. Course Project Intro 1:00
  2. The Airbnb Dataset 8:00
  Video Name Time
  1. Objective Domain Intro 2:00
  2. Fixed vs. Relative References 9:00
  3. Explicit vs. Structured References 9:00
  4. Logical Operations 3:00
  5. The IF Function 6:00
  6. Nested IF Functions vs. The IFS Function 8:00
  7. The NOT & “<>” Operators 5:00
  8. The AND/OR Operators 8:00
  9. The SWITCH Function 9:00
  10. The COUNTIF/SUMIF/AVERAGEIF Functions 8:00
  11. COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria 9:00
  12. The MINIFS & MAXIFS Functions 4:00
  13. Excel Date Values & Formatting 7:00
  14. PRO TIP: Converting Text to Dates 6:00
  15. The TODAY & NOW Functions 5:00
  16. YEAR/MONTH/DAY & HOUR/MINUTE/SECOND 3:00
  17. WEEKDAY, WORKDAY & NETWORKDAYS 6:00
  18. Recording a Macro 7:00
  19. Modifying & Deleting Macros 3:00
  20. PRO TIP: Adding Form Controls 4:00
  21. Lookup Functions 1:00
  22. The VLOOKUP & HLOOKUP Functions 14:00
  23. The INDEX Function 3:00
  24. The MATCH Function 4:00
  25. Combining INDEX & MATCH 10:00
  26. Approximate Match Lookups 5:00
  27. The PMT & NPER Functions 10:00
  28. Scenario Manager 6:00
  29. Consolidate Data 7:00
  30. Goal Seek 5:00
  31. Formula Auditing 12:00
  Video Name Time
  1. Objective Domain Intro 1:00
  2. Custom Number Formats 7:00
  3. Data Validation 8:00
  4. Group & Ungroup Data 5:00
  5. Subtotals & Totals 5:00
  6. Removing Duplicates 9:00
  7. Auto Fill & Flash Fill 9:00
  8. Advanced Fill Series Options 5:00
  9. Conditional Formatting 8:00
  10. Formula-based Conditional Formatting 13:00
  11. Managing Conditional Formatting Rules 5:00
  12. PRO TIP: Hiding Values to Create Heatmaps 3:00
  Video Name Time
  1. Objective Domain Intro 2:00
  2. Box & Whisker Chart 8:00
  3. Histogram 6:00
  4. Filled Map 6:00
  5. Combo Chart 8:00
  6. Tree Map & Sunburst Chart 8:00
  7. Waterfall Chart 4:00
  8. Funnel Chart 4:00
  9. Creating a Pivot Table 8:00
  10. Modifying Pivot Table Views 5:00
  11. "Summarize Values By" Options 6:00
  12. "Show Values As" Calculations 9:00
  13. Analyze & Design Tabs 1:00
  14. Report Layouts & Options 4:00
  15. Number Formatting 4:00
  16. Sorting & Filtering 7:00
  17. Slicers & Timelines 5:00
  18. Grouping Text Fields 3:00
  19. Grouping Numerical Fields 6:00
  20. Grouping Date Fields 5:00
  21. Calculated Fields 7:00
  22. Calculated Items 5:00
  23. Pivot Charts 5:00
  24. Pivot Chart Formatting 2:00
  25. Expanding & Collapsing Pivot Charts 3:00
  Video Name Time
  1. Objective Domain Intro 1:00
  2. Enabling Macros 3:00
  3. Copying Macros to Other Files 4:00
  4. Linking Data Across Workbooks 7:00
  5. Protecting Worksheets & Cell Ranges 6:00
  6. Protecting & Encrypting Workbooks 4:00
  7. Recovering Workbooks 3:00
  8. Managing Comments 6:00
  9. Formula Calculation Modes 4:00
  10. Language Options 4:00
  Video Name Time
  1. Practice Test Intro 2:00
  2. Practice Test Structure 3:00
  3. SOLUTION: Project 1 7:00
  4. SOLUTION: Project 2 5:00
  5. SOLUTION: Project 3 4:00
  6. SOLUTION: Project 4 6:00
  7. SOLUTION: Project 5 7:00
  8. SOLUTION: Project 6 3:00

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
5.0
Rating: 5.0
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • Alibaba
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • CertNexus
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HashiCorp
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • NetSuite
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Pulse Secure
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • Slack
  • SNIA
  • Snowflake
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Special Offer! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address