Microsoft Office Excel Training | MS Excel 2000, XP, 2003 to 2007 instructor led courses
Microsoft Office Excel Training
All of our courses are instructor led & can be delivered at your site anywhere in the UK. Delegates receive a course workbook to keep as well as a certificate, which help our clients to keep their staff training records up to date.

Any version of Excel can be covered from Excel 2000, Excel XP, Excel 2003,Excel 2007 to Excel 2010. All Excel courses are one day in length. Excel 2007 & 2010 courses also show delegates how to use the new ‘Fluent’ Office interface & find their way around the Ribbon.

MS Excel Introduction
This course introduces the delegate to the basic commands, functions and capabilities of Microsoft Excel. It is designed for those computer users who are new to spreadsheets or are only going to use Excel occasionally. Upon completion the delegate will be able to:

  • Use Excel to create, save & open spreadsheets
  • Enter & edit information in worksheets
  • Use formulas & simple functions to add, subtract, multiply & divide numbers
  • Enhance worksheets with fonts and borders
  • Format numbers & resize cells
  • Preview & print spreadsheets
  • Create & format Charts

MS Excel Intermediate
This course provides delegates with a brief review of Excel basics and introduces them to more features, functions and data handling techniques within Excel. It is designed for those computer users who use spreadsheets on a regular day to day basis. Upon completion the delegate will be able to:

  • Use relative, mixed & absolute cell references
  • Manage & navigate worksheets in a workbook
  • Sort & filter information held in tables
  • Create & use custom cell formats
  • Use conditional formatting to highlight results
  • Use Sparklines to add mini charts in cells (Excel 2010 only)
  • Use logical, mathematical, statistical, date/time & text functions
  • Use Named cell ranges in formulas · Customise charts & control chart options
  • Use drawing tools & fill effects for pictures & illustrations

MS Excel Advanced
This course introduces delegates to the advanced features of Excel. It is designed for the experienced computer user and helps delegates to analyse their data whilst increasing their proficiency as an Excel user. Upon completion the delegate will be able to:

  • Record Macros to automate tasks
  • Create & modify toolbars to run Macros
  • Create & use Custom Excel functions
  • Use Auditing Tools to check for errors in formulas
  • Combine functions in formulas & create Nested IFs
  • Use Protection to prevent accidental changes to formulas
  • Use formulas to link data in separate Worksheets & Workbooks
  • Use analysis tools such as Goal Seek & PivotTables to analyse data
  • Use Slicers to visually filter PivotTables & PivotCharts (Excel 2010 only)
  • Import & export Excel data with other programs

Email us now at andyhardy@f1rstit.co.uk or call us on 0115 926 2078 to discuss your Microsoft Excel training needs.

All of our courses are one day in length and can be delivered on-site or off-site.

Courses can be provided for all versions of Office from Office 2000 to Office 2010.

Enter your name & email address to receive our course information PDF:

Name:


Email:



Office 2010
As businesses replace & upgrade their IT equipment, they will inevitably move over to Office 2010. The interface for most of the Office packages has been dramatically changed.
No more menus or toolbars! Instead Microsoft created the Ribbon. This has radically changed the way you use Office & it has made many features more easily accessible. But it has also made some features hard to find.

Your staff WILL need training as you move over to the latest version of Office. Why struggle when we can help?