Microsoft Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions.
You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners.
By sharing a spreadsheet using Office Excel, you can navigate, sort, filter, input parameters, and interact with PivotTable views directly on the Web browser.
We offer classes for Excel 2002, Excel 2003, Excel 2007 and Excel 2010.
Our instructor led courses are filled with examples and designed with hands-on lab exercises so you can practice as you learn.
Our state of the art training rooms provide individual workstations to maximize your learning experience. We limit class size to 12 students, making the learning experience interactive yet personalized.
Bring a Buddy to class and save 10%
Register a colleague to attend class with you and you both get an additional 10% off the price of the course!
Microsoft Excel Level 1: Introduction to Excel
Recommended for individuals who are new to Microsoft Excel or have limited spreadsheet experience. This course will provide an introduction to spreadsheets and the practical uses and versatility of Excel. Students will learn time saving features and tips for using Excel effectively.
We offer this course in both Office 2003 as well as Office 2007
Microsoft Excel Level 2: Intermediate Topics
This intermediate course teaches spreadsheet users about additional features available in Excel. Key topics include naming ranges, protecting worksheets, linking between worksheets, and charting.
We offer this course in both Office 2003 as well as Office 2007
Microsoft Excel Level 3: Advanced Topics
This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel tools and features. Students will learn to apply custom formatting, and to use VLOOKUP function as well as how to use lists. Students will also learn how to customize and automate Excel using macros.
We offer this course in both Office 2003 as well as Office 2007
Microsoft Excel Level 4: Beyond the Spreadsheet
This course will go above and beyond all other Excel courses. Students will learn how to generate and edit custom lists as well as use custom views. Students will also learn how to efficiently use hyperlinking in spreadsheets and how to use the formula auditing feature. Working with comments and scenarios will also be covered in this course.
We offer this course in both Office 2003 as well as Office 2007
Microsoft Excel: Introduction to VBA
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. In Excel: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel: Level 1 and Excel: Level 2.
Microsoft Excel: Creating and Using Pivot Tables
Your worksheet has lots of data, but do you know what the numbers mean? Does your data answer all your questions? PivotTable reports can help to analyze numerical data and answer questions about it.
In seconds you can see who sold the most, and where. See which quarters were the most profitable, and which product sold best. Ask questions, see the answers.
With PivotTable reports, you can look at the same information in different ways with just a few mouse clicks. Data swings into place, answering questions, telling you what the data means.
We offer this course in both Office 2003 as well as Office 2007.
Transitioning to Microsoft Office Excel 2007
Microsoft Excel 2007 has been redesigned so that you can find and use program capabilities more easily. The overall look and feel has been streamlined. And, new enhancements to old tools make analyzing, sharing and managing important business information that much easier. In this instructor-led hands-on course, you will work the new tools and improved interface of Excel 2007.
If you require a custom or dedicated training program for your company, contact a VTEC Education Specialist at 207.775.0244, or email sales@vtec.org .
