Udemy – The Complete Excel Master Course – Become An Excel Guru

Udemy – The Complete Excel Master Course – Become An Excel Guru
English | Size: 1.76 GB
Category: Tutorial

This course was designed to take Excel users at any level, whether you are someone who is just starting out with Excel or someone who has used Excel for years but you just know that there is so must more you could be doing with Excel and by the end of the course turn you into an Excel Guru.
[Read more…]

Udemy – Learn SQL & Excel

Udemy – Learn SQL & Excel
English | Size: 1.73 GB
Category: Tutorial

Learn how easy it is to combine the two most popular business analytics tools in this comprehensive course.
With Brian Haas

There is simply no more valuable combination of data analysis tools than SQL & Excel.

Many business users can be intimidated by a database. This course will help you understand that in many ways, a database is like a supersized version of Excel. This means that you can bring invaluable insight to your team by delivering metrics that others can’t, and that in turn leads to new job opportunities and increased job security. [Read more…]

Udemy – Excel For Data Analysis Basic To Expert Level

Udemy – Excel For Data Analysis Basic To Expert Level
English | Size: 1.88 GB
Category: CBTs

Learn Excel for data analysis from basic to expert level and be able to apply this practical skill in any field. It explores spreadsheet software’s most relevant features which will help you become an expert as beginner, achieve proficiency as basic user or polish skills and finish learning curve as an intermediate one. All of this while using real-world data together with practical exercises done step-by-step. [Read more…]

Udemy – Excel VBA The Beginner’s Blueprint to Programming Excel VBA

Udemy – Excel VBA The Beginner’s Blueprint to Programming Excel VBA
English | Size: 1.00 GB
Category: Tutorial

What Will I Learn?

UNDERSTAND why you would want to use VBA in Excel
KNOW the difference between Macros and VBA
CREATE Macros in Excel
MODIFY your Macros
NAVIGATE comfortably in the Visual Basic Editor
LEARN the essentials of writing Excel VBA code [Read more…]

Lynda – Excel Scenario Planning and Analysis

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

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

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

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

The Complete Excel Master Course – Become an Excel Guru

Understanding ASP.NET Core Security
English | Size: 1.76 GB
Category: Video Training


Learn Real World Examples to Go From Beginner to Excel Guru. Ace the Interview, Build Confidence and get your Dream Job [Read more…]

Excel Data Analysis: Forecasting

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