Time: 9am - 4pm
Duration: 1 day
Compatible with 2013
This Foundation level is intended to help all novice computers get up to speed quickly. Understanding and experience with printing and using a Web browser is an asset, but not required. No previous experience with other versions of Excel is necessary.
This course is currently available in another city, on demand or for private classes only. Call us at 888.484.2933 to learn more about our flexible scheduling options or complete our Information Request Form and we will contact you to arrange a class date that is suitable to your availability.
- Getting Started
- This section teaches students everything they need to know about opening, interacting with, and closing Excel. In this section, students will learn about workbooks, worksheets, file types, and how to navigate around a spreadsheet. The Help feature is also covered in detail.
- The Excel Interface
- In order to get the most out of Excel, students need to know where to find commands. This section covers the basics of the Quick Access Toolbar and the basics of the Home, Insert, Page Layout, Formulas, Data, and Review tabs. A high-level overview of each tab and associated command groups is included, along with exercises that experiment with some of these commands.
- Excel Basics
- This section will teach everyone how to do day-to-day things in Excel. Topics include creating worksheet labels, printing, using features like AutoSum and AutoFill, and how to perform the ubiquitous Cut/Copy/Paste operations. Students will also be given a gentle introduction to using formulae, using Paste Special, dealing with advanced paste operations, perform Find and Replace operations, and how to check their spelling.
- Conditional Formatting
- Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.
- Editing your Workbook
- Now that students have had a chance to work with the basics and are comfortable with the interface, this section will teach them how to make Excel do more than just display black and white data. Students will learn how to modify cells and cell data, perform a number of cell formatting operations, and use styles and borders. Students will also get a comprehensive introduction to creating and modifying different types of charts. Finally, students will learn the importance of relative and absolute cell referencing.
- Printing and Viewing your Workbook
- This final section will help students display their data in different ways. Topics include an in-depth examination of the View tab, how to work with multiple worksheets at once, and finally how to print their final product. At the end of this section, students should be well on their way to becoming a competent every-day user of Excel.
Private training is available for this course.
Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.