If you clicked on this video you're probably wondering how am I ever going to pass the Excel 2019 or MO 200 exam when there's just no information out there about this exam?
CHECK OUT THE NEW UPDATED VERSION HERE:
https://www.youtube.com/watch?v=fyMA8SuksSY
PATREON: https://www.patreon.com/MikesOffice
UDEMY COURSE: https://www.udemy.com/course/mo-200-microsoft-excel-3652019-associate-certification/?referralCode=67F1B4330E36ECCACFE5
Well I'm going to share with you this practice exam with 6 projects that will show you tasks that are similar to ones you might run into on your Excel exam so that you can be well prepared. We're going to look at chart elements, new Excel functions, and tons of other skills you need to learn for your exam.
TIME STAMPS:
PROJECT 1
1:07 Navigate to a range and delete range
1:42 Format numbers to no decimal places
2:25 Remove table row
3:11 Average Function
3:45 Concat (join) Function
5:19 Remove table functionality
5:50 Freeze rows
PROJECT 2
6:59 Copy a formula
7:25 Remove conditional formatting
7:52 Format a table so every other row is shaded (Banded rows)
8:34 Sort multiple columns
10:20 Max Function
10:56 Remove duplicates
PROJECT 3
11:52 Print Titles (repeat titles on multiple pages)
12:56 Filter data
13:45 IF Function
16:13 Multiple two values
17:00 Create a chart in Excel
18:27 Add an alt description
19:19 Insert Sparklines
PROJECT 4
20:08 Left align text
20:24 Left Function
21:21 Conditional Formatting (Three Traffic Lights)
22:17 Apply a table style
22:53 Change chart color (Monochromatic Palette)
23:18 Add a data table to a chart
PROJECT 5
23:54 Import data from a text file
25:16 Move a chart to its own chart sheet
26:08 Add chart element: Add axis titles to a chart
26:57 Remove elements in a chart-Chart legend
PROJECT 6
27:54 Copy and paste formatting
28:48 Table name
30:01 Use named ranges in a formula
31:18 CountBlank Function