Month: October 2023

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” →

Discover the Untapped Settings in Power BI Desktop

Posted on by Annie D

There are a lot of settings within Power BI Desktop! Adam looks at a few you may not know about and should be aware of. Definitely review these!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – rel=”nofollow”>https://guyinacube.com/tools/

#PowerBI #MicrosoftFabric #GuyInACube

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 Formula: Extract City Name from Description. Excel Magic Trick 1839

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1839.xlsx
Learn about how to extract the city name from a description using the SEARCH and LOOKUP functions. Then see how to spill the formula with BYROW and LAMBDA functions.
Buy excelisfun’s book: The Only App That Matters:
Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Mr Excel Web Site: https://www.mrexcel.com/products/microsoft-365-excel-the-only-app-that-matters/

Topics:
1. (00:00) Introduction
2. (00:05) SEARCH and LOOKUP functions
3. (02:39) BYROW and LAMBDA functions
4. (03:43) Summary
5. (03:52) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #BYROW #LAMBDA #dataanalysis

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” →

Endless Demo Data – GPT4’s Advanced Data Extraction Capabilities

Posted on by Annie D

Join me as I take you through an incredible discovery with ChatGPT 4’s Advanced Data Analysis plugin. From generating datasets tailored to specific industries to understanding the power of this tool, we’ll uncover the potential for data analysis and science in real-time.

🔍 What to Expect:
– An introduction to ChatGPT 4 and its Advanced Data Analysis capabilities.
– Generation of specific datasets across varied industries.
– Real-time creation and download of large datasets.
– Exploration of data analysis suggestions using AI.

🔧 Tools & Tech:
Discover the speed and versatility of ChatGPT 4 in generating datasets and providing actionable insights.

🚀 Real-time Results:
See firsthand the extraction of Continue reading “Endless Demo Data – GPT4’s Advanced Data Extraction Capabilities” →