Excel 2010/2013 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Tutorials   News   Tips   Templates   Forums   Help   Logon   Order More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

 Access   Excel   Word   Windows   FrontPage   Hardware   Misc

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

 3/5/2013 Excel Tip: Price Markups 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 8/18/2010 Excel Tip: Breaking Up Text Strings 11/11/2009 New Excel Tip: SUMIFS Function 11/11/2009 Excel Tip: Get Data from a Web Site 11/1/2009 Excel Tip: Overtime Pay 9/29/2009 Excel 2007 Copy & Paste Link 9/25/2009 Excel Tip: Rank Function 8/27/2009 Excel Tip: Running Totals 6/11/2009 New Excel Video Tip - Count Work Days 3/30/2009 Excel Tip: Complex IF Function Example 3/27/2009 Enhanced Conditional Formatting in Excel 2003 3/25/2009 Excel Tip: SUMIF, COUNTIF 10/1/2008 Excel Tip: Conditional Formatting 9/21/2008 Excel Tip: Month Names 9/11/2008 Excel Tip: Count Items Between Dates 8/13/2008 Excel Tip: Difference in Hours 7/25/2008 Excel Tip: Adding Dates & Times 5/19/2008 Excel: Separating Time & Date 5/13/2008 Excel: Aged Accounts Receivable 4/28/2008 Excel: String Concatenation

Learn

 Microsoft Access index Microsoft Excel index Microsoft Word index Microsoft Windows index Microsoft PowerPoint index Adobe Photoshop index Visual Basic index Active Server Pages index Online Seminars More...
Customers

Online Theater
Insider Circle
Info

Latest News
New Releases
User Forums
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Help

Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services

Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order

Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact

Live Chat
General Contact Info
Support Policy
Contact Form
Email Us