Excel Intermediate

Excel Logo
Loading Map....

This event is currently not scheduled. If you are interested, please do not hesitate to contact us via the form below.

Location
Quill

Categories


This one-day course is appropriate if you have used Excel before and are reasonably confident with Excel basics such as simple formula creation, cell formatting, naming of cells, and saving and printing of workbooks.

Audience Profile

It is assumed attendees have good general computing skills, are familiar with the Windows environment and have attended an introductory course in Excel or have equivalent experience.

At Course Completion

At the completion of the course you should be familiar with a number of techniques that enable the creation of more sophisticated workbooks. You should be able to create a protected workbook that incorporates embedded charts and use a range of data list management tools.

You will also be able to create well documented and consistently formatted workbooks and automate simple tasks.

Course Topics

review of spreadsheet basics
text boxes and drawing objects
charting review
worksheet comments
worksheet and workbook protection
naming cells
linking worksheets and workbooks
conditional formatting
data list management (sorting, filtering, creating subtotals)
PivotTables
using lookup functions
adding form control to worksheets
data validation
creating simple macros using Visual Basic for Applications

NOTE: This course will be given online however if you wish to do the session at Quill please contact us directly as spaces are limited due to the COVID-19 precautions that need to be taken.

Bookings

Bookings are closed for this event.

Course enquiry

Would you like additional information about this event ?