This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets.
This course will help participants:
Create tables
Use functions
Manage rows and columns
Write formulas
Manage sheets
Use content formats
Handle larger tables
Create reports and charts
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