CategoryExcel Formulas

How to Split First and Last Name in Excel [with examples]

H

In this step by step tutorial, we are going take a look at how to split first and last name in excel with detailed examples. Data mining is a cumbersome work!You need to have a better understanding of various excel text formulas and tools like the Text to Columns to deal with the situation. If you happen to be the one who lacks these skills, then no worries, you’ll certainly have...

The Step-by-Step Guide to Creating Excel Heat Map That’ll Impress Your Boss

T

Creating excel heat map is an art. You need to know which colour combinations work better for your scenarios. According to a research conducted by Prof. Richard Wiseman, “about 25% of people found documents with colours are easier to analyse”.  In fact, colours can play a pivotal role in your analysis when you use it wisely. For example, if you’d like to highlight high-cost...

5 Clever Ways to Use Excel Go to Special Command

5

Excel Go to Special command has a special focus in the industry, do you know why..? As the name suggests, the user can quickly select a cell or a group of cells based on a preferred condition. For example, if you want to quickly see all formula cells in your workbook then your ideal option would be “Go to Special”. It’s not just limited to formulas, you can also use it for...

The Ultimate Guide to Excel Keyboard Shortcuts

T

The engine needs powerful thrust for speed, whereas analyst needs a handful of Excel keyboard shortcuts to crunch data and convert that into a useful information. Indeed it’s not always a good idea to work with the mouse for selecting various options. According to thekeycuts average analyst can save 10.79 minutes a day & 47 hours a year by using shortcuts, that sounds a lot isn’t...