Month: May 2023

Excel VBA Window is All Grey Or Panes Will Not Redock Correctly – Episode 2603

Posted on by Annie D

Microsoft Excel Tutorial: The VBA Editor Panes are missing or not docked correctly.

Chris writes in. His VBA Editor is completely grey. How does he get back to the classic view with the Project Explorer in the Top Left, the Properties window in the bottom left and the Code on the right?

To download this workbook: https://www.mrexcel.com/youtube/C4T9CDfVA5g/

Table of Contents
(0:00) Program Note
(0:11) Excel VBA Editor is all Grey
(0:50) VBA Panes not docking correctly
(0:55) Undocking VBA Pane
(1:08) Look for “Ghost” panel to redock
(1:28) Excel VBA Pane redocks full width
(1:46) VBA Editor no room for code pane
(1:56) Undock the Project Explorer
(2:08) Continue reading “Excel VBA Window is All Grey Or Panes Will Not Redock Correctly – Episode 2603” →

Excel – How to Draw a Circle in Excel #shorts

Posted on by Annie D

Microsoft Excel Tutorial – Draw a Circle in Excel

The drawing tools in Microsoft Excel offer an oval. There is a secret trick to making the oval into a perfect circle: Hold down the Shift key while drawing.

To download this workbook: https://www.mrexcel.com/youtube/vUtrQeqxqRA/

Table of Contents
(0:00) Draw a Circle in Excel using Shift Key
(0:22) Draw Many Circles in Excel
(0:33) Circle something on a chart in Excel
(0:44) Remove Fill in Excel circle

This video answers these common search terms:
how do you draw in a circle in excel
how to draw a circle in excel
how to draw circle in excel
how to draw circles in Continue reading “Excel – How to Draw a Circle in Excel #shorts” →

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” →