Column vs Bar Charts in Excel
A Column chart walks into a Bar chart … sorry, I couldn’t resist that. Column charts are one of the most popular and straightforward of Excel’s many chart types. Its close cousin is the Bar chart. (more…)
Joining Text in Excel the quick and easy way
The CONCATENATE function is redundant. You don’t to need to use it. There is a much quicker and easier way to join text together. (more…)
Loan summaries made easy in Excel
Excel’s built-in finance functions allow you to perform interest and repayment calculations quickly and easily. The PMT function allows you to calculate the monthly repayment on a personal loan or a mortgage. (more…)
How and why you should use Check Boxes in Excel
Check boxes make selections easy. Excel has a number of useful controls that can be added to sheets to improve the user interface. These include check boxes (tick boxes), option buttons and spinner controls. (more…)
Excel – Find and Replace for formats
Excel’s Find and Replace is quick and powerful. It’s great for replacing text. Did you know you can also use it to replace formatting? Well you can in Excel 2007 and Excel 2010. (more…)
Make the SHIFT with Excel
Using the SHIFT key in Excel can speed up range selection and make other tasks easier. Some of these tips will also work in Word and PowerPoint. (more…)
How to see the old Print Preview in Excel 2010
Excel 2010 introduced the File tab with its new Print Preview screen. Many users don’t like this new layout and want the good old fashioned Print Preview screen they are used to. As with many features in Excel, it’s still there, you just need to find it. (more…)
Customizing Excel 2007 and 2010 [VIDEO]
Excel 2007 introduced the new interface called the Ribbon. It’s a cross between a toolbar and a menu. It also has a Quick Access Toolbar (QAT) that many people don’t seem to be using. (more…)