Event details
- Virtual
- September 28, 2021 - September 29, 2021
- 10:00 AMto1:00 PM (Everyday)
Contact event manager
Tickets details
- Sorry, Event passed
Microsoft Powerpoint (Virtual)Passed
VIRTUAL (AEST)
Tue, 28 September, 2021 to Wed, 29 September, 2021
September 28, 2021
000000
Microsoft Powerpoint (Virtual)Passed
VIRTUAL (AEST)
Tue, 28 September, 2021 to Wed, 29 September, 2021
September 28, 2021
In this course we will learn how to create stunning PowerPoints that use a variety of media and techniques to present information in an interesting way, promoting your brand and engaging your audience.
Outcomes
On completion of our Beginners course, you should be able to:
- Navigate your way around Excel
- Understand the different features of the interface
- Create spreadsheets
- Work with basic formulae
- Make your spreadsheets look professional and presentable.
If you’ve already mastered these areas, talk to us about our more advanced courses.
GETTING THE MOST FROM YOUR DATA
• Outlining and Grouping your Data
• Goal Seek
• Data Tables
• Scenario Manager
• More on Pivot Tables
• Exploring Scenarios
• What if Analysis
WORKING WITH MACROS AND CONTROLS
• Creating Macros In Excel
• Absolute and relative referencing
• Macros & VBA
• Macros and the Toolbar
• Tabs & Controls
ADVANCED FUNCTIONS
• More Conditional Formatting
• Goal Seek
• Security & protection
ADVANCED EXCEL TASKS
• Creating and using Shared Workbooks
• Advanced File Management
• Consolidation
• Validation
• Dependant Lists
• Custom and Advanced Features in Excel
Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.
PREQUALIFICATIONS
Advanced Excel training is for people who can already create moderately complex spreadsheets and want to add more sophistication and automation. Candidates should have completed the Intermediate level, or feel competent they have an intermediate knowledge of Excel.
- 1-day workshop or customise a program to suit your organisation’s specific needs
Company specific courses are available for organisations that have a group of employees who need training. These closed courses are ideal where tailoring of the standard course content is required. They typically provide cost benefits, particularly where 3 or more workshops are scheduled.
- Extensive Learning & Reference Guides provided on USB
- Participation in the full day workshop
- Access to a Microsoft technical expert throughout and post the workshop