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.

More Videos on the Excel 2019 MO-20 Exam can be found here:    • Excel 2019 Exam MO-200  

Excel 2019 Exam Domains: https://certiport.filecamp.com/uniq/n...

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
MOS Study Guide for Microsoft Excel Exam MO-200: https://amzn.to/3aXgYYd
Microsoft Excel 2019 Step by Step: https://amzn.to/2M2Fa0D
Excel 2019 Bible: https://amzn.to/2M9IJSV
MOS Study Guide for Microsoft Excel Expert Exam MO-201: https://amzn.to/3aX8uAs

MY YOUTUBE GEAR

CAMERAS
Logitech BRIO: https://amzn.to/2M1Ky44
Logitech HD Pro Webcam C920: https://amzn.to/2Cfnr1x

MICROPHONES
Rode NT-USB: https://amzn.to/2M4wlDt
Blue Yeti USB Microphone: https://amzn.to/2H4BPiS

HEADSETS
Bose QuietComfort 35: https://amzn.to/2D00T6u
Logitech H800: https://amzn.to/2CgZ3g6

SOFTWARE
Camtasia 2020: https://amzn.to/2yqtOBa
Microsoft Office 365 Home (PC/MAC): https://amzn.to/2ulshqo
Adobe Creative Cloud: https://amzn.to/2RFy5rT
TubeBuddy: https://www.tubebuddy.com/Brendan

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!