LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Skillshare – 100 Powerful Excel Tips with Excel 2016

Leave a Comment

Skillshare – 100 Powerful Excel Tips with Excel 2016

English | Size: 858.51 MB (900,215,551 Bytes)
Category: CBTs


If you’ve ever thought to yourself, “There has to be a better way to do this,” while using Excel, then know you’re probably right. With over 100 HD Lectures + Excel Templates, I’m going to teach you the best 100 time-saving tips and tricks in Excel to make Excel more efficient than you ever imagined.
[Read more…]

Excel Data Analysis Forecasting [54 MP4, exercise files]

Leave a Comment

Excel Data Analysis: Forecasting [54 MP4, exercise files]
English | Size: 809.98 MB
Category: Business / Finance


Professor Wayne Winston has taught advanced forecasting techniques to Fortune 500 companies for more than twenty years. In this course, he shows how to use Excel’s data-analysis tools-including charts, formulas, and functions-to create accurate and insightful forecasts. Learn how to display time-series data visually; make sure your forecasts are accurate, by computing for errors and bias; use trendlines to identify trends and outlier data; model growth; account for seasonality; and identify unknown variables, with multiple regression analysis. A series of practice challenges along the way helps you test your skills and compare your work to Wayne’s solutions. [Read more…]

How to Use Advanced Functions in Excel

Leave a Comment

How to Use Advanced Functions in Excel

English | Size: 0.98 GB (1,050,276,774 Bytes)
Category: Tutorial


Learn reporting techniques and how to use basic and advanced functions in Excel.

The aim of this course is to show you basic and advanced functions, their use, and some real-life example how to use it in your daily work/life.
When I started learning Excel, I realized that it is very important to know Excel functions, but knowing them is not enough. [Read more…]

Easily Estimate Projects Using Statistics and Excel – Pluralsight

Leave a Comment

Easily Estimate Projects Using Statistics and Excel – Pluralsight

English | Size: 0.99 GB (1,060,529,815 Bytes)
Category: Tutorial


Use Microsoft Excel’s built-in statistical functions, course template files, and your own project knowledge to easily and confidently estimate project durations, work efforts, costs, agile sprints, and agile releases. Use the Unified Scheduling Method to confidently create a dynamic, right-sized project reserve for traditional projects. [Read more…]

Excel with Excel Pivot Tables!

Leave a Comment

Excel with Excel Pivot Tables!

English | Size: 2.60 GB (2,795,444,035 Bytes)
Category: Tutorial


This is the Ultimate Excel Pivot Table course which has 217 short and precise tutorials. It also expands in to Charts, Conditional Formatting, Macros and Excel Shortcut Tips!
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010 or 2013. There are 14 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.
[Read more…]

Breaking Into Wall Street – Excellence with Excel

Leave a Comment

Breaking Into Wall Street – Excellence with Excel
English | Size: 968.74 MB (1,015,801,897 Bytes)
Category: Tutorial


Excellence With Excel teaches you everything you need to know about Excel for investment banking and private equity, from navigation basics and formatting all the way up to formulas, macros, and advanced topics like pivot tables.

These lessons are based on two real-life case studies: how to format, manipulate, and analyze customer due diligence data, and how to build and format a 3-statement model and valuation of Wal-Mart.
[Read more…]

LiveLessons Predictive Analytics with Excel

Leave a Comment

LiveLessons Predictive Analytics with Excel
English | Size: 752.12 MB
Category:Others


Description

Moneyball made predictive analytics famous: now, you can put it to work! In just three hours of expert video, Conrad Carlberg will teach you all the core skills you need to create accurate predictions of your own with Microsoft Excel-hands-on! Learn how to use Excel to design and run the two most basic analyses used in quantitative forecasting: smoothing and regression. Explore the self-correcting nature of exponential smoothing, discover how to use autoregression to create effective forecasts, and get comfortable using Excel’s powerful Data Analysis and Solver add-ins. Understand trends in time series, and master differencing, the most important technique for dealing with them. Finally, learn about ACFs and PACFs, and uncover their patterns to identify the best ways to forecast any given time series. These hands-on videos are accompanied by Excel workbooks containing all sample data and analyses: workbooks you can easily replicate and adapt for your own needs!
[Read more…]