Mastering Excel Webinar Series

Go From Zero to Hero

Does Excel leave you confused and full of dread? 

Do you think that you need to be good at Math to use Excel? 

Or are your skills rusty because it’s been a while?

During a corporate training career that has spanned over 20 years, I have helped thousands of business people increase their efficiency, productivity, and confidence in using Excel.

In my experience, you don’t need to be a math whizz to be proficient at using Excel.  Instead, you need three things:

  • a clear understanding of how the Excel features work;
  • real life examples on which to build your knowledge; and
  • a little practice.

– Bronwyn Coulthart, Microsoft Office Certified Application Specialist

Excel Webinar Series

What?

Starting 3 July 2018, I will be running a 13-part live webinar series where I cover the 13 most frequently requested topics in Excel.

Each webinar is around 90 minutes including Q & A where I will cover one topic per webinar.  The topic outline is listed below in more detail.

Who?

Is there pre-requisite knowledge?

  • No, well as long as you know what Excel is … (it’s a spreadsheet application BTW). 
  • You don’t need to have any prior knowledge about any topic.  However, if you haven’t used Excel before I suggest you start with Webinar 1.

Do I need the latest version of Excel?

  • Either Excel 2013 or 2016 are fine. 
  • However, even if you have an earlier version of Excel, these topics are still relevant and work the same way.

So if you have ever wanted to sharpen your Excel skills but didn’t know where to start, now is the time.

When?

The full schedule with a more details description of the topic for the live webinars is listed below.  But here’s a summary …

Start: 3 July 2018 and run every Tue and Thu until all 13 webinars are complete.

Time: 7:30 am – 9:00 am (before work so you have the chance to attend if you want.)

What do you get?

  • 13 x 90 min Live Webinars (over 19 hours of training)
  • Lifetime access to the recordings
  • Downloadable notes & practice files
  • Q & A – your questions answered

Why should you?

  • This training is unique to my style and experience with Excel so you won’t find it available through any other training provider.
  • I have no plans to run this course live again anytime soon.
  • The prices will not be this low again.
  • So it’s a good time to take action!

“In our world of producing high-end corporate documentation like tenders and proposals, we need to be experts in Microsoft products so that we can make our documents flawless on every page. If you also need to present professionally on paper or screen, it is crucial to have good skills in Word, PowerPoint and Excel. Not only will your brand communicate more powerfully and consistently, but you’ll save yourself endless headaches and hours of wasted effort. For this reason, I highly recommend getting some training to set you on the right path and make your life easier. Bronwyn is one of the most experienced, capable and knowledgeable experts I’ve met, with an extraordinary understanding of Microsoft products as well as a range of IT programs and apps. She has developed detailed yet simple online lessons to help everyone from beginner to expert. Get the help you need right here.”

Leann Webb
Managing Director
Aurora Marketing – Australia’s leading tender and submissions management company

Mastering Excel - From Zero to Hero

Live Webinar Details

Full Course 13 Webinars

 

You may think that you have to be great at Math to create formulas in Excel. But what if that isn’t true? What if there was a simple process that could guarantee a perfect formula every time? Join me on this webinar where I will show you the logic behind formulas and my simple 6 Step process for creating a formula no matter how complex the formula may appear.

 



Registration

Started 3-Jul-2018


Webinar Schedule, below

Live Webinar Details

Webinar 1 – 6 Steps to the Perfect Formula

 

Description:
You may think that you have to be great at Math to create formulas in Excel. But what if that isn’t true? What if there was a simple process that could guarantee a perfect formula every time? Join me on this webinar where I will show you the logic behind formulas and my simple 6 Step process for creating a formula no matter how complex the formula may appear.


During this webinar we will cover:

  • The Order of Precedence.
  • Creating formulas is about logic not maths.
  • Tips that will have you creating formulas like a boss!

Below are some of the Excel features we will cover:

  • 6-Steps to the Perfect Formula – every time!
  • Cell Referencing and when to use it.
  • 3D Formulas.

Registration

Live Webinar Completed 3-Jul-2018


Lesson 2 – Practical Applications for Math & Statistic Functions

 

