• Virtual
  • September 28, 2021 - September 29, 2021
  • 10:00 AM to1:00 PM (Everyday)

Contact event manager

Tickets details

  • STANDARD 15 remaining
    $400
View cart
Thank you Kindly

Microsoft Powerpoint (Virtual)

VIRTUAL (AEST)

Tue, 28 September, 2021 to Wed, 29 September, 2021
September 28, 2021

000000

Microsoft Powerpoint (Virtual)

VIRTUAL (AEST)

Tue, 28 September, 2021 to Wed, 29 September, 2021
September 28, 2021

PRINT

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