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

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 two in the series and it covers the second and third subdomains called Format cells and ranges and Define and reference named ranges.

Video objectives are:
2.2.1 Merge and unmerge cells
2.2.2 Modify cell alignment, orientation and indentation
2.2.3 Format cells by using Format Painter
2.2.4 Wrap text within cells
2.2.5 Apply number formats
2.2.6 Apply cell formats from the Format Cells dialog box
2.2.7 Apply cell styles
2.2.8 Clear cell formatting
2.3.1 Define a named range
2.3.2 Name a table

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!

[jazminesalazar]

Thanks so much for doing these videos I truly appreciated it.

[augustinetettehozor]

Thank you Brendan. I just pass my exams.

[anamikaverma]

Thanks for uploading the new video. I have been waiting for it.

[haiyawo]

Excellent videos! thank you so much! will take exam in 3 weeks :)

[TengkuNurAzilaRajaMamat]

Nice sharing and very helpful for me to prepare/do revision for exam..thanks

[Diehardjeffhardyfan]

Hi Brendan your videos are awesome just letting you know there’s a glitch at 5:34