Blog

Excel Find Active Cell With New Focus Cell (in Beta Now)

Posted on October 3, 2024 by Annie D

In this Microsoft Excel tutorial, learn how to add a crosshair to locate the active cell with the new Focus Cell feature, now in beta! As our eyes age and screen resolutions increase, it can be tough to spot the active cell. But with the Focus Cell feature, Excel highlights the entire row and column of the active cell, making it much easier to find.

In this video, I’ll walk you through how to enable the Focus Cell setting, which is located on the View tab (next to View Gridlines). You can choose from eight different colors, and the crosshair appears Continue reading “Excel Find Active Cell With New Focus Cell (in Beta Now)” →

Excel – Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs – Episode 2657

Posted on October 3, 2024 by Annie D

Microsoft Excel Tutorial: Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs

In this video, I’m excited to show you a demo I saw from Microsoft that’s seriously cool! We’re diving into how to use the new Python integration with Excel Copilot to create an NBA basketball shot chart. With data sensors installed in every NBA arena since 2013, we now have detailed info on every shot, including the exact X and Y coordinates and whether the shot was made or missed. This data opens up a whole new world of possibilities for sports analytics Continue reading “Excel – Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs – Episode 2657” →

Mock up new web apps and automations fast – here’s how to do it.

Posted on October 3, 2024 by Annie D

In this video, I walk through how easy it is to create web apps using GitHub and AI tools, focusing on how these technologies have democratized app development, even for beginners like myself. I highlight how platforms like Replit and Streamlit, along with open-source projects, can supercharge the web app development process, making it faster and more accessible.

You’ll see how I quickly set up repositories on GitHub, find code templates or cookbooks, and fork them to start building my own web apps. I also explore the power of the Grock API and Replit as tools for rapid development, where I Continue reading “Mock up new web apps and automations fast – here’s how to do it.” →

Selenium in Python – What’s possible?

Posted on October 3, 2024 by Annie D

In this video, I dive into the powerful web automation capabilities of the Selenium library in Python, sharing how it can be integrated with AI tools to efficiently automate tasks. I talk about my personal experiences using Selenium to automate web interactions, such as data input, navigation, and even data acquisition, making it a great tool for anyone looking to streamline repetitive tasks.

You’ll see how Selenium can be used to automate workflows without needing to write a lot of Python code. I demonstrate how it grabs data from spreadsheets, loops through items in a CSV file, and inputs that data Continue reading “Selenium in Python – What’s possible?” →

Accelerating your skills acquisition using AI

Posted on October 3, 2024 by Annie D

In this video, I share my insights on leveraging AI to rapidly acquire new skills, emphasizing the unprecedented learning opportunities available. I discuss the transformative power of AI in learning, the efficiency of short bursts of learning followed by project implementation, and the personalized learning experience AI offers. I recommend integrating AI into skill acquisition processes and highlight the compounding effect it has on productivity and skill development.

You can build (almost) anything using Python and AI – Voice typing app for desktop

Posted on October 3, 2024 by Annie D

In this tutorial we work through how to build a simple AI transcription app so that you can voice type on your computer anywhere in any application.

Highline College Busn 210 Excel Statistical Analysis Fall, 2024 Introduction

Posted on October 3, 2024 by Annie D

For Fall 2024 matriculating students at Highline College in Seattle, Washington. This is the introduction to the Busn 210 Excel Statistical Analysis class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Highline College Busn 218 Advanced Excel Fall, 2024 Introduction

Posted on October 3, 2024 by Annie D

For Fall 2024 matriculating students at Highline College in Seattle, Washington: this is the introduction to the class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866

Posted on October 3, 2024 by Annie D

Download Excel File: https://excelisfun.net/files/EMT1866.xlsx
Buy M Code Book at Mr Excel site: https://www.mrexcel.com/products/the-… or Amazon: https://www.amazon.com/Transformative… Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel. Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

Topics in Video:
1) (00:00) Introduction
2) (00:55) Worksheet function to create column of employee names from a table using TOCOL and UNIQUE functions.
3) (01:30) Worksheet function to lookup manager names and join with a comma between each name using Continue reading “Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866” →

Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables

Posted on October 3, 2024October 3, 2024 by Annie D

Highline College Professional Development Day 2024 presentation by Mike “excelisfun” Girvin
Download Excel file: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.xlsx
Pdf file with video notes: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.pdf
In this video learn how to: Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function, Use Dynamic Spilled Arrays Formulas to Create Budget, Use Power Query to Import Student Grade Data from Canvas, Use PivotTables to Create Summary Reports from Student Survey Data.

Topics:
1. (00:00) Introduction
2. (01:25) Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function.
3. (12:05) Don’t be Tricked by Number Formatting
4. (16:05) BYROW and BYCOL functions to spill aggregate totals and Continue reading “Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables” →

Update Data Sources within Deployment Pipelines

Posted on June 22, 2024 by Annie D

Making use of a Deployment Pipeline within Microsoft Fabric? Not sure how to update data sources for your Power BI semantic model as you move through stages? Adam has you covered!

Get started with deployment pipelines
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines?tabs=from-fabric

Create deployment rules
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/create-rules

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Update Data Sources within Deployment Pipelines” →