How to predict cricket scores [Excel + Machine Learning]
Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.
Transpose this address data [VBA homework]
Here is an interesting problem to keep you busy.
Transpose the address data in column A into the format indicated in C:G using either VBA, formulas or Power Query. Once done, post your answers in comments section.
3D Max Formula for Excel
We all know about the MAX formula. But do you know about 3D Max?
Sounds intriguing? Read on.
Lets say you are the sales analyst at ACME Inc. Your job involves drinking copious amounts of coffee, creating awesome reports & helping ACME Inc. beat competition.
For one of the reports, you need to find out the maximum transactions by any customer across months.
But there is a twist in the story.
Your data is not in one sheet. It is in multiple sheets, one per month.
Quickly combine text in multiple cells using this trick! [Formulas]
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above.
Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.
How to transpose a values in a row to column using formulas… [Quick tip]
This is interesting, I am in Columbus to meet one of my college friends. I remember him as a very meticulous person from college days. So it is no surprise when he showed me his massively impressive finance tracker last night. He has been tracking expenses, income, credit card payments and gas (petrol) consumption since 2008. Very impressive indeed.
Then out of blue he said, he has a problem with his spreadsheet. In this own words,
When entering data for credit cards, I use one column per card. But in my report view, I want to show credit card details in rows. How do I do this?
Something like above…. Today, lets learn how to do this using Excel formulas.
Transpose a table quickly using Copy – Paste [Quick tips]
On Friday, we learned how to transpose a table of data using Excel formulas. Today lets learn a quicker & easier way to do this by just using copy, paste, find & replace.
Transpose a table of data using Excel Formulas
Today lets tackle a familiar data clean-up problem using Excel – Transposing data.
That is, we want to take all rows in our data & make them columns. Something like this:
Learn these 4 techniques to transpose data:
1. Using Paste Special > Transpose
2. Using INDEX formula & Helper cells
3. Using INDEX, ROWS & COLUMNS formulas
4. Using TRANSPOSE Formula