MS Excel is a powerful and versatile 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 short course Beginners Excel examines the skills necessary 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 workshop, allowing participants to receive hands-on experience of all topics covered.
The following areas will be covered:
Building & Editing Workbooks, including entering data, naming cells & ranges, series & lists.
Formatting, including cell formats & comments, conditional formatting, and validation
Formula, including simple calculations, functions, relative and absolute reference, and common error messages
Printing, including margins, headers/footers, and page setup