Tidy up lists

You don't have to be an Excel expert to be able to clean up lists - but if you tell your colleagues that you can help them clean data, it might sound like it! For example, when your colleague needs help with the number of duplicates in a list and you, with your new title of "Excel expert", can easily accomplish this with the formula: = NUMBER.OM.

Automate the building of schedules and plans

Is Excel the best planning tool in the world? Yes, it actually can be! Anyone can color cells to create a nice schedule or Gantt chart. With the =OM(AND( formula, if you add the number of days to the start date, you can use slightly more advanced formulas to make the cells color themselves.

Simplify the use of filters

Instead of managing your filters manually, you can use the formula =FILTER. The formula allows you to link your filter to conditions; such as filtering out sales for less than a specific amount.

Converting units of measurement at high speed

There are 102 different ways to convert units of measure in Excel. Feel free to watch a four-hour instructional video. No, we're just kidding. Using the formula=CONVERT, you can quickly and easily convert units such as speed, area and weight with a few keystrokes!

Interested in what else we can help you with in Excel?

We like challenges, and when it comes to Excel there are plenty of them. In Excel, with our clever add-ins, you can, for example, have direct access to ready-made chart templates that look exactly as you want them to. You can link Excel to both Word and PowerPoint. You can manage your stock balances automatically and you can keep track of your expenses.

We know that Excel can feel complicated and advanced. That's why we always aim to create intuitive design when developing an Excel model or template for you.