Excel for Corporate Finance Professionals | Michael McDonald | LYNDA

Excel for Corporate Finance Professionals | Michael McDonald | LYNDA
English | Size: 308.70 MB
Category: Tutorial

Discover how to use Microsoft Excel for the bread-and-butter tasks required by corporate finance and financial planning and analysis (FP&A) professionals. In this hands-on course, professor Michael McDonald steps through how to leverage this powerful tool to pick corporate investments, determine your firm’s cost of capital, and perform operational budgeting. Michael steps through how to estimate weighted average cost of capital (WACC), build a budget, perform stress testing and scenario analysis, and more. Throughout the course, Michael includes exercises-together with downloadable exercise files-that can provide you with a practical understanding of these key topics. [Read more…]

Excel Business Intelligence Part 3: Power Pivot and DAX | Chris Dutton | LYNDA

Excel Business Intelligence Part 3: Power Pivot and DAX | Chris Dutton | LYNDA
English | Size: 763.99 MB
Category: Tutorial

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course-the third and final installment of the Excel Business Intelligence series-experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models. Chris picks up where he left off in the previous installment of the series, demonstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.
[Read more…]

Excel: Tracking Data Easily and Efficiently | Oz du Soleil | LYNDA

Excel: Tracking Data Easily and Efficiently | Oz du Soleil | LYNDA
English | Size: 160.85 MB
Category: Tutorial

Learn how to build a super-charged Excel spreadsheet to help you and your team easily track any kind of data-sales transactions, inventory levels, project statuses, employee paid time off, student progress, household spending, and more. Follow along with Excel MVP Oz du Soleil as he shows how to create a basic spreadsheet and transform it into an effective tracking system for any kind of data that is regularly updated. Learn spreadsheet basics, as well as more advanced techniques such as writing formulas that check that information is complete, protecting and hiding sheets, and creating alerts for deadlines and bad data. Oz wraps up with a challenge that pulls together everything you’ve learned into a polished final project. [Read more…]

Access 2016: Building Dashboards for Excel | Robin Hunt | LYNDA

Access 2016: Building Dashboards for Excel | Robin Hunt | LYNDA
English | Size: 352.62 MB
Category: CBTs

Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor Robin Hunt shows how to analyze, query, and export Access data for use in Excel, and connect directly to Access from Excel, so that you always have a live view of your data. Then learn how to build dashboards with slicers, timelines, and charts, and create macros that make your dashboards more user friendly. By the end of the course, you should be able to extend your current reporting capabilities and create more engaging visualizations. [Read more…]

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