Date(s) - 27/05/2019
9:00 am - 4:30 pm
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.
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.
This course covers Excel versions 2010, 2013 and 2016
review of spreadsheet basics
text boxes and drawing objects
worksheet and workbook protection
linking worksheets and workbooks
data list management (sorting, filtering, creating subtotals)
using lookup functions
adding form control to worksheets
creating simple macros using Visual Basic for Applications