Microsoft Access 2013 - Level 1MS_ACCESS2013L1Microsoft Access 2013 - Level 1<p>In Access 2013 Level 1 students learn the basic skills and concepts needed to use Microsoft Access 2013 productively and efficiently. Topics covered include reviewing the Access 2013 environment, effectively planning databases, creating tables, organizing fields and records, and working with data entry rules. Students will also learn how to create basic queries, and how to work with forms and reports.</p><p>This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.</p>http://springhouse.com/course-catalog/MS_ACCESS2013L12/21/2017 7:47:47 PM0782aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse72080a38-092d-e211-85fe-00155d00bf00
Microsoft Access 2013 - Level 2MS_ACCESS2013L2Microsoft Access 2013 - Level 2<p>You will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields. </p>http://springhouse.com/course-catalog/MS_ACCESS2013L22/21/2017 7:47:55 PM0783aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse03442f4e-092d-e211-85fe-00155d00bf00
Microsoft Access 2013 - Level 3MS_ACCESS2013L3Microsoft Access 2013 - Level 3<p>In Microsoft Access 2013 Level 3 students will learn advanced features of Access. Topics covered include querying with SQL, writing advanced queries, working with macros, importing, exporting and linking objects, and performing database maintenance.</p>http://springhouse.com/course-catalog/MS_ACCESS2013L32/21/2017 7:48:01 PM0784aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsebce5036e-092d-e211-85fe-00155d00bf00
Microsoft Access Programming with VBAMS_ACCVBAMicrosoft Access Programming with VBA<p>Access Programming with VBA class teaches students how to examine and plan an application. Topics covered include automating forms, creating custom toolbars and menu bars, working with VBA code, and advanced VBA programming.</p>http://springhouse.com/course-catalog/MS_ACCVBA5/22/2017 4:13:04 PM0119aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse414d4710-4852-de11-b465-00155d00bf00
Microsoft Excel 2013 - Level 1MS_EXCEL2013L1Microsoft Excel 2013 - Level 1<p>Microsoft Excel 2013 is the most widely accepted spreadsheet tool available today. Students taking the Basic Excel course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Students will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. They will create and modify charts, and work with graphics. Finally, they will review workbooks for spelling errors, modify page setup, and print worksheets. </p>http://springhouse.com/course-catalog/MS_EXCEL2013L13/3/2017 9:37:57 PM0785aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse487f6999-092d-e211-85fe-00155d00bf00
Microsoft Excel 2013 - Level 2MS_EXCEL2013L2Microsoft Excel 2013 - Level 2<p>Students taking the Intermediate Excel course will work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.                                             </p>http://springhouse.com/course-catalog/MS_EXCEL2013L23/3/2017 9:37:57 PM0786aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse7f544bb5-092d-e211-85fe-00155d00bf00
Microsoft Excel 2013 - Level 3MS_EXCEL2013L3Microsoft Excel 2013 - Level 3<p>You will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. Students will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code. </p>http://springhouse.com/course-catalog/MS_EXCEL2013L33/3/2017 9:37:57 PM0787aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsea80b50d2-092d-e211-85fe-00155d00bf00
Data Analysis using PowerPivotMS EXC 2010 PPData Analysis using PowerPivot<p>​​You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.</p>http://springhouse.com/course-catalog/MS EXC 2010 PP9/22/2017 3:55:07 PM02664aspx39http://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse6bf01489-62bc-e411-abf8-00155d0a1406
Microsoft Power ViewMS_PowerViewMicrosoft Power View<p>​Explore data in insightful new ways and transform the way your enterprise uses BI with help from this expert guide. <em>Visualizing Data with Microsoft Power View</em> shows how to effectively analyze and communicate complex information through elegant interactive reports. Discover how to create and populate tables, connect to databases, build multi-view reports in real-time, and publish your results to end-users. BI Semantic Model development and administration are also covered in this comprehensive volume. </p>http://springhouse.com/course-catalog/MS_PowerView6/13/2016 7:20:34 PM03025aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse24c82c7f-b9cb-e311-97ab-00155d00bf00
Microsoft Excel Macro Programming/VBAMS_ExcelVBAMicrosoft Excel Macro Programming/VBA<p>​The Visual Basic for Applications programming language is a powerful addition to all Office, and particularly useful in Microsoft Excel.</p>http://springhouse.com/course-catalog/MS_ExcelVBA9/22/2017 3:55:06 PM0777aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsee94d38cf-1ce3-e111-a9a7-00155d00bf00
Microsoft Outlook 2013 - Level 1MS_OUTLOOK2013L1Microsoft Outlook 2013 - Level 1<p>Microsoft Outlook 2013 is more than just email, it’s your full-time personal assistant. Students taking the Basic Outlook course will learn how to send email, schedule appointments and meetings, manage contacts, and create tasks.</p>http://springhouse.com/course-catalog/MS_OUTLOOK2013L112/19/2016 6:33:11 PM0788aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse74973130-0a2d-e211-85fe-00155d00bf00
Microsoft Outlook 2013 - Level 2MS_OUTLOOK2013L2Microsoft Outlook 2013 - Level 2<p>Students taking the Advanced Outlook course will learn how to customize the Outlook environment, create custom messages, organize and manage mailboxes, create notes and journal entries and several methods of collaboration.</p>http://springhouse.com/course-catalog/MS_OUTLOOK2013L212/19/2016 6:33:11 PM0789aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsed8840d48-0a2d-e211-85fe-00155d00bf00
Time Powered Outlook - Your Time & MS OutlookPDSP_TIMEOUTLOOKTime Powered Outlook - Your Time & MS Outlook<p>E-mail has been voted as one of the toughest challenges to end user productivity.  It is a major cause of stress and often overpowers the benefits of desktop technology by dominating the day at the expense of many other critical tasks.  Even seasoned workers with an accomplished sense of time management are challenged to tame the e-mail beast.  </p> <p>Springhouse has created a most unique course aimed directly at assisting end users with both Time Management and the taming of e-mail through the effective management of Microsoft Outlook.  The course begins with participation in a time mastery survey which assists the student in understanding their personal responses to time issues.  Using the survey results as a guide, the class dives into principals of time management (improving workflow and reducing stress) by matching the unique features of Outlook which support the major principals of Time Management.  The result is a fuller understanding of the most appropriate use of Outlook and Time Management principals for each student.  </p>http://springhouse.com/course-catalog/PDSP_TIMEOUTLOOK1/6/2017 5:19:46 PM0120aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse814d4710-4852-de11-b465-00155d00bf00
Microsoft PowerPoint 2013 - Level 1MS_PPT2013L1Microsoft PowerPoint 2013 - Level 1<p>Microsoft PowerPoint 2013 can take any presentation from average to extraordinary. Students taking the Basic PowerPoint course will open and run a presentation and switch between views. They’ll create a basic presentation and add content; arrange, insert, and delete slides; and apply templates and design themes. Then, they’ll learn how to create and edit shapes, insert and modify WordArt objects and pictures, and work with tables, charts, and diagrams. Finally, they’ll learn how to proof a presentation, create speaker notes, and present and share their presentations. </p>http://springhouse.com/course-catalog/MS_PPT2013L112/19/2016 6:32:56 PM0790aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalseb993d377-0a2d-e211-85fe-00155d00bf00
Microsoft PowerPoint 2013 - Level 2MS_PPT2013L2Microsoft PowerPoint 2013 - Level 2<p>Students taking the Advanced PowerPoint course will learn to control global settings by using slide masters, and to apply effects such as transitions and timings. They’ll learn more about working with images, and how to include media files, animation, and a photo album in a presentation. Next, they’ll explore advanced tools for working with SmartArt, tables, and charts, and then learn how to create action buttons and equations. Students will also integrate other Microsoft Office files, embed and link external resources, and create hyperlinks. Then, they’ll insert review comments, protect a presentation with a password, and prepare a presentation for delivery in various formats. Finally, they’ll customize application settings and toolbars, and create and apply custom themes. </p>http://springhouse.com/course-catalog/MS_PPT2013L212/19/2016 6:32:56 PM0795aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse565bd592-0a2d-e211-85fe-00155d00bf00
Microsoft Publisher 2013MS PUBLISH2013Microsoft Publisher 2013<p>​Microsoft Publisher is a powerful desktop publishing software that provides all the tools you need to create, customize and share a wide variety of professional looking publications and marketing material.  Come join our intensive 1-day class in Publisher and learn to publish like a pro!</p>http://springhouse.com/course-catalog/MS PUBLISH201312/19/2016 6:32:52 PM04338aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsef6a8aa53-d67b-e411-86f4-00155d0a1406
Microsoft Visio 2013 Level 1MS_VISIO2013L1Microsoft Visio 2013 Level 1<p>​In Microsoft Visio 2013 Level 1 students will learn the skills necessary to be able to create a wide variety of charts and diagrams. In this course students will learn how to use stencils, scale and resize objects, draw basic shapes and compound lines, and arrange objects. They will also learn how to create diagrams, work with text, apply formatting, work with background pages, and set file and print properties. Finally, students will create network and brainstorming diagrams, set shape properties, and create reports.</p>http://springhouse.com/course-catalog/MS_VISIO2013L112/19/2016 6:32:45 PM0809aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsea33b8bbf-11a9-e211-b746-00155d00bf00
Microsoft Visio 2013 Level 2MS_VISIO2013L2Microsoft Visio 2013 Level 2<p>​Microsoft Visio 2013 Level 2 builds on the concepts and skills taught in Visio Level 1. In this course students will learn how to work with layers, create custom themes, stencils and templates, and create business and project management diagrams. They will also learn how to integrate Visio with other Office programs, create software and database diagrams, and present diagrams both in Visio and in a web browser.</p>http://springhouse.com/course-catalog/MS_VISIO2013L212/19/2016 6:32:45 PM0810aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsec080cd11-12a9-e211-b746-00155d00bf00
Microsoft Word 2013 - Level 1MS_WORD2013L1Microsoft Word 2013 - Level 1<p>In Word 2013 Level 1 students will learn all the basics of creating, editing and formatting documents in this powerful word processing software.  Topics covered include editing and formatting text, creating and inserting tables, inserting headers and footers, adding graphics and clip art, and proofing, printing and exporting documents.</p>http://springhouse.com/course-catalog/MS_WORD2013L112/19/2016 6:32:26 PM0792aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse09146f42-0b2d-e211-85fe-00155d00bf00
Microsoft Word 2013 - Level 2MS_WORD2013L2Microsoft Word 2013 - Level 2<p>In Word 2013 Level 2 students will further build on the skills acquired in the Microsoft Word basic course. Students will learn to use styles and outlines, and how to format tables. Then they will insert SmartArt diagrams, work with shapes, and format text graphically. They will also learn how to format a document by adding sections, columns, and design elements such as watermarks and themes. In addition, they will use Track Changes and prepare documents for sharing and exporting. Finally, students will learn how to work with fields and perform a mail merge. </p>http://springhouse.com/course-catalog/MS_WORD2013L212/19/2016 6:32:26 PM0793aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsecbf66660-0b2d-e211-85fe-00155d00bf00
Microsoft Word 2013 - Level 3MS_WORD2013L3Microsoft Word 2013 - Level 3<p>You will have the advanced skills and concepts students need to use Microsoft Word 2013 productively and efficiently. Students will learn to add interactive elements such as forms and content from other applications, and to save a file as a web page. Then they will learn how to use document references such as citations, indexes, and tables of contents. Next, they will learn to work more efficiently in Word by customizing the ribbon, creating macros, using building blocks, and inserting subdocuments. In addition, students will learn to record and copy macros, to create and modify VBA modules, and to control Word objects in the Visual Basic Environment. Finally, students will learn the fundamentals of VBA programming through creating control structures, designing VBA forms, and debugging programs. </p>http://springhouse.com/course-catalog/MS_WORD2013L312/19/2016 6:32:25 PM0794aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse5fc99f80-0b2d-e211-85fe-00155d00bf00
What’s New in Office 2013: Transitioning from Office 2007/2010 to Office 2013MS_OFFICE2013NFWhat’s New in Office 2013: Transitioning from Office 2007/2010 to Office 2013This course covers those features of Microsoft Office 2013 that are new to the Office system, with dedicated units for the new features of each application. Students will learn about changes to Backstage View and the Ribbon, including more general overview of using and customizing the Ribbon for those more familiar with Office versions previous to 2010. They will also learn Office 2013's new online features, including account sign-in, cloud storage, and online services. In Word they will use new tools to navigate and review documents, reply to comments, format a document, align graphics, work with tables, and open PDF files in Word. In Excel they will format data with the Flash Fill and Quick Analysis tools, insert charts and PivotTables using recommendations, and format a chart with the new tool buttons. In PowerPoint they will apply theme variants, match colors with the Eyedropper, create custom shapes, and rehearse a presentation in Presenter view. Finally, in Outlook they will use new interface and message elements, explore the new People View, and compose inline replies. http://springhouse.com/course-catalog/MS_OFFICE2013NF12/23/2016 8:01:33 PM01493aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse04147703-0a2d-e211-85fe-00155d00bf00
50433 PowerPivot for End Users5043350433 PowerPivot for End Users<p>​In this course students will learn how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. Students will also explore how PowerPivot workbooks can be integrated with SharePoint 2010. </p>http://springhouse.com/course-catalog/504335/26/2017 1:52:47 PM02716aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse182e0567-eb81-e311-83c4-00155d00bf00
55040 Data Mining/ Predictive Analytics with Analysis Services and PowerPivot5504055040 Data Mining/ Predictive Analytics with Analysis Services and PowerPivot<p>This course may be funded with Microsoft Software Assurance Training Vouchers (SATVs).</p><p>​​This three-day instructor-led course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilizing the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins.</p>http://springhouse.com/course-catalog/550405/26/2017 1:53:57 PM02025aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse69928c94-b2c6-e511-a1ec-00155d0a1406
55084 Excel 2013 Self-Service Analytics with No Code for the End User5508455084 Excel 2013 Self-Service Analytics with No Code for the End User<p>This course may be funded with Microsoft Software Assurance Training Vouchers (SATVs).</p><p>​This course is designed for the end users and analysts that are interested in exploring the new self-service business intelligence tools in Excel and SharePoint Server 2013.</p>http://springhouse.com/course-catalog/550845/26/2017 1:53:57 PM03334aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsefdf89c4c-1519-e611-a1ec-00155d0a1406
55108 Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)5510855108 Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)<p>This course may be funded with Microsoft Software Assurance Training Vouchers (SATVs).</p><p>​This course is intended to expose you to PowerPivot Data Analytic Expressions (DAX) concepts such as the Data Model and evaluation context, DAX functions, operators, and constants. This release adds a module on the Data Model, an introduction to patterns, and has lab versions for both Excel 2010 and 2013.</p>http://springhouse.com/course-catalog/551085/26/2017 1:53:57 PM03970aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse79963d6a-1519-e611-a1ec-00155d0a1406

Microsoft Gold Partner

PMI R.E.P.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.
The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 - info@springhouse.com