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. Refreshments are available from 9am.

We provide:

• Full course material
• Certificate of attendance
• 90 days post course support
• Note pad and pen
• Polos!

Also includes:

• Free on-site parking
• Refreshments throughout the day
• Lunch at a local restaurant
• Free WiFi

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.

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

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