6 Must Know Line Chart variations for Data Analysis
Line charts in Excel are essential for trend analysis, spotting distribution and outliers. Use these 6 variations to get more out your line chart.
- Indexed Line Chart
- Sparklines
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations
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.
Time series analysis and interactive forecasting in Excel – Sample video from 50 ways course
Are you hungry from some Excel awesomeness? It’s launch time. I am very happy to announce that our most popular analytics online class – 50 ways to analyze data is opening up for enrollments in first week of May 2018. As the name suggests, 50 ways program is all about data and making sense of it. You will learn many ways to analyze, visualize and present data to your clients and superiors. Next time someone asks you, “Can you look at this data and tell us what is going on?” you can confidently say YES.
Learn all about 50 ways program and signup for the waiting list.
In this article, Let me show case one of the examples from 50 ways to analyze data course and how it can help you.
Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]
One of the coolest features of Excel 2016 is forecasting. Today, let’s understand how it works with a sample data set.
Watch below video to understand forecasting in Excel 2016.
CP047: Best Excel tools for Entrepreneurs
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 47th session of Chandoo.org podcast, let’s see how Excel can make you an awesome entrepreneur.
What is in this session?
In this podcast,
- Why Excel for entrepreneurs
- Key areas of a business owner’s work
- Projects & to dos
- Finances
- Customers & marketing
- Planning & strategy
- Processes & workflows
- 5 features of Excel that help
- Conclusions
Show forecast values in a different color with this simple trick [charting]
Let’s say you made a chart to show actual and forecast values. By default, both values look in same color. But we would like to separate forecast values by showing them in another color.
If you are a seasoned Excel user, you may be thinking, “Oh, that’s easy. I will just create 2 sets of data (one for actual and one for forecast), make a chart from them and apply separate colors.”
But here is a really simple way to get the same effect.
Use a semi-transparent box to mask the forecast values, as shown above. Read on to learn how to do this.
Top 10 things we struggle to do in Excel & awesome remedies for them
Recently we asked you, what do you struggle doing in Excel? 170 people responded to this survey and shared their struggles. In this post, lets examine the top 10 struggles according to you and awesome remedies for them.