Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

In House Microsoft Excel Training Courses

This course is for new or users with little Excel experience. The course is designed to introduce the basic concepts of an excel spreadsheet. We look at spreadsheet terminology and become familiar with the Excel interface.

 

Delegates will learn to navigate worksheets and workbooks and how to get help when needed. They will learn to enter and edit text, values and formulas and to save their work and open other workbooks.

 

Delegates will also learn how to move and copy data on a wrksheet and between workbooks, as well as learning about absolute and relative references and their usage in formulas.

 

This course also covers simple functions like SUMm MAX, MIN and average as well as basic formatting techniques and printing.

 

Finally, delegates will learn how to create and format simple charts and learn how to handle large workbooks.

 

 

Read More

This Microsoft Excel Intermediate training course is intended for individuals who are self taught and wish to formalise and expand their knowledge of Excel or for those who have completed the Excel Introduction course and wish to increase their skills.

 

The course will show delegates how to use multiple worksheets and workbooks efficiently, working with more advanced formatting options including styles, themes & backgrounds and watermarks.

 

Delegates will also learn how to manage an Excel database including sorting, filtering and creating subtotals. They will learn to simplify formulas by creating and applying cell names as well as applying advanced charting techniques

 

Read More

On this Microsoft Excel training course you will work with advanced database management, database functions, data validation & protection. You will learn how to work with PivotTables and PivotCharts, use the......

 

Read More

By learning to write Excel VBA code, repetitive and tedious tasks in Microsoft Excel can be performed quickly and accurately. The result is increased efficiency, performance & productivity which means less time & cost performing these repetitive tasks.

 

 

Read More

An Excel Dashboard provides analysis and insight into what is happening in your business. They summarise large data sets in real time. If you are required to report complex information such as management information, financial reports or sales and marketing statistics, a Dashboard Report using Microsoft Excel can simplify this task. A dashboard report allow you to obtain a high-level and accurate overview of your business, enabling you to speedily make the right decisions.

 

Read More