Excel 2019 Exam MO-200 - Manage Data Cells and Ranges Part 1

In today's video, we are looking at the Excel 2019 MO-200 Exam and we are talking about the second domain for the exam called Manage Data Cells and Ranges. This is a two-part series. This video is part one in the series and it covers the first and fourth subdomains called Manipulate data in worksheets and Summarize data visually.

Part 2 of the series: is to be released in the future.

Video objectives are:
2.1.1 Paste data by using special paste options
2.1.2 Fill cells by using Auto Fill
2.1.3 Insert and delete multiple columns or rows
2.1.4 Insert and delete cells
2.4.1 Insert Sparklines
2.4.2 Apply built-in conditional formatting
2.4.3 Remove conditional formatting

BELOW ARE ADDITIONAL RESOURCES

RECOMMENDED READING

MY YOUTUBE GEAR

CAMERAS

MICROPHONES

HEADSETS

SOFTWARE

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This helps support the channel and allows me to continue to make videos like this. Thank you for your support!

[alanahorrell]

I passed the cert exam. Many thanks to you!

[sergemorales]

Cert exam passed! Your videos were a great help! Thank you Brendan!

[alangi]

thank you so much for this. its very transparent and clear.

[anamikaverma]

@Brendan Sinclair When are you uploading Part 2 of this video? I am learning a lot from your videos. Thanks for uploading clear and crisp videos.

[sarahm.jordan]

I took the test and found it to be a little difficult. Not really good with nesting formulas, but I need to work on my speed. Can't seem to move fast enough. You have any suggestions?