This five-day course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016.
This intensive instructor-led course provides students with the knowledge and experience to implement Office 365 in a large corporate environment using the FastTrack three-phase delivery process of Pilot, Deploy, and Enhance. The course consists of two distinct parts: •Lecture/Lab. Part One is the training phase of the course and consists of six modules. Each module has an associated paper-based lab that is based on an actual, real-world Office 365 deployment involving a medium-sized enterprise organization. The aim of the scenario is to confirm that students have learned the concepts from the modules. •Case Study. Part Two is the testing phase and consists of a different scenario based on another real-world deployment, this time involving a large enterprise deployment. During the case study, students will work in groups to create a design solution for the organization that is based on the information provided in the scenario and gained from interviewing the instructor, who will role-play the part of the customer. Each group will then present its design to the remainder of the class.
This is a 5-day instructor-led training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and its users.
his 2 day instructor-led course will teach you to implement functionality beyond a regular spreadsheet, a Microsoft Visual Basic programming environment is installed with Microsoft Office Excel.
This two-day, instructor-led course provides the knowledge necessary to effectively collect information from users using InfoPath.
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Outlook.
This one-day instructor-led course provides students with more advanced skills for managing e-mail, schedules, and contacts.
This one-day instructor-led course provides students with experience at creating more elaborate presentations in Microsoft Office PowerPoint.
This one-day instructor-led course provides students with an overview of the more advanced features and functions of Microsoft PowerPoint.
This is a 5-day Instructor Led Training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and users. This course maps to the following two certification exams: 70-346 and 70-347.
This three-day instructor-led course provides students with the knowledge and skills plan and manage projects using Microsoft Project. The course focuses on preparing the user to pass Microsoft Exam 70-178 Managing Projects Using Microsoft Project. This course is eligible for SATV’s.
This three-day, instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
You will create and modify new databases and their various objects.
You will improve and customize tables, queries, forms and reports, and share Access data with other applications.
You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ relational database application.
You have the basic skills needed to work with Microsoft® Office Access databases, including creating and working with Access tables, relationships, queries, forms, and reports.
Your training in and use of Microsoft® Office Access has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access.
You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on.
You will create and edit basic Microsoft Office Excel worksheets and workbooks.
This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.
In Microsoft® Office Excel®: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways.
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
With basic computer skills, it's likely that you are comfortable using a computer to perform basic tasks. Instead of using paper or a calculator, it's time to think about using the computer to store and manipulate data in electronic format.
Tandem Solution offers a special half-day course for students who cannot spend an entire day away from work. This compact course covers 4 lessons that our instructor considers to be most beneficial to students.
"Microsoft Office 365 for IT Professionals" is specially tailored for technologists looking for real-world proof of how cloud-based Office 365 enables organizations to solve more problems from more places. Microsoft Office 365 brings together cloud versions of our most trusted email, communication and collaboration software – Exchange Online, SharePoint Online and Lync Online – with the Office Professional Plus desktop suite
This course is an introduction to the Microsoft® Office 365™: Web Apps and Collaboration for Office in a cloud-based environment. Using Office 365, users can easily communicate with each other through Microsoft® Outlook® mail and Lync® instant messaging and online meetings. Additionally, the Microsoft® SharePoint® Team Site provides a central location for accessing and modifying shared documents. The Office Web Apps enable users to perform basic tasks, such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft® Office on the local computer.
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.
Students taking this course are database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills.
A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
You've covered many of the basic functions of Microsoft® Office Access® 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training, added to that which you've gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.
This course is intended for people who want to gain the foundational understanding of Microsoft Office Excel that is necessary to create and develop worksheets.
This course is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities through the application of advanced Excel functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts.
This course is intended for a student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets.
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.
This course is intended for students who have a foundational working knowledge of PowerPoint, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality.
Gone are the days of flip charts or drawing on a white board to illustrate your point. Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2016, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But, Microsoft® PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time.
Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the Outlook Microsoft Office Specialist (MOS) exam
This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.
This course is intended for students who create and work with lengthy documents, collaborate with others on documents, and create forms in Microsoft Word.
Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
Microsoft Word 2016 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
You will use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks, and create notes.
This course is the first in a series of three Microsoft® Office Outlook® courses.
This course is intended for people who have a basic understanding of Microsoft® Windows® and want or need to know how to use Outlook as an email client to manage their email communications, calendar events, contact information, and other communication tasks.
You will customize the Outlook environment, calendar, and mail messages, and will also track, share, assign, and quickly locate various Outlook items.
This course is intended for people who have a basic understanding of Microsoft® Windows® and Microsoft Office Outlook and want or need to know how to perform more advanced tasks in Outlook.
This course is the third in a series of Microsoft® Office Outlook® courses.
You will work with the advanced features of Outlook.
You will explore the PowerPoint environment and create a presentation. You will format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them.
You will enhance your presentation by using features that will transform it into a powerful means of communication. You will customize the PowerPoint interface to suit your requirements and use features to create dynamic and visually appealing presentations.
You will create and manage a project schedule using Microsoft® Project.
Students taking this course are responsible for managing projects in a work environment. This includes creating and maintaining project plans.
Students taking this course are responsible for managing projects in a work environment. This includes creating and maintaining project plans.
You will manage and customize project plans during the implementation stage of a project.
Welcome to Microsoft® Project 2016: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment. This course covers the critical knowledge and skills a project manager needs to create a project plan with Project 2016 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2016 and share it with your supervisor (and others) for review and approval.
You will manage and customize project plans during the implementation stage of a project.
In this 1 day instructor-led course you will design and manage basic diagrams, workflow, and flowcharts.
You will create custom elements and a custom template, represent external data as a drawing, and share your work with others.
From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.
Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft® Office Word courses. It will provide you with the basic concepts required to produce basic business documents.
This course is intended for students who want to learn basic Word skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.
You will create, edit, and enhance standard business documents using Microsoft® Office Word.
This one-day instructor-led course provides students with an overview of how to create complex documents and build personalized efficiency tools using Microsoft Office Word.
In the first course in this series, Microsoft® Office Word: Level 1, you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft Word on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency
You know to use Microsoft® Office Word to create and format typical business documents. Now, you may need to work on more complex documents. In this course, you will use Word to create, manage, revise, and distribute long documents and forms.
This one-day instructor-led course provides students with an overview of how to create, manage, revise, and distribute documents.
This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint.
This 5-day Instructor Lead course how to work with Microsoft Project Server. You will also create and management projects and schedules, resources, tasks and timesheets with Project Web App. Create and configure Business Intelligence for customized project reporting. Other topics include how to backup and restore and troubleshoot Project Server.
QuickBooks Pro is one of the most versatile and powerful accounting programs for small businesses on the market today. This class will teach students how to set up a QuickBooks company; enter account opening balances; create and customize company lists; set up inventory; invoice for services; process customer payments; work with bank accounts, enter and pay bills.