599CD.com Access Imaging Seminar Done   Collapse Menus
 
 
NEW Courses - Access Imaging, Excel 2007 Level 5 dismiss
 
   
 

What's New?  |  Courses  |  Theater  |  Demo  |  Tips  |  Blog  |  Forums  |  Search  |  Help  |  Order
 
What do you want to learn today? 
 
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  SUMIFS Function   One of the new functions in Excel 2007
NEW  Get External Data   Pull real-time stock data from the Web into your sheets
NEW  Overtime Pay   Calculating time-and-a-half and double-time pay
Rank Function   Rank monthly sales from 1 to 12
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
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:

 

 

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

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?

599CD on Facebook  599CD on Twitter  Subscribe to RSS Feed  Add to Live Bookmarks  Add to My AOL  Add to MyYahoo  Add to Google Reader or Homepage    hide help

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