126 тысяч подписчиков
1.5 тысяч видео
Copy email addresses from Outlook to Excel & separate name and address
Paragraph row in Excel cells. Create new line within a cell
Paste Excel to Word WITHOUT gridlines
Convert text to value- force Excel to treat time as number
Excel filter not working after certain row
How to put m2 in Excel
Pivot Table row labels in separate columns
Excel show plus (+) or minus (-) sign in front of percentage (or number), and make 0% appear as -
Excel date formatting NOT working? Dates not sorting in Excel?
Use Excel AI to pull email address into seperate column
Combine 2 rows into single row containing required Excel information
Excel CSV opens up in one column instead of separate columns
Excel copy paste without changing formula
Split text after FIRST delimiter only with Excel functions
Excel
Group number lists into text based categories in Excel
Extract text/ number AFTER last space in Excel
Split Excel cells based on line breaks
Automatic deletion of duplicates in Excel with NO VBA
Hide zero values in chart labels- Excel charts WITHOUT zeros in labels
Excel not allowing insert rows/ columns with message
Easily build functions and formulae in Excel with the Function wizard
Remove rows with subtotals/ totals in Excel data set
Pivot Table headings that say column/ row instead of actual label
Enter Date/ Time shortcut in Excel- input the current date/ time as a stamp (doesn't change)
Excel spell check very slow? Speed it up- works with goalseek too
Fill blank cells in Excel from the one above + merge cells issue
Pause/ disable conditional formatting in MS Excel (On/ Off switch)
Text to columns in Excel with multiple spaces (formula splitting)
Convert the month number into the month name e.g. 7 to July.
Fill blank cells in Excel with IF formula
Check if cell CONTAINS text from list in Excel
Automatically insert blank rows between data in Excel
Do quick calculations in Excel (without pulling out a calculator)
Fix ####,
Create remove duplicates template that is automatic (no VBA)
Force currency amount in Excel to appear in text with currency symbol
Split columns by delimiter in Excel Power Query
Remove line breaks from cell in Excel -Unwrap the text in a cell
Auto change the color of tick and cross in Excel
Tick/ cross option in Excel dropdown lists
Duplicates over multiple columns in Excel
Splitting text in Excel cells/ Remove characters from left or right
Drop-down list without data validation
Excel error check to determine if any of the other error checks have been triggered
Copy data validation to other cells with data in
Create a variable moving average formula in MS Excel
Formula to split text in Excel into separate columns
Use tick/ cross inside an Excel IF function
Add multi level labels to horizontal axis in Excel e.g. mth & qtr & yr
Excel date format dd.mm.yyyy not working
Text to columns fixed width Excel template (formula based)
Excel date risks where US and UK date formats are mixed together
Finding the typical IF errors in MS Excel spreadsheets in order of likelihood of a spreadsheet error
Quick list comparisons with Pivot Tables
Excel icon sets not working properly- Control conditional format icons
Resize Excel scroll bar to smaller sized spreadsheet
Excel CSV change delimiter and date format
Sorting COLUMNS in Excel, NOT the traditional sort by rows
Use Excel's AI to split your text into columns
Find spaces in Excel. Quick ways to find and remove unwanted spaces.
Calculate overtime hours in Excel