In life as in business, we always strive to find the easiest ways of getting things done. Sometimes, however, the simplest methods involve cutting corners, obtaining short-term results but long-term headaches. One of a long line of Excel features, the PivotTable is the best way to break your information down into more manageable chunks. In […]
It’s important to stay ahead of the game and decent spreadsheet software such as Microsoft Excel is still regarded as one of the most empowering and flexible ways to track your SEO campaigns. In conjunction with important tools such as Google Analytics & Keyword Tools, Excel is able to help provide unrivalled analysis to aid […]
Printing out Excel spreadsheets can be frustrating. Often you end up with one piece of paper with only one column of data on! If you are printing a spreadsheet that will take up more than one page, you have the ability to control were the page breaks. To do this you need to be in […]
When you have worked hard to set up and create an Excel workbook, which may include 3D formulas, pivot tables and links to other key worksheets, you will want to protect your work from unwanted changes. Excel allows you to protect your worksheets work and allow editing It isn’t just about stopping people from making changes to […]
I love shortcuts, they save me loads of time by using a couple of keystrokes instead of going to different tabs and menus. Here are my 10 favourite Excel shortcuts to speed up data entry in Excel. To undo the last action – use Control + Z no matter what program you are using, this shortcut […]
For those of us who can break out into a cold sweat at the mere mention of a “formula”, Excel has functions already set up to remove the need for towels and darkened rooms. I use Excel’s common functions every day – autosum, averages, count and minimum and maximum – all I have to do […]
A question that often arises when using AutoFilter with Excel is… how can I sum the visible data only? The solution to this question may not always be apparent but all is not lost as there are many Excel training courses in London that deal with how this can be achieved. There are 2 options […]
Excel has some great functions for “What if…” scenarios. One tool that can be used is the Excel Goal Seek. This allows you to choose any current formula and set the answer value to your own goal. e.g. If you have a formula that works out how much profit you make from selling items, such […]
Here’s a brief tip on how to instantly brighten up your Excel spreadsheet with very little effort. By changing the colours of the tabs, your Excel Worksheet will change from being dull and boring to exciting and colourful! It will also help in organization, being particularly useful when organizing all your Excel Worksheets relating to […]
Here’s how to view two Excel 2010 workbooks at the same time, side by side, a very useful tip when you want to compare data without having to go back and forth! 1) Open both Excel workbooks 2) Select Window then select Compare Side by Side with (Spreadsheet 2) 3) When you have finished, […]
When you have an Excel Worksheet with masses of data, it’s not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the […]
If you want to make your Excel Worksheet appear a little less dull, or maybe you want to draw attention to a certain section of text, why not try rotating the text. And here’s how you can do it.. – Select the cell with the text in you would like to rotate. – Click the […]
Above is an example of a standard pivot table in Microsoft Excel 2010. It is set up with financial quaters as column headers and products as Row labels. I’m interested in seeing the results for the combined sales for the first half and the second half of the year. As you can see I have […]
If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.
If you want to add a row to an Excel spreadsheet, these are the simple steps you should take: With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert. Follow exactly the same steps if you want to add a column […]
If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide columns and rows. Hide a single column: 1) Right click on the column header of the column you want to hide (this is […]
In the following example there is a column of stock codes. The numbers represent our Supplier and the letters after the hyphen (-) indicates our Item number. Suppose we need to extract the Supplier and Item codes and place in separate cells. If our Supplier codes were all equal length e.g. 3 numbers long, we […]
A new feature introduced in 2010 version of Excel is the Slicer tool. Used to visually and quickly filter data within a Pivot Table. Although the Pivot Table feature makes it extremely easy to manipulate the layout of data lists in Excel, we have found most attendees of our Excel 2010 training Courses are excited […]
One of the great new features of Excel that users enjoy employing during our Microsoft Excel Courses here in London is the Sparklines. These can be thought of as mini-Charts that reside in a cell, and can show a trend visually of a group of values. In the example shown below there are sales figures from […]
If you have a lot of data in Excel and you want to find the highest or lowest number in a row, column or range of cells, Excel provides an easy way to produce this answer for you, without the need to sort your data. Lowest number: The Excel function to find the lowest number […]