Excel has great charts to help you visual your numbers, but it can also allow you to use flowcharts to help visualise numbers in a different way and help explain relationships between numbers and how they are formulated.
Here’s the problem. You have a list of parts and prices, you want to manually update each price and you want the format to change for each price that has been updated. How can you do it?
Using numbers in automated text sentences can be frustrating. Typically you don’t want to display decimals, but you do want to use the comma format.
Excel has had an AutoCalculation feature for many versions. This means you can see the result of common functions without typing a single formula.
The Format As Table feature has many useful features that are worth taking advantage of. The previous post listed them. The video of this blog is shown at the bottom of the post.
Templates allow you to create blank sheets and blank workbooks that have customised formats as well as customised Page Setup settings, including headers and footers.
The new FORMULATEXT function in Excel 2013 will make my Excel training job a little easier. It also has a formatting use.
Keyboard shortcuts can really speed up your work in Excel. Here are some of my favourites that use the Ctrl key. I’ll share some more in later blog posts.
Styles are an underrated feature in Excel. They provide an easy way to achieve consistent formatting throughout a workbook.
Word has a keyboard shortcut to convert lowercase to uppercase. Shift + F3. Excel doesn’t. Macros to the rescue again.
I get many questions from Australian CPA’s and sometimes the solution involves a macro. Not everyone knows how to install and run a macro. This post will take you through the basics.
It’s amazing how passionate some people can be about zeroes. I have known people who hate, with a passion, to see zeroes displayed in their reports. They will sometimes use some formula acrobatics to avoid having a zero displayed.
Excel’s Go To feature provides a quick way to select certain types of cells. For example, if you wanted to apply the same fill colour to all formula cells on a sheet, you can do that in five easy steps using Go To.
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.
The shortcut is
Alt + Enter
To insert a line break within a cell hold down the Alt key (next to your space bar) and press Enter. This inserts a fixed line break within the cell.