LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Lynda – Excel Scenario Planning and Analysis

Leave a Comment

Lynda – Excel Scenario Planning and Analysis
English | Size: 266.87 MB
Category: Tutorial


A multitude of factors can affect the trajectory of your business. Learning how to document, summarize, and present projected business scenarios can help provide a basis for insightful business analysis, and help you evaluate the impact of various choices on your organization. In this course, explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel. The course starts with a chapter on the art and craft of scenario planning before turning to the technical capabilities of Excel. Tools covered include row grouping to show and hide detail, PivotTables, and functions for using the normal distribution. [Read more…]

Lynda – Excel – Analyzing and Visualizing Cash Flows

Leave a Comment

Lynda – Excel – Analyzing and Visualizing Cash Flows
English | Size: 158.41 MB
Category: Tutorial


By learning how to evaluate and visualize cash flows for your business, you can make more informed decisions about prospects and projects. In this course, Curt Frye demonstrates effective ways of evaluating and visualizing cash flows using Microsoft Excel. He demonstrates how to calculate the effect of interest rates and inflation, calculate the present value of an investment, and determine how much interest you can save by paying extra principal each month. Plus, he explains how to calculate net present value and internal rate of return, and shows how to create a cash tracking worksheet, where you can keep a record of income, expenses, and your current cash balance. [Read more…]

Excel: Analyzing Your Sales Pipeline | Rudolph Rosenberg | LYNDA

Leave a Comment

Excel: Analyzing Your Sales Pipeline | Rudolph Rosenberg | LYNDA
English | Size: 233.97 MB
Category: Tutorial


Enhance your sales pipeline and bolster business performance using Excel and Salesforce. In this course, follow along with Rudolph Rosenberg as he shows how to analyze your sales performance using these powerful tools. Rudolph begins with an overview of the sales cycle and the sales pipeline, including what information to extract from Salesforce, and how to do it. Next, he covers the key angles to analyzing sales performance, and explains how to create both qualitative and quantitative reports. Finally, he shows how to conduct effective pipeline reviews for you and your team. [Read more…]

Lynda-Excel Quick Tips 2017

Leave a Comment

Lynda-Excel Quick Tips 2017
English | Size: 149.92 MB
Category: CBTs


The most common questions about using Excel now have timely video answers. This set of quick tips provides helpful, condensed steps you can readily apply to keep on task-whether you’re running calculations, setting up a new workbook, fixing a sheet you received, or getting tables ready for presentation. Each video is about one minute long, so you can jump in and get some helpful insights in no time. [Read more…]

Excel Data Analysis: Forecasting

Leave a Comment

Excel Data Analysis: Forecasting
English | Size: 296.48 MB
Category: Video Training


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…]

Excel Data-Mining Fundamentals

Leave a Comment

Excel Data-Mining Fundamentals
English | Size: 402.66 MB
Category: Video Training


You don’t need to be a statistician to explore your own data. Learn how to use the software you already have, Excel, to perform basic data mining and analysis. Ron introduces core data-mining concepts like CRISP-DM (Cross Industry Standard Process for Data Mining), and then dives into the algorithms Microsoft offers for data mining right out of the box. Then learn about the data-mining structures and models in Excel SQL Server Analysis Services, and the new add-ins that make data mining in Excel both exceedingly powerful and incredibly easy. [Read more…]

Excel VBA in Depth

Leave a Comment

Up and Running with VBA in Excel
English | Size: 185.07 MB
Category: Video Training


In Excel: VBA in Depth, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.
[Read more…]

Excel VBA

Leave a Comment

Excel VBA
English | Size: 1.25 GB
Category: Tutorial


1 – Getting started with Range object, running and debugging
2 – Using the Cells object with and without range object, named ranges
3 – Using For and Next with variable, using loops for custom reporting
4 – IF THEN statements within the FOR NEXT loop
[Read more…]

ExcelVbaIsFun – Excel VBA

Leave a Comment

ExcelVbaIsFun – Excel VBA
English | Size: 1.25 GB
Category: Video Training


Auto-Hide Your Worksheet When You Click Away! Excel VBA
Capture Worksheet info To Userform and Save Back to Worksheet
Change MultiPage Tabs to Left, Right, Top or Bottom – Easy
Count and CountA in VBA Excel
CountIF Excel VBA
Custom Ranges and Getting LastRow to Work with Copy and Paste
[Read more…]