599CD Tips & Tricks - - 599CD.com

599CD.com

New Access Seminar: Web Data

Collapse Menus

NEW Access Seminar - Use Access with the Web!

dismiss

What's New? \| Courses \| Theater \| Demo \| Tips \| Blog \| Forums \| Search \| Help \| Order
Computing \| Microsoft \| Graphics \| Finance \| Web Design \| Programming
Microsoft Windows \| Using the Internet \| Digital Photography
Windows \| Word \| Excel \| Access \| FrontPage \| VB \| PowerPoint \| Outlook \| Seminars
Adobe Photoshop \| Digital Photography
Microsoft Excel \| QuickBooks \| Seminars
FrontPage \| HTML \| Internet \| Active Server Pages \| Digital Photo \| Seminars
Microsoft Access \| Visual Basic \| ASP \| Seminars
About 599CD \| FAQs \| Account & Order Status, Passwords \| TechHelp \| Forums \| Contact Us
Microsoft Excel 101 102 103 104 201 202 220 221 222 223 224 230 231 232 Topic Index NEW: Excel Forum
Microsoft Access Beginner Intermediate Advanced Recordsets Seminars Topic Index NEW: Forum
101 102 103 104
201 202 203 204 205 206 207 220 221 222 223
301 302 303 304 305 306 307 308 309 310 311 312 313
320 321 322 323 324 325 326 327 328 329
Microsoft Windows 101 102 110 120 121 201 Topic Index Windows Vista 101 102 NEW: Windows Forum
Microsoft Word 101 102 103 201 202 203 204 205 Topic Index NEW: Word Forum
Microsoft FrontPage 101 102 103 201 202 Topic Index NEW: FrontPage Forum
Microsoft Visual Basic 101 102 103 104 105 106 107 201 202 Topic Index NEW: Visual Basic Forum
Adobe Photoshop 101 102 103 201 202 203 204 205 Topic Index NEW: Photoshop Forum
ASP 101 102 103 104 201 202 301 302 303 304 Topic Index NEW: Active Server Pages Forum
Microsoft PowerPoint 101 102 103 104 201 Topic Index NEW: PowerPoint Forum

New Tips Added Weekly. Get Notified of New Tips & Tricks.

Tips & Tricks

Access Excel Word Windows FrontPage Hardware Misc

Excel. Click here for our complete Microsoft Excel course listing

	Topic
NEW	Number of Work Days NetWorkDays, Custom VBA Function
NEW	Complex IF Example Example of IF function with dues structure
NEW	Extended Conditional Formatting More than 3 options w VB
	SUMIF and COUNTIF adding and counting values conditionally
	Conditional Formatting How many days late invoices, TODAY() fn
	Month Names from Dates Month Fn, Named Range, VLOOKUP
	Count Records Between Two Dates IF, AND Functions
	Differences in Times Time Out - Time In = How many hours?
	Adding Dates & Times
	Using VLOOKUP / HLOOKUP to find a value
	Using the IF function to calculate sales tax
	Dealing with ZIP codes that start with zero
	Autosum Button not always working
	Sorting Data in Excel

Huge Discounts Available
When you purchase multiple classes together
Huge savings up to 50% off! Order Now.

You may want to read these articles from the 599CD Blog:

06/11 17:34	New Excel Video Tip - Count Work Days
03/30 04:38	Another Free Excel Video Tip
03/27 17:49	New Excel Video Tip!
03/25 00:46	New Excel Tip: SUMIF, COUNTIF
02/20 16:48	The End of Office 2003 Tutorials?
10/01 01:45	Excel Tip: Conditional Formatting
09/21 16:41	Excel Tip: Month Names
09/11 13:06	Excel Tip: Count Items Between Dates
08/13 12:03	Excel Tip: How Many Hours?
07/25 14:53	Excel Tip: Adding Dates & Times

	Need Help?

Do you have questions about Word, Excel, Access, Web Design, or computers in general? Just ask us anything you'd like.

Get Free Tips & Tricks

Join our mailing list today and get information on our Free Tips & Tricks Newsletter including free video tutorials, eBooks, live seminars, and more.

Email:

Name:

	Type in the word to the left:

Your email will be kept 100% safe and will never be given to 3rd parties.

CLICK HERE for a FREE lesson

Order your first 599CD course now.
Your Satisfaction is Guaranteed!

Subscribe to our RSS Feed. What's This?

Subscribe to RSS Feed

Add to Live Bookmarks

Add to My AOL

Add to MyYahoo

hide help

599CD Home | Learn More | What's New? | Contact Us | Free Demo | FAQs | Order Now | Become an Affiliate | TechHelp | MYOLP | Jobs | Chat | Downloads | Handbooks (Text) | Mailing List | Lost Passwords | Referral Program | Online Poll | Troubleshooter | Corporate / Educational / Government / Non-Profit Sales | Message Forums | Testimonials | Privacy Policy | Tips & Tricks