Back to Speaker Bureau Home Page

Traci Williams

Passionate about Spreadsheets | Founder of Excel Ace

Passionate about Spreadsheets | Founder of Excel Ace

Traci Williams is a self confessed ‘spreadsheet geek’ and has spent more than half of her life working with Excel spreadsheets. She has an infectious enthusiasm and a genuine passion for showing people how ‘simple’ Excel can be, how much time they can save by using it correctly, and even makes it seem like ‘Fun’!!!

Traci founded Excel Ace in 2008, leaving her career in accountancy, as she was frustrated at not having enough time to show colleagues how ‘ACE’ and simple Excel could be. Her mission with Excel Ace is to help people to love Excel as much as she does, or at the very least, not be afraid of it.

  • Exciting (and Simple) Excel Dashboards

    They say a picture paints a thousand words, and when it comes to numbers, data and specifically spreadsheets, that’s definitely true! People can look at numbers, and easily miss the obvious, but pop those numbers into a pretty little chart, and not only will people WANT to look at it, but the obvious will also jump right out and fail to be ignored!

    This session will show you how to create your own gorgeous dashboards; update them at the touch of a button when new data becomes available, and also drill into the detail as required… and this is all super simple to do too (Honest!).

    The session will use Excel functions such as:

    • Named Ranges
    • Pivot Tables
    • Pivot Charts
    • Slicers / Timelines

    Learning Outcomes

    • Create and edit Named Ranges
    • Create and edit multiple Pivot Tables
    • Create and edit Pivot Charts linked to Pivot Tables
    • Create Timelines / Slicers to manipulate multiple Pivot Charts at the touch of a button
    • Tips for data setup to make your Dashboard ACE!!
  • The Magic of Macros in Excel Spreadsheets

    We’ve all had tasks before that are boring and repetitive, but we have to complete them week in, week out.

    The good news is that there is a better way – and that is to use some ‘magic macros’ to complete the task for you.

    Not only will macros save you from the boring job, but they will complete the task in a fraction of the time.  Macros also increase accuracy as they remove the risk of human error (none of us are perfect!).

    This session will show you the simple way to generate a macro, and also explain the ‘hidden code’ that is created in the background, and how we can edit it.

    Learning Outcomes

    • Recording macros
    • Assigning macros to shapes
    • Accessing VBA
    • Editing macros
  • Basic Excel Workshop

    This workshop can be delivered online and in separate one hour sessions to fit perfectly into your day.

    Week 1: Column Width & Row Height / Formatting / Paste Special / Filter / Sort

    Week 2: Freeze Panes / Find / Conditional Formatting / Print Range & Page Set Up

    Week 3:  Basic formula; we will look at 11 simple formula and different ways of entering them and how to check if they’re right.

    Inclusions:

    • Practise material and documentation to use throughout the workshop
    • Follow up practise material and tasks to consolidate your understanding and increase confidence in your new skills
    • Certificate of Attendance
    • Recording of each session that can be accessed for 90 days following the training
  • Intermediate Excel Workshop

    This workshop can be delivered online and in separate one hour sessions to fit perfectly into your day.

    Week 1 : Keyboard Shortcuts / Dollar Symbol / Concatenate Formula / Blobby (Fill Handle)

    Week 2 : Named Ranges / Data Validation / Protect Workbooks

    Inclusions:

    • Practise material and documentation to use throughout the workshop
    • Follow up practise material and tasks to consolidate your understanding and increase confidence in your new skills
    • Certificate of Attendance
    • Recording of each session that can be accessed for 90 days following the training
  • Advanced Excel Workshop

    This workshop can be delivered online and in separate one hour sessions to fit perfectly into your day.

    Week 1 : Data Set Up / If Formula / Nested If Formula / VLOOKUP

    Week 2 : Pivot Tables / Pivot Charts / Timelines & Slicers

    Week 3:  Linking Files / Macros’ (Basic)

    Inclusions:

    • Practise material and documentation to use throughout the workshop
    • Follow up practise material and tasks to consolidate your understanding and increase confidence in your new skills
    • Certificate of Attendance
    • Recording of each session that can be accessed for 90 days following the training
  • David Elliot, Robinson Rice Associates

    Traci’s courses are a ‘must do’ for all Excel users of all standards. First class!

  • Nancy Whittaker, Macmillan Cancer Support

    I had several absolutely excellent Excel intermediate and advanced sessions with Traci. She is extremely knowledgeable and makes the sessions fun and interactive ~ both face to face and virtual. I would definitely recommend Traci if you need some Excel training ~ she’s excellent!

  • Charli George, Factco

    Traci is a wonderful teacher, although when first using excel seemed daunting, Traci made it easy, enjoyable and understandable to learn and put in to everyday use for work. 100% recommend the course and Traci!

  • Helen Cooper, Collection / Meiyume

    I will use this daily and it will make some manual processes much more automated and will ultimately give me time back. Love Traci’s style of training – the hour is also great in terms of length of time.

  • Andy Richards, Einhell

    Enjoyed the training and has given me a thirst for more. Well delivered at a good pace.

Looking for more information?