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.
The CONCATENATE function is redundant. You don’t to need to use it. There is a much quicker + easier way to join text together.
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.
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.
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.
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.
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.
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.