Microsoft Excel Foundation Training

Create a Table: Creating an Excel table from scratch - Wrapping text in cells - Formatting table content - Speed up data entry with AutoFill - Sorting columns.

Inserting Functions: Inserting and managing function calculations - Using AutoSum to sum numbers - Inserting statistical calculations AVERAGE, MAX and MIN.

Managing Rows and Columns: Inserting and deleting table rows and columns - Quickly adjusting multiple column widths and row heights - Hiding and unhiding rows and columns.

Writing 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.

Managing sheets: Inserting, renaming, moving and deleting sheets - Coping a sheet to another file - Copying a table to another location.

Managing Content Formatting: Appling content formatting - Managing number formatting - Control formatting with the Format Painter.

Sorting and Filtering Tables: Using Freeze Panes to lock table headings when scrolling - Sorting multiple columns - Using Filters to extract table information.

Table Reports: Using the Table tool to run reports - Including totals in reports.

Creating and Modifying Charts: Creating Pie and Column charts - Inserting chart titles and labels - Controlling chart formats - Changing chart type.

Printing: Previewing and printing tables and charts - Modifying page orientation - Adjust margins for printing - Printing selected tables.

Absolute Referenced Formula: Understand the difference between a Relative and Absolute formula - Using a $ sign to lock formulas to cells when copying.