App and Professional Development Courses

This course is an introduction to Microsoft® Office 365™ with Teams™ in a cloud-based environment. Using the Office 365 suite of productivity apps, users can easily communicate and collaborate together through Microsoft® Teams™ messaging and meeting functionality.

You can successfully complete this course without any prior software knowledge or computer experience. A basic understanding of the computer operating system you are using is recommended. Instructor-led, self-paced, classroom-delivery learning model with structured hands-on activities. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2018.

You can successfully complete this course without any prior software knowledge or computer experience. A basic understanding of the computer operating system you are using and completing the Get Going With QuickBooks 2018 course is recommended. Instructor-led, self-paced, classroom-delivery learning model with structured hands-on activities. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2018.

Sales professionals need a system for producing sales results. Logical Selling: A Practical Approach for Increasing Sales Results provides that framework and the tools to make it your own. In this course, you will identify what makes your product stand out and plan a strategy for reaching the customers who need it. You will also examine the stages of each sale—from finding the opportunity to realizing the deal—and use them to create win-win situations for you and your customer. Finally, you will build the interpersonal and negotiating skills to form lasting business relationships from these successes.

Motivation has a profound effect on employees’ productivity and performance. An organization improves its likelihood of success by maintaining a motivated work force. As a leader within your organization, you share in the responsibility of motivating your employees. You also want to be able to lead the individuals on your team effectively by conducting ongoing performance appraisals; delivering helpful and instructive feedback, training, and coaching; and designing and implementing performance standards. You want to develop talent within your team by employing effective performance-management strategies on the job. This course will help you cultivate the skills necessary to motivate your employees and give you essential performance-management skills.

Effective facilitators know how to take charge of meetings and lead groups toward successfully completing their work objectives. In this course, you will strategically plan meetings and create formal agendas, lead groups to generate new ideas through brainstorming events, and help people work through facilitated difficult sessions. You will also further develop your facilitation skills by leading virtual meetings and even moderating international sessions.

Good financial judgment can deepen the decision-making skills of any business professional. Fluency with monetary figures helps you tie everyday operations to the financial success of your organization at a department and senior level. Finance and Budgeting Essentials for Business Professionals grounds you in the functions and tools of finance. In this course, you will examine financial statements—including the balance sheet, income statement, cash flow statement, and statement of stockholders’ equity—as guides to fiscal health. You will also identify what you want to gain from a budget and describe the steps of budgeting to meet these goals.

As a leader in your organization, you’re expected to help people meet or exceed expectations and to help ensure productivity and profitability for the organization. Coaching is a leadership tool that is effective in improving performance and contributing to the goals of the organization. In this course, you will build a foundation for coaching, establish a coaching process, execute a coaching plan, and explore strategies for coaching in different business scenarios. Many different factors can affect employee performance. When performance problems arise, people need to be supported to get back on track and do their jobs well. Coaching is an effective way of confirming an employee’s value while improving performance. Coaching contributes to employee retention because it offers the opportunity to grow, provides motivation, and supports learning. Coaching also enhances the image and effectiveness of managers and supervisors.

To be successful in the workplace, you must be able to effectively communicate and cooperate with coworkers and external people.

You have transitioned from an individual contributor to a manager, or as an individual contributor, you’ve acquired practical skills to enhance your leadership abilities. When you want to take your leadership skills to the next level, you assess your leadership traits, develop your communication skills, and build your reputation. These strategies can increase your ability to effectively influence others and get results.

Problem-Solving Skills (Second Edition) focuses on eliminating corporate problems. Approaches to problem solving are defined, along with traits of good problem solvers and the company cultures that influence them. The course focuses on the three phases of problem solving and breaks each phase into steps. Strategies are provided for individual problem solvers and problem-solving teams.

