Excel App – productivity on the go – Card View.
To make it easier to read data on a smaller screen, you can use Card View on the Excel app. Your background data needs to be in a table for it to work. A table is a formal structure in Excel. To put your data into a table choose Format as table from the Home […]
Make your life easier: give a cell a name.
You can give a cell a name in excel. So, rather than being called A5 or E3 the cell could be GST or Total. This makes your formulas easier to understand. See below in the formula bar for an example: AccomodationTotal + ActivitiesTotal + FoodTotal + TravelTotal. This means a lot more to someone reading […]
Save time: Link to a cell
You can insert a link within a cell in Excel. This link could be to a web site, or a place within the spreadsheet. That way you can navigate around the worksheet or even to a different sheet without lots of scrolling and clicking. If you have a large sheet or a workbook with a […]
Quick Information: Use the Status Bar
In the bottom right-hand corner of your Excel sheet is the status bar. When you highlight a group of cells the status bar tells you some information about them, such as the average, count(how many cells have information in them) and the sum. You can add or remove which pieces of information to show here […]
Make your life easier, use shortcut keys in Excel.
Shortcut keys can make your time on Excel much more efficient. Reaching for the mouse or touch pad to do something is definitely slower than using a shortcut key. Also, some of the best shortcut keys saving typing time and are more accurate. It can take a bit of time to get used to using […]
Much more efficient manual entry
As much as I like to automate tasks, and avoid manual entry, sometimes it is unavoidable. But when it is required, it too can be done in an efficient or inefficient way. I see people type into one cell, then use their mouse to click in the next cell to enter the next piece of […]
New Window on the world, or at least on your spreadsheet.
When you want to see two parts of your spreadsheet at once, New Window is what you want to be using. Found in the View menu, in the Window Section. (Shortcut keys Alt, W, N) Activating New Window will open another window to the current workbook almost as if it was another workbook. So now […]
Side by side (With thanks to Harry M. Woods)
You can view two workbooks side by side and scroll them together. Very handy if you are comparing them. View Menu, Window Section, View Side by Side. (Shortcut Alt, W, B) If you have more than one other workbook open, you will then get to choose which workbook you would like to put side by […]
Split: See your spreadsheet differently.
When you want to view two different parts of your spreadsheet at once, you can use Split. Split is found in the View Menu, Window Section. (Shortcut Key Alt, W, S) Split will cut your spreadsheet into four based on the current active cell. Scroll up and down will move both the left and right […]
Easily add names for cells.
I have written about naming cells and why it is a good idea before. Here is an easy way to do a whole lot of those at once. Your data has to be set out in a particular way. I have a small example here. Select all the data, from the Income cell to the […]