P: 307-686-3025
F: 307-686-7563
info@k2technologies.net
HomeIT SolutionsTrainingTelephone ServicesWeb DesignSupportContact
Class List

 Microsoft Access 2003 Level I
 Microsoft Access 2003 Level II
 Microsoft Access 2003 Level III
 Microsoft Access 2007 Level I
 Microsoft Access 2007 Level II
 Microsoft Access 2007 Level III
 Microsoft Excel 2003 Level I
 Microsoft Excel 2003 Level II
 Microsoft Excel 2003 Level III
 Microsoft Excel 2003 Level IV
 Microsoft Excel 2007 Level I
 Microsoft Excel 2007 Level II
 Microsoft Excel 2007 Level III
 Microsoft Excel 2007 Level IV -Power User
 Microsoft Excel 2007 Level V - VBA Programming
 Microsoft Office 2007 Basics - For Outlook, Excel and Word
 Microsoft Outlook 2003 Level I
 Microsoft Outlook 2003 Level II
 Microsoft Outlook 2007 Level I
 Microsoft PowerPoint 2003 Level I
 Microsoft PowerPoint 2003 Level II
 Microsoft PowerPoint 2007 Level I
 Microsoft Powerpoint 2007 Level II
 Microsoft Project 2003 Level I
 Microsoft Project 2003 Level II
 Microsoft Project 2007 Level I
 Microsoft Project 2007 Level II
 Microsoft Publisher 2003 Level I
 Microsoft Publisher 2003 Level II
 Microsoft Publisher 2007 Level I
 Microsoft SharePoint Designer 2007 Level I
 Microsoft Windows 7 - Basic
 Microsoft Windows 7 Advanced
 Microsoft Windows 7 – New Features
 Microsoft Windows XP - Advanced
 Microsoft Windows XP - Basic Skills
 Microsoft Word 2003 Level I
 Microsoft Word 2003 Level II
 Microsoft Word 2003 Level III
 Microsoft Word 2003 Level IV
 Microsoft Word 2007 Level I
 Microsoft Word 2007 Level II
 Microsoft Word 2007 Level III
 Photoshop Elements 8.0: Level I
 QuickBooks Pro 2010 – For Windows: Advanced
 QuickBooks Pro 2010 – For Windows: Introduction
 Testing card
 Using Facebook To Enhance Your Business - Introduction
Microsoft Excel 2007 Level III
Class Duration:6 hours
Class Cost:$149.00
Students in this 6 hour course will build on their skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, match, and INDEX. In additions, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver0, running and recording macros, and sharing Excel data via the Web.
 




An upcoming training session for this course has not been scheduled yet.

Please contact us for the next available session.
Microsoft Certified Partner