Excel

Lynda – Excel Supply Chain Analysis Solving Transportation Problems

Lynda – Excel Supply Chain Analysis Solving Transportation Problems Bookware-KNiSO
English | Size: 327.91 MB
Category: Tutorial


Learn how to use Microsoft Excel to conceptualize, set up, and solve transportation problems in order to minimize costs in a supply chain

PluralSight – Building Excel Online Automation with Office Scripts

PluralSight – Building Excel Online Automation with Office Scripts Bookware-KNiSO
English | Size: 210.64 MB
Category: Tutorial


With more of Excel functionality going online, Excel automation will migrate from VBA into new Office Scripts. In this course, Building Excel Online Automation with Office Scripts you ll learn to create your own macros using the Office Scripts tool in Excel Online. First, you ll explore what makes Office Scripts different than other frameworks. Next you ll discover how to record a macro using Office Scripts Finally, you ll learn how to customize and write your own macros using Office Scripts. When you re finished with this course, you ll have the skills and knowledge of Office Scripts in Excel needed to automate Excel Online spreadsheets

Linkedin Learning – Excel Productivity Tips-ZH

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.

Cybrary – Intermediate Excel

Intermediate Excel | Cybrary
English | Size: 2.17 GB
Category: Tutorial


This course provides intermediary knowledge of Excel and teaches advanced calculations in Excel, creating macros, and data analysis on various data sets.