MS Excel Intermediate

This intermediate Excel training course will help you to create effective spreadsheets and apply automated applications. This course will introduce the ten best features for effective spreadsheet use that will enhance your productivity and save you time. If you have four or more participants in-house delivery may be more cost effective. Contact us for an in-house quote today. This course can also be delivered virtually.

MS Excel is a powerful and versatile spreadsheet tool which enables users to store, manipulate and analyse data quickly and easily. It includes a variety of business features which automate many common tasks, making it an essential application for businesses of all sizes.

This one-day course provides the knowledge and skills to create, edit and enhance spreadsheets. It includes a study of the automated tasks commonly used for data manipulation, calculation and data analysis. The course is designed as a practical course, allowing the participant to receive hands-on experience and guided practice of all the topics covered. The content will be relevant to both Excel 2007 and 2010.

By the end of the course you will have an understanding of the following topics:

Building and Editing Workbooks Entering and Editing DataManaging Cells, Rows and Columns and WorksheetsSeries and Lists

Formatting Styles and Format PainterConditional FormattingValidation

Manipulating Data Freezing Panes, Filters and SortsCharts

Formula Further Functions; Auditing Formulas

Functions PrintingPage Setup and Headers/Footers Is it For Me? If you wish to learn the essentials of spreadsheet design with a view to its application in a business environment then this course is for you. Those wishing to progress to learn the more advanced functions of Excel should look at the Excel Expert training course.