Description:
Have you ever wondered if Excel’s Maths & Statistical Functions can do anything other than total or average a range of numbers? Maybe you need to understand how effective a sales campaign is across different demographics to predict future success? If you think sounds complex – it isn’t! In this Webinar, we take a few common and not so common functions and show you a practical way to harness their power.

During this webinar we will cover:

  • Practical applications for Maths & Statistical Functions.
  • How to work with formulas you never used before.
  • How to find functions you didn’t know existed.

Below are some of the Excel functions we will explore:

  • COUNT, COUNTA, COUNTBLANK, COUNTIF
  • ROUND, ROUNDDOWN, ROUNDUP
  • CEILINGMATH, MROUND, PRODUCT
  • SUMIF, SUMIFS

Live Webinar Completed 5-Jul-2018


Webinar 3 – Mastering Logical and Lookup Functions

 

Description:
Including IF, THEN, ELSE logic in your spreadsheets is powerful! If you have ever wondered how you could use these Functions to lift your spreadsheets to the next level, then wonder no more. Let me show you how easy it is to use logic formulas to decide between two values or a whole table of values. The formulas make the decision based on the criteria you set!

During this webinar we will cover:

  • Building smart logic into your workbook
  • Using a multiple or a table of values for easy formula maintenance.
  • The most popular look up functions and when to use them.

Below are some of the Excel functions we will explore:

  • IF & Nested IF functions
  • IFERROR, AND, OR, NOT, VLOOKUP

Live Webinar Completed 10-Jul-2018


Webinar 4 – Projections with Financial and Time Functions

 

Description:
Using Excel to project the future value of investments and loans isn’t very hard when you use the right formulas. You too can calculate the monthly repayments on a loan or the future value of term deposit.

During this webinar we will cover:

  • Use the most popular Financial Functions.
  • Calculating current dates and future dates.
  • Calculating different date types.

Below are some of the Excel functions we will explore:

  • PMT, FV, NPV, PV, RATE
  • NOW, HOUR, MINUTE, TODAY
  • DATE, WEEKDAY, WEEKNUM, WORKDAY, EOMONTH

Webinar completed 12-Jul-2018


– ,

Description:

During this webinar we will cover:

Below are some of the Excel functions we will explore:

  • PROPER, UPPER, LOWER
  • CONCATENATE, LEFT, RIGHT, MID, LEN
  • SUBSTITUTE, T, TEXT VALUE, CELL
  • ISBLANK, ISERR, ISODD, ISEVEN, ISNUMBER, ISTEXT


Webinar 6 - Creating Custom Number Formats

7:30 am – 9:00 am, Thursday, July 19, 2018

Description:
Excel provides quite a few number formats. But what to do when the standard list doesn't meet the mark? Creating custom number formats is a solution to this problem. Once you know the codes and how to use them, the options are only limited by your imagination. Creating your own custom number formats, lifts your workbooks to the next level of sophistication and clarity.

During this webinar you will learn:

  • How to easily create your own custom number formats.
  • Using these formats to clean up formulas and data.
  • Uniquely highlight negative numbers.

Using Excel you will learn how to:

  • Understand number format codes
  • Create custom formats
  • Create custom formatting for large numbers
  • Create custom formatting for fractions
  • Create padding for numbers
  • Align numbers with custom formats
  • Customise negative number formats

Thu Jul 19 - Webinar 6 - Creating Custom Number Formats - Register Now

$297 inc GST pp

Webinar 7 - Levelling up with Conditional Formatting

7:30 am – 9:00 am, Tuesday, July 24, 2018

Description:
You may think that formatting is simply a matter of applying some colour and shading to your spreadsheet and you are done. Well what if I told you that formatting didn't stop there! What if you could change the formatting depending on the results the formulas provide. To draw attention to unusual data or results that are unbelievably good. In this webinar I will show you a few of the ways I use with conditional formatting that enhances the user experience.

During this webinar you will learn:

  • How to easily apply conditional formatting.
  • Which options are the most effective.
  • When to use and when not to use conditional formatting.

