We’ve fallen into it so many times that we know exactly what it is by now but that doesn't have to be the case with you. Here’s a little menace that Ctrl + Z won’t undo and frankly, when Ctrl + Z ducks out, we go into a grain of digital frenzy. If your arrow keys are working your spreadsheet instead of the cell selection, that woe is called Scroll … [Read more...]

Part of Excel norms is working with numbers and dates because that is Excel's forte. Where dates make the central part of the data, you may be working on them to add days, months, or years to them or to find the difference between them in days, months, and years.We'll walk you through counting the number of weeks between two dates today. By the … [Read more...]

Excel is a numerical life savior, a tabular knight, and many things more but it comes with its whims which might suit us like a charm at times or could leave us with a broken computer an unsolved notion later. One such whim is when Excel takes it upon itself to enforce a number into a date. Why it does that, you are soon to find out.We will begin … [Read more...]

Different times call for different measures because counting and totaling are going to be a substantial part of your Excel journey so you can get to know how to do it right. The how to do it different part comes when counting text-specific cells or counting without the blank cells. Use the SUMPRODUCT, ISTEXT, COUNTIF, and EXACT functions or a VBA … [Read more...]

Smart searching makes the whole search process a breeze and that's smart stuff for you, making everything easy breezy. As your search gets specific, the process gets more complicated and if you don't employ the right techniques, you'll find yourself having a bad fishing day in a ginormous Excel sea. See if you can get it right the first time with … [Read more...]