ask@excelatwork.co.nz

START LEARNING TODAY

START LEARNING TODAY

[email protected]

Excel

Hey there! Are you ready to take your Microsoft Excel skills to the next level? Look no further!

Our blog is packed with in-depth articles, helpful tips, clever hacks, and step-by-step examples to help you save time, work smarter and truly master Excel.

We've organized our content into different levels and topics, making it easy for you to find exactly what you need.

So don't wait, start exploring and enhancing your Excel skills today!

Learn how to get the most out of Microsoft Excel. Save time, work smarter and improve your understanding with our in-depth articles, tips, hacks, video and step-by-step examples. We’ve organised our posts into different levels and topics so that you can easily find what you need.

Browse Our Excel Blog Posts

Excel filter & sort

popular functions

All posts

Our Popular Blog posts

How to do a VLOOKUP with multiple criteria in Excel

How to Remove Blank Rows in Excel

Excel Ctrl End goes too far

How to add 0 in front of a Number in Excel

Our Latest Excel posts

NETWORKDAYS in Excel – Calculate the number of work days between two dates

NETWORKDAYS in Excel – Calculate the number of work days between two dates

6 Filter shortcuts in Excel to save you time

6 Filter shortcuts in Excel to save you time

How the SUMPRODUCT formula in Excel can help you work more efficiently

How the SUMPRODUCT formula in Excel can help you work more efficiently

Learn from Experts in Real-Time!

With live online tutoring, you can master Excel from the comfort of your own home or office.
No need to worry about traffic, parking, or travel time - simply log on and start learning with your personal tutor.

Excel Online Beginners Course

Excel Online Beginners Course

Excel for Beginners

Stage 1

Excel Stage 1 is designed specifically for individuals who are totally new to Excel, have been self-taught or have received bits and pieces of training from multiple sources.

Online Live Course

Online Self-Paced Course

Excel Intermediate Course

Excel Intermediate Course

Excel Intermediate

Stage 2

If you're ready to take your skills to the next level, and stop doing things the long and hard way, the Excel Stage 2 course is perfect for you! Improve your productivity and work smarter, not harder.

Online Live Course

Online Self-Paced Course

Excel Analyse Data and Pivot Table Course

Excel Analyse Data and Pivot Table Course

Excel Analyse & Report

Stage 3

Improve your workflow with advanced Excel tools like Lookup functions and Pivot Tables. Excel Stage 3 is perfect if you are wanting to streamline your data analysis and reporting process.

Online Live Course

Online Self-Paced Course

Excel Basics

How to Remove Blank Rows in Excel

How to Remove Blank Rows in Excel

Excel Ctrl End goes too far

Excel Ctrl End goes too far

Best Keyboard Shortcuts for Excel Beginners | Tips and Tricks

Best Keyboard Shortcuts for Excel Beginners | Tips and Tricks

Just starting out? If you're an Excel Beginner you’ll want to check out these blogs. Learn the essential skills needed to confidently create Excel worksheets that are both professional in look and design.

6 Filter shortcuts in Excel to save you time

5 Ways the Double-Click in Excel can help save time

Unlock the Power of Format Painter in Excel: Transform Your Spreadsheets with these 2 Super Tips!

How to Show Formula Bar in Excel (Formula Bar Missing)

Excel Basics

Just starting out? If you're an Excel Beginner you’ll want to check out these blogs. Learn the essential skills needed to confidently create Excel worksheets that are both professional in look and design.

How to Remove Blank Rows in Excel

Excel Ctrl End goes too far

Best Keyboard Shortcuts for Excel Beginners | Tips and Tricks

How to calculate GST at 15% using Excel formulas

Filter & Sort

How to Remove Blank Rows in Excel

How to Remove Blank Rows in Excel

How to Sum only visible cells in Excel when using Filter

How to Sum only visible cells in Excel when using Filter

5 Reasons why your Excel filter may not be working

5 Reasons why your Excel filter may not be working

Learn how to Filter and Sort your data in Excel. Step-by-step articles and examples to help you get the best results.

How to Sum only visible cells in Excel when using Filter

Filter data in Excel

How to Remove Blank Rows in Excel

Sort an Excel list into numerical, date or alphabetical order

Filter & Sort

Learn how to Filter and Sort your data in Excel. Step-by-step articles and examples to help you get the best results.

Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function

How to Sum only visible cells in Excel when using Filter

Sort an Excel list into numerical, date or alphabetical order

Filter data in Excel

Popular Functions

How to do a VLOOKUP with multiple criteria in Excel

How to do a VLOOKUP with multiple criteria in Excel

How to add 0 in front of a Number in Excel

How to add 0 in front of a Number in Excel

Excel – Using VLOOKUP to compare two lists

Excel – Using VLOOKUP to compare two lists

Need to master Excel functions? This may be the best place for you to start. Learn the most Excel popular functions and super useful formulas.

How to Remove #DIV/0 Error in Excel

Remove spaces in Excel cell before and after text

Excel – Using VLOOKUP to compare two lists

Use the SUMIF function to total only the cells that match your requirement

Popular Functions

Need to master Excel functions? This may be the best place for you to start. Learn the most Excel popular functions and super useful formulas.

How Change Case in Excel

Excel – remove unwanted spaces from a cell

Use the SUMIF function to total only the cells that match your requirement

Excel – Using VLOOKUP to compare two lists

Excel Organise, Analyse Data

November 22, 2021

Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function

There are many areas within business reporting where we are looking for the average of a selection of results.A good example of this may be ...continue reading >

Excel Combine, Analyse, Report

August 22, 2021

How to do a VLOOKUP with multiple criteria in Excel

There are times when you want to return a match for a VLOOKUP based on multiple criteria.For example, we may have customers who have multiple branches. ...continue reading >

All Excel Posts

NETWORKDAYS in Excel – Calculate the number of work days between two dates

6 Filter shortcuts in Excel to save you time

How the SUMPRODUCT formula in Excel can help you work more efficiently

5 Ways the Double-Click in Excel can help save time

Unlock the Power of Format Painter in Excel: Transform Your Spreadsheets with these 2 Super Tips!

How to Remove #DIV/0 Error in Excel

Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]

Elevate your Excel game and become a pro with our exclusive Insider Group

Be the first to know about new tutorials, videos, and tips for Microsoft 365 products. Join us now and claim your exclusive bonus today!

Join Free Now!

Join Free Now!