Advanced Microsoft Excel

Overview
Curriculum
Instructor

The course is aimed at those participants who have spent a considerable amount of time using Excel and need to incorporate work from other products. It is also for those who wish to automate and apply shortcuts to their work. A sound knowledge of spreadsheets and a familiarity with Microsoft Excel is necessary.

This course will provide instruction on;

Advanced Logical Functions
Lookup Functions
Solver
Goal Seek
Scenarios
List Management
PivotTables and PivotCharts
Macros

Participants in the course must complete all the listed assignments for marking by the instructor in order to pass.

Curriculum

1 Section
6 Lessons
6 Weeks

Expand all sectionsCollapse all sections

Advanced Microsoft Excel
12

Damien Wilson

Damien provides a depth of knowledge and skills in providing ICT training and consulting, specialising in “plain English” explanations, and the Microsoft Office suite of products. Having recently completed the Undergraduate Certificate in Cybersecurity and Networking, Damien is conversant with the current technologies and techniques to ensure a safe and secure experience when working with IT systems both as a user and the organisation. Damien’s skills in business, financial management and regulatory compliance are not only applied to our own organisation, but also to several community organisations as a board member and/or treasurer including Limestone Coast Women’s Football League (of which Damien is also vice-chair), South Gambier Football Club, and Spare Ya Change 4 Kids and as a volunteer for Four Reasons Why.

Advanced Microsoft Excel

Curriculum

Damien Wilson

Modal title