LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Technics Publications – 77-727 Microsoft Excel Core Data Analysis Manipulation and Presentation Certification Exam Crash Course-ZH

Leave a Comment

Technics Publications – 77-727 Microsoft Excel Core Data Analysis Manipulation and Presentation Certification Exam Crash Course-ZH
English | Size: 377.97 MB
Category: Tutorial


Apply the basics of Microsoft Excel data analysis, manipulation, and presentation, create workbooks and worksheets, manage data cells and ranges, design tables, use formulas and functions, and generate charts. Become prepared to take the 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification Exam. These six topics will be covered: [Read more…]

O’Reilly Python-Powered Excel-ZH

Leave a Comment

O’Reilly Python-Powered Excel-ZH
English | Size: 385.71 MB
Category: Tutorial


Excel is ubiquitous in the business world, and whether we admit it or not, we all have spreadsheets that are “critical” to the organization. When it comes to analyzing and reporting on data, it’s the tool of choice for a majority of business and data professionals. We use it for a range of projects–from personal budgets to mini-databases to complex data analysis tools.
[Read more…]

Linkedin – Learning Using Python with Excel

Leave a Comment

Linkedin – Learning Using Python with Excel-ZH
English | Size: 180.39 MB
Category: Tutorial


Python is the world’s fastest growing programming language. It’s a powerful tool that is helping to streamline development and data science. In this course from Madecraft, you can learn how to combine the power of the Python language with the data analysis and reporting tools in Microsoft Excel. Discover how to leverage the pandas and openpyxl libraries to inspect, filter clean, and convert data and how to build solid reports that help businesses take action. Discover how to work with large amounts of data that would be unmanageable in Excel alone. By the end of this course, viewers will learn how this combination of tools can lead businesses to better insights than ever before [Read more…]

Pluralsight – Summarizing and Organizing Data in Excel

Leave a Comment

Pluralsight – Summarizing and Organizing Data in Excel-XQZT
English | Size: 203.57 MB
Category: Tutorial


A practical and pragmatic course exploring the features of Excel that allow you to organize, summarize, analyze, and visualize large amounts of data. Quickly learn how to turn data into insightful and powerful tables and charts.
[Read more…]

Packt – Excel VBA Programming the Complete Guide

Leave a Comment

Packt – Excel VBA Programming the Complete Guide-JGTiSO
English | Size: 16.78 GB
Category: Tutorial


Learn
Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
Utilize objects in the Excel Object Model to emulate user actions in Excel
React dynamically to user events such as entering a cell value or opening a workbook
Get comfortable with the fundamentals of computer programming [Read more…]

Packt – Essential VBA Training for Excel

Leave a Comment

Packt – Essential VBA Training for Excel-JGTiSO
English | Size: 739.74 MB
Category: Tutorial


Learn
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code.
How to use intellitext with variables, particularly those that are defined constants.
What functions are, how they are used, and how to stage a scenario to complete.
How functions return values.
How to define inputs for functions.
How to use input boxes and message boxes to interact with the user.
The intricacies surrounding creating an array formula.
How to use the application object to control the user experience.
How to use errors to improve your code.
How to use the name and names object to manage named ranges.
General information about the PivotTable object and basic approaches to utilizing it. [Read more…]

Linkedin – Learning Cert Prep Excel Associate Microsoft Office Specialist for Office 2019 and Office 365

Leave a Comment

Linkedin – Learning Cert Prep Excel Associate Microsoft Office Specialist for Office 2019 and Office 365-BiFiSO
English | Size: 642.63 MB
Category: Tutorial


Demonstrate your knowledge of Excel 2019 by becoming a Microsoft Office Specialist (MOS). Get training to prepare for the Excel Associate certification exams for Office 365 and Office 2019. This course, created by Microsoft Certified Instructor and MOS Master Jennifer McBee, helps you prepare for the five main areas of focus for the Excel Associate Office 365 and Office 2019 exams: managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, performing operations with formulas and functions, and managing charts. The course includes an overview of the MOS certification program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.
Topics include: [Read more…]

SkillShare – Easy Excel Basics for Beginners – Get Started with Excel

Leave a Comment

SkillShare – Easy Excel Basics for Beginners – Get Started with Excel
English | Size: 108.83 MB
Category: Tutorial


About This Class
Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016.

Learn the basics of Excel quickly and easily.

This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying.
[Read more…]