SimonSezIT.com - We Teach IT. You Learn IT.

Tips, podcasts, advice and free video tutorials.

Entries Tagged ‘Excel Formulas’

How to Use the Vlookup Function in Excel 2007

Nov.29, 2008 in Excel 2007, Productivity, Video Tutorial Leave a Comment

The Vertical Lookup/Vlookup/Lookup function in Excel grabs information from another location based on some key or value.  Consider the Vlookup function the Excel 2007 lookup workhorse, so it’s important to know how to use it.
Watch our free video tutorial explaining how to use the Excel 2007 Vlookup function.
We have 5 hours of Excel 2007 training [...]

Tags: , , , , ,

How to Use the IF Function in Excel 2007

Oct.04, 2008 in Excel 2007, Video Tutorial Leave a Comment

The IF function in Excel 2007 is the single most powerful command for the non-programmer using Excel. It is a real powerhouse! Using the Excel IF functions offers a quick and easy method to create logical arguments with the end result of presenting and your analyzing your data from a different perspective.
Creating logical functions [...]

Tags: , , , ,
  

Learn More - Earn More!

Welcome to SimonSezIT.com Tech Tips. Don't forget to visit our main website SimonSezIT.com to subscribe to our online computer training. Only $25 for a 1 month subscription or $147 for an annual subscription. Get unlimited access to all our courses while your subscription is active. Try any of our courses for FREE! Learn Office 2010 Learn Adobe CS5 Learn Windows 7 Learn Dreamweaver Learn Photshop