Contact Nora at
Essex Computer Training
07557 192 434
or email me with your enquiries

Excel & Microsoft Office IT Computer Training Courses & Consultancy Services in Chelmsford, Harlow, Braintree, Brentwood, Southend, Colchester, Romford, Basildon, Benfleet, Witham, Rayleigh, Maldon, Burnham And Other Areas Of Essex.


Excel Training Courses 

Microsoft Office Excel is considered to be as one of the most useful and versatile office programs. Excel can make everyday administrative tasks quicker, easier and less prone to human error. Training your staff in Excel can significantly improve their business practices and productivity. Employees will be able to develop efficient solutions to daily tasks and save your business time and money.


Having worked with many businesses for over 20 years, the course content has been designed to provide practical application in the workplace, as well as demonstrate the power of Excel.


Course contents for standard courses are shown below. Alternatively courses can be tailored to your own requirements. The course content and exercises can be adapted so that they are built around your own spreadsheets and specific business requirements.


Excel training courses are offered at foundation, intermediate and advanced level and in versions 2003, 2007, 2010 and 2013 and can be delivered onsite at your company premises or in a local office in Basildon, Benfleet, Braintree, Brentwood, Chelmsford, Clacton, Colchester, Harlow, Romford, Southend  and all other areas of Essex.

1 Day Excel Foundation Training Course
This course is for those wishing to gain the confidence to effectively use a spreadsheet program to build, format, save and print a spreadsheet with simple formulas. It is suitable for those who have no previous experience of setting up or using spreadsheets.

Topics include:

Concepts of a spreadsheet
Enter and edit various data types
Introduction to formatting values (numbers, currency, dates, percentages, etc)
Using Cut, Copy and Paste
Relative Cell Addressing (=A2+B7, =G6/H5, -D9*10%)
The AUTOSUM function
The Fill Handle
Linking to different worksheets or workbooks e.g. =North!A5+South!A5
Introduction to common functions (Count, Average, Max, Min, etc)
Working with worksheets (adding, deleting, renaming, copying, pasting, etc)
Sorting and filtering data
Page layout features
Printing and working with large worksheets
Cell comments

2 Day Excel Intermediate Training Course
This course build on the skills learnt in the foundation course. Delegates attending this course must have must be able to create basic mathematical formulas using addition, subtraction, multiplication, division and percentages and have an understanding of formatting a worksheet. They will either have attended the Excel Foundation course or can work confidently with the topics covered in that course. 

Topics include:


Review of Excel Foundation
Utilising multiple sheets for grouping e.g. =SUM(Jan:Dec!A5)
Absolute Cell Referencing
Mixed Cell Referencing
Create and use cell names and named ranges
Protecting cells, worksheets and workbooks using locked & hidden properties and passwords
Data lists formatted as tables
Using data validation rules to control user input
Introduction to conditional formatting
Further work with functions: counta, countblank, countif, sumif)
Introduction to logical functions (simple IF statements)
Creating and formatting charts
Sparklines

2 Day Excel Advanced Training Course
The course provides practical experience of a range of features and participants will use Excel to setup or analyse more complex spreadsheets. Delegates will be encouraged to work independently to complete a number of projects using a range of Excel functions and features so it is imperative that they have attended both the Excel Foundation and Intermediate courses or be able to work confidently with the topics covered in those courses.

Topics include:

Review of some features of Excel Intermediate
More logical functions: AND, OR, IFERROR
​Nested Functions: IF with IF, OR, AND, MAX, etc
Lookup Functions: VLOOKUP, HLOOKUP, MATCH, INDEX
​Date Functions: TODAY, NOW, WEEK, MONTH, EOMONTH, EDATE, DATEDIF, etc
Text Functions: CONCATENATE, LEN, LEFT, RIGHT, SEARCH, FIND, REPLACE, TRIM, etc
Data Consolidation
​Subtotals
Pivot Tables & Slicers
Further Conditional Formatting
What-If Analysis (Goal Seek, Data Tables, Scenarios)
Workspaces

​Introduction to Developer Toolbar (and possibly Macros & VBA)

Improving the performance of spreadsheets



Excel and other Microsoft Office IT computer training courses in Excel, Word, Outlook and Access in Chelmsford, Southend, Harlow, Colchester, Ipswich, Basildon, Braintree, Brentwood and all other areas in Essex. On-site or in Chelmsford office. 1-2-1 and group training