Excel – introduction
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.
It will help you:
- Use Excel more efficiently – and more confidently
- Output accurate results for reports
- Trouble-shoot errors as they occur
Learning objectives
- Create tables
- Use functions
- Manage rows and columns
- Write formulas
- Manage sheets
- Use content formats
- Handle larger tables
- Create reports and charts
Pre-requisites
- No previous Excel experience required
- Designed for Office 365, versions: 2016, 2013 and 2010
This course offers useful shortcuts and is therefore also suitable for those who are self-taught.
Format
A very practical, interactive one-day session for a maximum group size of 12. Comprehensive materials provided.
Expert trainer
See what some of the participants have said about his workshops:
‘Fantastic. Well-paced and easy to follow.’
‘Great experience.’
‘Very personable, relatable, patient and able to present complicated processes in an understandable way.’
‘Friendly and good at checking people are up to speed.’
‘Very good and explained and answered all questions.’
‘Explains everything well.’
‘Very knowledgeable would love to have him again if there is another course – thank you.’
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
Any questions? Please just give us a call on 01582 463463 – we’re here to help!