Category: Power Pivot

Do NOT ask your Boss for Time Off to Celebrate Spreadsheet Day! #OITNB #SpreadsheetDay #Excel #nsfw

Posted on by Annie D

I don’t care how good you are at spreadsheets, do NOT try to ask your boss for time off to celebrate Spreadsheet Day. It won’t go well!

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

Many thanks to Alysia Reiner, the amazing actress who plays Fig on Orange is the New Black. I asked if she could improv, as Fig, her reaction to my request for time off for Spreadsheet Day. Awesome. My new favorite spreadsheet day Continue reading “Do NOT ask your Boss for Time Off to Celebrate Spreadsheet Day! #OITNB #SpreadsheetDay #Excel #nsfw” →

Spreadsheet Day – Never Merge Cells – PSA from Sheriff Buford T. Justice #excel #spreadsheetday

Posted on by Annie D

Even Buford T. Justice knows that Center Across Selection is better than Merge Cells in Excel!

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

Happy Spreadsheet Day from Roy Stride (Scouting for Girls) Original Song #spreadsheetday #excel

Posted on by Annie D

To celebrate Spreadsheet Day (October 17 2023), I convinced Roy Stride, frontman for Scouting for Girls to sing this little song for all spreadsheet fans everywhere!

Spreadsheet Day is October 17, 2023 and marks the anniversary of when Dan Bricklin and Bob Frankston first released VisiCalc in 1979. The holiday was created by Debra Dalgleish of Contextures.com.

Excel – How to Remove Lines, Borders, Gridlines, or Strikethrough #shorts #excel #walkthrough

Posted on by Annie D

Microsoft Excel Tutorial: Remove lines from Excel, whether they are borders, gridlines, or strikethrough.

In this quick and helpful Excel tutorial, we’re going to show you exactly how to clean up your spreadsheet and get rid of those pesky lines and gridlines that can clutter your view. Whether you’re dealing with borders, gridlines, or even strikethrough text, we’ve got you covered!

🔵 Borders Be Gone!
If you’re dealing with border lines that you want to remove, it’s as easy as 1-2-3. Just select the data with borders, head to the Home tab, open the Borders drop-down, and choose “No Border.” Your spreadsheet will Continue reading “Excel – How to Remove Lines, Borders, Gridlines, or Strikethrough #shorts #excel #walkthrough” →

Excel VBA Macro To Flip All Checkboxes In Excel – Episode 2629 #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: Multi-select all checkboxes and flip from true to false or back.

To download the workbook from today: https://www.mrexcel.com/youtube/mpQ7IrPzenM/

Copy this code and put it in your personal macro workbook:
Sub FlipCheckboxes()
On Error Resume Next
For Each cell In Selection.SpecialCells(xlCellTypeConstants, 4)
cell.Value = Not (cell.Value)
Next cell
On Error GoTo 0
End Sub

Sub AllTrueCheckboxes()
On Error Resume Next
For Each cell In Selection.SpecialCells(xlCellTypeConstants, 4)
cell.Value = Continue reading “Excel VBA Macro To Flip All Checkboxes In Excel – Episode 2629 #excelhacks” →

Excel – Better Checkbox Style in Excel – Quick Tips #shorts #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: Better looking checkboxes in Excel.

📊 Want to upgrade the look of your Excel checkboxes? In October 2023, a new Checkbox icon was introduced on the Insert tab. While it offers a convenient way to toggle checkboxes using your mouse or the spacebar, it can feel a bit cluttered.

👉 In this quick tip, discover a sleeker alternative! Learn how to add checkboxes and then make them disappear with a simple press of the Delete key. They’ll reappear when you hover over the cells, and with a click or spacebar press, you can easily turn them on.

🔘 However, keep Continue reading “Excel – Better Checkbox Style in Excel – Quick Tips #shorts #excelhacks” →

Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628

Posted on by Annie D

Microsoft Excel Tutorial: Checkboxes arrive in Microsoft Excel

To download the workbook from today: https://www.mrexcel.com/youtube/kunbe45v7-E/

In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.

Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the “Insert” tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true Continue reading “Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628” →

Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627

Posted on by Annie D

Microsoft Excel Tutorial: Calculate Average Cost per Year in Excel.

Derek has a fleet of vehicles and a list of all repairs made in the last 20 years. He wants to figure out how the annual repair and maintenance costs change as the vehicle ages.

In this video, MrExcel discusses how to calculate annual repair costs based on the age of a vehicle. He provides a data set of repairs made on a fleet of vehicles and explains how to determine the first date each vehicle was placed in service. He suggests using an approximation for vehicles without records by subtracting Continue reading “Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627” →

Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft Labs in Cambridge releases a great Python editor for Excel.

Just 27 days after Python preview appears in Excel, Microsoft has added a dramatically better Python editor.

To download the workbook from today: https://www.mrexcel.com/youtube/UKpmNAMjygg/

This new editor in the task pane offers AutoComplete, Intellisense, and automatic code coloring. Take a walkthrough the editor in today’s video.

#excel
#microsoft
#microsoftlabs
#microsoftexcel
#exceltricks
#excelpython
#microsoft365
#walkthrough

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Python Editor Added to Excel
(0:10) Free Silo Photos
(0:20) Theories on backstory
(0:59) Get Add-Ins moving from Insert to Home tab
(1:22) Update Excel Labs add-in twice
(1:49) Open Excel Labs & Continue reading “Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625” →

Excel – Oracle Sending Dates as Text MMM-YY Episode 2624 #excel #pivot_table #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: Sorting months in a pivot table when they are alphabetic.

I met people who are downloading data from Oracle through Analysis Services. Their dates are coming in as text in the format of Sep-20 for September 2020. When they create pivot tables, the months are alphabetic instead of sequential.

To download the workbook from today: https://www.mrexcel.com/youtube/BpgjOMlh39E/

There are two ways to solve it:
1) A convolunted method from Sam Radakovitz that you only have to do once
2) A simple method that you will have to do 1000 times a year.

In this episode, I show Sam Rad’s method of Continue reading “Excel – Oracle Sending Dates as Text MMM-YY Episode 2624 #excel #pivot_table #excelhacks” →

Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: How to use Excel’s Filter Search Box to remove items from Filter.

Melvin from Orlando shared a great Excel trick with me during yesterday’s live Power Excel seminar in Daytona Beach.

To download the workbook from today: https://www.mrexcel.com/youtube/Od5IwswzWnI/

We all know you can use the Filter drop-down Search Box to find all cells that contain Apple. But what if you want everything that does not contain Apple? Rather than use the old Text Filters for Does Not Contain, you can use this great trick from Melvin:
1. Search for Apple
2. Uncheck Select All Items
3. Check Add Current Continue reading “Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks” →