|
(800) 716-4324 info@academyx.com |
|
Training Links Register |
Excel 2007 Intermediate Class
You know the basics after our intro Excel class. Now delve deeper and learn more ways to speed up your work with our Intermediate Excel 2007 training class.
Excel: Multiple Worksheets & Workbooks Excel 2007 allows you to reference data from other worksheets, and even incorporate data from multiple Excel files into a single formula. In this part of the course you will learn how to:
Advanced Formatting in Excel Excel 2007 gives you several formatting tools to improve the look and feel of your spreadsheets, or even to compact your worksheet or a portion of it onto one printable page. We'll show you several tricks to accomplish this. In this part of the course we will explore how to:
Outlining & Subtotals in Excel Excel 2007 offers a number of tools and techniques that make it easier to navigate and work with large worksheets with lots of data. Since it isn't always necessary to see all the data on a particular worksheet, we'll show you how to use Excel's handy options for summarizing data. In this section you will practice how to:
Cell & Range Names in Excel Simplify your life! Instead of referring to cells as A8 or C23, you can assign logical names like "expenses" or "tax rate" to cells or ranges. You can then use these names when you create formulas elsewhere in your spreadsheet. In this part of the class we cover how to:
Excel: Lists and Tables Another way to organize data in a concise and logical format is with lists and tables - separate sets of data within your worksheets. Once a list or table has been defined, you can sort, filter, and subtotal its contents. We will show you how to:
Excel Web & Internet Features With just a few simple steps you can save your workbook as a web page, and make it available to anyone with a browser and a connection to your web site or intranet. Moreover, Excel 2007 makes it simple to ensure that the web-enabled version of the workbook is always up-to-date. In this section of the course we'll explore how to:
Advanced Charting in Excel Though you may know how to create a chart in Excel, you may not be aware of all the helpful chart tools that Excel 2007 provides. Here, we explore some of the more complex and interesting chart options to take your presentations and data management to the next level. In particular, you will learn about how to:
Auditing in Excel Make sure your data is error-free and clean. Auditing is the process of tracing how formulas are dependent on each other and on cells, so you can track down errors and circular references. In this section of the course, we discuss how to:
Excel Templates Excel 2007 offers over a hundred built-in or downloadable templates: calendars, balance sheets, expense reports, budgets, invoices, and more. You can save a lot of setup and formatting time by using these built-in templates, and you can even create your own templates. In this final part of the course, you will master how to:
Prerequisites:
Intermediate Excel classes are offered at four locations:: |
Newsletter subscribers can win $100 credit!