Get Your Excel Certification Here: The 2 Best Online Solutions Looking for a new job? Want to increase your salary or get promoted? If so, then having a certificate to showcase your expertise in Excel is a must. In this article, we’ll show you 2 different solutions you can try and get [...]
The VALUE Function Explained: Convert Text to Numbers In this tutorial, you learn how to use the 'VALUE' function in Excel. The VALUE function convert numbers stored as text into number format. Don't worry if it sounds a bit complicated, I show you everything step-by-step. Later, you'll also see how this conversion can be necessary [...]
How to Use Comments in Excel's VBA Editor Like any scripts, Excel’s VBA modules can be very long and complicated to read. Basic VBA scripts are easy to work your way through. But once you start adding more variables and functions, it gets very difficult to figure out what’s going on. So, how do you [...]
All Excel's Date and Time Functions Explained! This is the complete guide to date and time in Excel. It’s a whopping +5500 words (!), so be sure to bookmark it. The first part of the guide shows you exactly how to deal with dates in Excel. I will show you how to perform calculations involving [...]
How to integrate Excel Online with Zapier (Gmail Example) Written by co-founder Kasper Langmann, Microsoft Office Specialist. A few weeks ago, we were contacted by Jose Proenca, who wrote us the following: I figured you'd be interested in a new release we're super excited about. Zapier is one of the first to make [...]
These Are The 69 World's Best Excel Blogs That Will Teach You Everything About Spreadsheets Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you are looking for practical, in-depth educational blogs about Excel, you've come to the right place. Here are the top 69 best blogs to learn everything about Excel. As [...]