Every day, millions of email messages are exchanged among people within and between organizations. Email has a ubiquitous presence in the lives of many, and it’s likely that email technologies will continue to evolve with the changing needs of workplaces. After all, email communication has not been replaced, or its growth slowed, as many predicted with the rise of social media and the widespread adoption of mobile technologies. Many organizations have implemented mail management systems that combine the back-end power of Microsoft® Exchange Server and the front-end intuitive user interface of Microsoft® Office Outlook® 2016. In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.This course builds upon the foundational knowledge presented in the Microsoft ® Office Outlook® 2016: Part 1 course and will help you customize a communication system well-suited to your work styles. In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook 2016.

The ability to deliver presentations is vital to achieving advancement for yourself and for your ideas. Few skills in life will contribute to your success as much as presentation skills. Without a dynamic and coherent presentation, even stellar ideas can fail to convince your audience. In this course, you will learn to organize your ideas to create coherent and convincing oral presentations, while also utilizing available visual aids and using public-speaking techniques to strengthen your delivery.

You have developed skills to be successful in your field. In this course, you will learn the practical skills you need to be an effective leader in your organization. Leadership enhances the skills employees at all levels need to be truly successful. When you learn practical leadership skills, you’ll have the ability to motivate, coach, communicate with, and teach employees in such a way that they are more effective in their jobs and, as a result, you become more effective in your job.

An organization improves its likelihood of success by effectively managing conflict. As a leader within your organization, you share in that responsibility. This course will help you cultivate the skills necessary to help manage conflict and ultimately to decrease the presence of conflict in the workplace.

You learned the rules of grammar in school, but now you’d like to refresh and refine your grammar usage for your professional life. You need to state your ideas clearly and concisely in written communications and present yourself in a professional manner. In this course, you will review the rules of grammar, identify common grammar errors, and refine your business writing style. Improving your grammar will help you deliver polished and professional written communications. Correct grammar and a refined, concise writing style can help you clearly express your ideas to others, streamline the directions and instructions that you deliver, and create impressive presentations and reports.

Time is a form of currency, and the ways you talk about it illustrate its value: people say “Time is money,” and “My time was well spent,” or “It’s a waste of time.” Like most professionals, you’ve probably struggled with managing time effectively. In this course, you will acquire day-to-day time-management tools that will help you more effectively use your time so you can direct your energy towards fulfilling your short- and long-term professional and personal goals. Your time is a precious and limited resource. Too often, you may feel frustrated that there aren’t enough hours in the day to accomplish everything you hope to do. Effective time managers enjoy the satisfaction of directing their talents and energy towards productive, goal-centered activities. By identifying improved time management and organizational skills, you, too, can use your time and energy effectively, focusing your efforts on the activities that will help you reach your goals.

Though businesses increasingly rely on technology, technological skills alone do not guarantee success in the workplace. You must still develop your ideas, express them clearly, and persuade others of their viability. This course offers effective strategies to sharpen your writing skills by structuring your ideas logically, exercising diplomacy in letters and reports, and shaping your arguments. In contemporary business environments, information overload makes it necessary for you to communicate clearly and concisely. Trying to make sense of a disorganized email message can be frustrating given the number of emails you have to answer daily. By analyzing your audience, organizing your writing, and employing effective persuasive techniques, your writing will make an impact.

As a customer service representative, you are expected to handle customer interactions in the best way possible. The expectations of both your company and your customers hinge on your ability to provide the right service in the right way. In this course, you will explore the background and techniques of customer interactions. Providing quality customer care ensures that every single contact with your company is a positive experience. Customers can range from external consumers to internal employees in other departments. Knowing how to provide the same level of service to all customers will enrich your time spent at work by establishing positive business relationships. Recognizing crucial points throughout customer interactions increases your ability to solve problems and offer affirmative solutions. Applying this knowledge to trends in service and consumer desires allows you to contribute to the company’s bottom line and make a customer’s life a little easier.

