MS Excel Int
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.
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, 2010 and 2016.
By the end of the course you will have an understanding of the following topics:
Building and Editing Workbooks
Entering and Editing Data
Managing Cells, Rows and Columns and Worksheets
Series and Lists
Formatting
Styles and Format Painter
Conditional Formatting
Validation
Manipulating Data
Freezing Panes, Filters and Sorts
Charts
Formula
Further Functions; Auditing Formulas
Functions
Printing
Page Setup and Headers/Footers
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.
-
LouiseLouise is an IT professional with over 22 years' experience in IT and telecommunications. During her career she has worked in IT consultancy, project management and as an in-house trainer.
Louise is an Associate with AKU Training and provides specialist IT training in Belfast including MS Excel, MS Word, MS Access, MS Project and marketing through Twitter and LinkedIn training.
Louise also runs her own IT consultancy in Belfast through which she operates as an IT consultant, mentor and IT trainer. She is an Accredited Microsoft Master Instructor and an accredited ECDL and Advanced ECDL Tester. She has worked as an Associate Lecturer with the Open University and a part-time lecturer with Castlereagh College and EDIFHE.
Please note that the cancellation policy for our public training courses is as follows:
NON-ACCREDITED TRAINING
More than 3 weeks prior to the course start date - No cancellation fee payable.
Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.
ACCREDITED TRAINING
More than 6 weeks prior to the course start date - No cancellation fee payable.
Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.
Substitute delegates will be accepted at any time at no cost.
Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@akutraining.com.
Download a copy of our standard Terms and Conditions for course bookings.
