Download Excel File: https://excelisfun.net/files/EMT1768.xlsx
Happy Holidays, Online Excel Team!!!!!! –excelisfun
Song Credits:
Jingle Bells 7 by Kevin MacLeod is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/
Artist: http://incompetech.com/
Today a question from someone who frequently uses three currency styles in Excel: USD, EGP, and SAR. Excel makes it easy to choose USD, GBP, EUR, CHF but if your currency is not in that drop-down, then you are scrolling Continue reading “Excel Easily Choose Which Currency – 2455”
My courses on Retrieve: https://mrexcel.retrieve.com/store/#/
For a special holiday-week treat, change the color of the gridlines in Excel to red. It could drive your co-workers insane.
Actually, as time goes by, the gridlines are becoming more faint. Changing the Continue reading “Red Gridlines In Excel – 2454”
Today, a quick tip for sorting left to right in Excel.
With the correct headings, it is a faster way to rearrange columns.
Check out all 12 expert tricks at: https://www.youtube.com/watch?v=nOIEeUHyye0
My course on Retrieve: https://mrexcel.retrieve.com/
Download Excel File: https://excelisfun.net/files/EMT1767.xlsx
Learn how to count unique dates for each item four ways: PivotTable and DAX Implicit Measure, Spilled Array Formulas, FREQUENCY Function and LAMBDA function.
1. (00:00) Introduction
2. (00:18) Goal of unique count formula
3. (00:30) Data Continue reading “Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767”
Check out my Excel Guides on Retrieve: https://mrexcel.retrieve.com/#/
A question from the Las Vegas IMA: How do you do date rollups in Excel when the company is on a fiscal year that does not end on December 31?
This Continue reading “Excel Pivot Table Fiscal Year Date Rollups – 2452”
Download Excel File: https://excelisfun.net/files/EMT1766.xlsx
Learn how to.
1. (00:00) Introduction
2. (00:38) Why we build formulas in cells before pasting formula into Conditional Formatting Dialog Box
3. (01:19) Logic for formulas to find missing numbers in the incident number
4. (02:09) Create Continue reading “Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766”
How to create your own custom data types in Excel using ScriptLab and the Javascript API.
Important Links:
Try out the workbook with my custom data types: https://1drv.ms/x/s!As7G72Sl487JliYRnUs0P4hYYNQj?e=rIL25J
Github for the example using a Custom Function:
<a href="https://gist.github.com/smozgur/a34ad495fb75e19c3e21904875ef0170" Continue reading “Wow! Excel Custom Data Types From JavaScript API – 2451”
The data types gallery with Geography, Stocks, Currency, and Wolfram is mildly interesting. But I think the real goal is to get your own company data in the Data Type. I want it to be a very rich experience, just Continue reading “Excel Custom Data Types From Power BI – 2450”
The Excel team snuck a new feature into Excel and I didn’t realize it for a while. Thanks to Excel MVP Abiola David for realizing that you can left-click any number in the status bar to copy that number to Continue reading “New! Copy Any Status Bar Number To Clipboard In Excel – 2449”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about how to create X-Y Linear Data Scatter Charts from X-Y data in Excel using Excel Charts and the Microsoft Artificial Intelligence Data Analyze Button.
Topics:
1. (00:00) Introduction
2. (00:34) First X-Y Scatter Data Set: Continue reading “Excel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button?”
Jon wants to generate 6-letter sequences using only the letters B and P.
So, for example: BBBBBB, PPPPPP, BPBPPB, BBBPPP, and so on. There are 64 such combinations and Bill shows you one way to solve this use BASE and SUBSTITUTE.
Formulas Continue reading “Random Combination Of PBPBBP – 2448”