RedCloud Consulting
  • What We Do
    • Business Solutions & Intelligence
    • Delivery Excellence
    • Marketing & Sales
    • Privacy & Security
    • Strategy & Transformation
  • WHO WE ARE
    • MEET THE TEAM
  • CAREERS
  • COMMUNITY
  • HIGHLIGHTS
    • BLOG
    • CASE STUDIES
  • CONTACT
  • Sustainability

Microsoft 365 Conference | Day 3 Highlights

5/10/2023

 
Picture

Office Scripts in Excel and more

The final breakout session of the weekend for us was on Office Scripts in Excel. This is a relatively new feature that helps automate tasks, both inside Excel, but also outside of the context of an Excel file. In our opinion, these Scripts are an underutilized capability.  ​
These Scripts are like VBA scripts in many ways but do have differences. As noted by the speaker, they are not yet on parr with the capabilities of VBA but are tracking to reach parity in the near future. Where they really shine is in integration with Power Automate. A common example would be formatting an Excel based report that is generated every week. The Automation detects when the report was received via email, saved to the proper SharePoint folder, and then runs the Office Script to properly format, filter data, and even generate pivot tables and charts. 
​

There were a couple of other exciting improvements. First was the general release of Power Automate buttons within Excel. This will run very similarly to the instant flow triggers that can be found on a SharePoint list. We think this will be useful, but once again, it will temp everyone to create Excel files that really should be replaced with a Power App. 

Another exciting one is a new Power Automate Excel automated trigger. This trigger would be activated when a particular range in an Excel file is modified! It will use a named range, and there are some things to still be figured out by the engineering team. Powerful? Yes! Tempting to turn Excel into an app again? Yes!
 ​
Picture

Closing Keynote

The Conference closed out with a fitting keynote that provided tangible advice on change management, adoption, and engagement. Dan Holme, the Microsoft product leader for Viva Engage, led the keynote with grounded advice that unified best practices that any business could benefit from, with the Viva platform. ​
Picture
Before the conference we were not as excited or informed about Viva as we are now. Yes, it is a newer service that is still maturing, but it is clear that internal company communications, community, and culture can be cultivated with its help. We’d encourage you start exploring Viva one module at a time so you don’t get overwhelmed. For example, start with Viva Connections or Viva Engage. Get to know it and share with others what you think is actually helpful. 
Other links we think you’d find helpful 
  • Microsoft Adoption Learning 
  • M365 Champions 
  • Community Days 
 

Comments are closed.

    Categories

    All
    10 Min Spotlight
    A Day In The Life
    BI & Automation
    Community
    Employee Kudos
    Latest News
    Lunch & Learn
    Meet The Team
    Privacy & Security
    Sustainability
    Welcome To The Team

    Archives

    September 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    December 2019
    August 2019
    June 2019
    August 2018
    February 2018
    August 2017

    RSS Feed

Button to glassdoor page
Main Office:   425-305-4121​        |         info@redcloudconsulting.com
©2020 RedCloud Consulting, Inc.  |   All Rights Reserved.  |  Privacy Policy  |  Terms of Use 
  • What We Do
    • Business Solutions & Intelligence
    • Delivery Excellence
    • Marketing & Sales
    • Privacy & Security
    • Strategy & Transformation
  • WHO WE ARE
    • MEET THE TEAM
  • CAREERS
  • COMMUNITY
  • HIGHLIGHTS
    • BLOG
    • CASE STUDIES
  • CONTACT
  • Sustainability