We are delivering Microsoft Excel Training Courses in Yorkshire at Foundation, Intermediate & Advanced levels and in all versions from 2000 – 2010. The training is delivered at your own offices anywhere in Yorkshire and we provide all the equipment required to quickly convert any room into an IT training suite for a day. This includes a projector, screen and also laptops if you don’t already have your own. You may wish to take a look at what some of our clients have to say about our training services on the Testimonials page.
Here is a brief overview of the three levels of Microsoft Excel training courses. Please keep in mind that we can tailor any course to fit your personal training requirements:
Foundation Excel Overview
- Introduction to spreadsheets
- Overview of the Excel menus and toolbars
- Entering & editing data and text
- Saving workbooks
- Formatting spreadsheet data & text
- Calculating using AutoSum
- Modifying spreadsheet (resizing & inserting columns, rows etc)
- Constructing basic formulas
- Copying formulas
- Understanding absolute cell references
- Introduction to Excel functions
- The SUM function
- The MIN function
- The MAX function
- The Average function
- The COUNT & COUNTA functions
- Working with the date and time functions
- Highlighting data with Conditional Formatting
- Managing large workbooks (freezing rows, columns & panes etc)
- Printing workbooks & selected spreadsheet data
- s
Intermediate Excel Overview
- Excel overview refresher
- Linking workbook data
- Protecting workbooks & cell ranges
- Advanced conditional formatting techniques
- Finding data records with VLookups & HLookups
- Filtering data with the Auto & Advanced filters
- Macros and their uses
- Calculating Subtotals and working with Levels
- Sorting data using Pivot Tables & Pivot Charts
- Consolidating data in multiple spreadsheets
- Linking worksheets with 3D formulas
- Using the Watch Window
- Data validation & creating drop-down lists
- Creating and applying custom styles
- Creating spreadsheet templates
- Embedding & linking spreadsheets in Word documents & PowerPoint slides
Advanced Excel Overview
- Using advanced functions
- Conditional Logic: using the IF function
- Using Not, AND, OR functions
- Nested IF functions
- The IFERROR function
- Using maths & statistical functions
- The SUMIF function
- The COUNTIF function
- The AVERAGEIF function
- Introduction to the new 2007 Excel functions: SUMIFS, COUNTIFS, AVERAGEIFS
- Working with data
- Speeding Data Entry with Excel Forms
- Tidying the database with the TRIM function
- Extracting text & data using FIND and MID functions
- Using the VALUE function
- Working with advanced database functions
- The DSUM function
- The DAVERAGE function
- The DCOUNT function
- Creating a Dashboard with PivotCharts & Slicers
- Using Goal Seek
- Creating & merging Scenarios
Excel Training Course Prices
Our current onsite training rates are as follows:
- 1 – 3 learners – £400
- 4 – 6 learners – £450
- 7 – 10 learners – £500
These rates are per group, not per person. All prices are + VAT, we do not charge extra for travelling expenses or any other hidden costs. Included in the price are personal Microsoft Excel training manuals, which learners keep as a reference after the course, along with a course certificate.
If you would like further information regarding Microsoft Excel Training Courses in Yorkshire, or indeed anywhere in the UK, please call or phone using the details below.