Now offering Microsoft Office 2013 Training Courses

Microsoft Office has long been the most popular productivity suite used by more people than any other. The new Office 2013 is packed with powerful new features. Whether you’re an IT administrator managing a user community, or a network manager supporting Office 2013 on your network, Office 2013 training from Certified Staffing Solutions will prepare you to help your users get the most out of this new platform. With new “use-anywhere” capabilities and incredible new user features, there’s much to learn. Learn about it from Certified Staffing Solutions!


Individual Training

Just yourself needing training?

  • Live Instructor-led online classes
  • Appropriate for individuals
  • Attend class from home or office
  • NOT e-Learning - live instructors teaching

Group Training

Have a group needing training?

  • Private training at your office
  • Appropriate for groups of 5 or more students
  • Custom classes based on your needs

Microsoft Office 2013 Courses

Access 2013 - Advanced - 1 days
This ILT Series course builds on the skills and concepts taught in Access 2013: Basic and Access 2013: Intermediate. 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.


Access 2013 - Basic - 2 days
This ILT Series course covers the basic skills and concepts students need to use Microsoft Access 2013 productively and efficiently. After an introduction to the Access 2013 environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports. 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.


Access 2013 - Intermediate - 2 days
This ILT Series course provides students with additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. They 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. 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.


AutoCAD 2012/2013 Advanced - 3 days
AutoCAD 2012/2013 Advanced introduces advanced techniques and teaches you to be proficient in your use of AutoCAD. This is done by teaching you how to recognize the best tool for the task, the best way to use that tool, and how to create new tools to accomplish tasks more efficiently.

AutoCAD 2012/2013 Essentials - 3 days
The objective of AutoCAD 2012/2013 Essentials is to enable students to create a basic 2D drawing in AutoCAD. All topics, including features and commands, relate to both AutoCAD and AutoCAD LT unless specifically noted otherwise in the training guide.

AutoCAD 2013/2014 3D Drawing and Modeling - 3 days
AutoCAD 2013/2014 3D Drawing and Modeling introduces students who are proficient with the 2D commands in the AutoCAD® software to the concepts and methods of 3D modeling. This course provides a thorough grounding in the fundamentals of 3D and explores the main features of the advanced 3D Modeling workspace in the AutoCAD software.

Crystal Reports 2013 Part 1 - 2 days
Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports 2013 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2013 helps you build advanced reports with ease, presenting complex information in an understandable way.


Crystal Reports 2013 Part 2 - 2 days
Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports 2013. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.
Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved.


Excel 2013 - Advanced - 1 days
In this ILT Series course, students will further build on the skills acquired in the Microsoft Excel 2013 Basic and Intermediate courses. They 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. They 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. 

Excel 2013 - Basic - 1 days
This ILT Series 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.

Excel 2013 - Intermediate - 1 days
This ILT Series course will teach students how to 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.

MCSE Exchange Server 2013 Boot Camp - 8 days
This Microsoft Certification Camps Exchange Server 2013 bootcamp will provide you with the knowledge and skills to design, deploy, configure an Exchange Server 2013 messaging environment. This course is designed to provide qualified Microsoft Professionals to earn the Microsoft Certified Solutions Expert (MCSE): Messaging for Exchange Server 2013 certification. This program is designed to provide you with cutting-edge skills development. We provide you with expert instruction and our hands-on labs that are accelerated and based on real-world scenarios. We offer test preparation and our 100% test pass guarantee. The exam preparation for two exams to help you acheive Exchange Server 2013 MCSE Messaging certification. They are:Exam 70-341 MCSA: Microsoft Exchange Server 2013, Core Solutions of Microsoft Exchange Server 2013And Exam 70-342 MCSE: Advanced Solutions of Microsoft Exchange Server 2013.

This course can be attended live online or in person in Orlando, Florida.


MCSE: Sharepoint 2013 Administration Boot Camp - 8 days
Our SharePoint 2013 Boot Camp is a 8-day course that immersed students into hands-on lab environment covering all essential aspects of working with and supporting SharePoint 2013. You will build a Multi-Layer SharePoint environment from the ground up. Starting from the Domain Controllers to the Web Front Ends to SQL Back ends. Our course incorporates interactive demostrations by SharePoint Engineers with Real World exampls that go past the book. Providing students with additional insight into Design, Planning, Implementation, User Experience and Troubleshooting. You will discover how to effectively deploy and configure a multi-layer SharePoint 2013 environment. Each Microsoft Certification Boot Camp will start on a Wednesday and end on a Wednesday.

This course can be attended live online or in person in Orlando, Florida.


Outlook 2013 - Advanced - 1 days
This ILT Series course builds on the skills and concepts taught in Outlook 2013: Basic. Students will learn how to customize Outlook, use Quick Steps, create Folder pane shortcuts, customize the Navigation bar, customize their messages and signatures, and set up automatic replies. Then students will learn how to set rules for organizing messages and use advanced techniques for managing and maintaining their mailboxes. Students will also learn how to search various folders, use filters, and apply categories, as well as how to work with notes and Journal entries. Finally, they will learn how to share Outlook calendars and contacts and stay informed with RSS feeds. This course will help students prepare for the Microsoft Office Specialist exam for Outlook 2013 (exam 77-423). For comprehensive certification training, students should complete the Basic and Advanced courses for Outlook 2013. 