As a business professional, you have some experience using Adobe® Acrobat®. Now you’re ready to take further advantage of all the features of Acrobat Pro DC to bring your documents to the next level. Whether you are creating PDFs for commercial printing or for viewing digital versions on a range of platforms, Adobe Acrobat Pro DC enables you to output your content so your audience will be able to access and view the document just the way you intended. In this course, you will use Adobe Acrobat Pro DC to convert technical documents to PDF files, enhance PDF documents, create interactive PDF forms, and prepare PDF files for commercial printing.

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations, people work with a wide variety of devices running on a wide variety of platforms. And sometimes, what works well or looks good on one device, won’t work at all on another device. Or, your carefully designed and formatted document may end up looking like a jumbled mess on someone else’s computer. So, how do you balance the need to communicate ideas to large groups of people with the enormous diversity found in today’s electronic devices? The answer: you don’t have to because Adobe created the Portable Document Format (PDF) as a solution to incompatible document formats. Adobe® Acrobat® Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat, you will ensure the integrity of your electronic documents regardless of who views them, on what devices, or with what operating systems. And that will give you the confidence and peace of mind that comes with knowing that what you meant to communicate is what your document recipients will see.

As a business professional, you have some experience using Adobe® Acrobat®. Now you’re ready to take further advantage of all the features of Acrobat XI to bring your documents to the next level. Whether you are creating PDFs for commercial printing or for viewing digital versions on a range of platforms, Adobe Acrobat XI enables you to output your content so your audience will be able to access and view the document just the way you intended. In this course, you will use Adobe Acrobat XI Pro to convert technical documents to PDF files, enhance PDF documents, create interactive PDF forms, and prepare and PDF files for commercial printing.

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations, people work with a wide variety of devices running on a wide variety of platforms. And sometimes, what works well or looks good on one device, won’t work at all on another device. Or, your carefully designed and formatted document may end up looking like a jumbled mess on someone else’s computer. So, how do you balance the need to communicate ideas to large groups of people with the enormous diversity found in today’s electronic devices? The answer: you don’t have to because Adobe created the Portable Document Format as a solution to incompatible document formats. Adobe® Acrobat® XI Pro puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat, you will ensure the integrity of your electronic documents regardless of who views them, on what devices, or with what operating systems. And that will give the confidence and peace of mind that comes with knowing that what you meant to communicate is what your document recipients will see.

Photoshop is a leading graphic creation application, popular among graphic designers, illustrators, and photographers. Photoshop’s numerous features work together to provide a comprehensive toolset for you, the design professional. This course delves into some of the more advanced image creation and editing techniques, and offers you hands-on activities that demonstrate how these techniques can be used in combination to create exciting visual effects.

Adobe® Photoshop® CS6: Part 1 focuses on some of the basic features of Photoshop so that the student can navigate the environment and use Photoshop tools to work with photographic images. In addition, the orientation to Adobe Bridge and organization of files in Bridge is covered. Although Photoshop is used by a variety of professionals, from photographers to designers to videographers, Photoshop Part 1 will focus mainly on the photography component. The illustration and animation techniques are covered in subsequent levels of Photoshop. You can also use this course to prepare for the Adobe Visual Communication using Photoshop CS6 exam.

In Adobe® InDesign® CS6: Part 1 you were introduced to the many features that help you create professional looking documents. Now you need to create much lengthier interactive documents that need to be accessed across a range of devices. In this course, you will learn advanced InDesign techniques to enhance the look and functionality of your documents. Using Adobe InDesign, you can create interactive documents and export them for viewing in a web browser with various features such as buttons, page transitions, movies and audio files, hyperlinks and animation. You have the ability to assign color profiles and establish print presets. In creating longer documents, you’ll be able to include such features as a table of contents, footnotes, cross-references and an index.

Giving your documents a well-designed, professional look will put you a step ahead in the marketplace cluttered with all kinds of communications. Paragraph and character styles that allow you to format pages of text uniformly, layout features that help you to build alternate size configurations of your document, and various panels that enable you to easily customize both text and graphics. Adobe ® InDesign ® CS6 has all the tools you need to elevate the look of your document and get it out to the people who need to see it, whether it be in print or on the web.

You have created simple artwork using the basic drawing and painting tools available in Illustrator. You now want to create complex artwork using advanced tools, options, and effects. In addition, you want to ensure that your artwork is ready for commercial printing and also save it for the Web. In this course, you will draw complex illustrations, and enhance them using various painting options. You will also use her techniques using painting tools, manage colors, format type, work with effects, prepare artwork for commercial printing, and prepare graphics for the web. This course also is designed to cover the Illustrator CS6 Adobe Certified Expert (ACE) certification exam objectives.

