Scripts

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

Apress – PowerShell Core for SQL Server – Automating Your Transact-SQL Scripts

Apress – PowerShell Core for SQL Server – Automating Your Transact-SQL Scripts
English | Size: 549.17 MB
Category: Programming


Get up and running with accessing SQL Server from PowerShell Core. By the end of this video you’ll have learned how to issue Transact-SQL statements and get results back, how to insert, modify, and delete data in the database, and how to import and export data to and from SQL Server. You’ll be equipped to automate database administration and other maintenance tasks through using PowerShell to automate the execution of Transact-SQL scripts that are stored in files that you can easily edit to keep up with changing business needs.

PluralSight – Automating Node Js With Npm Scripts

PluralSight – Automating Node Js With Npm Scripts-JGTiSO
English | Size: 378.83 MB
Category: Tutorial

What if you could greatly improve your efficiency as a developer? This course will teach you how to use automation to optimize your time and reduce manually executed, repetitive tasks. You will see NPM is the tool for this when building Node.js apps.