THIS COURSE HAS IT ALL

Full HD Video, Downloadable Files, Challenges, Case Studies & Quizzes

We've designed this course to take any user from beginner to advanced at Excel. Whatever your skill level, choose your journey and become a true Excel Guru. This isn't just another course you'll have forgotten by next week - every lesson is designed to help you use Excel to solve real world business problems.

Start Here

  • The Excel Minded Course Roadmap
  • One rule - Keep it simple

Module 1: Master The Basics

  • Using the Excel Window
  • Formatting Text, Cells & Borders
  • How to Use & Customise Text Styles
  • Challenge: Create a custom text style
  • Preparing Your Work for Printing
  • Challenge - Prepare a file for printing
  • Saving Your Work Correctly
  • Paste & Paste Special
  • Challenge: Using paste special
  • Keyboard Shortcuts
  • Quiz: Have you mastered the basics?

Module 2: Your Data Game Plan

  • The 10 immutable laws of structuring data
  • How to Sort Your Data Correctly
  • Using Autofilter to Effectively Search & Filter Your Data
  • Creating Drop Down Selections & Restricting Data Entry Using Data Validation
  • How To Colour Cells Depending on Their Contents Using Conditional Formatting
  • Creating Advanced Conditional Formatting Data Bars & Icons
  • How to Import External Data From Databases
  • How to Download Data Tables From Websites
  • What to do When Excel Can't Read Your Data - Text To Columns

Module 3: Your Functions Toolkit

  • SUM, AVERAGE, MAX, MIN
  • Challenge: Find COUNT, SUM and AVERAGE Sales Value
  • Absolute vs Relative cell references
  • SUMIF, COUNTIF, AVERAGEIF
  • Challenge: Finding duplicate rows using COUNTIF
  • VLOOKUP & HLOOKUP
  • Challenge: Find mismatching data between two tables using VLOOKUP
  • INDEX & MATCH
  • Challenge: Perform a lookup using INDEX & MATCH
  • IFERROR & ISERROR
  • Challenge: Create a VLOOKUP with a custom error message
  • LEFT, RIGHT, MID
  • FIND & SEARCH
  • TODAY & NOW
  • DATE
  • Challenge: Turn a text date into an Excel date
  • Functions Quiz

Module 4: Your Data Analysis Strategy

  • Preparing your data for charts
  • Challenge: Prepare Data for a Chart
  • Pie & Donut Charts
  • Line Charts
  • Bar & Column Charts
  • Challenge: Create a Stacked Bar Chart
  • Chart & Axis Formatting
  • Multi Type Charts & Dual Axis Charts
  • Scatter & Bubble Diagrams
  • An Introduction to Pivot tables
  • Challenge: Create a Pivot Table
  • Pivot Table Calculations
  • Challenge: Create a Pivot Table with a Percentage Summary
  • Pivot Table Custom Fields
  • Challenge: Create a Pivot Table with a Custom Field
  • Pivot Tables Styles & Formatting
  • An Introduction to Pivot Charts
  • Pivot Charts Styles & Formatting
  • Challenge: Create a Pivot Table & Pivot Chart

Module 5: Your Dashboard Playbook

  • The Data Visualisation Strategy
  • Designing Your Metrics
  • Case Study: Creating engaging metrics
  • How to create red/amber/green metrics
  • How to create up/down change metrics
  • List style dashboards
  • Challenge: Create a list style dashboard
  • Designing chart style dashboards
  • Challenge: Create a chart style dashboard
  • Create a seamless self service dashboard by joining slicers
  • Challenge: Create slicers and filters that apply to a whole report
  • Choosing the right method for report distribution

Module 6: Your Excel Automation Machine

  • Your Excel Automation Machine
  • An Introduction to the VBA Window
  • Using the Macro Recorder for Basic Tasks
  • Creating Buttons and Message Boxes to Your Spreadsheet
  • Referencing spreadsheet objects
  • How to Store and Recall Data in Code Using Variables
  • How to create If and Case Statements
  • The Power of Loops
  • Case Study: Build a Reconciliation Tool
  • Case Study: Build an Automated Dashboard
  • Case Study: Build a Capacity Forecasting Tool
  • Challenge: Build a tool to convert time-sheets into pay slips
  • Excel VBA Forms: Create Interactive Data Entry Forms
  • Challenge: Build a questionnaire pop up form and store the data in a table

Certification

  • Test: Take the Excel Minded certification test
  • Integrate with your LinkedIn profile

READY TO GET STARTED?