Microsoft Excel Course (Basic)
Our Microsoft Excel Basic training course introduces you to the central workings of Excel enabling you to produce spreadsheets that can benefit your business. It is expected that you will have a basic knowledge of using computers but no prior experience with Microsoft Excel.
Entering and editing data with shortcuts
Entering data, adding rows / column, moving data around quickly and keyboard shortcuts.
Performing calculations like qty x price and giving you an understanding of how maths works within Excel including use of the $ symbol in a calculation.
Using sum, min, max and average
In addition to standard maths you will be shown how to summarise lists providing totals and more.
Changing the appearance of a spreadsheet, adding colours to cells and text. You will also be able to add gridlines to your spreadsheet.
Showing you how to set print areas and control what goes on each page.
You will look at producing graphs based on data within an excel spreadsheet and change various formatting elements.
Microsoft Excel Course (Intermediate)
Our Microsoft Excel Intermediate training course builds on your prior knowledge of Excel and incorporates this into producing more complex spreadsheets to enhance business capabilities. It is expected that you will have had a working experience and/or training within Microsoft Excel prior to this course.
Working with large worksheets
Working within printing and viewing options for a large workbook, you will learn how to get things on the screen and a print out better.
Working with multiple workbooks
You will work with more than one file on the screen at the same time and see tips to make this easier and also how to link them together with maths.
Depending on the version of Excel you have you will learn to customise toolbars and or Ribbon tabs allowing you to but buttons you want where you want them.
Formatting – Cell styles, Tables and Conditional
These are the clever pre-set and automated formats within Excel. You will be able to format large sets of data based on pre-sets and also format cells based on what is within them e.g. if value less than 5 make the cell red.
Modifying Graphs and Sparklines
You will get an understanding of how to manipulate graphs and create spraklines which are tiny graphs in a cell that show trends (Sparklines are Excel 2010 onwards)
Working with lists
You will see how to sort and filter a list within Excel allowing you to create reports very quickly.
This module will allow you to go through existing calculations with a fine tooth comb and identify how an answer is arrived at.
You will be able to lock down a spreadsheet so that only certain people will be able to change parts of the spreadsheet. So allowing you to control how the spreadsheet is used better.
This allows you to protect an original format of Excel file. Eg if you have a quote form you want people to fill In, saving as a template will mean that each time they use the form it will be blank and ready to fill in. Rather than potentially having the last persons entry in it.
Microsoft Excel Course (Advanced)
Our Microsoft Excel Advanced training course introduces techniques employed by experienced users to enhance your use of Excel and build feature rich spreadsheets. This will not only benefit your business but will develop your own key skills. Previous training and a working knowledge of Excel are needed before embarking on this course
This allows you to make formulas more readable and easier to maintain. Rather than referring to a cell as A1 it could be DollarExchangeRate.
If, sumif, sumifs, Dsum and DFunctions
This allows you to pass the baton of decision on to Excel, in the sense that you can tell these formulas you want to calculate one way for some items in your list, and another way for other items. IF is line by line ,and the rest give you totals based on a criteria you define Eg all the sales for apples please total.
Vlookup and lookups
This function allows you to link data together between more than one list. So if you have two lists and you want to “mash” the data together Lookups allow you to fetch data from one list in to another.
This allows you to break a list down into groups and summarise with totals very quickly.
This allows you to control what data can be entered to a spreadsheet by people using it. Eg I only want a value between 1 and 5 OR I only people to select from a drop down list of options.
This is one of the most powerful reporting tools you will have access to. It allows you to get a detailed list and summarise it by any column very quickly. It is very flexible and once you understand a couple of simple rules it is very easy to use.
This allows you to tell Excel what you want a formula result to be and it will then go and change one of the inputs to make the answer hit what you want. E.g. if you have to hit a particular selling price but you are not sure what discount you must give to hit this, Goal seek will work it out for you.
This allows you to snapshot data and revert back to it at any time. So if you change the data in your spreadsheet you can restore back to a previous point in time.
This allows you to snapshot how you are viewing a spreadsheet, saving filters, print setting and hidden rows / columns. Really useful when applied to a shared spreadsheet setting.
This allows you to automate repetitive and robotic tasks. Rather than you having to re do these tasks like a robot each time Excel will perform the task for you.