Outlook 2013 - Basic - 1 days
This ILT Series course covers the basic functions and features of Outlook 2013. After an introduction to Outlook’s window components, students will learn how to read and send email messages using several methods. Then they will learn how to manage email messages and attachments, configure message options, and use basic search functions. Students will also learn to manage contacts and contact groups, work with tasks, and create appointments. Finally, they will learn to send and respond to meeting requests. This course will help students prepare for the Microsoft Office Specialist exam for Outlook 2013 (exam 77-423). For comprehensive certification training, students should complete the Basic and Advanced courses for Outlook 2013. 


PowerPoint 2013 - Advanced - 1 days
This ILT Series course builds on the skills and concepts taught in PowerPoint 2013: Basic. Students 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. This course will help students prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, students should complete the Basic and Advanced courses for PowerPoint 2013.


PowerPoint 2013 - Basic - 1 days
This ILT Series course covers the basic functions and features of PowerPoint 2013. After an introduction to PowerPoint’s window components, students 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. This course will help students prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, students should complete the Basic and Advanced courses for PowerPoint 2013.


Project 2013 - Advanced - 1 days
This ILT Series course builds on the concepts and skills taught in Project 2013: Basic. Students will learn how to work with templates, create baseline plans, monitor and update projects, analyze project statistics, handle delays and conflicts, create reports, share resources, consolidate projects, and customize Project. Students will also learn how to communicate project information by using Project Server 2013, and how to integrate Project data with other Office applications.

Project 2013 - Basic - 1 days
This ILT Series course teaches the basic commands and features of Microsoft Project 2013. Students will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. Students will also apply filters and groups, and sort task and resource data. Finally, they will learn how to resolve resource conflicts.

Microsoft Publisher 2013 - 1 days
Microsoft® Publisher is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher offers a large selection of ""building blocks"" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates mail merge features, which is handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Microsoft Publisher makes it easy to create and edit publications.

QuickBooks 2013 - Level 1 - 1 days
This course covers the fundamentals of using QuickBooks 2013 to show you how to track the finances of a small business. Students will learn how to set up a company, work with lists, set up inventory, sell your product, invoice for services, process payments, work with bank accounts, enter and pay bills and use the EasyStep Interview.

QuickBooks 2013 - Level 2 - 1 days
This course builds on the skills and concepts taught in QuickBooks 2013: Level 1. Students will learn how to memorize transactions, customize forms, use other QuickBooks accounts, create reports, create graphs, track and pay sales tax, prepare payroll with QuickBooks, use online banking, share files with an accountant, estimate, time track, and job cost and write letters.

Core Solutions of Microsoft SharePoint Server 2013 (70-331) - 5 days
This course will provide you with the knowledge and skills to configure and manage a Microsoft SharePoint Server 2013 environment. This course will teach you how to configure SharePoint Server 2013, as well as provide guidelines, best practices, and considerations that will help you optimize your SharePoint server deployment.
After completing this course, students will be able to: Describe the key features of SharePoint 2013, Design an information architecture, Design logical and physical architectures, Install and configure SharePoint Server 2013, Create web applications and site collections, Plan and configure service applications, Manage users and permissions, Configure authentication for SharePoint 2013, Secure a SharePoint 2013 deployment, Manage taxonomy, Configure user profiles, Configure enterprise search and Monitor and maintain a SharePoint 2013 environment.


Advanced Solutions of Microsoft SharePoint Server 2013 (70-332) - 5 days
This course examines how to plan, configure, and manage a Microsoft SharePoint Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the Search experience, how to develop and implement a governance plan and how to perform an upgrade or migration to SharePoint Server 2013.

Business Intelligence in Microsoft SharePoint 2013 - 5 days
Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions.
In this course you will learn how to take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. You’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.
This course will show you how to: Manage the entire BI lifecycle, from determining key performance indicators to building dashboards, Use web-based Microsoft Excel services and publish workbooks on a SharePoint Server, Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot, Create data-driven diagrams that provide interactive processes and context with Microsoft Visio Services, Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business and Use SharePoint to view BI reports side by side, no matter which tools were used to produced them.


SharePoint 2013 for End Users - 2 days
This course is designed for non-IT personnel that need to administer and edit SharePoint sites from within a web browser. Get the fast facts that make learning Microsoft SharePoint 2013 plain and simple! This course contains easy steps and clear, concise language to learn the simplest ways to get things done. 
In this course, students will learn to: Create libraries for all kinds of media, Share information in one location, Organize people and processes, Connect SharePoint to Microsoft Office with no fuss, Find things fast with the Search Center and Expand your community with social networking.


Visio 2013 - Advanced - 1 days
This ILT Series course builds on the concepts and skills taught in Visio 2010: Basic. 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.

Visio 2013 - Basic - 1 days
This ILT Series course teaches the basic functions and features of Visio Professional 2013. 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.

Word 2013 - Advanced - 1 days
This ILT Series course covers 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.

Word 2013 - Basic - 1 days
This ILT Series course covers the basic skills and concepts students need to use Microsoft Word 2013 productively and efficiently. After an introduction to Word's window components, students will learn how to create and save documents and how to navigate documents. Then they will edit, copy and paste, and find and replace text. They will also learn how to enhance the appearance of a document by using various formatting options. In addition, they will create tables, adjust page layout, work with graphics, and proof and print documents.

Word 2013 - Intermediate - 1 days
In this ILT series course, 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.

by

Loading

                           Course Catalog | Schedules | Group Training | Pricing | About | Contact

Attend Class Right From Your Home or Office

Register for a Class | Download PDF with Full Details

Private Training for a Group at Your Office

Request a Quote