This online course is suitable for those with a busy schedule and is adaptable to the challenges of every lifestyle. Participants can attend the live course at the times outlined below and will have access to the recorded courses for 6 months after completion.
A trainer will be on hand after each module to answer trainee questions and participants will have access to a dedicated trainer email for queries after the course is completed.
If you’re unable to attend the live courses, a recorded copy of the course will be provided to you also along with all relevant course files and documents!
Module 6: 26th March – 11:00am – 12:30pm
Module 7: 31st March – 09:30am – 11:00am
Module 8: 31st March – 11:30am – 01:00pm
Module 9: 1st April – 09:30am – 10:30am
Module 10: 1st April – 11:00am – 12:30pm
Excel 6: Working with Dates / Protecting worksheet and workbook content including Data Validation.
Working with Dates
Understanding how Excel sees dates
Calculating the difference between 2 dates
The TODAY Function
EOMONTH / ISONUMBER
Using the Text Function with dates
Text to Columns to convert date format
Protecting worksheets, workbooks and restricting input.
Data Validation – Text, Numbers, Drop-Down List.
Locking cells and enforcing protection
Password protecting workbooks
Excel 7: More on Functions – Named Ranges / Subtotals / SUMIFS / COUNTIFS / IF Function (and / or), Nested Functions / IFERROR
Refreshing a Pivot Table / Refresh automatically on opening
Using the Pivot Table Design Ribbon
Resizing columns and preserving column widths
Grouping Dates / Grouping Fields
Using Slicers with Pivot Tables
Creating / Modifying Calculated Fields
Creating and Modifying Pivot Charts
Excel Webinar 10: Recording and Editing Macros
Recording simple macros
The VB Editor
A brief explanation of VBA code
Assigning macros to buttons
Building a macro to open a file and copy data
Assigning macros to the Ribbon
Who Should Attend?
This course is designed to follow-on from MS Excel Level Two (Intermediate). Having already familiarised yourself with the most efficient way of performing everyday tasks and now that you have mastered the more commonly used Intermediate topics, it is now time to build on that knowledge. A large proportion of the course is dedicated to managing and manipulating lists of information from working with tables & slicers up to creating and working with Pivot Tables.
Useful functions such as IF and VLOOKUP are covered in addition to automating tasks using Macros etc. It is highly recommended that you first attend the Excel Level Two (Intermediate) course before attending this advanced course if you are not already fully familiar with the Intermediate topics.
All participants will be given access recordings of the webinars by way of an email along with copies of files used and User Reference Material. These will be available to participants for 6 months following the course.
A Cork Chamber Skillnet / E-Bridge Certificate of Attendance will be awarded to each participant on completion of all courses. A sample copy is attached for your approval.
Ideally, those attending should have already attended the Excel Intermediate course or have an equivalent skill level. If you have a very basic knowledge of Excel, it is recommended that you attend the Excel Intermediate course in advance.