Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Microsoft Excel Tips

 Beginner

New: Price Markups Marking up prices using copy & paste values

Copy & Paste Link Link cells in multiple sheets, create a summary page
Overtime Pay Calculating time-and-a-half and double-time pay
Conditional Formatting How many days late invoices, TODAY() fn
Autosum Button not always working
Sorting Data in Excel
What's New in Excel 2010 Learn all of the cool new features

 Expert

Difference Between Two Dates How to calculate the difference between two date values
Difference Between Two Times How to calculate the difference between two time values
SUMIFS Function With Criteria Another SUMIFS example, add numbers between two values
Difference in Times This is my older tip on time differences, but still worth a read
SUMIFS Function One of the new functions in Excel 2007
Breaking up Text Strings Change "Joe Smith" into "Joe" and "Smith"
Rank Function Rank monthly sales from 1 to 12
MATCH and INDEX Functions Lookup with multiple criteria
2D Matrix Lookups Another example using MATCH and INDEX
Get External Data Pull real-time stock data from the Web into your sheets
Running Totals Relative v. Absolute References
Number of Work Days NetWorkDays, Custom VBA Function
Complex IF Example Example of IF function with dues structure
Extended Conditional Formatting More than 3 options w VB
SUMIF and COUNTIF adding and counting values conditionally
Month Names from Dates Month Fn, Named Range, VLOOKUP
Count Records Between Two Dates IF, AND Functions
Using VLOOKUP / HLOOKUP to find a value
Using the IF function to calculate sales tax

 Tips from the 599CD Blog

 4/4/2021 Text to Columns 3/15/2021 VLOOKUP in Access 2/17/2021 Old Excel 2003 Outlines 2/17/2021 Excel Expert Outlines 2/17/2021 Excel Beginner Outlines 2/4/2021 Free Beginner Courses 12/26/2020 Import New, Changed Records 12/13/2020 Duplicates Conditional Formatting 12/3/2020 Access v Excel 8/18/2020 Excel Expert 11 Lessons 8/17/2020 Excel Courses 8/17/2020 Excel Expert Courses 8/15/2020 Excel 2010 Beginner 1 8/15/2020 Worksheet Change 8/14/2020 XLOOKUP Function 8/14/2020 Excel TechHelp 7/27/2020 How to Get Microsoft Excel for Free 5/25/2020 Excel Expert 11 5/20/2020 Excel My Name is Richard 5/18/2020 Excel Expert 11 Outline 5/18/2020 Excel Expert Level 11 5/4/2014 Microsoft Access Expert 20 3/5/2013 Excel Tip: Price Markups 2/3/2013 Signed Copies of my Excel Book 9/27/2012 Excel Expert 10 Handbook Ready 9/18/2012 Two New Excel Tips: Date/Time Differences 6/20/2012 Excel Tip: Sum Cells Between Two Values 6/16/2012 New Excel Tip: Paste Link 3/26/2012 Excel Tip: 2D Matrix Lookups 11/18/2011 Dashboards in Excel 10/6/2011 Excel Expert 11 On Hold 10/1/2011 Excel 2010 Expert 10 8/22/2011 Two New Excel Handbooks Posted 8/9/2011 Excel 2010 Expert 9 7/20/2011 Help Me Decide on Excel Topics 7/20/2011 Excel 2010 Expert 8 7/19/2011 Excel Expert 8 Recorded 6/14/2011 Excel 2010 Expert 7 6/8/2011 Excel 2010 Expert 6 6/6/2011 Excel 2010 Expert 5 6/4/2011 Excel Expert 4 Handbook Released 5/24/2011 Two new releases today 5/24/2011 Excel 2010 Expert 4 5/18/2011 New Excel Handbooks Added 3/21/2011 Excel 2010 Expert 3 3/21/2011 Excel 2010 Expert 2 3/21/2011 Excel 2010 Expert 2 & 3 Finished 3/19/2011 Excel 2010 Expert 1 Now Available 3/19/2011 Excel 2010 Expert 1 2/21/2011 Excel 2010 Beginner 5 is Online 1/30/2011 Complete Idiot's Guide to Excel 1/26/2011 Excel 2010 Beginner 4 is recorded 1/12/2011 Excel 2010 Beginner 3 is in the can 12/27/2010 Excel 2010 Beginner 2 Online 11/19/2010 Excel 2010 Now Available 8/23/2010 Working on Excel 2010 Videos 8/18/2010 Excel Tip: Breaking Up Text Strings

By Richard Rost