When you need to improve the looks of a spreadsheet, it’s good to know how to install a font in Excel. Fonts improve the style of documents and web pages. They can also make text more readable and give personality to your projects. There are numerous free and paid fonts available on the Internet. In
We have seen people ask this question online quite a bit. The reason is simple, there is a SUM function in Excel. But is there also an opposite of SUM? A formula that will subtract all numbers that you give it? A spreadsheet ‘minus sum’, so to speak? There are two answers to this question.
Did you know that Microsoft Excel has over 500 functions at your disposal? These functions make Microsoft Excel useful as an analytical tool for almost any industry. Marketers may not think of Excel as such, but Excel can be a super helpful tool to make their daily analysis of data simpler. Because nowadays, successful marketers
Sometimes you’re just strapped for time. You may be applying for jobs and looking for a quick CV boost. Or you might need to learn Excel fast for an upcoming project that requires it. Whatever the reason, it can be a relief to hear that it is possible to learn Excel fast and without much
In this article, I’m going to walk you through a couple of Excel exercises that are perfect for beginners. We will slowly ramp up the difficulty from beginner to advanced so if things are too easy for you, just scroll down a bit. Getting started with formulas ‘Formulas?!’ You may be thinking. ‘That’s way too
A lot of us are familiar with this function. You could even make a case that it’s the most (in)famous Excel function out there: Vlookup. The Vlookup function (Vlookup stands for Vertical Lookup) is widely used in business and personal Excel use alike. Whenever a value needs to be found in a long list of
In this short video, I’ll tell you how to calculate someone’s age based on a date of birth and how you may be doing it wrong right now. Once you realize that age is just the difference in years between a date of birth and the current date, it becomes easy to do. Check the video
To go from a beginner or intermediate Excel level and become a master, you will need to improve your speed. One of the quickest ways to greatly improve your Excel speed is by learning some keyboard navigation shortcuts. In this video I’ll show you what buttons and keyboard shortcuts you need to know to navigate
Many people use Excel as a tool to keep up with their personal finances. In this video I show you how you can create a spreadsheet where you can keep track of your personal finances every month. The result is a dashboard with charts giving you insight in your spending and saving.Video Download xlsx fileDownload
What’s up with dates and times in Excel? What is a serial number? And what does the date January 1st, 1900 have to do with it? Today, we’re de-mystifying dates in Excel.