Microsoft Excel IT Training

Anyone who has never used Excel before (or any other spreadsheet package) or has some experience but is unfamiliar with using the software to perform calculations and create charts.

Delegates must be confident in using a mouse.

By the end of the course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae.

In particular you will be able to:

• Create, save, close, open and print spreadsheets
• Insert and delete rows or columns in your spreadsheet
• Get Excel to automatically add up numbers
• Copy formulae in your spreadsheet whilst keeping one of the cell references constant
• Alter the look of the numbers and text, to make parts of the spreadsheet stand out
• Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand

Anyone who has used Excel before to create and alter simple spreadsheets.

Delegates must be confident in using a mouse. Additionally you must have used Excel before and be familiar with using formulae for simple calculations, for example, AutoSum, basic formatting and autofill to quickly copy formulae.

By the end of the course, you will be confident in going beyond the basic features in Excel. For example using multiple sheets, linking them to create formulae across sheets, use common functions such as Average and If statements and manage data in an Excel database.

In particular you will be able to:

• Protect part of your spreadsheet to avoid deleting formulae
• Create and work on more than one worksheet
• Copy part of your Excel spreadsheet to a Word document and have any changes made in Excel updated in the Word document
• Use features such as average, minimum and maximum to create statistical information
• Create a calculation based on a condition. For example, add a £10 bonus to all staff who have achieved results above target
• Extract specific information from an Excel database. For example, show only the organisations with more than 1000 employees

Anyone who has been using Excel for budgets and managing information.

Delegates must be confident in using a mouse. Additionally you must have used Excel before and be familiar with entering formula and using absolute cell references (see our Excel Essentials and Intermediate Outlines).

By the end of the course, you will be confident in using some of Excel's more advanced features. You will be able to do more complex "what if" scenarios and use conditional formula and pivot tables to manipulate information.

In particular you will be able to:

• Move around a spreadsheet speedily using range names and even use them in formula to make them easier to read
• Use the auditing feature to check where the errors such as DIV?0 or NAME come from
• Create calculations based on conditions. For example, add a £10 bonus to all staff who have achieved results above target
• Use Hlookup and Vlooukup functions. For example, to look up how much poll tax should I pay based on the value of my house?
• Use Filters and Pivot Tables to help manipulate your data to find only the data you are interested in and make it easier to read
• Create macros to automate your work
• Assign a button on a toolbar to a macro to make it easier to use

Anyone who has never used Excel VBA (or any other Visual Basic package) and who prefers to learn at a regular pace. This course is especially useful if you need to build spreadsheets that go beyond what Excel alone is capable of.

Delegates must have an excellent working knowledge of Microsoft Excel.

By the end of the course, you will be confident in using the essential features of Excel Visual Basic to create simple spreadsheet solutions. For example creating a form to capture information from users.

In particular you will be able to:

• Understand what VBA is
• Create macros to automate tasks, as well as understand their limits
• Create your own forms to collect information from users
• Manipulate the values in your spreadsheet
• Declare variables, and manipulate them
• Write code which looks at a condition and carries out different actions accordingly
• Write code which repeats an action a specified number of times
• Write functions, frequently used pieces of code
• Understand the Excel object model, and make use of its properties, methods and events
• Trap errors, to avoid users seeing problems and find problems in your code