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.
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
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.
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
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.
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
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
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.
Essex Computer Training