57272 подписчиков
185 видео
Transpose from column to row, AND create a numbered list.
Use the SORT function to pull a sorted list from an array.
Use ChatGPT to help create formulas in Excel
Convert Text to Number and Text to Date
Filter using multiple criteria using the Advanced Filter feature
Excel COUNTBLANK function
Add a dropdown based on the value of another dropdown.
Short: Copy/Paste without CTRL + C or CTRL + V
Excel short: how to hide and unhide rows or columns
Import data into Excel from a picture.
Use the countif function to find out how many times something comes up in a table.
Find the last value in a column using Index and CountA functions.
Excel Tips: Alt + Enter - Creating Line Breaks in Cells
Change Table References from Structured Reference to Cell Reference
Excel Formula Magic: Explore Specific Arguments & Results Using This New Feature
Stop Guessing! Use ChatGPT & Excel to Bill Smarter (Full Tutorial)
Remove duplicate values in a range of data
Excel Tutorial: Adding Checkboxes to Cells for Efficient Data Management
How to separate a list of names into first and last name columns
Make an index tab in your spreadsheet with a hyperlink to all the other tabs.
Don't Use More Space Than you Need To! Keep Wide Columns When Your Data is Narrow!
Find the biggest sale using the MAX function!
Randomize your list in Excel quickly and easily!
Stop using merge & center!! Do this instead!!
Use a slicer to quickly filter a table of data!
Don't try to filter source data of your pivot table!!! Do this instead!!
Show the sum of ONLY visible cells using SUBTOTAL instead of SUM!
Copy your formula down a column, instantly!
Copy sheet and keep fonts, formatting, and formulas
Format pivot table numbers
Why your numbers will add cell by cell, but won't sum! How to convert unconvertable text to numbers.
Import Data from a PICTURE!!!
Excel sumifs function to find data in a range of dates
Windows 10 Clipboard will change your life!!
Paste a formula down a column WITHOUT losing the existing formatting!!
Create a running total with just a few clicks!
Embed an Excel spreadsheet into a PowerPoint presentation, and it will automatically update!
Create custom date format in Excel
New Excel TAKE function.
Insert multiple subtotals into your spreadsheet.
Excel Short: Column Width Hack Will Change Your Life
