This video will share with you five new MOS Excel exam projects and over 30 MOS Excel exam tasks. This version works for MOS Excel 2016 and 2019.
Need the practice files? Consider supporting the channel for $3 here and get them all!
PATREON: https://www.patreon.com/MikesOffice
Want more in depth training? Join my class for more training and practice exams:
https://www.udemy.com/course/mos-excel-exam-77-727/?couponCode=18630E267091D31B2BE2
Time stamps:
0:30 Find and replace text in Excel
1:31 Merge cells without moving the text in Excel
2:36 Wrap text in Excel
3:06 Count Function
4:27 CountIF Function
5:51 Subtotal Excel
7:35 Picture effects in Excel
8:29 Create a new worksheet
9:01 Change worksheet tab color
9:53 Hide a worksheet
10:53 Remove personal information from a workbook
11:34 Import information from a Word document into Excel
12:25 Apply a table style
13:00 Add chart elements to a chart in Excel
14:29 Move a chart to its own chart sheet
15:40 Switch/Swap axis data on an Excel chart
16:31 Add document properties
17:11 Copy a formula and fill without formatting
18:45 Average Function
19:38 Rotate a picture in Excel
20:29 IF Function
23:32 Add a sparkline in Excel
24:41 Add a series to a chart in Excel
25:00 AverageIF Function
Want more MOS Excel practice?
Click on this video for my previous Excel exam practice: https://www.youtube.com/watch?v=0wCCN_ab5Gk
and here for my Excel crash course: https://www.youtube.com/watch?v=Vrxjz5TV3VU
Need more help? Let me know what you would like to see in my next MOS Exam Excel 2019 video
