Automate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports

[@LJC320]

I spend a huge amount of time setting up finance reports from CDM+ and now because of this video, I will automate this process. You are Amazing, Sharon!!!

[@SharonSmith]

That is awesome! Good luck with your reports! I'm so glad you found my videos helpful. Thanks for watching!

[@eremas]

How to make Purchase Order and automatically generate invoice and subtract products from inventory.

[@teerockwell3449]

what's the advantage of this over macro ?

[@whitefox8291]

I'm wondering too

[@whitefox8291]

You're so beautiful 😍. Thanks for the content

[@SharonSmith]

Too kind! Thanks for watching!

[@piyaomietimi7992]

This is so helpful. Please how can I get the sample excel sheet so I can practice?

[@waleedal-kahef3555]

Hello, why would an ORG block such useful feature?

[@SharonSmith]

Hello! There might be security concerns since Office Scripts can execute code, or it can complicate version control and collaboration in shared documents. But hopefully you can access it since it is a great feature. Thanks for watching my videos!

[@janakachathuranga9780]

Is it available on 2021 version 😮

[@SharonSmith]

Microsoft made Office Scripts generally available for Excel on the Web app version in 2021. If you have an eligible license, you’ll find the Office Scripts feature-set in the Automate tab in the ribbon. Please note that if you do not have the Automate tab in Excel for the web, your admin may have disabled the feature. I hope this helps! Thanks for watching!

[@Dexter101x]

I don't see the automate tab either on 365 or online

[@SharonSmith]

Hello, if you have a Work or Enterprise subscription to 365 then you should be able to go to: File - Options - Customize Ribbon and then on the Main Tabs, scroll down and check "Automate" and then click OK to display the Automate tab. If you don't see it, then your organization may not allow it to be enabled. Hope this helps! Thanks for watching!

[@Dexter101x]

@@SharonSmith OK, I guess I don't have that

[@waleedal-kahef3555]

why would an org block such useful feature?

[@SharonSmith]

If you have Microsoft 365 (or Excel 2016 for Windows or later versions) then you can access Power Query to automate your data formatting tasks. Very similarly to Office Scripts, the Power Query editor will record the steps you take to "Transform" your data and then apply that to your sheets. Here is an easy Power Query tutorial so you can see how to do that: kzbin.info/www/bejne/jafchqeEq6xgfpo Hope this helps!!

[@SharonSmith]

If you have Microsoft 365 (or Excel 2016 for Windows or later versions) then you can access Power Query to automate your data formatting tasks. Very similarly to Office Scripts, the Power Query editor will record the steps you take to "Transform" your data and then apply that to your sheets. Here is an easy Power Query tutorial so you can see how to do that: kzbin.info/www/bejne/jafchqeEq6xgfpo Hope this helps!!