LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

LINKEDIN LEARNING CERT PREP EXCEL 2016 MICROSOFT OFFICE EXPERT 77 728 UPDATE 20190131

Leave a Comment

LINKEDIN LEARNING CERT PREP EXCEL 2016 MICROSOFT OFFICE EXPERT 77 728 UPDATE 20190131
English | Size: 638.74 MB
Category: Tutorial


Demonstrate your advanced knowledge of Microsoft Excel by becoming a Microsoft Office Specialist (MOS). This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Microsoft Office Specialist (MOS) exam for Excel 2016, which focuses on creating and managing worksheets and workbooks, managing data cells and ranges, creating tables, performing operations with formulas and functions, and creating charts and objects.
[Read more…]

Excel – Beginners to Advance and Data Analytics

Leave a Comment

Excel – Beginners to Advance and Data Analytics
English | Size: 3.20 GB
Category: Tutorial


What Will I Learn?
Introduction to worksheets, workbooks, and toolbar: Learn the basics of Excel and how to navigate a spreadsheet.
Cells, Ranges, Tables, Worksheet operations: Navigate the spreadsheet and begin to change the way cells, ranges, and tables look and function.
Formatting cells and conditional formatting: Easily set rules and conditions for cells within the worksheet, so you stay organized.
Formulas and Functions: Learn how to calculate complicated equations the easy way.
Charts: Give your data a visual representation that is easier to understand and useful.
Data Protection and Validation: Keep others from changing the cells in your worksheet through data protection and validation. [Read more…]

Excel for Corporate Finance Professionals | Michael McDonald | LYNDA

Leave a Comment

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

Leave a Comment

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

Leave a Comment

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

Leave a Comment

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

Leave a Comment

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

Leave a Comment

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

Leave a Comment

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

Leave a Comment

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