Tweet

Get a feed of new tips directly to your outlook

Worksheet Functions

• Add 2 Strings Together In Excel
• Add a Link To Email
• American Date To Proper Date
• Analysis Toolpak
• Calculating Proportions With COUNTIF
• Copy Sheet To New Workbook
• Does A Cell Contain A String
• File Path Formula
• Function To Return The Worksheet Name
• Format Text In A Cell
• Get Initials From Name
• How Many Times Does A Letter Appear In A Cell
• IRR Internal Rate Of Return
• Moving Averages
• Nth Largest Value In A Range
• Random Numbers RANDBETWEEN
• Random Sort In Excel
• Remove Non-Numeric Characters
• Reverse A Name
• Select All Text In A Cell
• Small Numbers In Excel
• Use Inverted Commas In Excel Formula
• Using The LEN Function In Excel
• VLOOKUP
• VLOOKUP INDEX MATCH

Worksheet Operations

• Autofit Selection
• Align Shapes
• Capture Screen Shot Of Excel
• Camera Tool
• Cause Of Big Excel Files
• Create Numbers 1 To 10
• Center Text Across Cells
  
• Change Values On Multiple Sheets
• Conditional Formatting
• Copy And Paste The Same Formula
• Copy Down
• Create Range Names Quickly
• Data Validation For Percentages
• Data Validation Part 1
• Debugging Large Excel Function Calls
• Deleting Sheets
• Display All Range Names
• Display Function Arguments
• Display Excel File Path
• Easily Change The Print Area
• Enter Array Formula
• Find And Replace Across The Whole Workbook
• Find Broken Links
• Find The Last Cell For Non Contiguous Range
• Fix Corrupt Spreadsheet
• Keep Your Headings In View - Freeze Panes
• Keyboard Shortcut To Open Excel
• Function Debugging Using F9
• Helpful Hints On The StatusBar
• Hiding Sheets
• Insert Alternate Blank Lines
• Inserting Rows And Columns
• Launch Excel Using The Keyboard
• Modify Array Formula
• Multiply Formulas By 100
• Need Help With Excel
• Open Excel Safely
• Paste As Hyperlink
• Paste Special Values
• Pasting Values
• Remove Dupes With Multiple Columns
• Remove Duplicates From A Sorted List
• Remove Unwanted Characters
• Replace The * Character
• Save As Web Page
• Select Current Region
• Separate Text
• Sheet Navigation With Lots Of Sheets
• Show Formulae
• Toggle The Screen Lock In A Function
• Useful Excel Shortcuts
• Using Go To
• Why Is My Excel File So Big ?
• Wrap Text For Headings

Date / Time

• Calculate The 1st Day Of The Month
• Calculate The Last Day Of The Month
• Create All The Days Of The Week In 5 Seconds
• Date Formatting Show The Day Of The Week
• Difference Between 2 Dates
• Last Friday In The Month
• Tell The Time In Excel
• Toggle Date Format

Calculation

• Calculation In Excel
• Slow Calculation Excel
• Ways To Calculate In Excel

Pivot Tables

• Introduction To Pivot Tables
• Pivot Tables For Dummies

Charting

• Dynamic-Charting
• Put Chart On A New Sheet
• Copy Charts To Powerpoint