Category: Excel

Excel Hold Alt+1 To Repeatedly Run 1st QAT Icon Perhaps Increase Decimal 2368

Posted on by Annie D

A cool Excel trick from Geert Delmulle – you can increase decimal repeatedly by holding down Alt+1. This works if you move the Increase Decimal icon to one of the first 9 spots on the Quick Access Toolbar.

Table of Contents
(0:00) Fast Way to Increase Decimal in Excel
(0:47) After Alt key, use 1-9 for first 9 QAT icons
(1:02) Hold Alt+2 to run 2nd QAT icon repeatedly
(2:30) Adding icons to the Excel QAT
(2:54) Moving QAT icon to beginning
(3:06) Finding icons not on Ribbon for QAT
(4:06) Save icon too far left after AutoSave removed

Hide Excel Pivot Table Rows Using Sets And Then Edit The MDX – 2367

Posted on by Annie D

If you need to hide some rows in an Excel pivot table, you can Create a Set Based on Row Items.

This is a rarely used feature: First, it is only available if you choose Add This Data To The Data Model.

Once you create a set, it is a bit strange to remove rows. And if you add data later, you have to go back in to edit the set. Excel offers to let you edit the MDX, but what is MDX?

Thanks to David Jefferson who provided a comment to a YouTube video, he shows how to Continue reading “Hide Excel Pivot Table Rows Using Sets And Then Edit The MDX – 2367” →

Excel Suggest The Next Awesome Excel Idea – 2366

Posted on by Annie D

Do you love Excel? Do you have a feature that would make Excel easier for you? Write up your idea and post it to the new Feedback Forum for the Excel team. Other people can vote for your idea and many ideas each year are added to Excel.

The Feedback portal for Excel is at: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472

Vote for my idea to use the Custom Lists when renaming copied worksheets, vote here: https://feedbackportal.microsoft.com/feedback/idea/13963988-a0a0-ed11-a81b-000d3a0450e3

If you post a great idea at the Feedback forum, let me know the title in a YouTube comment and I will vote Continue reading “Excel Suggest The Next Awesome Excel Idea – 2366” →

Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/12-M365ExcelClassVideoFiles.zip
Full Free M Code Class from Basic to Advanced in Excel and Power BI Power Query taught by Excel MVP and Highline College Professor, Mike Girvin. Full Class: Microsoft 365 Excel Complete Story.
This video covers.
1. (00:00) Introduction
2. (00:26) Define M Code
3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop
4. (05:08) Advanced Editor button in Excel & Power BI Desktop
5. (05:39) Power BI Desktop “Enable Load”
6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We Continue reading “Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12” →

Excel Reverse Wildcard Search – 2365

Posted on by Annie D

VLOOKUP, XLOOKUP, and SUMIFS all allow a wildcard in the Lookup_Value. But today, Chris wants wildcards wrapped around the lookup table! After trying XLOOKUP, FILTER, and COUNTIF, I finally end up with TEXTJOIN, IF, and SEARCH. Do you have a better way?

Table of Contents
(0:00) Use wildcard for the lookup range
(0:34) XLOOKUP, FILTER, COUNTIF failed
(0:54) SEARCH function on an array
(2:11) TEXTJOIN, IFERROR, and SEARCH
(3:15) Surprisingly difficult

Excel Secret To Maximizing Euro Jackpot Winnings – 2364

Posted on by Annie D

Markus is looking for Excel help to pick numbers for the Euro Jackpot where you have to choose 5 numbers from 1 to 50. In this video, I share secrets from my late friend Dogtrack Bill.

To use the number picker in a free Excel Online, follow this link:
https://1drv.ms/x/s!As7G72Sl487JljvjcWPxwg0_pTe1?e=CMGO1E

The Euro Jackpot payout for matching 5 numbers with no bonus numbers is a parimutuel system. A fixed percentage of the betting pool is split between all people that matched five numbers. To maximize the payout if you win, choose numbers that are not likely to be chosen by Continue reading “Excel Secret To Maximizing Euro Jackpot Winnings – 2364” →

Excel Use Previous Workday If Not A Workday – 2363

Posted on by Annie D

Vicki: I have a list of dates and I’m looking for a formula to calculate the previous workday only if the date in the list is a weekend or holiday.

Why: Accrue Fed Fund Interest Daily (Fed Funds Rate only published on Business Days).

This is mildly complex, because you need to be able to create a named range for the holidays, and after building the long formula, Excel will likely give you the date serial number instead of the formatted date.

Table of Contents
(0:00) Introduction
(0:23) Create a named range with holidays
(1:23) Excel formula to detect if date is a workday using NETWORKDAY Continue reading “Excel Use Previous Workday If Not A Workday – 2363” →

Free Excel Templates From Microsoft Create – 2361

Posted on by Annie D

The Microsoft Create platform is in preview. Sign in with a Microsoft 365 Home account to access free templates for Excel and more. It also includes training on social media from Kat Norton Miss Excel and promises future features.

Table of Contents
(0:00) Free templates in Preview
(0:34) Start at Create.Microsoft.Com
(1:30) Opening a template in Excel Online
(1:54) Accessing from Win32
(2:24) Learning videos including Kat Norton
(3:00) Designer & Clipchamp coming

Less F9 In The Excel Formula Bar And Two Other New Features – 2360

Posted on by Annie D

Three new features coming to Excel.
1) Value Preview will evaluate part of your formula when you select it in the Excel formula bar. You don’t have to press F9 and Esc anymore.
2) AutoSave moves from an icon to Words in the Excel Title Bar
3) Small preview of Personalized Toolbar in Excel

Table of Contents
(0:00) Three new Excel Features
(0:30) F9 replaced with Value Preview
(3:57) AutoSave icon moves to Title Bar words
(5:07) Personalized Toolbar in Preview
(10:38) Wrap-up

Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1816.xlsx
Learn about new “Value Preview” for Excel Formula Elements: No More F9 & Ctrl + Z
Topics:
1. (00:00) Introduction
2. (00:01) Learn about new “Value Preview” for Excel Formula Elements: No More F9 & Ctrl + Z
3. (00:47) Closing, Video Links

#Shorts

Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1814-1815.xlsx
Learn who to copy Excel Formatting and Apply in other locations
Topics:
1. (00:00) Introduction
2. (00:05) Copy Only Formatting with the Format Painter in Ribbon
3. (00:20) Format Painter in Mini Toolbar
4. (00:31) Apply Formatting multiple Times by Double-clicking Format Painter
5. (00:43) Keyboard for Format Painter
6. (01:03) Apply Same Formatting to Many Columns Simultaneously
7. (01:19) Closing, Video Links

#Shorts