Video-1.jpg

Please watch the following Videos as they will demonstrate the material in this section and how to complete required coursework:

Video 1: Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions (Publisher Content)

Video 2: Move Data, Resolve Error, Messages, and Rotate Text  (Publisher Content)

Video 3: Use COUNTIF and IF Functions and Apply Conditional Formatting  (Publisher Content)

Video 4: Use Date & Time Functions and Freeze Panes (Publisher Content)

Video 5: Create, Sort, and Filter an Excel Table  (Publisher Content)

Video 6: View, Format, and Print a Large Worksheet  (Publisher Content)

Video 7: Navigate a Workbook and Rename Worksheets  (Publisher Content)

Video 8: Enter Dates, Clear Contents, and Clear Formats  (Publisher Content)

Video 9: Copy and Paste by Using the Paste Options Gallery  (Publisher Content)

Video 10: Edit and Format Multiple Worksheets at the Same Time  (Publisher Content)

Video 11: Create a Summary Sheet with Column Sparklines  (Publisher Content)

Video 12: Format and Print Multiple Worksheets in a Workbook  (Publisher Content)