Click on the blue links to view or download
Email me if you want to subscribe:

Excel Tips March 2021
Collapse Columns or Rows
Compare lists
     With a shortcut
     Using a menu
     Conditional Formatting
     Use the COUNTIF function
Creating and Using a Cell Name (Part 1)
Creating and Using a Range Name (Part 2)
Replace the wildcard problem
March 2021 Excel File

Excel Tips February 2021
The easiest way to enter a check sign P
Show/Hide Formulas
How to fill blank cells with value above
Animate your charts
Dynamic Row or Column Numbers
IS Functions
February 2021 Excel File

Excel Tips January 2021
Get rid of a letter or symbol
Three ways to extract dates from text
How to embed an excel object in word or ppt     
Rounding to the nearest 1000
Autofill dates with options
Compare lists
Nested if or VLOOKUP
January 2021 Excel File

Excel Tips December 2020
Binary Files Reduce File Size
CTRL + Number Shortcuts
Prefill a Cell
Select a range – a different way
Data validation
Display circles around invalid data
Filter using Colors
Check for Errors

December 2020 Excel File

Excel Tips November 2020
Four Ways to Hide/Show the Full Ribbon Menu
Insert Header and/or Footer
Get the Function Menu
Show the Status Bar
Remove Duplicates
Eliminate Link
Format Painter for the Entire Sheet
Food Conversion Table
November 2020 Excel File

Excel Tips October 2020
Evaluate Formulas
Frequently used Financial Ratios
Making an Exact Copy of a Range of Formulas
Show/Hide Formulas
Time Stamp in Excel
Go to a Specific Sheet with Right Click
Helpful Reference Functions
October 2020 Excel File

Excel Tips September 2020
AUTOSUM Shortcut
Entire Workbook Search
COUNTIF for entire columns
Formatting Time to Get the Correct Values
Turn a Date into a Weekday
Handy Shortcuts
To Turn On the full view of your clipboard
September 2020 Excel File

Excel Tips August 2020
Hide the Rest of the Sheet
Sort Left to Right             
Keep the last names only
Select Precedents and Dependents
CTRL Number Shortcuts
Week Long Formula
Remove Duplicates
Apply color to alternate rows
Excel August 2020 File

Excel Tips July 2020
Copy Here as Values Only
Fixing Gaps on Date X-Axis of Charts
Delete all Errors Simultaneously
Text Function Chart
Display Positive (+) and Negative (-) Signs in Cells
Helpful Formatting ideas: Display Units and Hide Contents
Excel July 2020 File

Excel Tip June 2020
Display the Auto-Complete list
Autofill Menu
Autofill with the CTRL key
Go to (Fast) to a Cell
Jumping to the Next Corner: Ctrl+. (Period)
Formatting Elapsed Number of Hours
Two Ways to Wrap Text
Multi-Tier x Axis on chart
Excel June 2020 File

Excel Tips May 2020
Add a secondary axis to a chart
Move a Formula to another Sheet
Fast navigation
Pinning frequently used files in Excel
Rounding functions
Nth Root
Excel May 2020 File

Excel Tips April 2020
Double click the Format Painter for multiple use
CONVERT function (time, distance, energy and many more units)
The DATEDIF function (compute the difference between two dates – years, months, etc.)
Bullets in Excel
Replace all Errors in a Range
Sheet Background Picture
Excel Apr 2020 File

Excel Tips Mar 2020
Comparing Lists Shortcut
Edit, Fill and Justify
Align Decimals Numbers
Change Font Case
Format Millions
Formatting Dates and Time
Jump to any Cell
Excel Mar 2020 File

Excel Tips Feb 2020
The CELL Function
The LEN Function
The FIND Function
The RIGHT Function
Display the Sheet Name in a Cell
The PMT (payment) function – paying off a loan
The PMT (payment) function – as a Sinking Fund
Excel Feb 2020 File

Excel Tips Jan 2020
Copy Addresses from Excel to Your Email-Message Address Line
Two Ways to Hide Data in a Cell
Use Drag and Drop to Convert Formulas to Values
Copy Sheet by Dragging
Getting the Check Sign P
Remove Hyperlinks

Excel Tips Dec 2019
Hide Data in a cell
Input Values Starting with 0
Shrinking Text to Fit Cells
Custom Format ( meters, feet, miles, etc.)

Email me if you want to subscribe to the email list: