Excel Certification Exam - Professor Adam Morgan

Excel 2016 - MOS Exam Certification - Microsoft Office Specialist Test Practice Training

Highlights

• 01:05 Change the backstage title
• 01:35 Hyperlink a website
• 02:30 The average over a specific number
• 04:05 Autosum
• 04:45 If function
• 06:15 Conditional formatting
• 07:40 Create a graph/chart
• 08:10 Change the chart title
• 08:30 Change the series
• 09:37 Create a table
• 09:50 Display a total row
• 10:15 Create banded rows
• 10:30 Remove duplicates
• 11:00 Convert table to range
• 11:14 Sparkines
• 11:50 Rows that repeat at the top when print