To meet the demands of individuals and organizations for flexible, reusable, and easily modified visual content, Adobe Systems has created a cadre of applications that collectively provide a scalable, end-to-end solution for nearly every type of visual design project one can contemplate. Called Creative Suite 6 (CS6), the collection of applications perform specialized design tasks while interoperating among each other to deliver superlative content. This course focuses on Illustrator CS6, the component within CS6 used to create “drawn” graphics, while enabling its users to integrate content from other domains (such as photo-oriented graphics and animation, which belong to Photoshop® and Flash®). With Illustrator’s many, easily used tools, you will discover that not only can you unlock the same creative impulses you’ve always had as you’ve picked up a pencil to sketch out an idea, but also capture those multiple ideas and “what ifs” during the creative process in ways that you never imagined. And for those of you who are just embarking on building your creative skills, you will be surprised at “how good” your work will appear even at the outset of your exploration of the world of graphic design.

You create Flash animations. You can find your way around the Library and can work in the timeline. You’ve even created symbols and have embedded one MovieClip inside another. But now you want to create functionality that can’t be accomplished on the timeline alone. You want to import content from external sources, such as XML and video files, and you want to create items that respond to user interaction. These things require an understanding of ActionScript and other advanced features of Flash. This course, combined with Adobe® Flash® CS6: Part 1, covers ACA and ACE exam objectives for Adobe Flash CS6, and is intended to help prepare students to take the Adobe Certified Associate and Adobe Certified Expert exams.

The tools available in Adobe® Flash® CS6 can be used to create and manipulate a variety of graphics and animations ranging from simple designs to complex animated sequences. In this course, you will learn to navigate the Flash CS6 interface, and gain knowledge in using the tools and features necessary for drawing graphics and creating a website that contains an animated introduction. This course also is designed to cover the Flash CS6 Adobe Certified Associate (ACA) and Adobe Certified Expert (ACE) certification exam objectives.

You are familiar with creating web pages and now you will enhance the web pages by means of adding advanced functions such as navigational controls, media elements, and forms. Also, it is essential to ensure that your websites are compatible with various modern day display devices such as mobile phones, tablets, and smartphones. In this course, you will create fluid CSS layouts, implement mobile integration techniques, and share files over a server to work in a collaborative manner. All this will ensure that you develop a website that helps retain user interest by means of providing an engaging user experience across multiple display devices. This course covers the Adobe Web Communication using Dreamweaver CS6 objectives to help students prepare for the Adobe Certified Associate (ACA) exam. This course is also designed to cover the Adobe Certified Expert (ACE) exam objectives.

You want to create and maintain web pages for your website. The fundamental elements of a web page are HTML, XHTML, CSS, and some JavaScript. These technologies take some time to master. In this course, you will use Adobe Dreamweaver to create web pages while focusing on the content, styling, and design. As you construct the web pages, Dreamweaver will competently create the XHTML, CSS and JavaScript required. You will also maintain and administer your website with Dreamweaver’s site and page management tools. The website and pages you create will reflect your content and design and will be professionally accurate for your site visitors. The course covers the Adobe Web Communication using Dreamweaver CS6 objectives completely and can be used to help prepare students to take the Adobe Certified Associate (ACA) exam. This course is also designed to cover the Adobe Certified Expert (ACE) exam objectives.

The office productivity apps that comprise Google G Suite™ support both real-time and asynchronous collaboration. In this course, you will learn about the features and functionalities of the apps included in most G Suite editions—Gmail™, Google Drive™, Google Docs™, Google Slides™, Google Drawings™, Google Sheets™, Google Forms™, Google Hangouts™, Google Calendar™, and Google Sites™—and work within their respective environments.

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® OneNote® for Windows® 10 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others.

Welcome to Introduction to Personal Computers Using Microsoft® Windows® 10. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This course will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.

