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

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

Rank a number in Excel against a list to see where it ranks (top to bottom or bottom to top)

Sum all the negative numbers only in Excel. Easily add up numbers that are all negative or positive

Data Cleanup Fundamentals- first steps in Excel data scrubbing

SUM function not working

Protect Excel BUT allow filtering, sorting and pivoting

Text to columns in Excel. Wizard to help you split a column into multiple columns

Split columns using fixed width in Power Query (even if fixed width looks wrong)

Find text, numbers, formula references and replace them with different items in Excel 2003

Names in Excel (quick split, combine, reverse)

Fit text into cell WITHOUT wrap text

Excel Text to Columns, keep leading zeros, fix dates

Find all range names (including hidden named ranges) in Excel. See related link below

Data Cleaning Techniques in Excel- Categorize lists with misspelling

Automatically change text cases in Excel 2003 from current tExt to UPPER, lower or Proper case.

Stop users from inserting deleting row in Excel- 2 ways- with/ without using normal protection tool

Shortcut to building nested formula in Excel

Where is old Text Import Wizard in Excel

Automatically fill blank cells with cell above/ below with PowerQuery

Excel copy paste without changing formula

Split text after FIRST delimiter only with Excel functions

Excel