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

 Tips & Tricks New Tips Added Weekly! Click here to get on our Mailing List

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
Adding Dates & Times
Dealing with ZIP codes that start with zero
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

 6/23/2021 Import Data 5/14/2021 Quick Queries #4 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

By Richard Rost
Click here to sign up for more FREE tips

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Account Login Online Theater Downloads Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey