Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets. In order to help you work a little bit faster, or maybe more efficiently, we have assembled 60+ of the best Excel shortcuts that you need to know. F2 : …
Excel is genuinely one of the most popular pieces of software in the market today, but many professionals still don’t fully understand its capabilities despite the fact that it can save a lot in their daily tasks. Well, today’s your lucky day! We’ve rounded up 10 different Excel hacks you’re sure to use and love. 1. Easily format numbers Let’s …
Learning to use Excel properly is a talent in itself. Many people spend a lot of time using it without ever truly knowing the many features or hacks that can make their lives so much easier. In this post, we’re going to outline no less than 101 different tips that you absolutely should know in Excel. Keyboard Shortcuts for Excel …
We all know the famous star of Excel functions VLOOKUP. It is commonly used for looking up values with a unique Id. But this is not the only function that can be used for looking up values in Excel. There are many other functions and formulas that can be used to lookup value. In this article, I will introduce you …
Microsoft Excel is an integral tool for most businesses. Some people relish the capabilities of Excel, finding it to be a useful tool that allows them to easily manage, report on, and illustrate tables of data. Others, however, find it tedious and downright obtuse, unable to make heads or tails of what Excel can do for them aside from keeping things …
There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa – remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you what I am talking about. …
Excel already has a couple of ways to sort data quickly. You can easily sort a data set by using the sort icons in the ribbon or the sort dialog box. Then why do you need to know how to do this using VBA? Knowing how to sort data using VBA can be helpful when included as a part of …
One way of getting the VBA code is to record the macro and take the code it generates. However, that code by macro recorder is often full of code that is not really needed. Also macro recorder has some limitations. So it pays to have a collection of useful VBA macro codes that you can have in your back pocket and …
When you create/record a macro in a workbook in Excel, it can only be used in that workbook. But what if you have a list of useful Excel macros that you want to use in all the workbooks? In such a case, it’s a good idea to save these in your Personal Macro Workbook. Doing this would allow you to access the …
Excel is a great spreadsheet tool, but there are a few things about it that may irritate you sometimes. For example, if you add a plus sign before a number in a cell in Excel, that plus sign would just go away. The same happens when you try and add leading zeros before a number. The reason for this is …