Course description
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.
Upcoming start dates
Choose between 2 start dates
Outcome / Qualification etc.
- Create tables
- Use functions
- Manage rows and columns
- Write formulas
- Manage sheets
- Use content formats
- Handle larger tables
- Create reports and charts
Training Course Content
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
Course delivery details
A very practical, interactive one-day session for a maximum group size of 12. Comprehensive materials provided.
Request info
The In-House Training Company
22 South Burgundy House, The Foresters, High Street
AL5 2FB Harpenden
The In-House Training Company
We offer top-quality in-house training, in a wide range of subjects, at sensible prices. All of our programmes are delivered by independent subject specialists who also have outstanding training skills. We have rigorous standards and only work with the very...
Ads