Excel - introduction (In-House)

1 Creating a table

• Creating an Excel table from scratch
• Wrapping text in cells
• Speeding up data entry using AutoFill
• Sorting columns

2 Inserting function

• Inserting function calculators
• Using AutoSum to sum numbers
• Statistical calculations AVERAGE, MAX and MIN

3 Table rows and columns

• Inserting and deleting rows and columns
• Adjusting multiple column widths and row heights
• Hiding and unhiding rows and columns

4 Formula writing

• The basics of formula writing
• Understanding mathematical symbols
• Using multiple mathematical symbols in a formula
• When to use brackets
• Troubleshooting calculation errors

5 Managing sheets

• Inserting, renaming, moving and deleting sheets
• Copying a worksheet to another file
• Copying a table to another sheet

6 Managing content formats

• Applying data formats
• Managing number formats
• Controlling formats with the Format Painter

7 Managing larger tables

• Applying freeze panes to lock tables when scrolling
• Sorting on multiple columns
• Using filters to extract table information

8 Creating and modifying charts

• Creating a pie chart
• Creating a column chart
• Inserting chart titles and data labels
• Controlling chart formatting
• Changing chart types

9 Printing

• Previewing and printing tables and charts
• Modifying page orientation
• Adjusting print margins
• Printing a selection

10 Calculating with absolute reference

• The difference between a relative and absolute formula
• Changing a relative formula to an absolute
• Using $ signs to lock cells when copying formulas

11 Pivot tables

• Create a pivot table report
• Insert a pivot chart into a report