Microsoft Excel can now do the job for you, yes, really

Microsoft Excel can now do the job for you, yes, really
Microsoft Excel just got an update that could streamline your workday by letting you automate repetitive tasks, without the need for VBA macros. Office Scripts are a new way for users to record their actions in an Excel workbook (such as turning a newly imported spreadsheet into a presentation for daily meetings) and save it as a script to use later or share with others. This scheduled spreadsheet software feature is now available to anyone with a retail or education version of Microsoft 365, as it was announced in November 2019. You can find the Office Scripts feature under the Automate tab on the taskbar / top ribbon. In its blog post about the new update, Microsoft says: "As an example, let's say you start your workday by opening a .csv file from an accounting site in Excel. You then spend several minutes removing unnecessary columns, formatting a table, adding formulas and creating a pivot table in a new worksheet Actions you repeat daily can be logged once with logger actions From there running the script will handle all the .csv conversion No Not only will you eliminate the risk of forgetting steps, but you'll be able to share your process with others without having to teach them anything."

Make life easier

You can even set a specific time to run a script on a schedule using Power Automate, formerly known as Microsoft Flow, which allows you to trigger a set of actions to react to a specific event, even outside of it, other apps and services. This can also be set to simply respond to a timer to create hourly reports or sort ongoing downloads. Microsoft has provided a list of sample scripts and scenarios that you can use right out of the box, along with how-to video tutorials to guide you through creating your own. Essentially, if part of your job is performing the same daily tasks, it will be a godsend, saving you time for other, less mundane tasks by allowing you to go about your regular daily process at the touch of a button. You can read more about this new feature on the Developer Update page, including how to fix problems you may encounter when trying to use Office scripts or Power Automate. Today's Best Microsoft Office 365 Deals Via MSPowerUser