Welcome to episode 6. During this podcast, I discuss different types of Malware including Worms, Trojans, Adware, Botnets and other nasty things that can infect your computer. We computer geeks are notorious for throwing these terms with the assumption that everyone knows what we are talking about. During this podcast I explain different types of [...]
The Side-by-Side view in Word 2007 is a great option to view two Word documents for comparison reasons. You can also lock the scroll bars so when you scroll, the scroll bar for both documents will move at the same time. This is called Synchronous Scrolling, which you turn-on by clicking on Synchronous Scrolling [...]
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 [...]
In this lesson, we will introduce two popular Excel 2007 financial functions: the Payment function and the Future Value function. Excel has many financial functions, and if you are new to financial functions in Excel, the Payment and Future Value functions are excellent way to build a comfort level with these functions.
The Payment function is [...]
During in our previous tutorial, we discussed how to use the IF Statement. Let’s make it a little more complicated by using the Nested IF function in Excel. The Nested IF function extends the power of the IF statement, allowing you to create Excel reports and spreadsheets that are even more detailed and granular.
Creating logical [...]
