This chapter from Excel 2016 Formulas and Functions takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.
This chapter from More Predictive Analytics: Microsoft Excel takes a look at how to decompose a time series so that you can see how its seasonality operates apart from its trend (if any).
No matter how smart, focused, and hard working you are, you can't do everything by yourself all the time. Sometimes you simply must delegate tasks to other people. Nobody is born knowing how to delegate; as with any other skill, delegating well takes thought and practice. Learn from Pat Brans how to delegate any kind of task successfully.
In this excerpt from Predictive Analytics with Excel LiveLessons (Video Training), Downloadable Video: Exponential Smoothing and Autoregression, Conrad Carlberg takes a look a exponential smoothing.
Why Grandfather clocks? What links are there between IT and clock movements?
New Mac OS X Means New Tricks...
Wow, who abducted our Windows 10 assumptions and left this smooth running and easy-to-use Operating System in their place?
It's time to consider the foibles of Laptop Life...