Author: Annie D

Custom web app development is becoming achievable for everyone!

Posted on by Annie D

***** Video Details *****
I’ve been exploring some new tools recently, and I wanted to share my new web application workflow.

These tools are incredibly new—some are less than three months old—and they’re enabling transformations I’ve never seen before.

I believe we’re witnessing a massive democratization of app development that’s going to change everything.

The amount of software being created worldwide is about to go exponential.

Now is the best time to learn how to build applications and create automations.

I’ve been using a tool called Lovable (formerly GPT Engineer) to build front-end applications very quickly.

It writes all the code for you, and you can see Continue reading “Custom web app development is becoming achievable for everyone!” →

Excel Assign Thanksgiving Dinner Sides Using Excel – Episode 2662

Posted on by Annie D

Microsoft Excel Tutorial: Randomly Assign Sides for Thanksgiving Dinner

In today’s tutorial, we’re tackling a fun holiday challenge: assigning dinner sides for Thanksgiving using Excel! Whether you’re hosting a big feast or coordinating a potluck, Excel makes it easy to assign dishes randomly and fairly. In this video, I’ll walk you through the process step by step, using Excel’s powerful SORTBY and RANDARRAY functions.

Have you ever used a spreadsheet to manage your holiday meals? Let me know in the comments! My friend Katie from my morning workout group inspired this video—she needed a way to assign sides for her Continue reading “Excel Assign Thanksgiving Dinner Sides Using Excel – Episode 2662” →

MS 365 Excel Basics #4: Date & Time Formulas, Functions & Formatting: Everything You Need to Know!!

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics04.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics04.pdf
In this video learn about
Topics:
1. (00:00) Introduction
2. (00:38) How Dates work in Excel (Date Serial Numbers, Date Number Format and Date Formulas)
3. (07:57) Formulas to calculate number of days between two dates, for invoices, loans and projects
4. (10:00) Formulas to count workdays with NETWORKDAYS.INTL function
5. (12:00) Series dialog box to create list of dates
6. (14:40) Add days to date to get future date. Learn about WORKDAY.INTL to find future or past date based on workdays only. Examples such as calculating loan due dates..
7. (16:22) Subtract Continue reading “MS 365 Excel Basics #4: Date & Time Formulas, Functions & Formatting: Everything You Need to Know!!” →

New productivity workflow for learning anything new! Real time voice

Posted on by Annie D

***** Video Details *****
In this video, I share essential tips and strategies for debugging and managing small issues when building a new web app. From planning thoroughly to leveraging AI tools like lovable.dev, I discuss how to streamline your development process, handle project evolution, and focus on high-level product creation through natural language prompting. Whether you’re a seasoned developer or just starting out, these insights can help make your web development journey smoother and more efficient.

Timestamps:
0:00 Introduction to Debugging in Web Development
0:18 Managing Small Issues and Seeking Better Approaches
0:33 Tips for Strategic Debugging
1:01 Strategically Managing Development Processes
1:19 Using Natural Language Continue reading “New productivity workflow for learning anything new! Real time voice” →

MS 365 Excel Basics #3: Number Formatting as Façade & when you MUST use ROUND Function

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.pdf
In this video learn about how to not be tricked by Number Formatting, and how to use the ROUND function rather than number formatting to calculate accurate payroll, invoicing and income tax calculations. Lean about difference between Currency and Accounting Number Formatting.
Topics:
1. (00:00) Introduction
2. (01:04) What does Number Formatting do?
3. (02:38) Formulas do not see Number Formatting
4. (04:10) Keyboard to apply General Number Formatting (Eraser): Ctrl + Shift + ~ / `
5. (04:40) Number Formatting can save time entering data.
6. (07:40) Currency and Accounting Number Formatting
7. Continue reading “MS 365 Excel Basics #3: Number Formatting as Façade & when you MUST use ROUND Function” →

Excel Which Products Contain Both Of These Items – Episode 2661

Posted on by Annie D

Microsoft Excel Tutorial: Which Products Contain Both Of These Items?

Today, an odd data problem. I have a solution, but I suspect there are much easier ways to do this. I have a list of songs in workouts from Supernatural VR. Over 500 workouts are Quick Hits with just two songs. Each Quick Hits workout should be a subset of a longer workout. Given the two lists, how can you use Excel to find the parent workout?

My solution involves an XLOOKUP with a concatenated key and a concatenated lookup vector. This gives me a list of the Workout IDs that contain Continue reading “Excel Which Products Contain Both Of These Items – Episode 2661” →

MS 365 Excel Basics #2: Add & Count Formulas with COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS & IF

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelBasics02.xlsx
pdf notes: https://excelisfun.net/files/ExcelBasics02.pdf
In this video learn every trick there is for Excel formula counting and adding with 10 different Excel Built-in Functions, including how to add and count with a single condition, two or more conditions, an AND Logical Test, and even the elusive OR Logical Test. See many use business examples.
This video is taught by Mike “excelisfun” Girvin, Highline College Profession since 2002 years and excelisfun YouTuber since 2008. This video is #2 in a class of 10 free videos and Excel files! This is a free YouTube class that Continue reading “MS 365 Excel Basics #2: Add & Count Formulas with COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS & IF” →

Edit your Direct Lake models directly in Power BI Desktop!

Posted on by Annie D

Creating Power BI Direct Lake models? You can now edit your Direct Lake semantic models right in Power BI Desktop! Patrick walks you through how!

Live edit of Direct Lake models in Power BI Desktop
https://powerbi.microsoft.com/en-us/blog/live-edit-of-direct-lake-models-in-power-bi-desktop/

Direct Lake in Power BI Desktop (preview)
https://learn.microsoft.com/fabric/get-started/direct-lake-power-bi-desktop

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #DirectLake #GuyInACube

REPLAY Microsoft Fabric / Power BI Q&A w/ Kasper de Jonge (April 27, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric & Power BI! With special guest, Kasper de Jonge!

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

Connect with Kasper:
Website: https://www.kasperonbi.com/
YouTube: https://www.youtube.com/@KasperOnBI
Twitter: https://twitter.com/kjonge

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

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

Want to take your Power BI skills to the next level? We have Continue reading “REPLAY Microsoft Fabric / Power BI Q&A w/ Kasper de Jonge (April 27, 2024)” →

REPLAY Let’s talk Microsoft Fabric – LIVE w/ Josh Caplan (May 11, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

Connect with Josh:
Twitter: https://twitter.com/JoshCaplan1984
LinkedIn: <a href="https://www.linkedin.com/in/josh-caplan-2139a3a6/" Continue reading “REPLAY Let’s talk Microsoft Fabric – LIVE w/ Josh Caplan (May 11, 2024)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (May 18, 2024)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

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

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

Want Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (May 18, 2024)” →

MS 365 Excel Basics #1 What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelBasics01.xlsx
pdf notes: https://excelisfun.net/files/ExcelBasics01.pdf
In this video learn about the different types of formulas and functions in MS 365 Excel, as well as how to so style and number formatting. Learn about all the shortcuts that will allow you to create an Excel solution with lightening speed and accuracy.
In this video get a complete introduction to Excel basics taught by Mike “excelisfun” Girvin, Highline College Profession since 2002 years and excelisfun YouTuber since 2008. This is video is first in a class of 10 free videos and Excel files!
This is a free YouTube Continue reading “MS 365 Excel Basics #1 What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup” →