LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Linkedin Learning – Excel Productivity Tips-ZH

Leave a Comment

Linkedin Learning – Excel Productivity Tips-ZH
English | Size: 267.16 MB
Category: Tutorial

Supercharge your productivity, work more efficiently, and become an Excel power user by mastering the same tools and techniques used by the pros. In this course, analytics expert and instructor Chris Dutton guides you through demos and case studies designed to help you add powerful productivity tools to your Excel skill set Learn how to navigate worksheets with keyboard shortcuts, remove blank rows quickly, apply fill patterns, protect cells and formulas, apply advanced sorting and filtering tools, and more Follow along from home with downloadable PDF cheat sheets practice workbooks, and solution files. [Read more…]

Skillshare – Intermediate Excel for the Real World Cleaning Data for Analysis and Forecasting

Leave a Comment

Skillshare – Intermediate Excel for the Real World Cleaning Data for Analysis and Forecasting-ViGOROUS
English | Size: 752.62 MB
Category: Tutorial

Follow along with me as I show you some of the most common techniques and tips I use for cleaning up a data set in Excel before doing analysis and forecasting. In order to clean up and summarize data, I’ll show you some intermediate formulas like IFERROR, COUNTIF, and nesting formulas together. You’ll also learn some forecasting techniques using basic regression in Excel. Most of the skills in this class apply to Google Sheets as well. [Read more…]