Excel Online Archives - Xelplus - Leila Gharani

How to Use Office Scripts with Power Automate

Leila Gharani — Thu, 12 Aug 2021 08:00:00 +0000

Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

The post How to Use Office Scripts with Power Automate appeared first on Xelplus - Leila Gharani.

Introduction to Office Scripts

Leila Gharani — Fri, 28 May 2021 11:09:00 +0000

This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

The post Introduction to Office Scripts appeared first on Xelplus - Leila Gharani.

What’s the Difference Between Excel VBA and Office Scripts

Leila Gharani — Mon, 24 May 2021 11:19:00 +0000

What's the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

The post What’s the Difference Between Excel VBA and Office Scripts appeared first on Xelplus - Leila Gharani.

How to Show Changes Made to Your File in Excel

Leila Gharani — Thu, 06 May 2021 10:48:00 +0000

Excel Show Changes Feature lets you know who changed your data and formulas. You'll see the previous value below the current value. With Version History you can easily revert back to a previous version of your file.

The post How to Show Changes Made to Your File in Excel appeared first on Xelplus - Leila Gharani.

How to Use Power Automate in Excel to Get More Done

Leila Gharani — Thu, 18 Mar 2021 10:00:00 +0000

Learn to combine Microsoft Excel with Power Automate and get more done! We'll look at two practical examples: Record your working hours in Excel by clicking a button on your phone - AND - Post on LinkedIn from the comfort of your Excel file.

The post How to Use Power Automate in Excel to Get More Done appeared first on Xelplus - Leila Gharani.

How to Use Microsoft Forms

Leila Gharani — Thu, 22 Oct 2020 09:00:00 +0000

With Microsoft Forms you can easily create surveys & quizzes to share with others. You can export the Microsoft Form results to Excel (You can also create an automatic connection between Forms and Excel online). Check out the complete tutorial to find out more.

The post How to Use Microsoft Forms appeared first on Xelplus - Leila Gharani.