K has an line at the bottom of one cell. How can we remove it?
Other questions here:
Why does AutoFit Row Height not work in Excel?
Why can’t I delete this border in Excel?
Deleting drawing objects in Excel?
Borders using Conditional Formatting in Excel?
How to remove page breaks in Excel?
Paste Picture Link in Excel?
Why is there one extra line of whitespace at the bottom of my cell?
How do I manually change row height in Excel?

Thanks to YouTubers: DropMeSort, Finnur Torfi Gunnarsson, Rico S., and Vesa Ruusunen.
Thanks to Debra Dalgleish at Contextures.

Table of Contents
(0:00) Remove the Line at the bottom of a cell
(0:19) Use Continue reading “Excel Remove Line At Bottom Of Cell 2527” →

My productivity hack: https://www.magicmind.co/mrexcel Use my
code MREXCEL20 for 20% off #magicmind

Today, we take a look at analyzing YouTube stats year over year. Along the way, you will see:
Unpivoting KPI columns in Excel Power Query
Creating a pivot table in Excel
Using the SEQUENCE function
XLOOKUP in Excel
Charting in Zebra BI for Office

#productivitytips #productivityhacks #productivityatwork
#adhdmanagement #mondaymotivation #lifehack #inspiration #lifetips

Table of Contents
(0:00) Welcome
(0:10) Magic Mind Challenge
(0:35) Szilvia, Rob, and Matcha
(0:51) Magic Mind Ingredients
(1:49) How does it taste
(2:35) Analyze YouTube Stats
(3:10) Power Query
(3:40) Unpivot KPI columns
(4:10) Pivot Table
(4:55) SEQUENCE function
(5:40) XLOOKUP function
(6:22) Adjust formula by dragging
(6:41) Slicer Shape
(7:09) Pivot Table Lock Column Continue reading “Excel Analyzing Year Over Year Changes When Drinking Magic Mind – 2526” →

These new Artificial Intelligence Art Creators are the buzz lately. You can type a few sentences and it will generate art for you. I am going to see if I can manage to generate an artistic Excel spreadsheet.
How to use Night Creator Studio to generate artwork.
Type a description, a style, and artistic influences.
Choose dimensions, aspect ratio.

Your Excel charts should always show a variance. Maybe a variance from plan or a variance from last year. A new Excel (and PowerPoint) tool from Zebra BI makes this very easy.

Links from the video:
IBCS Standards: https://www.ibcs.com/ibcs-standards-1-2/
About Zebra BI: https://bit.ly/3D0hipe
The free templates from Zebra BI: https://bit.ly/3zeLiws

Table of Contents
(0:00) Life-changing
(0:29) Excel Chart
(0:58) ICB Standards
(1:29) Some ICBS rules
(2:18) Zebra BI for Office
(3:14) Creating chart in Zebra BI
(3:52) Interpreting Chart
(5:14) Second chart
(6:06) Formatting
(7:01) Free templates
(7:15) Wrap-up

A look back to the early days of Tickling Keys, Inc. – when our main product was rock and roll player piano rolls. This is my favorite spreadsheet. What is yours? #ExcelAtEverything

Thanks to video footage from David Shivers at the Salem (Ohio) Historical Society.

Excel randomly choose Yes or No.
Use CHOOSE and RANDBETWEEN for a roughly 50/50 split.
Or use IF and RAND to generate an approximate percentage of one or the other.