How to Reset or Unfreeze an iPad

by File in: Computer Tips

Previously, I wrote up a popular post on how to reset or unfreeze a frozen iPod, which happens a lot! It’s clocking in over 500 comments so far! Now with the iPad out, you might run into the problem of your iPad becoming unresponsive or frozen! This can happen in different ways, such as one […]

Use Excel to Figure Out an Effective Interest Rate from a Nominal Interest Rate

by File in: MS Office Tips

Among Excel’s more popular formulas, the EFFECT formula is often used by financial professionals to figure out an effective interest rate from a nominal interest rate. Also called annual percentage rate (APR) and annual percentage yield (APY), Excel makes it easy to calculate effective mortgage, car loan, and small business loan interest rates from the […]

AutoFit Column Widths and Row Heights in Excel

by File in: MS Office Tips

Excel’s grid-like appearance can seem static at times without the possibility of creating customized interfaces to match the needs of the data stored in a worksheet. Although this is true to some extent, Microsoft has built into Excel the ability to instantly customize column widths and row heights to match the size of the data […]

How to Connect a Projector to a Windows PC

by File in: MS Office Tips

Since Windows 7, one feature that’s been greatly enhanced in Windows is the ability to instantly connect a projector using different options depending on your needs. Using a simple keyboard shortcut, you can quickly duplicate your screen, extend it or just have it appear on the projector only. In this article, I’ll show you how to […]

Add Headers and Footers to a PowerPoint Presentation

by File in: MS Office Tips

Although PowerPoint presentations are usually displayed on a screen, they are just like other documents in the Microsoft Office suite such as Word, Excel, and Publisher. Just like those other applications, you can add custom headers and footers to a PowerPoint presentation to display a variety of important information. Why Display Headers and Footers in […]

Add a Cover Page to a Word Document

by File in: MS Office Tips

As any good writer will tell you, the presentation of your work is as important as the content. Consequently, if you want people to perceive your work as professional, you need to make it look good too. Using Word’s built in cover page feature, you can add a professional looking cover page to any document. […]

Adjust Gamma, Brightness, and Contrast on a LCD Monitor

by File in: Free Software Downloads

ATI and NVIDIA are locked in a war for top place in the graphics card  market. AMD’s relatively recent acquisition of ATI has given the company a slight edge over its competition. As part of the marketing process, both companies not only innovate newer and more powerful graphics chips, they also struggle to provide an […]

Add a Linear Regression Trendline to an Excel Scatter Plot

by File in: MS Office Tips

Although Excel is capable of calculating a number of descriptive and inferential statistics for you, it is often better to show a visual representation of data when presenting information to a group. Using Excel’s built in trendline function, you can add a linear regression trendline to any Excel scatter plot. Inserting a Scatter Diagram into […]

How to Add Action Buttons to a PowerPoint Presentation

by File in: MS Office Tips

Found in a strange place in the application, you can add action buttons to a PowerPoint slide to make your presentation more interactive and easier to use for the viewer. These action buttons can make a presentation simpler to navigate and make the slides in your presentation behave like web pages. Before you add action […]

Dealing with Too Many Fonts in Windows?

by File in: Computer Tips

Unknown to some Windows users, it’s the operating system that stores and manages fonts on a computer, not the individual applications that make use of them. Still, with each application you install on your computer such as word processors and desktop publishers, more and more fonts accumulate on your PC. It’s entirely possible for you […]