Hello Everyone! Welcome to the Group.
A group which tries to bring the latest news on Excel, interesting solutions using Excel, thoughts and ideas, tips and tricks and anything that revolved around Excel and Analytics using Excel.
Please feel free to actively contribute!
The annual Excel and Financial Modeling World Championship 2014 Event (known as ModelOff) is here.
Check out more details at www.modeloff.com
A lot of the time, there are differences between different pieces of data received from a client/ data team – one being when different pieces roll up to different levels in a nested structure, for eg. weekly vs monthly vs yearly. Is that problem? Let’s take a look.. Taking the example here – let’s assume […]
How does the Time format work in Excel? – The DATE & TIME is integrated to be represented by one number – a floating point number! – The decimal part characterizes the time, while the integer part the date. – [0,1] = [00:00 HRS,00:00 HRS + 1 day] This is the set that determines the […]
All the while it’s been Excel can do this, and Excel can do that. But what are its pitfalls? Where does it fail? What should we beware? Surprisingly, there’s a whole community that’s at this topic! And I only recently stumbled upon them. That while trying to learn the new software “R”. Here’s a link […]
Scatter plots are generally a nice tool to represent data, especially ones where we’d like to show a pattern of some kind. But what happens when we have more than 2D data for a scatter plot? Let’s take an example here. This is how the data looks like – While the above scatter plot gives […]