Woodthorpe IT Solutions Ltd

core_01


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.

Spreadsheet maths

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.

Basic formatting

Changing the appearance of a spreadsheet, adding colours to cells and text. You will also be able to add gridlines to your spreadsheet.

Printing

Showing you how to set print areas and control what goes on each page.

Creating graphs

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.

Customisation

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.

Formula auditing

This module will allow you to go through existing calculations with a fine tooth comb and identify how an answer is arrived at.

Protection

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.

Templates

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

Names

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.

Subtotals

This allows you to break a list down into groups and summarise with totals very quickly.

Validation

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.

Pivot tables

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.

Goal Seek

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.

Scenarios

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.

Custom Views

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.

Recording Macros

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.

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×