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

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network Access AI Bot ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

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

 5/31/2024 Excel Automation 2 5/30/2024 Excel Automation 5/28/2024 Excel Automation From Excel 5/28/2024 Excel Automation 3 5/24/2024 Excel Automation 2 5/23/2024 Excel Automation 5/23/2024 Excel Automation 3/20/2024 Default Template 1/12/2024 Colored Data Bars 1/11/2024 Color Scales 1/10/2024 Data Bars 11/4/2023 Daylight Saving Time 10/1/2023 VB.NET Expert 2 9/18/2023 Access EOMONTH 9/11/2023 Automated Import 9/8/2023 Automated Export 9/7/2023 Export to Excel 8/29/2023 MCA Loan Calculator 8/4/2023 Expense Tracker 7/19/2023 Account Balances 2 7/18/2023 Account Balances 1 4/17/2023 Military Time Import 4/12/2023 Timestamp 4/7/2023 Excel VBA 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

By Richard Rost