The perfect training course for people who need to learn how to use Microsoft Excel from the ground up.
Understanding these areas lie at the heart of correct Excel use. There’s a focus on shortcuts so you can tackle these areas quickly.
The methods and shortcuts covered in this topic will help dramatically reduce time spent working with large Excel worksheets.
Unnecessary entry of data will slow down spreadsheet creation. The Auto Fill tools lets Excel do the work for you. A great time saver.
We’ll cover the fastest and most effective methods of changing the appearance of the contents of cells.
This chapter covers all you’ll need to know about creating manual and function-based calculations.
Understanding how and why we need to “lock” cells is a must before moving on to intermediate Excel use.
As well as performing calculation within a single spreadsheet, we can calculate across multiple sheets, and even other Excel files.
We can program Excel to “trigger” automatic changes in formats. It’s a powerful visual tool.
Working with lists is a prime Excel function. You’ll learn how to manipulate databases quickly and correctly.
Easy to create, charts are a great tool to show data in an understandable graphical form.
Excel spreadsheets can be very large in size, and this topic goes into details about how to view and print exactly what you need to
The bulleted items listed above comprise a condensed overview of course topics.
Download full course outline (PDF)
This course is designed for beginner users who have little or no experience in using Microsoft Excel. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.