Using this Excel feature we will:

  • Create Conditional Formatting – Values, Other cell options
  • Format the Top Ten Items
  • Apply Top and Bottom formatting
  • Use Data Bars, Colour Scales, Icon Sets
  • Understand and apply Sparklines

Tue Jul 24 - Webinar 7 - Levelling up with Conditional Formatting - Register Now

$297 inc GST pp

Webinar 8 - Getting Visual with Charts and Graphs

7:30 am – 9:00 am, Thursday, July 26, 2018

Description:
Charts or Graphs are an amazingly concise way of presenting data and reporting trends. Unsurprisingly, most people prefer to read a chart than rows of data that never seem to end - why? Because a picture paints a thousand words and information can be absorbed more quickly. In this webinar I will show you my favourite time-saving techniques for creating charts and which data is best suited to which type of chart. When charting data "one size" does not fit all! It is essential to select the correct chart type for the data you are presenting.

During this webinar you will learn:

  • How to quickly create charts/graphs.
  • Which chart/graph type best displays your data.
  • How to create troubleshoot chart/graph errors.

Below are some of the things I will show you:

  • Selecting the right chart for the right data
  • Two ways to create charts from scratch
  • Changing the chart to suit the data
  • When to embed and when not to embed!
  • Adding and removing data ranges
  • Plotting trends
  • How to fix a bad chart

Thu Jul 26 - Webinar 8 - Getting Visual with Charts and Graphs - Register Now

$297 inc GST pp

Webinar 9 - Prepping Data for Analysis and Categorisation

7:30 am – 9:00 am, Tuesday, July 31, 2018

Description:
Excel is the best tool for cleaning data. No matter where the data has come from or how bad it looks, you can use Excel to clean it up and sort it out before you use it. That includes separating data, removing filler characters, changing upper and lower case just to name a few. Once prepared you can apply Excel's inbuilt grouping and summarising features to easily analyse and categorise the data. In this webinar I will introduce you to my favourite data cleaning processes.

During this webinar you will learn:

  • Importing and cleaning data from any source.
  • Grouping data both manually and automatically.
  • Using the Subtotal feature to apply quick statistics to the data.

Below are some of the things I will show you:

  • How to import and separate data into separate columns.
  • Using the Grouping and Outlining features.
  • Using Excel’s Summarising and Subtotalling features.

Tue Jul 31 - Webinar 9 - Prepping Data for Analysis and Categorisation - Register Now

$297 inc GST pp

Webinar 10 - Documenting Projected Values and Saving "What IF" Scenarios

7:30 am – 9:00 am, Thursday, August 2, 2018

Description:
In modern business, planning for a range of scenarios to minimise risk is a given. Excel has three features you can use for data consolidation, projection and "What IF" analysis without the need for programming or complex apps. Join me on this webinar where I will show you the practical application of these tools.

During this webinar you will learn:

  • Consolidating data from multiple sources.
  • Automatically creating tables of results produced by inserting different values into a formula.
  • Creating and saving "What If" scenarios for comparison and evaluation.

Below are some of the Excel features I will show you:

  • Using the Data Consolidation feature.
  • Creating and modifying Data Tables.
  • Creating and using What IF Scenarios for data analysis.

Thu Aug 02 - Webinar 10 - Documenting Projected Values and Saving "What IF" Scenarios - Register Now

$297 inc GST pp

Webinar 11 - Taking Filters to the Next Level

7:30 am – 9:00 am, Tuesday, August 7, 2018

Description:
You may think the basic filter is as far as you can go with Excel. But what if I told you that there was an Advanced Filter where you can use wild card characters, formulas in filter criteria and purpose-built database functions to extract data from a list and put it somewhere else? Does that sound too good to be true? It's not! Join me on this webinar to see just how effective the Advanced Filter can be.

During this webinar you will learn:

  • How to easily creating filter criteria to extract data either in-place or transfer elsewhere.
  • Mastering the use of different wild card characters in criteria.
  • Using Database functions to produce useful statistics based on certain criteria.

Below are some of the Excel features I will show you:

  • Compound and custom filters.
  • Using wild cards characters and formulas to extract data.
  • The benefits of extracting records with the Advanced Filter.
  • When to use Database Functions – DSUM, DMIN, DMAX, DCOUNT.

