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

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   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

 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab 8/10/2022 Transpose 7/26/2022 Lottery Numbers 2 7/22/2022 Lottery Numbers 6/30/2022 Sales Chart 6/17/2022 Fast AutoSum 2/22/2022 ISO Date Format 1/27/2022 Work Days 1/11/2022 Excel Fast Tips 1/7/2022 Count Cells by Color 1/7/2022 Excel VBA 1/7/2022 Excel Count by Color 12/26/2021 Conditional Formatting 12/9/2021 Excel 2003 Quick Start 1 12/9/2021 Excel 2003 Expert 232 12/9/2021 Excel 2003 Expert 231 12/9/2021 Excel 2003 Expert 230 12/9/2021 Excel 2003 Expert 224 12/9/2021 Excel 2003 Expert 223 12/9/2021 Excel 2003 Expert 222 12/9/2021 Excel 2003 Expert 221 12/9/2021 Excel 2003 Expert 220 12/9/2021 Excel 2003 Expert 202 12/9/2021 Excel 2003 Expert 201 12/9/2021 Excel 2003 Beginner 104 12/9/2021 Excel 2003 Beginner 103 12/9/2021 Excel 2003 Beginner 102 12/9/2021 Excel 2003 Beginner 101 12/9/2021 Excel 2007 Beginner 5 12/9/2021 Excel 2007 Beginner 4 12/9/2021 Excel 2007 Beginner 3 12/9/2021 Excel 2007 Beginner 2 12/9/2021 Excel 2007 Beginner 1 12/9/2021 Excel Expert 11 12/9/2021 Excel 2003 12/9/2021 Excel 2007 12/8/2021 Excel Expert 11 12/8/2021 Excel Expert 10 12/8/2021 Excel Expert 9 12/8/2021 Excel Expert 8 12/8/2021 Excel Expert 7 12/8/2021 Excel Expert 6 12/8/2021 Excel Expert 5 12/8/2021 Excel Expert 4 12/8/2021 Excel Expert 3 12/8/2021 Excel Expert 2 12/8/2021 Excel Expert 1 12/8/2021 Excel Beginner 5 12/8/2021 Excel Beginner 4 12/8/2021 Excel Beginner 3 12/8/2021 Excel Beginner 2 12/8/2021 Excel Beginner 1 11/30/2021 Import Multiline Cells 11/11/2021 Link to Excel 11/11/2021 Read Write Excel Data 11/10/2021 Excel Moving Average 9/11/2021 Circular References 8/25/2021 Stock History 8/23/2021 Concatenation 8/17/2021 Flash Fill 8/5/2021 Stock Portfolio 8/4/2021 Stock Portfolio 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 1/2/2021 Excel Expert Courses 1/1/2021 Excel Beginner Courses 12/26/2020 Import New, Changed Records

By Richard Rost