Free Microsoft Office Training and Tutorials Blog




    



12 Excel Tips and Articles

Here are 12 Excel Tips and Learning Articles, from 599cd.com, that will help you learn the the following Excel functionality: VLOOKUP / HLOOKUP Functions, IF Function, Autosum Button, Sorting, Working with Dates and Times, String Concatenation, and a Button to Change Values. 


6 Excel Tips:

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 


6 Excel Learning Articles:

Excel: Separating Time & Date
Excel: Aged Accounts Receivable
Excel: Days Between Dates
Excel: String Concatenation
Excel: Button to Change Value
Excel VLOOKUP Function


Page :  1