The 7 Best Excel Templates For Any Purpose Templates can be really helpful in achieving a goal or maintaining a routine. Whether you need to plan your credit card repayment or prepare your weekly meal list, Excel spreadsheet templates can help you do both. You can create a list yourself too. But why [...]
How to Use Multiple IF Statements in Excel (Step-by-Step) The IF function is an awesome logical function of Excel. When used the right way, it will offer results that will leave you fascinated 🤩 The IF function, by default, tests a single logical condition. But with the classic nesting of the IF function, [...]
How to Undo & Redo in Excel (Shortcut + Button) Life has no Ctrl + Z but luckily, Microsoft Excel has! 😀 Mistakes are common and inevitable in Excel. To undo any of it, we press Ctrl + Z. To redo, we press Ctrl + Y. The undo and redo buttons are ultimate [...]
Excel Crash Course: Learn Excel in Just 30 Minutes (Free) This crash course on Excel is the quickest way to learn Excel. I’ve taken what I learned from teaching Microsoft Excel for 10 years and compressed it into a 7-part free Excel course that teaches you Excel in 30 minutes. In short: If [...]
Numbers vs Excel: When to Use Excel & When Numbers Is Better A spreadsheet program is a vital tool in the business world. You might think Microsoft Excel is the only real spreadsheet out there, but Apple actually has its own "free Excel" called Apple Numbers. Aside from their OS compatibility, which one [...]
How to use the Excel functions TRUE & FALSE (Boolean) There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. For example, you might manage a sales team. You may need to calculate whether each salesperson qualifies [...]
Learn Microsoft Office with Ribbon Hero 2 - Free Download Ribbon Hero 2: Clippy's Second Chance (how awesome a name is that?) is Microsoft's answer to learning Office in a fun, free easy way. Ribbon Hero 2 was released for Office 2007 and 2010. Despite the game being a few years old, the fact [...]
Review of Visual Studio Community - Replacing Express If you’ve looked for Microsoft’s Visual Studio Express IDE lately, you’ll have noticed that it’s no longer available. Which may have made you nervous. Express was the free version of Visual Studio, so now that it’s gone, will you have to fork over your cash to [...]
How to Switch X and Y Axis in Excel (Flip Chart Axes) Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble. Microsoft Excel is powerful spreadsheet software that will let you store data and make calculations on it. You can then visualize the data using [...]
How to Create a Box and Whisker Plot in Excel If you’re a stats person, a box and whisker plot must be your go-to chart 📈 That’s because this one chart accommodates most of the key statistical values for any dataset. Starting from quartiles to the median to the outliers of that dataset. [...]