Lesson 1Create a Table: Creating an Excel table from scratch. Wrapping text in cells. Formatting table content. Speed up data entry with AutoFill. Sorting columns.Lesson 2Inserting Functions: Inserting and managing function calculations. Using AutoSum to sum numbers. Inserting statistical calculations AVERAGE, MAX and MIN.Lesson 3Managing Rows and Columns: Inserting and deleting table rows and columns. Quickly adjusting multiple column widths and row heights. Hiding and unhiding rows and columns.Lesson 4Writing Formulas: The basics of writing formulas. Understanding the use of mathematical symbols. Using more than one mathematical symbol in a calculation. When to use brackets. Troubleshooting calculation errors.Lesson 5Managing sheets: Inserting, renaming, moving and deleting sheets. Coping a sheet to another file. Copying a table to another location.Lesson 6Managing Content Formatting: Appling content formatting. Managing number formatting. Control formatting with the Format Painter.Lesson 7Sorting and Filtering Tables: Using Freeze Panes to lock table headings when scrolling. Sorting multiple columns. Using Filters to extract table information.Lesson 8Table Reports: Using the Table tool to run reports. Including totals in reports.Lesson 9Creating and Modifying Charts: Creating Pie and Column charts. Inserting chart titles and labels. Controlling chart formats. Changing chart type.Lesson 10Printing: Previewing and printing tables and charts. Modifying page orientation. Adjust margins for printing. Printing selected tables.Lesson 11Absolute Referenced Formula: Understand the difference between a Relative and Absolute formula. Using a $ sign to lock formulas to cells when copying.