Month: February 2023

How To Unhide Multiple Rows In Excel

Posted on by Annie D

can you unhide multiple rows in excel
easy way to unhide multiple rows in excel
excel how do i unhide lines
excel how to unhide collapsed rows
excel how to unhide rows when hidden
how can i unhide rows from excel
how can i unhide rows in excel
how do i get lines to unhide excel
how do i unhide lines in excel
how do i unhide lines in excel spreadsheet
how do i unhide multiple rows in excel at one time
how do i unhide multiple rows in excel spreadsheet
how do i unhide multiple rows on excel
how do i unhide row in excel
how do i unhide rows excel
how do i Continue reading “How To Unhide Multiple Rows In Excel” →

How To Unhide All Rows In Excel

Posted on by Annie D

Short video showing how to unhide all rows in Excel.
excel how to easily unhide all rows
excel how to unhide all columns and rows
excel how to unhide all rows in one
excel how to unhide all the rows
how can i unhide all rows in excel
how can you unhide all rows in excel
how do i unhide all rows in excel?
how do i unhide all rows on excel
how do i unhide row all rows in excel
how do you unhide all excel rows and colums
how to get excel to unhide rows at once
how to quickly unhide all rows in excel
how to unhide al rows in Continue reading “How To Unhide All Rows In Excel” →

Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1819.xlsx
The best Excel formulas are not always what they seem. In this video: learn the best ways to create counting formulas in Excel using COUNTIFS, FILTER and SUM( IF ). Learn both Microsoft 365 Excel formulas and formulas that will work in any version of Excel.
Topics:
1. (00:00) Introduction
2. (00:14) COUNTIFS for counting customers who paid Cash. (Single Condition)
3. (01:07) AND Logical Tests. OR Logical Tests. And what is required in counting formulas.
4. (01:32) COUNTIFS for counting customers who spent less than $50 and paid with PayPal. (AND Test). Learn about two ways to enter Continue reading “Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819” →

Excel Subtotal By ID And Name 2381

Posted on by Annie D

Kara asks: Do you have a trick for the subtotal function?
In a “subtotal by” task where I use three fields (ID / Name / Amount) to get the total amount, Excel makes me choose between ID or Name for “at each change in” but I’d like to retain both so I currently perform data gymnastics to concatenate the ID and Name fields…..and then after using the function, I perform more gymnastics after selecting level 2, “go to special” / visible cells only on the subtotals, paste to another sheet, and then split the ID and name back out Continue reading “Excel Subtotal By ID And Name 2381” →

Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1818.xlsx
Learn about how to create a joint probability table from a cross tabulated frequency distribution, then five tricks for calculating probabilities. Everyone should know this – not just staticticians.
Topics:
1. (00:00) Introduction
2. (00:04) Calculate Joint Probability Table from Cross Tabulated Counts with Excel Formulas.
3. (02:55)Makes probability calculations from a Joint Probability Table.
4. (03:14) Single Conditional Probability
5. (03:27) AND Logical Test Probability (Joint)
6. (03:49) OR Logical Test Probability (Mutually Exclusive)
7. (04:20) OR Logical Test Probability (NOT Mutually Exclusive)
8. (05:02) Conditional Probability
9. (05:40) Closing, Video Links

#excel
#excelisfun
#excelformulas
#excelfunctions
#dynamicarrays
#array #arrayformula
#statistics
#excelsolutions
#joint
#probability
#probabilitytricks Continue reading “Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818” →

Different ways to work with Microsoft Excel in Power BI (2023)

Posted on by Annie D

Using Excel? Of course, you are! How can you take advantage of Power BI? Adam shows you the different ways you can leverage Excel with Power BI to get the most out of it!

📢 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
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Continue reading “Different ways to work with Microsoft Excel in Power BI (2023)” →

Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22

Posted on by Annie D

Session 22: Advanced SQL Skills For Data Analysts

When is it?
February 23rd – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
February 24th – 6am Sydney (AEDT), 8am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Kedeisha Bryan – Co-founder & Community Leader at Data in Motion LLC

During This Free Event, You Will:

• Simplify complex queries, break down complex calculations, or perform recursive queries using Common Table Expressions (CTEs)
• Perform calculations across a set of rows in a query result, without Continue reading “Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22” →

Using Power Automate To Email Power BI Data As A CSV File

Posted on by Annie D

Session 23: Using Power Automate To Email Power BI Data As A CSV File

When is it?
February 23rd – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
February 24th – 8am Sydney (AEDT), 10am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Jarrett Moore – Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to setup and schedule a Power Automate flow using data from your Power BI Reports
• Know how to get DAX Query data from Power BI Desktop without Continue reading “Using Power Automate To Email Power BI Data As A CSV File” →

DAX Is Easy, CALCULATE Makes It Hard | Innovations In Power BI & Power Platform Summit Session 24

Posted on by Annie D

Session 24: DAX Is Easy, CALCULATE Makes It Hard

When is it?
February 23rd – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
February 24th – 9am Sydney (AEDT), 11am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Brian Julius & Greg Deckler (MVP)

During This Free Event, You Will:

• Understand the Challenges of Working with CALCULATE in DAX
• Examples of how to write DAX measures Without using CALCULATE
• Techniques for Visualizing Intermediate Tables in Data Analysis
• Discover methods for automating intermediate table measures Continue reading “DAX Is Easy, CALCULATE Makes It Hard | Innovations In Power BI & Power Platform Summit Session 24” →

ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 25: ChatGPT & The Future Of Learning Data Skills

When is it?
February 23rd – 3pm Los Angeles (PST), 6pm New York (EST), 11pm London (GMT)
February 24th – 10am Sydney (AEDT), 12pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay & Brian Julius

During This Free Event, You Will:

• Learn what we think about ChatGPT
• See how it can compliment your learning journey
• How can you use AI tools right now!
• What’s the future of ChatGPT and its integration with MS tools

If Continue reading “ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit” →

Excel Select All Formulas And Their Precedents – 2380

Posted on by Annie D

Harsinchh asks if there is a way to highlight all formula cells and the precedents of those formulas. There are a lot of techniques discussed in this video:
Show Formulas in Excel
Select all Formulas in Excel
Go To Special Precedents in Excel
Direct versus All Precedents in Excel
VBA to select formulas in Excel
VBA to select precedents in Excel
VBA to union two ranges in Excel

Table of Contents
(0:00) Excel: Select Formulas & the precedents
(0:25) Excel Show Formulas
(0:55) Selecting all Excel Formulas
(1:16) Selecting Formula Precedents with Go To Special
(1:40) All Precedents versus Direct Precedents
(2:52) Four-step is a kludge
(3:08) VBA Macro to select formulas and precedents
(4:49) Personal Continue reading “Excel Select All Formulas And Their Precedents – 2380” →

Harnessing The Power Of Dataverse – A Practical CRM Example

Posted on by Annie D

Session 15: Harnessing The Power Of Dataverse – A Practical CRM Example

When is it?
February 22nd – 8pm Los Angeles (PST), 11pm New York (EST)
February 23rd – 4am London (GMT), 3pm Sydney (AEDT), 5pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Ben Clist – Business Analytics and Applications Manager, Napier Port

During This Free Event, You Will:

• Learn how you can utilise out of the box Dataverse functionality to quickly develop a CRM solution
• Ideal for small teams without the budget for Dynamics 365, Continue reading “Harnessing The Power Of Dataverse – A Practical CRM Example” →