Welcome to Using Microsoft® Windows® 10. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This course will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.

Mobile devices are becoming increasingly popular. As a result, many business professionals find themselves regularly performing a greater number of work-related tasks from a variety of devices. You may find yourself included in this group of multiple-device users. But, you still perform a majority, or at least a large part, of your work from a desktop or a laptop computer. With the release of Microsoft® Windows® 10, Microsoft has made strides in bridging the gap between your laptop or desktop PC and a variety of mobile devices. Developing an understanding of how to accomplish your day-to-day work tasks in this new environment will push you one step closer to being able to comfortably work from a number of platforms, and a number of devices, nearly anywhere you go. Once you’ve gained a foundational understanding of how to operate within the Windows 10 environment from your PC, you’ll be able to take full advantage of the many sharing, storing, and multi-platform benefits inherent in the Windows 10 operating system.

Microsoft® SharePoint® 2016 is a platform designed to facilitate collaboration and allow people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. As such, SharePoint has many distinct features that must be enabled and configured, and many content structures that can be selected, added, and configured. In this course, you will learn how to create, configure, and manage a SharePoint team site so that your team or organization can share information and collaborate effectively. SharePoint content structures and configuration options are complex. Site owners must understand what features, options, and content structures are available in SharePoint, and how to properly configure them. With SharePoint sites, features, and content structures properly implemented, users will be able to securely share files, collaborate on documents, and access information they need to work with their colleagues more effectively.

In many professional environments today, people work collaboratively in teams. Information technology and applications facilitate this by allowing people to easily share, access, edit, and save information. Microsoft® SharePoint® 2016 is a platform specifically designed to facilitate collaboration, allowing people to use familiar applications and Web-based tools to create, access, store, and track documents and data in a central location. In this course, you will learn about and use a SharePoint Team Site to access, store, and share information and documents. SharePoint is a complex platform with many features and capabilities. A strong understanding of those features and capabilities will allow you to work more efficiently and effectively with SharePoint, and with the documents and data stored in SharePoint. Furthermore, effective use of new social networking capabilities will allow you to identify, track, and advance issues and topics most important to you, and collaborate with colleagues more effectively.

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office.

Welcome to Microsoft® Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment. In Microsoft® Project 2016: Part 1, you learned the basic features of Microsoft® Project 2016 during the planning phase of a project. Microsoft® Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

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.

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® Office 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. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

It’s hard to imagine a day going by without people passing along large amounts of information. Messages are everywhere, and the number of messages we receive seems to be increasing each day. Whether via phone, email, mass media, or personal interaction, we are subjected to a constant stream of information. With so much communication to contend with, it can be difficult to grab people’s attention. But, we are often called upon to do just that. So, how do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® Office PowerPoint® 2016 can help you do. 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. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

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. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam.

After you master the basics of using Microsoft® Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, you’re ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization. Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam.

These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing. 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. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam.

Every day, millions of email messages are exchanged among people within and between organizations. Email has a ubiquitous presence in the lives of many, and it’s likely that email technologies will continue to evolve with the changing needs of workplaces. After all, email communication has not been replaced, or its growth slowed, as many predicted with the rise of social media and the widespread adoption of mobile technologies. Many organizations have implemented mail management systems that combine the back-end power of Microsoft® Exchange Server and the front-end intuitive user interface of Microsoft® Office Outlook® 2016. In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system. This course builds upon the foundational knowledge presented in the Microsoft ® Office Outlook® 2016: Part 1 course and will help you customize a communication system well-suited to your work styles. In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook 2016.

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees. In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style. This course is the first in a series of two Microsoft® Office Outlook® 2016 courses. It will provide you with the basic skills you need to start using Outlook 2016 to manage your email communications, contact information, calendar events, tasks, and notes. You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.

Clearly, you use Excel a lot in your role. Otherwise, you wouldn’t be taking this course. By now, you’re already familiar with Excel 2016, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do. This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2016: Part 1 and Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do. 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 covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

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 covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

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 multiple-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. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

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 can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data. 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. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.