by Violeta Matei | Oct 13, 2023 | Microsoft Office, Tutorials
If you work as a data analyst or marketing specialist, you may already know how time consuming formatting tables and reports can be. Keyboard shortcuts are more than welcome, as they can save you lots of time on repetitive formatting tasks. The Merge and Center...
by Violeta Matei | Oct 13, 2023 | Microsoft Office, Tutorials
More than once my work colleagues got irritated by seeing the dreaded #NA or #N/A text breaking their beautiful tables and worksheets. Younger ones didn’t even know that the #NA acronym stands for, so I had to explain it time and again. What If We Could Replace...
by Violeta Matei | Sep 25, 2023 | Microsoft Office, Tutorials
Comparing and matching data between two columns is a common task in Excel. For example, you may have one list of customer names and another list of email addresses, and you need to identify which emails match to each customer. Or you might have two sheets with product...
by Violeta Matei | Sep 24, 2023 | Microsoft Office
More often than not Excel users are prone to entering typos and other misspellings into cells, making a mess out of a database or table. The best way to prevent such errors is to limit choices in a cell to restrict data entry to a set of desired values. This article...
by Violeta Matei | Sep 23, 2023 | Microsoft Office
Why would anyone want to reduce Excel file size or to compress such files? Main Reasons To Reduce Excel File Size There are multiple reasons for wanting to reduce Excel file size outcomes. Here are a few of them. I’m sure you can find others, if you think...
by Violeta Matei | Sep 23, 2023 | Microsoft Office, Tutorials
If you’re a Microsoft Excel user, you probably know how much time repetitive tasks take. The good news is that you can speed up your work by recording and customizing macros. When it comes to Excel macros, sky is the limit. Just get creative and put your ideas...
