Automate the formatting of your reports in Excel using Office Scripts in Microsoft 365 and save valuable time. If you are running reports, exporting them to Excel, and then manually formatting them, then watch this video to learn how to use Office Scripts to auto format your reports with the click of a button. Record all the actions you take, like formatting the header row or adding a calculated column of data, and then apply those same formatting updates to your next report with a single click. By automating these boring repetitive tasks, you will gain so much time to spend on more productive tasks!
If you're using the Work version of Microsoft 365, you'll discover the "Automate" tab in Excel. Please note that the availability of the Automate tab may vary based on your organization's settings. If you have access, you can leverage Office Scripts in both the Web and Desktop App versions of Excel 365.
Join me to walk through a realworld scenario. Imagine running a regular HRIS report and exporting it to Excel. Typically, the exported data lacks the desired formatting and additional columns. We'll transform this raw data into a polished, structured report with ease.
I'll demonstrate how to record an Office Script to automate the entire process. Once your script is ready, you'll only need to execute it on new reports. With a single button click, your formatting, header styles, currency conversion, and additional columns will be applied seamlessly.
Unlock the potential of Office Scripts and revolutionize your HR reporting experience. Start saving time, minimizing errors, and elevating your data management game today!
TIMESTAMPS ⏰
00:00 Automate Reports in Excel with Office Scripts
00:12 Automate Tab in Excel 365
00:45 How to Record an Office Script in Excel 365
02:30 How to Save an Office Script in Excel 365
03:20 How to Run an Office Script in Excel 365
COURSE
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: • Creating Fillable Forms in Microsoft ...
WATCH NEXT Create an Inventory List in Excel: • Create and Track a Basic Inventory Li...
CHANNEL LINK
/ @sharonsmith
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!
TEMPLATES
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel!
FREE DOWNLOADS ⬇
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to signup for my email list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
CONNECT WITH ME
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
Instagram: / sharonsmithlearning
Facebook: / sharonsmithlearning
GEAR ⚙
Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
Green Screen: https://amzn.to/2DnHsY2
Camera: https://amzn.to/39KvpQA
Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏ JotForm: https://www.jotform.com/pricing/?utm_...
TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSm...
Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
SUPPORT THIS CHANNEL
Hit the "$Thanks" button on any video, or
Donate through my PayPal link: https://www.paypal.com/cgibin/webscr...
If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤
PLAYLISTS
➤ Excel Tutorials: • Microsoft Excel Tutorials
➤ Excel Tips & Tricks: • Excel Tips & Tricks