Skills Boost – Beginner to Expert

 
Website Header Image

Skills Boost – Beginner to Expert
Master the core skills every Excel user should know

EXPLORE COURSES ➜
GET ACCESS ➜

Catch up on the training you never received.

Do you ever feel lost with Excel? The formulas confuse you, formatting takes forever, and someone just asked for a PivotTable you’ve never even heard of.

You’re not alone.

Most people learn Excel on the job by copying their work colleagues or watching random videos. This leaves huge knowledge gaps and makes advanced tasks feel out of reach.

You deserve better than that. Which is why we have the Skills Boost – Beginner to Expert course. It provides all the skills you need to finally take control of your spreadsheets.

Skills Boost – Beginner to Expert isn’t another video series. It’s a structured learning journey with short focused lessons.

Fill the gaps in your Excel knowledge once and for all.

You’ll learn how to:

  • Use all the necessary functions
  • Apply conditional formatting
  • Ensure valid input with data validation
  • Apply workbook protection
  • Create charts for data analysis
  • Work with Tables and PivotTables
  • Get and clean data with Power Query
  • Analyze large data sets with Power Pivot
  • Automate work with VBA macros.
Excel Skills Boost

Mastering Power Pivot is only available within the Excel Academy.

GET ACCESS ➜
LEARN MORE ➜

What’s included?

✓ 15 hours of on-demand video (130+ lessons).

✓ Work through common scenarios

✓ Exercises to embed the knowledge

✓ Certificate of completion

✓ English closed captions

✓ Ask questions and get expert answers

Syllabus:

Introduction
  • Introduction
Working with large worksheets
  • Freeze Panes
  • Split Screen
  • Hiding and unhiding columns
  • Sorting a large list
  • Filtering a list
Essential tricks for printing spreadsheets
  • Scaling a print
  • Repeating headers across multiple pages
  • Printing selected range
  • Aligning a print
  • Using Page Breaks
Getting started with Excel formulas
  • Introduction to formulas
  • Order of calculation – BODMAS
  • Calculating percentages
  • Unleash the power of Excel functions
  • Referencing other sheets and workbooks
  • Calculating date difference
  • Understanding absolute cell addresses
  • The COUNTIF function
Logical functions
  • IF Function 1
  • IF Function 2
  • IF Function 3
  • Nested IF functions
  • AND and OR functions
  • The IFS Function
  • The SWITCH Function
Conditional formatting
  • Using conditional formatting
  • Managing conditional formatting rules
  • Conditional formatting to highlight due dates
  • Data bars to compare values and show progress
  • Heat maps
  • Using icon sets
  • Conditional formatting to an entire row
  • Conditional formatting with multiple conditions
Dynamic array functions
  • Introduction to dynamic arrays
  • The UNIQUE function
  • The SORT function
  • The SORTBY function
  • The FILTER function
  • The SEQUENCE function
Lookup functions
  • The VLOOKUP function explained
  • Using VLOOKUP for a range lookup
  • VLOOKUP with dynamic column index number
  • Handling errors with lookup formulas
    The INDEX and MATCH combo
    Two-way lookup with INDEX and MATCH
    Sort and return non-adjacent columns
    The XLOOKUP function
    Multi-column XLOOKUP
    Two-way lookup with XLOOKUP
Validating and protecting Excel
  • Validate the number of characters
  • Create data validation rules
  • Create drop-down lists
  • Dependent lists to break up large lists
  • Custom data validation messages
  • Encrypt a file to prevent access
  • Protect the structure of a workbook
  • Protect data on a worksheet
Functions for data analysis
  • The SUMIF, COUNTIF, and AVERAGEIF functions
  • Sum values between two dates
  • Advanced sum with SUMPRODUCT
  • Sum values for a specific weekday with SUMPRODUCT
  • The AGGREGATE function
  • The AGGREGATE function – advanced example
Charts
  • Create your first chart
  • Add and remove chart elements
  • Formatting charts
  • Modify the chart axis
  • Save time with chart templates
  • Combo charts – two chart types in one
  • Chart filters
  • Change chart data with a drop-down list
  • Using cell values for chart labels
  • Conditional formatting with charts
  • Sparklines for quick data analysis
Manipulating text
  • Splitting text across multiple columns
  • The CONCAT and CONCATENATE functions
  • The TEXTJOIN function
  • Extracting text from a cell
  • Using the MID and FIND functions together
  • The VALUE function
  • The SUBSTITUTE function
  • The awesome Flash Fill tool
Tables
  • Format data range as a Table
  • Key benefits of using Tables
  • Create Table styles
  • Formulas using Table data
  • Convert a Table back to a range
PivotTables
  • Creating a PivotTable
  • Changing the Values function
  • Formatting values efficiently
  • Creating PivotTable styles
  • Sorting PivotTable fields
  • Grouping data in a PivotTables
  • Showing values as percentage, difference, and ranking
  • Conditional formatting with PivotTables
  • Filtering PivotTable data
  • Refreshing a PivotTable
  • Creating a PivotChart
  • Using Slicers for interactive PivotTables
  • Using the timeline Slicer
Introduction to Power Query
  • What is Power Query
  • Transforming messy data
  • Unpivot columns
  • International dates and number formats
  • Merge queries 1
  • Merge queries 2
  • Combine and append multiple worksheets
  • Import multiple files from a folder
  • Importing data from the web
Introduction to Power Pivot
  • Introduction to Power Pivot
  • Add Tables to the data model and create relationships
  • Create a PivotTable from the data model
  • Enable the Power Pivot Add-in
  • Explore the Power Pivot window
  • Introduction to DAX calculated columns
  • Introduction to DAX measures
Introduction to Macros & VBA
  • Recording your first macro
  • Assigning your macro to a toolbar button
  • Add your macros to the ribbon
  • Editing your macro code
  • Using relative references when recording macros
  • Saving a workbook containing a macro
  • Editing your macro code (Part 2)
  • Adding a button to your worksheet
Get started writing VBA
  • Introducing the VBE
  • Writing your first macro
  • Cleaning recorded code
  • Working with method arguments
  • Referencing cells, worksheets, and workbooks in VBA
  • VBA Errors
Wrap up
  • Wrap-up
  • Feedback
  • Certificate

No fluff. No filler. Just the core skills that every Excel user should know.

What difference will Skills Boost make?

Avoid the Pitfalls

If you don’t invest in your Excel skills now, here’s what happens:

  • You’ll keep wasting time on manual, repetitive tasks
  • You’ll be passed over for opportunities because others know Excel better
  • You’ll stay stuck doing reactive work instead of being the person who solves problems

The Transformation

After completing this course, you will:

  • Confidently tackle tasks others avoid
  • Build formulas, reports, and dashboards with ease
  • Stop Googling basic functions, because you understand how Excel actually works
  • Unlock career opportunities and take on more meaningful work

But when you know Excel, you become faster, smarter, and more valuable to your employer.

Every future Excel skill will build on this solid foundation.

Number 1

Join the Excel Academy

Enrol today to get instant access to the Skills Boost – Beginner to Expert course.

Number 2

Follow the course

Start learning the essential Excel skills you were never taught.

Number 3

Apply the learning

Apply the skills and start saving time today.

Every future Excel skill will build on the solid foundation of this course.

Skills Boost – Beginner to Expert is only available within the Excel Academy.

GET ACCESS ➜
LEARN MORE ➜