Folks… I have an exciting news.
Excel School 2nd batch is now officially open.
If you want to know more about the program and join, head over the Excel School page.
In this post, you can find some information about Excel School and links to sign-up for the program. Read on, if you want to be even more awesome in Excel.
What is Excel School?
Excel School is an online Excel Training Program. It is full of real world examples. The aim of Excel School is to make beginners become productive and awesome in Excel.
How does it Work?
Once you pay the course fees and sign up for excel school,
- You will be given a userid and password to access excel school classroom
- Once you login to excel school, you will find links to all the material
- You can view lessons in any order or follow the order recommended by me
- You can download example excel files, home work and videos (if you sign up for download option) for further learning
- You can ask questions or discuss topics with other classmates thru comments
- Once every week, I will send you a news-letter with information, links and discuss course progress
Learn more about Excel School from this guide. [PDF]
Who should Join?
If you are a total newbie and dont know the difference between a cell and formula, Excel School is not for you.
If you are a wizard and can bake a cake with VBA, Excel School is not for you.
But, if you are someone who knows how to use Excel, write some formulas or make charts and looking for ways to boost your skill-set and productivity, Excel School is for you.
What topics are covered?
In Excel School, we cover these 12 topics in very detail.
| Excel School Topics: | |||
| Formulas | Formatting | Conditional Formatting | Basic Charting |
| Advanced Charting | Excel Tables | Pivot Tables | Data Validation, Filters |
| Advanced. Formulas | Importing External Data | Shortcuts, Productivity | Basic Form Controls, Macros |
Sign-up for Excel School Today:
Excel School comes in 2 flavors.
You can sign-up for ONLINE Option for $67 and access all the lessons online. You will be able to download example files, some bonus material. But you cannot download the videos.
For that, you need ONLINE+DOWNLOAD Option which costs $97. This gives you option to view lessons even after Excel School is closed.
See the below table to compare both options and choose the one you want. Click on the sign-up links to make a purchase.
| What you will get? |
 |
|
| Download HD Quality Lessons |
 |
|
| 1,200 Minutes of Excel Lessons |
|
|
| 40+ Example Excel Workbooks |
|
|
| Access to Online Classroom |
|
|
| Free Bonus – Formula Cheat-sheet |
|
|
| Free Bonus – Useful Shortcuts PDF |
|
|
| Free bonus – Chart Design E-book |
|
|
| 15 Day Money Back Guarantee |
|
|
 |
|
|
[If you are from India, Click here to Pricing in INR]
Any Questions?
- Visit Excel School FAQs page to get answers.
- Visit Excel School sales page to get full details
- Checkout Testimonials from Past Students to know how it feels.
- Download a sample lesson and see it for yourself.
If you still have questions, write to me at chandoo.d @ gmail.com or post a comment here. I will be very glad to answer your questions.
See you in Excel School.
PS: Uff.. I finally finished all the work required for Excel School 2 signups. Regular broadcast will begin tomorrow.
9 Responses to “Show forecast values in a different color with this simple trick [charting]”
While this works in a pinch, it clearly "lightens" the colors of the entire chart. Depending on where you use this, it will be blatantly obvious that you don't know what you are doing and present a poor looking graph.
Why not separate the data into different segments when charting and have as many colors as you have data points? You might have to create a new legend and/or repeat the chart in "invisible ink", but it would be cleaner and more consistent when new or updated data becomes available.
While I think I agree that doing it "properly" via a second series is preferable, I don't necessarily agree that making the entirety of the "future" (data, gridlines, and even the axis) semi-transparent is "poor looking". I think it could be seen as adding more emphasis to the "future-ness" of the forecast data.
In short, it's another tool for the toolbox, even if it's never needed.
Simply and clever 🙂
Quick & effective, cool. thanks.
I always use the dummy series.
Nice little trick, thanks very much!
Two sets of data better. Control is much better.
You can use the same chart next month to see what is actual and what is forecast.
To use this trick, I think grid lines has to be removed, that will make the graphic much more sharp.
to be honest, i dont understand why there is needed to do this way... in this case horizontal lines will be pale as well. then why a just can't change the color of the line partly???
Great tutorial. Thanks for the tutorial!