Cracking the Mystery of Custom Number Formats in Excel. Excel has many built-in formatting options that you can apply to your information. These range from Number, Currency, Accounting, Date, Time, Percentage, etc to name just a few. But what do you do if you cannot find the exact format you want to apply to your information? Why you create your own custom format that’s what. To create your own […]
Do you need to Merge that? There are a number of “basic errors users make in Excel” that results in their spreadsheet life being that much more challenging when it doesn’t necessarily need too. One of these, which we are discussing today, is the use (or unnecessary use) of merged cells in an Excel spreadsheet. Why Merge Cells? Merging cells in a spreadsheet is a process that […]
D.A.R.E. to be different! A common misconception when it comes to learning about Excel and how to use it is that it is all about how do I use and implement all these functions and their capabilities. This misconception is further compounded by the fact that most Excel training just simply teaches you new functions and capabilities and does not dive into the VERY important stages that you need to […]
How to shade alternate rows with Conditional Formatting I regularly work with large sets of data. One quick and simple “trick” I use ALL the time is to shade every alternate row in the data to make it easier to read. If you look at the example below, by itself, it is a very visually unattractive spreadsheet, full of lots of data that is hard to read. We can […]
