If you've used Excel before and understand simple calculations including AutoSum, then this course will help move your knowledge and confidence on to the next level.

• How to work with dates and times - Calculate age or stock date expiry warnings
• ​Build in logic with the IF function - Monitoring stock levels to display re-order information
• Conditional formatting - Automatically highlight relevant information, e.g. stock that needs re-ordering
• ​Absolute cell addressing - Lock cell references with dollar signs and learn why you would use this
• Database features - Sort, filter and sub-total lists of stock by category
• Calculations across multiple sheets - ​Store data with a sheet per month and create an annual summary
• ​Charting - Create a graphical representation of summary data for use in meetings

Revision

• New Features and Product overview
• File Formats and Working in Compatibility mode
• Quick Access Toolbar and Excel Options
• Revision Exercise

Functions

• Date function
• Time function
• Round function
• IF function
• Integer function

Cell Addressing

• Absolute cell addresses
• Relative cell addresses

Conditional Formatting

• Applying conditional formats to text
• Applying conditional formats to numerical values
• Clearing rules

Database Features

• Using a spreadsheet as a database
• Sorting data
• Basic subtotals
• Filtering data with Filter
• Custom Filter
• Find Feature

Working with Multiple Sheets

• Selecting sheets
• Inserting & deleting sheets
• Copying sheets
• Copy and paste between sheets
• Naming sheets
• 3D calculations
• Group edit facility
• Using Hyperlinks to link worksheets

Working with Multiple Workbooks

• Opening multiple workbooks
• Arranging windows
• Linking workbooks
• Hyperlinks to worksheets and workbooks

Additional Features

• Inserting comments

Charting

• Revision of basic charts
• Chart types
• Sizing and moving a chart
• Editing a chart
• Changing chart data
• Formatting chart elements
• Drawing features
• Printing a chart

The course runs from 9:30am through to 4:30pm.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

• Excel Advanced Level 1
• Excel Advanced Level 2
• Word Intermediate