Category: Business

Sort By Last Name using Excel Formula: Amazing Solution!! #Short Excel Magic Trick 13

Posted on by Annie D

Learn how to create a formula to sort a column of full last names with an Excel Formula.
Download Excel File: https://excelisfun.net/files/SEMT00013-14.xlsx
#excel #excelisfun #analytics #microsoftexcel #microsoftmvp, #short #shorts #excelmvp #excelformulas #excelfunctions #excelformulaforjobinterview #excelforbegginers #excelshorts #exceltutorial #exceltips #exceltipstricks #freeclass #freecourse #freeclasses #freeexcelcourse #freeexcel #shortsyoutube #shorts #short #Sort #sortby #SortNames
#sortfunction #sortvideo

Jeopardy Masters Semi-Finals Tie! What Are The Odds – Episode 2602

Posted on by Annie D

Mattea Roach and Andrew He finished the Jeopardy Masters Semi-Finals in a tie. Mattea Roach advanced thanks to a complex tie-breaker. What are the odds that the contestants who advanced to the finals would be decided by a tie-breaker?

It turns out that 18.5% of the possible outcomes would have required using a tie-breaker.

This video explains the math behind it all and the Microsoft Excel model used to make the calculation. To download the workbook: https://www.mrexcel.com/youtube/SUXTNAp4XgU/

Table of Contents
(0:00) Spoiler Alert
(0:21) Tie game is like kissing your sister
(1:06) Odds of a tie in Jeopardy Masters Semi-Finals
(1:33) Continue reading “Jeopardy Masters Semi-Finals Tie! What Are The Odds – Episode 2602” →

Excel – Draw a Semi-Circle

Posted on by Annie D

Microsoft Excel Tutorial – how to draw a semi-circle in Excel.

The Insert Shapes drop-down menu in Excel offers an oval, but not a semi-circle. How can you draw a semi-circle? Most of those shapes include a yellow handle for changing the inflection point. You can use this handle to make the partial circle into a half-circle or quarter circle.

Download the workbook from today: https://www.mrexcel.com/youtube/U2gvZtUW0vk/

This short video shows you how.

Table of Contents
(0:00) Draw a semi-circle in Excel
(0:15) Yellow handle
(0:27) Rotation handle

This video answers these common search terms:
How to draw a semi-circle in Excel
How to draw a half Continue reading “Excel – Draw a Semi-Circle” →

Excel – Embed Growing Range In Word Document – 2601

Posted on by Annie D

Microsoft Office Tutorial – live link to Excel range in Word.

Ashley wants to embed a range of Excel data in a Word document.

If the data in Excel changes (including adding more rows), she wants the Word document to update.

Annoying: If you use Insert, Object in Word, it captures the wrong range and truncates if you add more data.

My method: (1) Set the Print Range in Excel, (2) Select the Print range and Copy. (3) Paste to Word, (4) Open the paste drop-down menu and choose Linked Keep Source Formatting. This reliably works.

How do you solve this? Let me know down Continue reading “Excel – Embed Growing Range In Word Document – 2601” →

Excel VLOOKUP Fails At Strange Hyphen – 2600

Posted on by Annie D

Microsoft Excel Tutorial – Deep Dive on diagnosing VLOOKUP errors.

To download the workbook: https://www.mrexcel.com/youtube/_q0VdM1ES1g/

This is an advanced look at troubleshooting hard VLOOKUP errors. After using TRIM, CLEAN, and making sure there aren’t numbers stored as text, then I use this method to look at the ASCII code, character by character to figure out why the two values do not match.

But today, the vendor part number is reporting that a hyphen is ASCII CODE 63 instead of 45. What is up with this?

I had to modify my workflow to add UNICODE functions in order to discover that the Continue reading “Excel VLOOKUP Fails At Strange Hyphen – 2600” →

What does Tooltip Auto-scale actually do in your Power BI Report?

Posted on by Annie D

Is your tooltip going off the page of your Power BI report? Maybe it looks weird on an iPad or smaller device. Adam shows how the new tooltip auto-scale feature can help.

April 2023 Update reference
https://powerbi.microsoft.com/blog/power-bi-april-2023-feature-summary/#post-23001-_Toc1599845071

Documentation:
https://learn.microsoft.com/power-bi/create-reports/desktop-custom-tooltips?tabs=powerbi-desktop#allow-tooltips-to-auto-scale-preview

📢 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/
— Continue reading “What does Tooltip Auto-scale actually do in your Power BI Report?” →

Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/17-M365ExcelClassVideoFiles.zip
50 pages of pdf notes: https://excelisfun.net/files/17-M365ExcelClassDax..pdf
This video teaches how the fundamentals of Columnar Database, DAX Calculated Columns, DAX Measures, Row Context, Filter Content, Context Transition, Overwrite Operation, DAX X Iterator functions, DAX CALCULATE function and much more!
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:25) Topics in Video
3. (01:13) Why we use DAX, M Code & Worksheet Formulas: What makes Each Continue reading “Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17” →

12 Data Wrangling Functions In Python That You Should Know

Posted on by Annie D

Data wrangling in Python refers to the process of cleaning, transforming, and organizing raw data into a more structured format for analysis. It involves tasks such as data cleaning, data integration, handling missing values, data formatting, and feature engineering.

Data analysts can best utilize data wrangling in Python to ensure the data is reliable, consistent, and suitable for analysis. In this video, Gaelim shares 12 essential Data Wrangling functions in Python to be familiar with.

*****Video Details*****
00:00 Introduction
00:38 Dataset 1
00:42 Libraries to import
01:16 Dataset 2
01:35 Merging data set
02:13 Droping columns
02:44 Fill missing values
03:15 Replacing missing values
03:44 Replacing a specific value
04:25 Replacing Continue reading “12 Data Wrangling Functions In Python That You Should Know” →

Enabling Drillthrough with Power BI On-Object Editing

Posted on by Annie D

Using the new On-Object editing in Power BI Desktop? Have you figured out how to enable drillthrough yet? Adam has and is here to show you the clicks!

Power BI April 2023 Feature Summary
https://powerbi.microsoft.com/blog/power-bi-april-2023-feature-summary/

On-object Interaction
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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/
— <a Continue reading “Enabling Drillthrough with Power BI On-Object Editing” →