Microsoft Excel Tutorial – is there a way to know at a glance if the macro recorder is in Relative Recording Mode or not?
Category: Excel
Excel – Draw a Line through Text (Strikethrough) #shorts
Microsoft Excel Tutorial – How to draw a line through text.
Some people call it Strikethrough. Others call it crossing out text.
How can you do it in Microsoft Excel.
This short video starts with a memory aid about taking inventory with a mechanical pencil and making hashmarks. You might start with |||| to mean 4. After the 4th vertical hashmark, you cross out the lines to indicate 5. It is the 5th line that crosses the others out. This is how I remember that Ctrl+5 is Strikethrough!
Download the workbook from https://www.mrexcel.com/youtube/PmQpp46p3ls/
Table of Contents
(0:00) Counting with Hashmarks
(0:12) Cross out Continue reading “Excel – Draw a Line through Text (Strikethrough) #shorts”
Excel – Draw Arrows or Dotted Line in Excel – #shorts
Microsoft Excel Tutorial – How to Draw Arrows or Line in Excel.
How to draw an arrow in Excel?
To download this workbook: https://www.mrexcel.com/youtube/ojM42vamBQY/
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
Common Search Terms:
how do i draw arrows in excel
how do you draw arrows in excel
how to draw a arrow in excel
how to draw an arrow in excel
how to draw an arrow in excel 2010
how to draw an arrow line in excel
how to draw arrow in excel
how to draw arrow in Continue reading “Excel – Draw Arrows or Dotted Line in Excel – #shorts”
Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18
Create Reports & Visuals from Two Fact Tables with Different Grains. 3 Solutions. 365 MECS Class 18
Download Zipped Folder with All Files: https://excelisfun.net/files/18-M365ExcelClassVideoFiles.zip
50 pages of pdf notes: https://excelisfun.net/files/18-M365ExcelClass.pdf
This video shows how to deal with Two Fact Tables with Different Grains. Learn three solutions: 1) Power Query, DAX Formulas or Worksheet Formulas. Learn how to create reports and visuals from Two Fact Tables with Different Grains.
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. Continue reading “Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18”
Excel Variance Inside The Pivot Table – Episode 2605
Microsoft Excel Tutorial: Adding a Variance inside of a pivot table.
Keani has a pivot table with current year and last year across the top. She wants a variance. Her current solution is a formula outside of the pivot table which points inside of the pivot table.
This video shows three methods for adding a variance inside the pivot table.
1. Regular pivot table, add Revenue twice. Change calculation to Difference From, Years, and (Previous Item)
2. Regular pivot table. Remove Grand Total. Use 2 Excel Calculated Items to calculate Variance and Total
3. Data Model Pivot Table. Add four DAX Measures to calculate last Continue reading “Excel Variance Inside The Pivot Table – Episode 2605”
INDEX Function Beats XLOOKUP? #Short Excel Magic Trick 14
Learn how to use the INDEX function to make an easier lookup formula than using the XLOOKUP function when the lookup values to match are sequential numbers starting at 1.
Download Excel File: https://excelisfun.net/files/SEMT0008-12.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
#xlookup #indexfunction #indexfunction
Excel All Combinations One To Six in Four Columns – Episode 2604
Microsoft Excel Tutorial: Generating all combinations of N outcomes for K games.
In episode 2602, I had to generate all possible combinations of 4 games with 6 possible outcomes in each game. I used my very convoluted “binary count up, but not binary because it is base 6, but not base 6 because I need the digits 1 to 6 instead of 0 to 5” method. This involves a lot of typing and two different formulas.
Today, a much easier way from Kyle Freistedt. Kyle DOES use Base 6. He does use a SEQUENCE function but starts at 0 instead of Continue reading “Excel All Combinations One To Six in Four Columns – Episode 2604”
Excel – Circle Invalid Data – #shorts
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: https://www.mrexcel.com/youtube/OpVReJuDvWs/
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 Continue reading “Excel – Circle Invalid Data – #shorts”
Excel VBA Window is All Grey Or Panes Will Not Redock Correctly – Episode 2603
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
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
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
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”