Instructor Led Excel Training in North Carolina, USA

Microsoft ® Office 2010 Tips & Timesavers Course Description: Based on the besta selling courses in our KSI's history, John Sweet has developed this one day course that is filled with everya day shortcuts and timesavers that truly are a wow!a moments. The course is filled with tips for the experienced Microsoft Office user, and includes some of the newest features in MS Office 2010 designed to enhance your productivity. Don' t miss  more...

Microsoft Excel Advanced Topics Software Version 20072010 ...Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. Course Objectives: enhance productivity and efficiency by streamlining the workflow. collaborate with other workbook users. audit worksheets. analyze data. work with multiple workbooks. import and  more...

Microsoft Excel 2010 Level II Intermediate Course Objectives: use advanced formulas. organize worksheet and table data using various techniques. create and modify charts. analyze data using PivotTables, Slicers, and PivotCharts. insert and modify graphic objects in a worksheet. customize and enhance workbooks and the Microsoft Office Excel environment.  more...

Microsoft Excel Level I Foundations Course Objectives: create a basic worksheet by using Microsoft Excel 2010. perform calculations in an Excel worksheet. modify an Excel worksheet. modify the appearance of data within a worksheet. manage Excel workbooks. print the content of an Excel worksheet.  more...

Microsoft Excel Advanced Topics-2007 2010 ...Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. Course Objectives: enhance productivity and efficiency by streamlining the workflow. collaborate with other workbook users. audit worksheets. analyze data. work with multiple workbooks. import and  more...

Excel Crash Course Course Description: The first day of this course, you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. On the second day, you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.  more...

Microsoft Excel 2007 Level III Advanced ...Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, 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  more...

MicrosoftOffice 2010 Transitioning from Office 2003 identify the features that are common to all applications in the Microsoft Office suite. modify documents using Microsoft Office Word 2010. present spreadsheet data using Microsoft Office Excel 2010. create Microsoft Office PowerPoint 2010 presentations. work with databases using Access 2010. manage tasks using the new features in Microsoft Office Outlook 2010. share files in Microsoft  more...

Excel Macro Programming Level II Take this course to develop a strong understanding of the Excel object model used in VBA. Learn advanced Variable concepts, exploit VBA tools and functions.  more...

Excel Macro Programming Level I After completing this course, participants will be able to: Use the VB Recorder to create macros Learn and practice six different ways to run macros Learn how to open the Visual Basic Editor (VBE) Understand the VBE interface Use 4 simple rules for learning the Visual Basic for Application language (VBA) Practice simple edits in VBA using messaging tools, simple branching  more...

Microsoft Excel 2007 Formulas Functions PivotTables for the Advanced Excel User Take this course if you want to learn useful tools, tricks and tips for utilizing functions and formulas available in Microsoft Excel 2007. Learn which are best suited from over 300 available built-in functions. If you need to analyze large amounts of data quickly and easily, this class covers PivotTables - Excel's best resource for doing so.  more...

Microsoft Excel 2007 Level II Intermediate This course is designed for the Excel user who has attended the Foundations course or who is proficient with those topics covered.  more...

Office 2007- New FeaturesTarget Student This course is a high-level overview of those features of Microsoft Office 2007 that a ...acro file formats. In addition, dedicated units for Word, Excel, PowerPoint, Outlook, and Access introduce the some of the new features of each application. Course Content: Unit 1: The Office 2007 interface Topic A: The Office Button menu Topic B: The Ribbon Topic C: The Mini toolbar Topic D: The Quick Access toolbar and the Status bar Unit 2: The Office XML file format Topic  more...

Office 2007-2 Days of NonstopTips, Shortcuts, and TImesavers ... prior) Course Content: Learn every-day useful tools in Excel, Outlook, PowerPoint and Word. This course is designed for people who have either already attended formal training, or consider themselves seasoned users of each of the applications. Think you know the ins and outs of Microsoft Office? You will be taken back by all of the non-stop tips and timesavers in this fast-paced,  more...

Access 2007 Level II Intermediate Target Student: Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a  more...

Microsoft Office 2007 Crash Course Learn the Fundamentals of Excel Outlook PowerPoint and Word in Two Days ...e management techniques through a "quick start" for Word, Excel, PowerPoint, and Outlook. If you have never had formal training (or need a refresher), or if you are new to the Office 2007 Suite, this is the perfect course for you! This two-day course serves as a prerequisite for all intermediate-level classes, so there is no need to register for this class in addition to, for example,  more...

Microsoft Excel 2007 Macros Crash Course Learn VBA Programming in Two Days Overview Save time and increase productivity by automating mundane and repetitive tasks with Macros and VBA procedures. Develop a strong understanding of the Excel 2007 object model used in VBA. Learn advanced Variable concepts. Exploit VBA tools and functions.  more...

Excel for Beginners April 5 930 to 100 6900 Starting the program and creating a workbook. What is an active cell and all about the Excel cell referencing system. Entering numbers vs. text, selecting a cell, a range etc., adding up a column of numbers and using basic formulas, saving a workbook, adding a worksheet to a workbook. Saving a template workbook with a different name. Getting help online.  more...

Spreadsheets You will learn both basic and advanced Excel techniques including templates, charts, graphics and formulas. In these college courses you will learn all about how to work with Excel. You will learn how to apply this knowledge to business situation in order to summarize and analyze large amounts of data.  more...