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)