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

Split text to columns using LAST delimiter only in Get & Transform

Excel format painter- single or multiple cells

Revert to original sort order? Add an index column in PowerQuery

Copy every nth row to another sheet in Excel

Excel Find & Replace with wildcard characters (* and ?)

Excel 2003 Inserting cell errors- The spreadsheet errors caused by inserting cells (not rows)

Combine multiple cells into one separated by comma etc in Excel

Jump to last sheet in Excel (button missing?)

Replace problem commas to fix #VALUE errors in Excel

Fill in empty cells with the cell above- formula based template

Find ALL external links in Excel -incl the Break Links that dont work

Build errors checks into ALL spreadsheets- Ensure integrity in Spreadsheet Best Practice

Fill in blank cells in Excel with value above

Hide blank rows in Excel with a button

Grouping by weeks in a Pivot Table

Change cell colour based on value in cell

Excel chart columns with no gaps

Create your own chart template for re-use in Excel 2007- same as the latest versions of Excel

Force Excel text to fit into a cell (shrink it)

Reusable charts in Excel- chart templates to save time

Group dates in Pivots in weeks #excelpivottable #youtubemadeforyou

Decrease the indents on multiple cells at the same time in Excel

Create unique items list & count duplicates using Pivot Tables

Pivot Tables Row Labels in Excel 2007

Excel 2007 Pivot Tables- Column labels can do everything row labels can do- same in latest versions

Customize column fields in a Pivot Table

To change data source disconnect filter controls in Pivot Tables

Remove duplicates but keep first instance in Excel (formulas- NO VBA)

Extract the text BETWEEN two delimiters in Excel

Conditional format Pivot Tables with wizard colors (good/ bad)

Stop Excel notes from moving/ shrinking/ expanding

Use multiple characters as delimiter in Excel Text to Columns

Move columns in Excel without overwriting

Percentage of subtotals WITHIN a Pivot Table

Add the plus symbol in front of a number in Excel

3D formula using different cells on each sheet

Excel WORKDAY function not working

Run WhatIfs in Excel 2003 with 1 one or two variable data table

Paste special examples in Excel

Find errors in Pivots, Charts, Cond. Formatting & data validation

Excel main window options- scroll, minimize, freeze rows/ columns

Split account number and account name into 2 columns in Power Query

Find all the external links in Excel. See related video link below

Stop the format painter from formatting every cell you click on

Copy formula WITHOUT cell reference change- $ signs in XL formula

Compare month and year in Excel dates (ignore the day)

Select Visible cells tool built into Excel

Copy Paste cells so that cell references dont change

Data Tables slow down Excel open/ close of files