• Virtual
  • July 20, 2021 - July 21, 2021
  • 10:00 AMto1:00 PM (Everyday)

Contact event manager

Tickets details

  • Sorry, Event passed
View cart
Thank you Kindly

Microsoft Excel – Advanced (Virtual)Passed

VIRTUAL (AEST)

Tue, 20 July, 2021 to Wed, 21 July, 2021
July 20, 2021

000000

Microsoft Excel – Advanced (Virtual)Passed

VIRTUAL (AEST)

Tue, 20 July, 2021 to Wed, 21 July, 2021
July 20, 2021

PRINT

Excel is a spreadsheet application packaged with the Microsoft Office suite. It is a very powerful and flexible tool for organising and analyzing data. Excel’s functionality and popularity have made it an essential component on computers in countless organisations, businesses, and other institutions throughout the world.

Excel is comprehensive enough to meet the needs of beginners and experienced users. With Excel you can do a wide range of tasks, from building basic spread sheets, to performing advanced data analysis. If you start at the beginning and work your way up, it won’t be difficult to learn and work with Excel at any level you want.

Because of its layout and widespread availability, it is often used as a tool to create and maintain a list. More seasoned users use it to store database records, create charts or graphs. A lot of organisations use Excel to manage their budgets, business planning, customer records, business intelligence, analysis of sales data, customer data, performance dashboard, etc.

 

Outcomes

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks. Upon completion of this course, students should be able to use advanced techniques to manage, manipulate and analyse complete data.

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