Tue Aug 07 - Webinar 11 - Taking Filters to the Next Level - Register Now

$297 inc GST pp

Webinar 12 - Mastering Pivot Tables & Pivot Charts

7:30 am – 9:30 am, Thursday, August 9, 2018

Description:
You may have heard of Pivot Tables & Pivot Charts but do you know how to harness their power? Very few people know how to use them effectively, if at all. In this webinar I will show you how to take a basic list of data and transform it into a PivotTable and PivotChart with all the bells and whistles. Don't worry if you have never used PivotTables or PivotCharts before, after attending this webinar, you will be using them like a pro!

During this webinar you will learn:

  • How to easily create and modify PivotTables and PivotCharts.
  • How to apply calculations to the PivotTable results.
  • Know how to switch the data to answer questions about the data.

Below are some of the Excel features I will show you how to:

  • Understand Pivot Tables and how they work.
  • Create your own Pivot Table from scratch.
  • Use the Switch and Set Method.
  • Format PivotTables to best highlight the results.
  • Create Slicers and what benefits they bring.
  • Use Timeline Filters within your PivotTable.
  • Use compound fields in a PivotTable.
  • Apply totals, subtotals, running totals and calculated fields.
  • Create Percentage of Total and Difference From
  • Create PivotCharts.
  • Change the PivotChart Type.
  • Apply filters to PivotCharts.
  • Move the PivotChart to a Chart Sheet.

Thu Aug 09 - Webinar 12 - Mastering Pivot Tables & Pivot Charts - Register Now

$297 inc GST pp

Webinar 13 - Using Data Validation and Protection to Protect your Work

7:30 am – 9:00 am, Tuesday, August 14, 2018

Description:
In the past, you may have set up spreadsheets for others to use. All is good until you get the spreadsheet back and find formulas have been overwritten or changed , invalid data entered or the formatting is all messed up. Wouldn't it be great if you could protect your work, hide the formulas and instantly notify the user they have entered the wrong value? Sound too good to be true? Well it's not! Let me show you how to save your time and protect your work with Excel's Data Validation and Protection features.

During this webinar you will learn:

  • Easily validate the data entered into a worksheet.
  • Force anyone using your spreadsheet user to enter correct data.
  • Protecting and hiding formulas in your workbook.

Below are some of the Excel features I will show you how to:

  • Understand the Data Validation options.
  • Create a Number Range Validation.
  • Create an Input Message to guide the spreadsheet user.
  • Create an Error Message to warn the spreadsheet user.
  • Create a Drop Down List to give the spreadsheet user set choices.
  • Use Formulas as Validation Criteria.
  • Protect Cells and Formulas.
  • Hide Formulas from the view of users of your spreadsheet.

Tue Aug 14 - Webinar 13 - Using Data Validation and Protection to Protect your Work - Register Now

$297 inc GST pp

Bronwyn

Bronwyn is a Microsoft Office Certified Specialist and has been presenting introductory to advanced training in Microsoft Office (Access, Excel, Outlook, PowerPoint, Project and Word) since 1995.  Below are listed some of the clients she has provided Microsoft Office training and support to over the years.

  • Aurora Marketing
  • Bank of Queensland
  • BHP
  • Brisbane Airport Corporation
  • Brisbane City Council
  • CRL – Consolidated Rutile Limited
  • CSR Emoleum
  • Drake Training International
  • Gold Coast City Council
  • GPPartners
  • Greenslopes Hospital
  • HATCH
  • Institute for Healthy Communities
  • International Relations University Sunshine Coast
  • J.E Taske Medical Group
  • KPMG
  • LegalIT Lawyers
  • Mirvac PFA
  • Nestlé Australia
  • New Horizon Australia
  • QANTAS
  • QIDC
  • Queensland Education Department
  • Queensland Eye Institute
  • Queensland Government
  • Queensland Theatre Company
  • RPM Rental & Leasing
  • Santos
  • Stewarts Group
  • Suncorp
  • Telstra
  • Thiess
  • Toyota Australia