Excel - Intermediate

Courses will be delivered on Office 2013 but are also suitable for Office 2010 users.

So, you’ve mastered basic excel but you want to learn more about the application and delve a little deeper into its functionality:

Module 1

Customise quick access toolbar, database rules, Sort a database, multiple sorting, find and replace data

Module 2

Using the dataform, autofilter, conditional criteria, top 10fFilters, advanced filters

Module 3

Text to columns, merge cell data, database functions, formula and command linking, linking workbooks, hyperlinking

Module 4

Protect sheets, protect cells, protect workbook, freeze panes, working with comments

It is the responsibility of the student to ensure that they are booking onto the correct level of course based on their current level of understanding of the application.

We would ask that students have basic computer skills and have a good command of English.

Please also note that you will need access (on a desktop computer) to your personal email address during the course so please ensure you have your password with you.

Bespoke Requirements?

We also offer all of the above courses (as well as Word, Outlook and PowerPoint) on a bespoke basis for businesses at dates and times mutually convenient, if this would be of interest please contact me to discuss further and we’ll organise a quotation based on your requirements.

For more information about this course, contact our specialist team on 01254 29 25 00 or email business@blackburn.ac.uk.