Category: Training Club

Intermediate Excel Training Courses in Scunthorpe

Training Club

June’s local Friday training session is Intermediate Microsoft Excel. The course is ideal for anyone who is either a basic knowledge of Excel’s formulas and functions, or has been on our Intermediate course. Here is a brief overview of the course content:

  • Excel overview refresher
  • Linking workbook data
  • Protecting workbooks & cell ranges
  • Advanced conditional formatting techniques
  • Finding data records with VLookups
  • Filtering data with the Auto & Advanced filters
  • Calculating Subtotals and working with Levels
  • Sorting data using Pivot Tables & Pivot Charts
  • Consolidating data in multiple spreadsheets
  • Linking worksheets with 3D formulas
  • Data validation & creating drop-down lists

The venue is our training centre at Normanby Gateway, Normanby Enterprise Park, Scunthorpe, DN15 9YG. The course starts at 9.30am and finishes at 1pm. Price is £49 per person + VAT. There is ample free parking along with complimentary refreshments.  To reserve your place please call 0800 2922842 or email info@microsofttrainingcourses.org

Foundation Microsoft Excel Training Courses Scunthorpe

Training Club

This month’s local Friday training session is Foundation Microsoft Excel. The course is ideal for anyone who is either new to Excel, or currently only uses the software for data input or review. Here is a brief overview of the course content:

  • 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
  • Managing large workbooks (freezing rows, columns & panes etc)
  • Printing workbooks & selected spreadsheet data

The venue is our training centre at Normanby Gateway, Normanby Enterprise Park, Scunthorpe, DN15 9YG. The course starts at 9.30am and finishes around 1pm. Price is £49 per person + VAT.  We have ample free parking along with complimentary refreshments.  To reserve your place please call 0800 2922842 or email info@microsofttrainingcourses.org