I'm going to show you how you can produce a forecast using just Excel trend lines and charts. We'll go through all the various different types of trend lines and how you can use them to form a forecast within a spreadsheet. I’ll show how to add seasonality to a trend so you can end up with a respectable forecast in minutes.FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
Some of the things you’ll learn in this video:
» All the Types of Trendlines
» Forecasting Forward
» Checking Trend Fit
» Deriving the Underlying Values
» Adding Seasonality to a Forecast
» General Chart Tips and Shortcuts
» LEFT, RIGHT and CHAR Formulas
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
Here’s some of the things you could do with the time you’re going to save: » Invest in yourself, saving even more time with Up4Excel training videos
» Spend more of your time on interpreting rather than compiling reports
» Get ahead of the game and accelerate your next promotion
» Or perhaps leave work on time, or even early, and enjoy your home life
We release a video every week, packed full of ways to save time and impress those around you. Make sure you subscribe, and hit the bell icon, so you don’t miss out and fall behind!
Here are links to some other videos you will find useful on chart techniques:
» Excel Charts Made Easy: Excel Charts and Graphs for Beginners
» 7 Tips for Improving Excel Chart Appearance
======================================================================================
The Webcam I Use:
Logitech C920 HD Pro Webcam, Full HD 1080p
https://amzn.to/2nlc9FE
Recommended Advanced Formulas Book:
Ctrl+Shift+Enter: Mastering Excel Array Formulas (by Mike Girvin of ExcelIsFun fame)
https://amzn.to/2ofPytU
======================================================================================
Get more FREE Training on Up4Excel here: https://cutt.ly/ewsz9Sn
FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
======================================================================================
▶️ DTube
▶️ YouTube