MrExcel Excel Videos

Microsoft Excel Tutorial - How to Draw Arrows or Line in Excel. How to draw an arrow in Excel? To download this workbook: Excel - Draw Arrows or Dotted Line in Excel - #shorts Sample Files - MrExcel Publishing Table of Contents (0:00) Draw arrow in Excel (0:08) Change Arrow Color, Weight, Arrow Heads (0:21) Make line dotted in Excel (0:24) Curve arrow around an obstacle in Excel (0:51) Wrap up

Microsoft Excel Tutorial - Circle invalid data in Excel This video shows a cool use for Data Validation: Circling Invalid Data. Also: manually circling a cell in Excel using the drawing tools. This method creates a filled circle. This video shows you how to remove the fill so you have a circle that does not cover the data. To download this workbook: Excel - Circle Invalid Data - #shorts Sample Files - MrExcel Publishing Table of Contents (0:00) Circle invalid data in Excel (0:08) Define valid data in Data Validation first (0:28) Manually drawing circles (0:38) Making filled circle an outline (0:46) Ctrl+Drag to copy circles in Excel (0:52) Wrap-up This video answers these search terms: how do you circle invalid data in excel, how...

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: Excel VBA Window is All Grey Or Panes Will Not Redock Correctly - Episode 2603 Sample Files - MrExcel Publishing 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) Undock...

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: Excel - How to Draw a Circle in Excel Sample Files - MrExcel Publishing 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 excel how to make a circle in excel how to make circles in excel in excel how to draw shapes...

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: Jeopardy Masters Semi-Finals Tie! What Are The Odds - Episode 2602 Sample Files - MrExcel Publishing 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) Jeopardy Masters Tie-Breaker Rules (1:50)...

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: Excel - Draw a Semi-Circle Sample Files - MrExcel Publishing 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 circle in Excel How to draw a quarter circle in Excel

How to split delimited into rows. I tried using Power Query. With Power Query I can do it only for 1 column. If I select more than 1 column, the Split Column is disabled in the Power Query Editor. Is there any other solution for splitting delimited into rows for more than one column? This video offers three solutions. Solution 1 is a formula such as =TEXTJOIN("|",,TEXTSPLIT(C2,",")&"-"&TEXTSPLIT(B2,",")) and then Power Query. The 2nd solution is M code written by Suat Ozgur. let fnSplit = (row as record) => let Invoice = row[Invoice], Product = row[Products], Qty = row[Quantities], ProductList = Text.Split(Product, "," ), QtyList = Text.Split(Qty, ",")...

Microsoft Excel Tutorial - Deep Dive on diagnosing VLOOKUP errors. To download the workbook: Excel VLOOKUP Fails At Strange Hyphen - 2600 Sample Files - MrExcel Publishing 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 hyphen - which the CODE function reports as ASCII 63 is really Unicode 8208. Why did the vendor decide to use...

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 in the YouTube comments below. Table of Contents (0:00) Problem Statement