Microsoft Excel - Advanced

Face-to-face duration: 2 days

Course Objectives

This two (2) day course aims to provide learners with some of the more advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user.

Participants will learn how to use Excel to analyse numbers, keep track of data and graphically represent their data. With Excel 2010 they can manage more data than ever with increased worksheet and workbook sizes.

This course will teach managers how to use the array of powerful Excel tools to turn their data into useable information which will in turn lead to better decision making.

Learning Outcomes

  1. Automate worksheet functions.
  2. Audit worksheets.
  3. Create charts and tables.
  4. Analyse and manage data.

Benefits

  • Make more informed decisions using advanced functions.
  • Gain confidence in creating and formatting spreadsheets and charts.

Topics

  • Using formulas and functions.
  • Time saving tools.
  • Formatting data and advanced formatting tools.
  • SmartArt and objects.
  • Auditing.
  • Pivot tables and charts.
  • Macros.
  • Solving formula errors.
  • Using ‘what if’ analysis.
  • Analysing and managing data.

Audience

  • People who already have experience working with Excel and want to add greater automation and sophistication.

Format

  • Use templates and checklists.
  • Practical and experiential
  • Theory small sessions.
  • Skills practice.
  • Facilitator-led discussions.

Delivery Strategy

This two (2) day course has been designed by our senior trainers who combine industry experience with academic excellence.

Our program design and delivery is based on adult learning principles and experiential learning.

Participants will also receive a state-of-the-art student manual with all reference material, PowerPoint presentations and activities.

Click here

(See discount at Checkout)
 
Items in cart: 0

Testimonials

"The Student Manual is a logical, carefully thought through and well presented document. The face-to-face facilitators are helpful, patient, knowledgeable and passionate. Thank you for the time and effort that blueVisions have put into preparing and supporting this course."

David Thorpe iiNet Australia

"Your personal contribution to our training has been invaluable. Your infectious high spirits and genuine want for our success have shone through. I sincerely thank you for your efforts over the past two years."

Stephen Davies Group Manager, Construction Services Group, NSW

"Your course made me realise how irrelevant what I was learning through my university course actually was to my job. Due to this, I will be seeking to complete the remainder of the modules in this diploma through blueVisions."

Damien Bleeker Project Coordinator, Liverpool City Council, NSW

"Thank you for a wonderful course....This has been by far the best development course I've ever been a part of."

David Darcy LSPSPO - Defence Materiel Organisation

"Having sat in at various times in both courses, as well as being present for the final summary and feedback sessions I was really impressed with the positive feedback and outcomes. The blueVisions trainers did an awesome job and really motivated and inspired both groups. The level of the course was spot on for each group."

Brian Clarke Leadership Development Coordinator, Gasco