Centre for Continuing Education

Microsoft Excel

Microsoft Excel

Microsoft Excel. Unlock insights and tell the story in your data.

Master one of the world’s most popular spread-sheeting software applications. Learn how to create macros, create pivot tables and combine Excel with the power of Visual Basic (VBA) to unleash a world of new possibilities. Improve the way you manage and present information and take the legwork out of calculations and data manipulation. Learn Microsoft Excel the smart way with Microsoft Excel courses at CCE, the University of Sydney.

Microsoft Excel VBA Course: A Masterclass

Microsoft Visual Basic. Master programming for Windows. Aims This three-day advanced course shows you how to use a combination of the Microsoft Excel Object Model and VBA to improve your productivity, adding power and flexibility to spreadsheets by creating user-defined functions and macros. Basic knowledge of Microsoft Excel is required, and you should strongly consider completing the one-day Microsoft Excel VBA Course: An Introduction prior to undertaking this course. All... [More]
Back to Top
Microsoft Excel VBA Course: A Masterclass

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This three-day advanced course

...
Microsoft Excel VBA Course: A Masterclass

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This three-day advanced course

...
Microsoft Excel VBA Course: A Masterclass

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This three-day advanced course

...

Microsoft Excel Course: Level 1

Microsoft Excel. Unlock insights and tell the story in your data. This Microsoft Excel short course will help you improve the way you manage and present information, and take the legwork out of calculations and data manipulation. It provides the skills and knowledge necessary to create and manage workbooks and covers topics including adding data, editing data, working with formulas, printing and charting. This is an ideal introductory course before progressing onto Microsoft Excel... [More]
Back to Top
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...
Microsoft Excel Course: Level 1

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This Microsoft Excel short course will help you improve the way you manage and

...

Microsoft Excel Course: Level 2

Microsoft Excel. Unlock insights and tell the story in your data. This short course will extend your knowledge of Excel beyond Microsoft Excel: Level 1 and provide you with the skills and knowledge to produce more effective and productive workbooks. Learn essential functions as well as how to manage list data, cover formulas and function techniques, intricate formatting, setting complex printing options and using intricate charting features. Completion of this course provides... [More]
Back to Top
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...
Microsoft Excel Course: Level 2

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}<br/>This short course will extend your knowledge of Excel beyond <a href="/course/MSE1">

...

Microsoft Excel Course: Level 3

Microsoft Excel. Unlock insights and tell the story in your data. This short course focuses on the more advanced features beyond Microsoft Excel: Level 2. Advanced analysis tools including data linking, data consolidation and outlining and summarising are covered, as are some key automation features such as macros. Learn how to import and export data, create Data Tables and Scenarios for What If analysis, techniques to validate data, and create form controls such as List and Combo... [More]
Back to Top
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...
Microsoft Excel Course: Level 3

<p>{block name:“Course Tagline - Microsoft Excel”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course focuses on the more advanced features beyond <a href="/course/mse2"

...

Microsoft Office Course: Essentials

Microsoft Office. All the office productivity tools you need. This short course will allow you to become productive by acquiring a basic understanding of Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook, and teach you to share data between these applications. Outcomes By the end of this course, you should be able to: minimise, maximise, move and resize windows start Microsoft Office applications and work with the Microsoft Office interface create... [More]
Back to Top
Microsoft Office Course: Essentials

<p>{block name:“Course Tagline - Microsoft Office”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course will allow you to become productive by acquiring a basic

...
Microsoft Office Course: Essentials

<p>{block name:“Course Tagline - Microsoft Office”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course will allow you to become productive by acquiring a basic

...
Microsoft Office Course: Essentials

<p>{block name:“Course Tagline - Microsoft Office”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course will allow you to become productive by acquiring a basic

...
Microsoft Office Course: Essentials

<p>{block name:“Course Tagline - Microsoft Office”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>This short course will allow you to become productive by acquiring a basic

...

Microsoft Excel VBA Course: An Introduction

Microsoft Visual Basic. Master programming for Windows. Aims This one-day introductory course assumes no prior programming knowledge, and builds a solid foundation of the skills and knowledge required to learn to read and write industrial VBA code in Microsoft Excel. You will gain an understanding of the background knowledge (and more) a programmer should have, in order to successfully learn to program Excel VBA macros and functions. It is strongly recommended you complete this... [More]
Back to Top
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course

...
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course

...
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course

...
Microsoft Excel VBA Course: An Introduction

<p>{block name:“Course Tagline - Microsoft Visual Basic”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Course Heading - Aims”}</p><p>This one-day introductory course

...

Financial Modelling Best Practice Course

Finance. Boost your financial know-how. In order for finance professionals to effectively perform their duties, they need to be able to construct robust and transparent financial models that can be easily used and understood by others. Creating such models requires a systematic introduction to the best practice principles that underpin financial modelling. This course provides an introduction to the disciplines and techniques underpinning the construction of financial models that... [More]
Back to Top
Financial Modelling Best Practice Course

<p>{block name:“Course Tagline - Finance”}</p><p>{block name:“Course Message - Business and management”}</p><p>In order for finance professionals to effectively perform their duties, they need to be

...
Financial Modelling Best Practice Course

<p>{block name:“Course Tagline - Finance”}</p><p>{block name:“Course Message - Business and management”}</p><p>In order for finance professionals to effectively perform their duties, they need to be

...
Financial Modelling Best Practice Course

<p>{block name:“Course Tagline - Finance”}</p><p>{block name:“Course Message - Business and management”}</p><p>In order for finance professionals to effectively perform their duties, they need to be

...
Financial Modelling Best Practice Course

<p>{block name:“Course Tagline - Finance”}</p><p>{block name:“Course Message - Business and management”}</p><p>In order for finance professionals to effectively perform their duties, they need to be

...

Power BI course

Microsoft Excel. Unlock insights and tell the story in your data. Power BI – Microsoft’s self-service business intelligence tool – will help you leverage the power of your data and gain valuable insights. During the course, we will take a sample data set and use it to explore navigation and functionalities of Power BI, touch upon the underlying business intelligence concepts and learn how to develop and deploy reports and dashboards. Aims The aim of the course is to fast-track your... [More]
Back to Top