Excel Intermediate – Training
In this sessions you will learn how to create/write formulae using some of the popular functions within Excel and create pivot tables, charts and a simple dashboard.
READ MORECreating Dashboards using Microsoft Power BI
Always wanted to know how to create interactive dashboards and recently found how to do this. In Excel 2013 it is simple enough if you think it through.
READ MORERecent Training Events
Over the last few weeks I have delivered a number of training events. I was very surprised that these were all at Introductory level. The first being Introduction to Technology, this was delivered to a group of senior citizens (average age 75) who signed up for 2 hours for 6 weeks workshop. They wanted to…
READ MOREI never knew Excel could do THAT!
I was reading a report written by Jeff Robson (CEO of Access Analytics Solutions) – “I never knew Excel could do THAT!” He writes about three common mistakes on how Excel is viewed by businesses: Mistake 1: “Everyone knows Excel” That is so, even children as old as 5 can type numbers into boxes! Spreadsheets…
READ MOREHow to Cutomise a Microsoft Office Ribbon
Another way you can save time is by customising a Ribbon. If you have all the frequently used commands on a single Ribbon, wouldn’t that save you time looking for a command? Within 9 minutes you will be able to create a custom Tab/Ribbon. In the video I’m using Microsoft Excel 2013 as an example,…
READ MORESaving time by Automation
Recently I was asked by a new client if I could help them with some statistics that they produced for their own clients. We discussed as to what they wanted to be able to do. Having linked to their computer screen remotely, we went through the process of what they did every week to produce…
READ MOREBuying a new computer?
For the many years that I have worked in IT, I have been asked “I’m looking to buy a computer but I don’t know what to get?” or something along those lines. The first thing I tend to ask is “What do you want it for?” This is an important question as this will help…
READ MOREThe function of Excel spreadsheets in business
To understand how Excel and can play a key role in business, let’s take a brief look at what a spreadsheet is and how they work. What is a Spreadsheet? A spreadsheet consists of a table of cells arranged into rows and columns the columns, are normally represented by letters, “A”, “B”, “C”, etc., while…
READ MOREDealing with the Charms Bar
Recently I was talking to fellow colleague in IT at a Meet the Buyer event, in Luton and we somehow got to talk about the annoying Charms bar that keeps appearing when we go to top right-hand corner of the screen, to minimise the application window. We know that they must be a way to…
READ MOREOutlook Housekeeping part 2
We all find it a chore to keep on top of our filing and in particular our emails. With most things our mailbox has a limit to the amount of information it can store and many Corporate IT departments are constantly fighting a battle to free up storage space just to keep then users happy.…
READ MORE