VBA

Power Apps

How to use Office Scripts in Excel & Power Automate

In this step-by-step tutorial, Kevin Stratvert shows you how you can use Office Scripts in Excel on the web to automate repetitive and mundane tasks. Additionally, learn how you can trigger you scripts automatically using Power Automate. With Power Automate, you can set a Teams message, an email, or other app to trigger your script.

Read More
Developer

Excel VBA Beginner Tutorial

Learnit Training provides this Excel VBA Beginner Tutorial for those looking to boost their Excel skills. Sure, it’s not Spark or Python, but not everything needs to be. Exercise files: https://bit.ly/2OGV7eu Content: Introduction 0:03 What is VBA? 1:44 Object Oriented Programming Languages 5:59 Turning on the Developer Tab 10:17 The Macro Recorder 13:40 Using Relative […]

Read More
Interesting Microsoft

How to Create Barcodes in Excel

Leila Gharani shows us how to create UPC-A barcodes in Excel. The solution is a good mix of Excel formulas such as the MOD function, Excel Text functions like LEFT, RIGHT & MID functions as well as Conditional formatting and some Excel VBA.

Read More