Sometimes we use software to complete a task out of habit. Yet, in some cases, the job would be better accomplished using different software … with the added benefit of improving our business systems. I’ll give you an example. Say you have a service price list you’d like to give to clients. You format it using […]
Use Excel to make your business data both presentable and functional Read More »
Technology not only helps us in a practical sense, but it can also teach us to look at things in a different way. Let’s take using cell reference within Excel as an example: it’s a very simple formula but this small automation can certainly transform the way you do things. If you work with Excel
Sometimes it’s the simplest things that make the biggest impact, and this is definitely the case when it comes to formatting your Excel spreadsheet. Following are five sure-fire ways to jazz up your Excel spreadsheet, with the least amount of effort. Remember to take into consideration the content of your spreadsheet before trying any of
Five sure-fire ways to jazz up your Excel spreadsheet Read More »
Copy and paste is a popular way to replicate data, but did you know that Excel has a shortcut which does the same thing but in less time? The shortcut I’m talking about is Ctrl+D, and it enables you to copy all data and/or formatting located in the cell immediately ABOVE the active cell. Similar
Does the nature of an Excel spreadsheet – lots of data, displayed in rows and columns – really necessitate drab looking documents? Personally, I don’t believe so. And the good news is that, by working in Page Layout View, making your Excel spreadsheet pop becomes a breeze. Here’s an example. I recently set up a
Have you ever spent time setting up an Excel spreadsheet to then decide it would work better if your data ran horizontally rather than vertically? What do you do? Well, you could copy each cell individually, moving down the column as you go and pasting the data across your chosen row, but this is really
