## Rounding Numbers in Excel: Round, MRound, Ceil & Trunc explained

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.

## Everything About Excel’s IF Function

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.

## Quick Excel Guide: How to Export as PDF

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.

## Remove Spaces in Excel

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.

## Find and Replace in Excel: The COMPLETE Guide

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.

## VLOOKUP explained in 2 minutes

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.

## Beginners Excel tips and tricks

You’ve worked with Excel a few times. You’ve seen others use it to great effect. And now, it is your time to start on your path to becoming the Excel guru of the office. Welcome to the beginners tips and tricks for Excel. Let’s get right to it. 1. Drag and drop to move A … Read more