During episode 11 of the SimonSezIT Tech Show podcast, I’ll answer some listener’s emails, including how to determine the number of days between two dates. This podcast includes 2 new video tutorials:
1) How to use the date and time function in Excel 2007.
2) How to erase Google Toolbar search history.
I also review to web hosting [...]
Excel 2007 uses .xlsx file format for saving files by default, which makes it difficult to share with others who don’t use Excel 2007.
To default your saved Excel 2007 files to save to the .xls extension, follow these steps:
Click the Office button in the top left corner.
Click the Excel Options button.
On the left-hand side, select [...]
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 [...]
There are some marvelous things you can do with the Text function in Excel 2007. There are functions that were convert your text into upper case or all capitals, lower case, and proper – which will turn all case into proper case. Using the Text function in Excel is easy to learn and another great [...]
The Auto Fill handle in Excel 2007 is a nifty way to quickly auto-complete or auto fill data on your spreadsheet. For example, you can use the auto fill handle to complete months, days of the week, even numbers. This is an often overlooked productivity tool in Excel and remember: Excel is designed to save [...]
