The Excel Factor

21/02/2023

Looking for a formula to test if a cell has one or multiple text from a list of text values?

https://www.theexcelfactor.com/test-cell-for-multiple-matches-to-a-list/

22/08/2022

Using Excel's native Autocorrect more effectively

You can use Excel's native Autocorrect for better productivity with formulas, unusual custom formats or whatever you can't always remember such as the custom format to suppress zeros

01/06/2022

Need help with your business spreadsheets? Maybe you are thinking about automation of time consuming tasks like quoting, payroll prep, reporting, printing, budgeting and cashflows? Maybe you need a dashboard or other reporting solutions?
www.theexcelfactor.com

21/03/2022

I recently bought a standing desk from Omnidesk and they really are a great investment in yourself.

I was actually reluctant and skeptical about the benefit of a standing desk so resisted for way too long. I have been presently surprised how enjoyable having one is. I don't stand and work for that long in a working day, but just standing when you have been sitting too long, or bogged down with something, even if for just 30 minutes every so often just changes your energy levels. Also what I hadn't realised is, for some jobs where you might be waiting for uploading or downloading to complete, it's great to be standing so you can flit in and out behind your PC to check where its up to. Also for working with someone else standing behind the PC is often better. Plus even being seated, being able to adjust that desk height to just right really makes a difference.

So I did a lot of research and bought the Omnidesk Pro 2020 Wildwood Collection 1800 wide with a straight edge and a cable management bar and it's sturdy than I thought it would be and just looks great. Assembly took a while but was pretty straight forward. The controls are great and wow proper cable management makes a big difference.

So I am very happy I made the leap to a new desk style, can recommend Omnidesk https://theomnidesk.com.au as a great option, I had no quality issues and they are straight forward to deal with and deliver fast.

17/01/2022

Left-handed Perixx mouse, why didn't I get you years ago!

https://www.theexcelfactor.com/left-handed-mouse/

29/12/2021

Show and Hide columns using Power Query
https://www.theexcelfactor.com/hide-and-show-columns-with-power-query/

28/12/2021

Here are my 5 tips in more effectively using Microsoft To Do
https://www.theexcelfactor.com/5-tips-on-better-using-microsoft-to-do/

13/12/2021

Helping local businesses large and small with all things spreadsheeting!

29/07/2020

Watch this entertaining Oz du Soleil video on using the new FILTER() formula and only returning the columns you want!
https://www.theexcelfactor.com/use-new-filter-formula-and-retrieve-only-the-columns-you-want/

04/06/2020

Hi everyone see this Lifehacker post about an Excel based scam...
John from theExcelFactor.com

Beware Coronavirus-Themed Malware Disguised As Excel Spreadsheets
https://www.lifehacker.com.au/2020/05/beware-coronavirus-themed-malware-disguised-as-excel-spreadsheets/

While many parts of the world are preparing to slowly reopen after months of lockdown, coronavirus-related scams and malware campaigns show no signs of abating. The Microsoft Security Intelligence Team recently disclosed details on two massive coronavirus phishing campaigns duping users into downloa...

20/05/2020

Taking the new Dynamic Array functions out for a spin
https://www.theexcelfactor.com/dynamicarrays1/