AuditExcel Advanced Excel and Financial Model Training and Consulting

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