I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.
Is it worth taking advantage of the Free Upgrade to Windows 10? Microsoft are offering Windows 10 as a Free upgrade for Windows 7/8 users. Why should you upgrade, is it really worth it? Windows 7 users are decidedly hesitant, after all, Windows 8 removed the Start Menu, Power Button and adjusted how individual Windows closed! Is Windows 10 something to be […]
Here’s what’s New in Excel 2016 With the launch of Office 2016 in the Autumn of 2015, you may be wondering about the new features in 2016 and what’s changed. With Excel at the core of many businesses, it would help to have all of the new features explained. We have compared the different versions of […]
An easy to update Gantt chart in Excel Building a Gantt chart in Excel is pretty easy. But what if you needed to update any of the tasks? This would usually mean lot’s of time consuming manual editing of cells. But there is an easier way…. Step in Excel and the ever flexible conditional formatting function! Yes […]
By Ann K. Emery With an estimated user base of 500 million people worldwide, many of us use Excel at work and personally for home budgets, projects, to-do lists, and more. It doesn’t take too much use of Excel before you reach the point of trying to express your data visually. This is where Excel charting […]
Using loops to easily make changes across multiple worksheets Loops are one of the key tools in Excel VBA when we need to perform tasks through a number of objects (cells, worksheets, charts, workbooks etc.) . Here we will look at how to loop through Excel worksheets and workbooks. Loop Through Excel Worksheets Below you will […]
Quickly create drop down lists in Excel with automatic sorting The Drop Down list in Excel is a great automation tool. You can turn any data list into a drop down list which makes it easier to place items in cells. Drop down lists show the data in the same order in which they appear […]
Creating an Excel Dashboard – Election Special Video What is an Excel Dashboard? Dashboards are essentially reports in Excel that help you visualise and analyse complex pieces of data. In the following video we look at an example Excel dashboard to guide us through the mind boggling data being produced by the current UK general […]
Say goodbye to copy and pasting. Connecting Excel to website data There are times when having live data in Excel can be really useful. You may need the latest currency exchange rates, monitor your stocks, track house prices, the possibilities are endless. Once you have established the data links you can refresh the data, also […]
Make sense of someone else’s workbook When you are given a workbook that has already been created it can be hard to work out which cells contain manually entered values and which cells are the result of formulas. So how do you show formulas in Excel? Below is an example workbook, at first glance it’s not easy […]
Save yourself from errors with the BODMAS rule A question we often hear is “Why do we need to put Brackets in Excel Formulas?” Some formulas that you use won’t need brackets. If you write the formula =5+2+10, It will calculate the result as 17. There were no brackets in that formula, and it still […]
How to remove duplicates from a column of data in Excel It’s not uncommon when adding or importing records that you may need to remove duplicates in Excel. Whilst filtering and deleting records to make a list of unique items is an effective solution, there is an even easier way. Simply follow these steps to remove duplicates […]
How to use SpecialCells method in Excel VBA SpecialCells in VBA is a really useful method to deploy in Excel. It returns a Range Object that only covers the type of cells you specify. You can use the SpecialCells in VBA Method to return a Range Object that only holds numbers, text, blank cells, formulae, cells with […]
What’s the difference between Count and CountA in Excel? The Count function is one of the 400 functions in Excel. Count as the name suggests, counts the number of cells selected that contain numbers. You can use the Count function to obtain the number of values within a range, rather than the total of those values. If we wanted to count the […]
Quickly and easily delete blank rows and columns in Excel It’s not uncommon to end up with blank cells or rows in an Excel worksheet. If you need to delete these to maintain accuracy, especially when calculating the average value, the quick way is to filter out all blank cells / rows and delete them […]
Refine your filter options with the Advanced Filter in Excel For most filtering of data Excel AutoFilter is perfectly adequate. Here we’ll look at some benefits for moving beyond the AutoFilter by using the advanced filter in Excel. A Recap of AutoFilter Benefits For ease of use, it’s hard to beat the Excel AutoFilter feature. Just click […]
By J. Peter Bruzzese The recent global recession is still quite fresh in everyone’s minds. From an IT perspective it forced IT administrators to tighten their belts and hold off on upgrades of both hardware and software for quite some time. The growth of “cloud” solutions (like Office 365) has provided IT teams with another option when considering new […]
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 […]
How to quickly create a post in WordPress. There are plenty of detailed online guides, but this a quick guide to get you started within the context of our WordPress environment. WARNING. like with any system, the WordPress interface is massive and festooned with a plethora of features (lot’s of which I haven’t even checked […]
Content creation process – Excel Hints & Tips created by Jacob What is it? We are creating useful (hopefully!) Excel Hints & Tips which are emailed weekly to a selection of our customers (and subscribed website visitors) and published on our blog as well. Why are we doing this? We are generating this content to […]
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 […]
An easy way on how to calculate the age from date of birth using Excel formula Here we’ll look at how using the Today() function along with a less well known function, Datedif(), calculates the age from a date of birth. Even if this isn’t a pressing need of yours the example below is a handy […]
Imagine you’re at an important hospital appointment and you’re kept waiting because the scanner, which potentially cost £100K, needs a re-boot. And then you discover it’s driven by Windows XP which is no longer supported by Microsoft. That would be insane wouldn’t it? Sadly not. It’s a true story and it’s probably just the tip […]
In Excel there’s a lot of data being moved around, perhaps via copy and paste. If you leave a lot of stuff lying around on in memory or cache you’ll get a message along the lines of “you’ve left a lot of information on the clipboard…”. Generally in VBA you can avoid this with other […]
Ever received a spreadsheet and all the data on it is in the wrong case? You might received a dodgy dump of data from your website or database, or maybe the user-inputted data is poorly or inconsistently formatted. Here I’ll guide you through how to do Excel VBA Uppercase, lowercase and capitalising the first letter […]
Excel VBA is used for all sorts (!) of data manipulation tasks. One of the most common is sorting your data. Performing an Excel VBA sort seems trivial but some parts of it may misbehave if you’re not diligent. I’ve seen some people try to write their own sort routine in Excel VBA, but frankly […]
VLOOKUP is one of the most useful and versatile functions in Excel. As you work further with macros it’s not uncommon to make your create an Excel VBA VLOOKUP macro. With this you get the ability to reference your tables of data, but automated. Wait, what’s a VLOOKUP function? The Vertical Lookup is one of […]
Excel pixel art is a global phenomenon, and while it’s as geeky as ASCII art, it somehow feels a little friendlier – perhaps because it brings back happy memories of 8-bit computer games to people of a certain age. Here are 10 of the best Excel pixel art pictures we were able to find online, […]
That’s not a headline designed just to capture your attention. It’s a very real possibility. Spreadsheets can be powerful. They’re full of functionality yet easy to use. Everyone can create and use a spreadsheet without much in the way of training. But all those benefits are also the dangers. Spreadsheets weren’t designed to carry the […]
If you’re running Windows XP, you’ll be familiar with that annoying update that happens when you try and shut down for the day. It takes ages, it means you can’t simply switch off and run out the door, and there’s a good chance you’ll miss your train because of that wretched ‘Updating 1 of […]
We’ve already discussed what the cessation of support for Windows XP means for your business. Deciding whether to upgrade to Windows 7 or 8 has had the Google+ community divided, though one thing is for sure: Windows XP is going to be missed. Windows XP X-Tinct To celebrate the success of the operating system, Microsoft […]
Everyone knows the best things in life are free. That’s why we’ve made our entire library of Microsoft Office training manuals available for you to download completely free of charge. Our comprehensive resources include manuals for Word, Excel (as used on our Microsoft Excel Training courses), PowerPoint, Access, Project & Visio, ranging from 2003 to […]
Released on August 24th, 2001, Windows XP is widely regarded as Microsoft’s most successful OS, boasting over 400 million active users at its peak in January 2006. Now almost 12 years old, Microsoft have decided to cease support for Windows XP effective April 8th, 2014. Continued use of the OS after this date runs the […]
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 easy to see why Office 365 is now the most popular MS suite to date. With over 1 million subscribers during its 2013 launch, it’s packed with all the great features that we know and love about Office, with the added bonus of online storage, file sharing and collaboration. With new save and share […]
In the right hands, PowerPoint can be an extremely useful presentation tool. However, much like Excel, the low barrier to entry for PowerPoint means that anyone can get their hands on the software and that’s where the problems begin. Cue poor presentations and cringe moments. These three tips twinned with our other bite-sized tips will […]
See the timing of trends in your Excel 2013 PivotTable data with the new timeline feature. By default the data is split into months, though manipulation allows you to break this down into weeks, quarters, years or even days if you prefer. If you make user of Slicers in your PivotTables and PivotCharts, you will […]
Visual reports are another fantastic way to share figures with stakeholders in way that’s digestible and easy to break down. In Project 2013, you can view specific project data in a visual report in Excel or Visio, if you have those programs installed. How to: Select Reports, Visual Reports, select an Excel or Visio report for your project […]
Whether you’ve decided to use a suggested chart to represent your data or already knew which one works best from the outset, a new toolbar in Excel 2013 allow you to customise your visualisation quicker. Selecting the chart will automatically reveal two tool ribbons: Design & Format, both specifically designed to help you manipulate your […]