In this video, I demonstrate all of the formulas that you could see on the Excel 2019 Exam MO200. Ultimately I am going over the exam domain called Perform Operations by using Formulas and Functions which makes up 2025% of the exam. This video covers insert relative, absolute and mixed references, using named ranges and named tables in formulas, and these functions: AVERAGE, MAX, MIN, SUM, COUNT, COUNTA, COUNTBLANK, IF, RIGHT, LEFT, MID, UPPER, LOWER, LEN, CONCAT, AND TEXTJOIN.
BELOW ARE ADDITIONAL RESOURCES
All domains and subdomains for the Excel 2019 MO200 Exam can be found here: https://certiport.filecamp.com/uniq/n...
Extra reading for EXCEL
MOS Study Guide for Microsoft Excel Exam MO200: 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 MO201: 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 NTUSB: 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!