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 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...
by Violeta Matei | Mar 14, 2013 | Tutorials
If you use PayPal to sell products or services on your website, you probably noticed that Buy Now buttons don’t change on mouse over. I believe it’s much nicer if they did. The project I currently work on require PayPal buttons, because it’s about...
by wp_update-1716481042 | Jul 23, 2012 | Tech & Internet, Tutorials
This is a simple method to attract more readers to your website: get more people click on it from Google’s search results pages. You may have noticed that some results look more appealing than others: they have little stars or a small photo of the author. Research...