Microsoft Excel (2016) Certification Exam

Want more in depth training? Join my online course here for more practice tests and Excel activities that will help you pass your MOS exam: https://www.udemy.com/course/mos-excel-exam-77-727/?couponCode=18630E267091D31B2BE2

Also, check out this link for the required skills for this exam that was posted by Microsoft: https://www.microsoft.com/en-us/learning/exam-77-727.aspx

Skip to any skill in this video by clicking on the ⌚time stamps⌚ below:
Project 1:
1:12 Table Formatting-Banded rows
1:36 Sorting table fields
3:07 Average function
3:36 Conditional formatting
4:11 Max function
4:40 Remove duplicates
Project 2:
5:07 Hide rows
5:22 Delete column
5:33 Proper Function
6:17 Print titles
Project 3:
6:47 Insert a new worksheet
7:16 IF function
9:00 Insert Sparkline
9:38 Add a new series to a chart
10:13 Display formulas
Project 4
10:30 Property Title
10:45 Auto fill
11:00 AverageIF function
11:32 Copy a worksheet
12:07 Insert a picture

Project 5:
12:36: Import data from a CSV file
13:33 Add a row to a table
14:03 Resize a chart
14:47 Move a chart
15:23 Switch Rows and columns of a chart
16:04 Insert column
16:26 Convert a table to a range
16:48 Copy and Paste data
17:12 Insert a chart and change chart title

Видео Microsoft Excel (2016) Certification Exam канала Mike's Office