There are a ton of ways to round numbers in Excel. Ways you may not have thought of at first, like rounding to the nearest 1000 or truncating a specific number of digits. This page is meant as an overview to find the specific rounding type that you’re looking for.
Welcome to the COMPLETE guide on the Excel If function. We’ll go into formulas containing If, nested If statements, AND and OR. The different conditional operators that can make up the conditions of the If function.
A 4 step guide to make Excel export as PDF. Information on how to convert the entire workbook, specific worksheets and an in-depth look at all the other PDF exporting options.
How to remove spaces from Excel workbooks and worksheets. There are quite a few ways of doing this. In this video I’m showing a couple of them. I also show how to remove line breaks or substitute them for something else.
Excel’s find and replace allows you to search for something (a text, a number, all formulas, etc) and replace it with something else. This blog post gives an entire overview of all options there are when finding and replacing in Excel. Wildcards, removing values, finding line breaks and extra options.
It doesn’t have to be difficult: Vlookup, the most infamous function in Excel, explained in less than 2 minutes! We’ll also get into it further with another example and some common questions and pitfalls and how to overcome them.
You know most of the ins and outs of Excel. You’re using it to create reports and automate things for yourself or your work. But there is still one thing that you haven’t been able to get into: Visual Basic. Welcome to the advanced lesson on Excel. We’ll be introducing you to the world of … Read more
You know your way around Excel. You may already be using it to create reports for yourself or your work. But when you get past the beginner stage you also start to see something else: all of the things that you don’t know about Excel. We’re here to fill you in on any gaps of … Read more