Microsoft Excel for Gaming Professionals

BullsEye CX and the CMAA are proud to bring to you 1 and 2-day workshops in Microsoft Excel® tailored for Gaming and Club Professionals.
There are 2 Courses available:

  • Advanced Excel for Club Professionals (1 Day) | Price: $395 + GST
  • Creating Dashboards for Club Professionals (1 Day) | Price: $395 + GST
Book both courses & Avail $100 Off* Your Next BULLSEYE CX Course

* This Offer cannot be combined with any other offer.

BYOD! Bring Your Own Device – Laptops / Surface Pros

(please note that iPads and other tablets are not suitable)

At the end of the course, participants will receive a CMAA Certification in recognition of the same. These courses will be available in 3 Cities across Sydney, Brisbane and Melbourne.

Limited Spots Available.
To Reserve Your Place or for Further Inquiries, please Contact the CMAA or:
Brett Jones, Senior Advisor – BullsEye CX | 0435812177

SYDNEY

Dates

Advanced Excel for Club Professionals
(1 Day) - Wednesday, 21st Feb 2018

Creating Dashboards for Club Professionals
(1 Day) - Thursday 22nd Feb 2018

Venue

Dooleys Lidcombe Catholic Club
24-28 John St, Lidcombe. NSW 2141.

Time

9:00 AM to 4:40 PM

BRISBANE

Dates

Advanced Excel for Club Professionals
(1 Day) - Wednesday, 28th Feb 2018

Venue

Kedron-Wavell Services Club
21 Kittyhawk Drive (off Hamilton Road),
Chermside South. QLD 4032.

Time

9:00 AM to 4:40 PM

MELBOURNE

Inviting Expressions of interest

Dates

To Be Confirmed

Venue

Kedron-Wavell Services Club
21 Kittyhawk Drive (off Hamilton Road),
Chermside South. QLD 4032.

WORKSHOP 1

Advanced Excel for Club Professionals (1 Day)


Modules

MODULE 1: PLAYING EXCEL WITH KEYBOARDS

Having Excel keyboard shortcuts at your fingertips simplifies complex processes. Shortcuts create efficiency and promote accuracy. Spend more time analyzing the data and less time processing it.

  • Basic and advanced cell selections
  • Format cells
  • Apply basic borders to cells
  • Formulas
  • Manage multiple worksheets
  • Pivot tables
  • Auto filter
  • Adjust column width and row height

MODULE 2: DATA VALIDATION

Create reports and insights which include a self-error handler. Data validation maintains the integrity of the data when accessed by other users. Create customised rules, and drop down lists to assist users to efficiently modify reports without risk of changing raw data.

  • Create a drop-down list of items in a cell
  • Restrict entries, such as a date range or whole numbers only
  • Create custom rules for what can be entered
  • Prevent duplicates
  • Restrict to specific date range
  • Restrict to dynamic date range
  • Prohibit weekend dates

MODULE 3: PIVOT TABLES

Pivot tables are one of Excel’s most powerful features. A pivot table allows you to extract specific data from a large and detailed data set. A pivot table can tame hundred of thousands of data cells into a manageable application with click and drag functionality.

If you are finding yourself writing lots of formulas to summarize data in Excel, then Pivot Tables can save you a lot of time and work and give you insights into your data that are otherwise too hard to discover.

MODULE 4: PROTECTING YOUR SPREADSHEET

If you are working with confidential data, you might want to password protect your entire Excel file. Though Excel security is not foolproof, in most cases it is a good enough security option. If you don’t want to password-protect the entire Excel file, you may use the following options:

  • Locking/ Unlocking Specific Cells
  • Selectively unlock the cells that are supposed to be edited by someone, leaving the rest locked.
  • Setting Ranges with Passwords

MODULE 5: RECORDING A MACRO

Macros are small programs that run within Excel and are used to automate common repetitive tasks. Using macros, you can save hours and boost productivity manifold. Macros are one of Excel’s most powerful features, yet most of the users fail to utilise it fully. A macro can be designed as the recording of a series of tasks, so that it can be automated. It’s the simplest form of automation – showing a software program the steps to be followed to get something done, and using that recorded macro to automate that process.

Macros in Excel are written in Excel VBA (Visual Basic for Applications). This is a version of Visual Basic (a prominent Microsoft programming language) developed specifically for use in Office-like applications.

WORKSHOP 2

Creating Dashboards for Club Professionals (1 Day)

An Excel Dashboard provides insight, analysis and alerts. They’re fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

KEY FEATURES:

1. Usually fits on one page

2. Displays key trends, comparisons and data graphically or in small tables

3. Provides the reader with conclusions to their objective

4. Is often interactive allowing the user to filter data and switch views themselves

5. Employs best practices that enable the report to be updated quickly and easily (often at the click of just one button)

WHAT YOU’LL LEARN:

1. Learn the 5 key questions to ask in the planning stage of your dashboard

2. Learn how to get the Data Ready for Excel Dashboards

3. Learn how to choose the right chart for your data.

4. Learn how to create amazingly powerful dashboard that are easy to read and interpret.

5. Learn how to make them sticky across the organization.

Modules

MODULE 1: EXCEL DASHBOARD ESSENTIALS

In this module, you get started with an Introduction to Excel Dashboards and some inbuilt Excel features that are useful while creating a dashboard.

  • Introduction to Excel Dashboards
  • Overview of Excel Table
  • Number Formatting Tricks for Dashboards
  • Using Symbols in Dashboards
  • Wonders of Conditional Formatting
  • Using Sparklines in Excel Dashboards

MODULE 2: DASHBOARD NUTS & BOLTS

Once you have a good understanding of the Excel dashboard essentials, this module will expose you to the building blocks.

  • Getting the Data Ready for Excel Dashboards
  • Understanding Important Dashboard Formulas
  • Using Interactive Controls in Excel
  • Dashboards (Scroll Bar, Check Box, Radio Button, Drop Down Lists, etc.)

MODULE 3: EXCEL CHARTING FOR DASHBOARDS

In this module, you learn all about Excel charting. It begins with charting basics and then covers advanced charting concepts in detail.

  • Introduction to Excel Charting
  • Creating the Right Chart
  • Creating Interactive Charts in Excel
  • Using Bullet Charts in Excel Dashboards

MODULE 4: CREATING DASHBOARDS FROM SCRATCH

In this module, you will learn how to create dashboards from scratch. Real life examples will show you how to take the raw data and create beautiful and dynamic dashboard using it.

MODULE 5: DASHBOARD EXTRAS

In this bonus module, you’ll learn about some additional features that will add more power to your Excel dashboards.

  • Data Validation Techniques for Dashboards
  • Excel Named Ranges Overview
  • Pivot Table Overview

Spots are Limited.
To RSVP or for Further Inquiries, please Contact:
Brett Jones, Senior Advisor – BullsEye CX | 0435812177