This 1 day course is designed for users that have little or no familiarity with Excel. The focus is on creating formulas, formatting, layout and printing. Instead of listening to hours of lecturing we spend most time playing with Excel. In the various sessions we learn how to use the keyboard shortcuts to accomplish common tasks.
At the end of this workshop, the participants will be able to create simple but accurate worksheets containing formulas and formatting. Also they will learn the skills necessary to print various layouts of data.
- Tour of the screen
- First project – A simple worksheet containing test and numbers with formulas. We format the exercise to make it look more professional.
- Second project – Simple HR worksheet where the user creates formulas based on hourly rate and hours worked. Then some basic statistics are extracted using SUM(), AVERAGE(), MIN(), MAX() and COUNT() functions. In the end the worksheets is nicely formatted.
- Third project – The user completes a worksheet where all the labels and numbers are already typed.
- Selection techniques. This module discusses single range and multiple range selections. Resizing selections using the keyboard.
- Working with worksheets. Inserting, deleting, renaming, moving, copying and hiding worksheets.
- Copying and pasting. Excel offers a range of copying and pasting features for different need. This module discusses copy data and copy as a an image and normal pasting. Understanding Paste Special options.
- Fourth projects – We look at a couple of exercises where Paste Value is essential to the completion of these exercises.
- Other formatting features like formatting columns and rows and understanding the Draw Borders tool.
- Preparing for printing. Understanding the benefits of the Page Layout View and how to add a header and a footer using this view.
- Getting familiar with Page Break Preview and Page Setup. Working with page breaks.
- Final projects – We complete two exercises hard to print and set them up for printing.
In this introduction the user gets a lot of hands-on practice in order to have a feel for how Excel works. In this first installment users will have an opportunity to learn more than a dozen of keyboard shortcuts.