📊 Automate Reports in Excel using Office Scripts | Step-by-Step Tutorial | Tech Jugaad 4U | #ExcelAutomation #OfficeScripts #ExcelTips #PowerAutomate #Microsoft365 #AutomateExcel #ProductivityTools Tired of doing the same Excel reports over and over again? Discover how to automate your Excel reports using Office Scripts in this easy-to-follow tutorial!
In this video, you'll learn: ✅ What Office Scripts are and how they work ✅ How to create and edit your first script ✅ Automate tasks like data formatting, report generation, and email delivery ✅ Schedule scripts to run automatically using Power Automate
🔧 No advanced coding skills required – just some Excel basics and a little curiosity! 🔔 Subscribe for more Excel automation tips and tricks!
00:00Hello friends, in today's video we will learn how you can automate the formatting of your reports in Microsoft Excel with the help of Office Script
00:12Because this will save you a lot of time, so let's get started
00:18As soon as you open Excel, you will see a tab named automate here.
00:25If you don't see the automate tab, your IT admin may have disabled it
00:34But if you see the Automate tab, it means you can create an Office Script
00:42and you can run it
00:44We will use this to format this report.
00:49We will do this work once and then next time the same work will be done automatically with just one click
00:57Now we will click on automate
01:01Here we have a report and we will change some formatting in this report
01:08So we will record every step here.
01:11When we click on record action, a panel will open which will record our every step.
01:21First of all we will select all the columns and set the width by double clicking
01:28Here you can see that whatever action we are taking is being recorded here.
01:36Now we will select the adder row and go to the home tab and make the text bold, center and color it
01:46Now we have this sales column, we will change its format so that it looks like currency
01:59For this we will go to the home tab, click here and select rupees English, now we will insert a new column
02:09Let's write the rate here and to find the rate, we will write the formula here.
02:17And we will drag it and apply it on all sales.
02:21As you can see, every step is being recorded here. Now our work is complete. We will stop it by clicking here.
02:36Now all our steps are saved as a new office script. We will click on edit to change its name.
02:50We will name it, format the report and interface it. You can also see its script here. Every step is commented here.
03:04This means that you do not need to know the script language, it will be recorded here itself.
03:10Now we will text it, without making any changes we will use it on new data
03:20Now we will open a new sheet here with the same columns and the same data that we used earlier and then we will apply the same format on it with just one click
03:33So here we will click on run or go to the automate tab and select the script that we had saved
03:42So as soon as we clicked on run and see, all our steps got applied in just one click
03:50The column motor got fitted, the adder style got changed, all the sales data came in currency style
03:57And the rates also came out, meaning just one button did all our work.
04:03This was the way to create an office script that can reduce your workload in just one click.
04:12If you liked this video, please like and share it with your friends
04:20Subscribe to the channel and click on the bell icon to get notification when a new video is uploaded
