General

7 essential worksheet functions to cut down your business analysis time by 40%

Excel is huge and it contains hundreds of worksheet functions. But not all of them are needed if you want to analyze your business data. There are 7 essential worksheet...

Fast Track Data Analysis in Excel Training Program
0Comments

Wedding Dinner

When I was preparing for my wedding dinner , I have to count how many guests I have to invite, colleagues, ex-colleagues, Church friends, etc. All these names were pulled out...
Fast Track Data Analysis in Excel Training Program
0Comments

A new formula called TEXTJOIN

I was exploring how I could help one of my friends how to join text together that I stumble on this new formula called TEXTJOIN which was added a few months ago by Excel. With...
Fast Track Data Analysis in Excel Training Program
0Comments

Why you should not use VLOOKUP?

I was just pasting some data over from one worksheet to another in the same file. The destination worksheet contains a few thousand VLOOKUP formula. When I paste the data...
Fast Track Data Analysis in Excel Training Program
0Comments

Free Excel Course

If you are computer literate but do not know how to Excel, here is how you can get a Free and Excellent guide to get you started. Here is how you get it. 1. Open Excel or open...
Fast Track Data Analysis in Excel Training Program
0Comments

INDIRECT worksheet function

I have a formula which is used to find out if a particular description is available. It works well except that I have to keep readjusting the range in the formula because it...
Fast Track Data Analysis in Excel Training Program
0Comments

Excel Table

Excel Table is a new function in Excel. It can organize information neater compared to a normal Excel worksheets. But one thing Excel Table cannot do is insert cut cells...