# LATEST POSTS

Automatic vs Manual Calculations In Excel

Advanced users of large Excel spreadsheets can benefit from switching the default automatic calculations to manual calculations.

Useful Alt codes to insert special characters

Alt codes allow special characters like the pound sign, copyright symbol, fractions and diacritical (non-English) characters to be added.

Sorting in Excel: The Ultimate Guide

What is the secret to sorting data in Excel effectively? Discover how to sort rows using value, colour, icon or custom sequence or rearrange columns

Conditional Formatting Formulas That Highlight Entire Data Rows Automatically

Conditional Formatting is versatile. When a condition is true, a format is applied. Using conditional formatting formulas hands you complete control.

How To Create Your Own Custom Date Format In Excel

Creating a custom date format in Excel is easy and lets you get away from bog-standard date formats like dd/mm/yyyy. Find out how.

Goal Seek: Reverse Engineer An Answer

Goal Seek is a simple tool that finds the exact input value required to generate the answer you have specified.

VLOOKUP: The Ultimate Guide

Having problems with VLOOKUP formulas? Discover how to create them from scratch the right way, every time.

3D Formulas: The Smart Way To Do Cross-Sheet Formulas

3D formulas are simpler, take less time to create than regular formulas and are less prone to errors. What's not to like?

Degree Symbol: 3 Ways To Insert Degrees Into Excel Spreadsheets

Discover 3 ways to insert a degree symbol into an Excel spreadsheet - using the built-in character sets and using superscript.

21 Major Formula Fails & How To Fix Them

Identify, fix and avoid the most common formula errors on an Excel spreadsheet. Finally, put your formula headaches to bed.

Managing Duplicates in Excel

Duplicates creep into any large Excel list. Here we explain how to (a) highlight duplicates, then (b) remove duplicates leaving just the unique items.

3 Easy Ways To Calculate Averages In Excel

Average values are easy to work out in Excel. The Average, Mode and Median functions provide 3 ways. The AVERAGE function is the simplest and most common

Hide Gridlines (On Spreadsheets) For a Clean Finish

Hide Gridlines to apply a clean, crisp finishing touch to your spreadsheet. Gridlines are great while designing, but hide them when done to remove clutter.

Worksheet Tab Navigation – A Rare Expert Tip

Worksheet tabs can be renamed, reordered and navigated, but it's painful to scroll through lots of tabs. If that's you, you'll love this quick tip.

How Many Rows & Columns Does Excel Have?

To discover how many rows and columns are available, there is a quick shortcut. Advanced users may also want to switch calculations from auto to manual.

COUNT vs SUM vs COUNTA vs COUNTBLANK vs COUNTIF

COUNT is different to SUM. This post explains why then goes beyond the basics revealing the different types of data that can be counted.

Merge and Centre: A Better Alternative

Using Merge and Centre in Excel can cause many problems. This little gem is a fantastic alternative with no known side effects!

How to Calculate a Percentage in Excel: A Comprehensive Guide

Percentages in Excel are easy once you understand the simple maths behind them. Discover for yourself how to calculate percentage in Excel.

How to keep leading zeroes in Excel

When you type a number with leading zeros, e.g. 00123, Excel drops the leading zeros as soon as you press Enter ... unless you do this ...

How to Manipulate Text and Clean Up Your Data Like a Pro

With text functions you can manipulate text in Excel however you want. Trimming, searching, concatenating, extracting certain parts - Excel has it all

DropDown Lists: Functional & Awesome

Drop down lists in Excel are functional and useful, But best of all it makes you look good! It also improves the accuracy of data and is easy to set up.

Finding the biggest number or smallest number

Picking out the biggest number or the smallest number from a range of cells in Excel is super easy. Here's how.

Formulas Quick Start Part 1 of 4: How To Get Started

Formulas Quick Start Part 2 of 4: SUM & AUTOSUM

Formulas Quick Start Part 3 of 4: AVERAGE, MAX, MIN and COUNT

Formulas Quick Start Part 4 of 4: Order Of Operations

Excel formulas are easy with a little bit of guidance. In this free 4 part blog guide, discover how to build Excel formulas the right way, step-by-step and without errors.

#001 | 3 Simple Productivity Tips For Getting Your Butt In Gear

Are you a perfectionist? Do you too suffer from paralysis by analysis? Stop overthinking and get your butt in gear with these productivity tips.

# 30 EXCEL POWER TOOLS

Revealed: The shortcuts, tools and techniques the experts didn't want you to know