Hints and tips for MS Office and other applications. Contributions from our team of talented trainers.
Quick and easy ways to change case text in Excel. You may have a list which you wish to change the case test in Excel. Rather than manually re-entering the data in Excel, there are some useful functions you can call on to save you this work. Let’s look at a few of them. In […]
A comprehensive guide to these powerful functions in Excel The LOOKUP functions can be used to look up data in an Excel list or Excel database, saving a lot of time and potential error when comparing two lists of data. You have two LOOKUP functions, Excel VLOOKUP and the HLOOKUP. The only difference between the two functions is that the VLOOKUP is used for […]
Discover some useful options available in the Excel status bar The Excel status bar, which is located at the bottom right side of the Excel screen, is an often overlooked but informative feature in Excel. For example say you wanted to find the total, or average of a selection of cells, the status bar is quickest place to […]
Summarise data quickly by using Subtotal Excel’s subtotal feature provides a quick and easy way of summarising tabular data. A common use of the feature is to display only the totals for different categories. For example suppose you want to calculate and display only the total units for each product from data (partly shown below) Step 1 Sort the data by the Product field. Click inside the […]
The concatenate function quickly links the content of two or more cells The concatenate function in Excel allows you to join text strings from different cells (like first name and last name) which can be very useful. It can be used with a number of other Excel functions. You can concatenate in Excel by using the Concatenate function […]
Pull out a segment in an Excel pie chart Pie charts are great for visually showing categories. Occasionally we might want to emphasise a segment. To do this, we can pull out a pie chart segment! 1 – Create a Pie Chart Start by selecting your data, going to the Insert tab along the Ribbon […]
Save hours in Excel: spend a few minutes learning these shortcuts Keyboard shortcuts are great time-savers; allowing you to shave seconds off a task, but ultimately saving hours in the long run. This is especially true when you are working with Excel. There are over 200 Excel keyboard shortcuts that you can use, here we have selected 15 […]
The Definitive Guide to Excel Keyboard Shortcuts Keyboard shortcuts can be a real productivity booster, here’s a comprehensive list to serve almost any situation that arises in Excel. CTRL combination Excel shortcut keys Key Description CTRL+SHIFT+( Unhides any hidden rows within the selection. CTRL+SHIFT+) Unhides any hidden columns within the selection. CTRL+SHIFT+& Applies the outline border to […]
Save time and reduce errors by viewing two or more worksheets at the same time It’s not uncommon to end up jumping between different Excel worksheets/workbooks because you are comparing data, copying & pasting or even creating links. This back and forth process takes up time and can increase the risk of error. Well there is a […]
Save hours and eyesore by using freeze panes in Excel Reviewing data in spreadsheets can be very demanding on the eyes and time consuming when you are trying to remember what a particular column or row of data actually is! If you’re not already familiar with how to freeze panes in Excel, read on and […]
Save time by avoiding repetition and errors Excel is great for lists; sales figures, staff rota’s, stock control, to name a few. But an easy trap to fall into is repetitive error prone data-entry that leads to inaccurate business reporting and lost time in troubleshooting. If you create a drop-down list in Excel, you can avoid […]
Improve collaboration and save time It is not uncommon with Excel to have multiple people requiring access to the same file. Whether the file in question is a sales report, marketing budget, or time-sheet for example. This is where the Share Workbook feature in Excel comes in handy, here we’ll look at how to share files […]
How to create AND split a stacked chart in Excel Amongst the many charts available in Excel, some of the most popular are column charts, and the main variants being clustered and stacked. We’ll look at how to split a stacked chart in Excel, and to do this let’s start by creating a basic column […]
Trying to review a spreadsheet with unformatted data can be a real eye sore, but by using the Total cell style in Excel you can quickly give your data more context. An example of using the Total cell style in Excel Below we have a list of sales figures for several sales reps in a travel […]
Easily copy & paste using the Transpose option This is a very useful little tool (and one of many that we cover on our Advanced Microsoft Excel courses). Sometimes when setting up a worksheet you may realise that it would be better to put your column data into a row. One way to achieve this […]