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.
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.
Microsoft Excel Level 1: Introduction to Excel
Recommended for individuals who are new to Microsoft Excel or have limited spreadsheet experience, or ideal if you just need a refresher! 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.
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.
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 and pivot tables. Students will also learn how to customize and automate Excel using macros.
Microsoft Excel: Creating and Using Pivot Tables (1/2 Day)
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.
Excel 2007: Introduction to Programming in 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 2 and 3.
Questions? Email us at learn@vtec.org or call us at (207)775.0244
