For business IT peace of mind call
01553 609969

Update and refresh with Microsoft Excel Update and refresh with Microsoft Excel

This one day course is designed for users who wish to update and refresh their knowledge in the Excel application to become more confident and adept when selecting and applying commands. There will be an opportunity to create spreadsheets incorporating basic formulas, charts, applying editing and formatting techniques.


Delegates should be familiar with the keyboard, knowledge of working with Microsoft Office Excel and Microsoft Windows Operating System.

Course details

Excel Interface
Quick Access Toolbar
Backstage view
Save and Sharing Options
The Ribbon, Tabs and Groups
Contextual Tabs and Mini Toolbar
Using Pre-made Templates

Refresh on structure of Worksheet
What’s new? (Excel 2010 / 2013)
Working with Workbook Window
Inserting new Worksheets
Linking between Worksheets
Renaming and colouring Worksheets

Page Setup, Layout and Printing
Display and Page Layout
Headers and Footers
Page Orientation
Print Options
Open a New Window within a Workbook
Copying, Moving Data

Formatting and Editing techniques
Formatting Options
Date and Time, Currency
Cut, Copy and Paste Special options
Wrap and Merge Cells
Find and Replace
Sorting and Filtering Data
Working with Hyperlinks
Applying Conditional Formatting
Freeze and Hide Columns and Rows

Formulas and Functions
Operators and Basic Formula Add, Subtract, Multiply and Divide
Autosum, Average, Min, Max, If (count & Sum) Statements
Viewing and Checking Formulas

Introduction to Charts
Building Charts and Sparklines
Adjust Chart Design and Layout
Resizing and moving Charts

Time Saving Tips
Applying Keyboard Shortcuts
Using Hot Keys
Using Help
Using Paste Special
Using the Format Painter
Add Comments to a Workbook
Replication using the Fill Handle

* There may be some flexibility in content according to the audience on the day

Reserve Your Place(s)


£175 per person (+vat)


Yours Business Network
Bishops Lynn House
18 Tuesday Market Place
King's Lynn
PE30 1JW

This course can also be held at your own premises or at a venue of your choice, please contact us for details.

Our Blog

How to Keep Your Data Safe Online

For both individuals and business, keeping data secure is crucial - whether it is passwords, financial information and any other personal data. Cyber attacks have... Read More »

Windows 7 end of life, what does it mean for my business?

On the 14th of January 2020 Windows 7 will be entering its end of life, the implications for machines running this are far reaching as... Read More »

Is your phone recording your conversations?

We are always on guard when talking -- whether on the phone or in public -- we obviously do not want any stranger to listen... Read More »

Call today if you would like to learn more about how you can protect and streamline your IT and data with Anglia IT Solutions.

King's Lynn Office01553 609969

Norwich Office01603 959000