Leila Gharani teaches us to pull live stock data in Excel with Stock data types.

With Excel’s stock data feature you can get live stock information. Stock data types allows users to quickly pull stock information into Excel from various exchanges.

In this tutorial I’ll show you how you can pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin into your spreadsheet. This way you can easily calculate your portfolio value directly from within Excel. You’ll learn to build your very own stock portfolio in Excel. We’ll use Excel tables together with conditional formatting.
With stock data types you can retrieve stock prices, stock volume, 52 week high, 52 week low, shares and a lot more. If the stock data type is showing you an incorrect stock or the wrong exchange, you can easily change it. I’ll show you how to in the video.

Microsoft Mechanics shows us how to make automation more accessible so you can focus on what’s important.

From code-free automation to your everyday processes in Microsoft teams, the new Power Automate Desktops Robotic Process Automation (RPA) capabilities expands UI automation across a broader spectrum of legacy apps and your favorite web browsers.

Automation is no longer only referring to IT automation. As more of what we do every day is digital, automation can apply to almost any process or task. Whether it’s an approval process across the stakeholders, or data entry between different apps, there’s nothing stopping you from automating many of the things that you do every single day. With Power Automate, part of the Microsoft Power platform, you can do digital process automation for any task or business process.

Index:

  • 00:00 – Introduction
  • 03:00 – Demo RPA for Legacy App
  • 05:08 – New Power Automate Desktop
  • 08:39 – How to test the automation
  • 10:02 – Automation in a web app in browsers
  • 12:23 – How to track what’s been automated
  • 12:58 – Closing notes

Links:

Chris Seferlis introduce us to the newly added Apache Spark Pools in Azure Synapse Analytics for Big Data, Machine Learning, and Data Processing needs.

From the description:

I give an overview of what Spark is, and where it came from; why the Synapse Team added it to the suite of offering, and some sample workloads why you might use it.In this video I introduce the newly added Apache Spark Pools in Azure Synapse Analytics for Big Data, Machine Learning, and Data Processing needs. I give an overview of what Spark is, and where it came from; why the Synapse Team added it to the suite of offering, and some sample workloads why you might use it.