• Excel Dashboards

    Microsoft Office Excel 2016/2019 Dashboards

    $0.00 

    To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. And that’s exactly what this Excel Dashboards courseware aims to help you do.

    This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Part 1, 2 and 3 courses and will help start you down the road to creating advanced workbooks and worksheets that you can use to create Excel dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.

    This course presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

    Objectives:

    • Create range names and advanced formulas.
    • Automate workbook functionality.
    • Apply conditional logic.
    • Visualize data by creating basic charts.
    • Create trendline and sparkline charts.
    • Use PivotTables, PivotCharts, and slicers to create a dashboard.
  • Windows 10

    Introduction to Personal Computers Using Microsoft Windows 10

    $0.00 

    Whether you are new to computers or have used them in the past, this courseware will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This courseware will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this courseware, 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.

    Objectives:

    • Access Windows 10.
    • Use Windows apps and desktop applications to complete day-to-day tasks, including installing new apps and multitasking with multiple programs.
    • Work with files and folders by using File Explorer and OneDrive.
    • Use Cortana as your virtual personal assistant and use Edge for web browsing.
    • Customize the Windows 10 environment.
    • Install and remove printers and peripheral devices.
    • Use Windows 10 security features to create more secure passwords and protect your device against common attacks.
  • Access 2016

    Microsoft Office Access 2016 Part 1

    $0.00 

    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 courseware, 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.

    Objectives:

    • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
    • Organize and manage data stored within Access tables.
    • Use queries to join, sort, and filter data from different tables.
    • Use forms to make it easier to view, access, and input data.
    • Create and format custom reports.
  • Access 2016

    Microsoft Office Access 2016 Part 2

    $0.00 

    In this courseware, 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.

    Objectives:

    • Design a relational database.
    • Join tables to retrieve data from unrelated tables.
    • Validate data entered into a database.
    • Use advanced queries to manipulate your data.
    • Organize a database for efficiency and performance, and to maintain data integrity.
    • Customize reports to organize the displayed information and produce specific print layouts.
  • Access 2016

    Microsoft Office Access 2016 Part 3

    $0.00 

    In this courseware, you will 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. This courseware, added to that of Microsoft Office Access 2016 Part 1 and Microsoft Office Access 2016 Part 2 courseware, rounds out your Access education and provides you with marketable job skills.

    Objectives:

    • Customize a form layout to improve usability and efficiency of data entry.
    • Share data across applications.
    • Use macros to improve user interface design.
    • Use VBA to enhance tasks.
    • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
    • Lock down and prepare a database for distribution to multiple users.
    • Create and modify a database switchboard and set the start-up options.
  • excel-2016

    Microsoft Office Excel 2016 Part 1

    $0.00 

    This courseware 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 Expert Exam.

    Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

    Objectives:

    • Get started with Microsoft Office Excel 2016.
    • Perform calculations.
    • Modify a worksheet.
    • Format a worksheet.
    • Print workbooks.
    • Manage workbooks.
  • PowerPoint 2016

    Microsoft Office PowerPoint 2016 Part 1

    $0.00 

    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 courseware, you will begin creating engaging, dynamic multimedia presentations.

    Objectives:

    • Identify the basic features and functions of PowerPoint 2016.
    • Develop a PowerPoint presentation.
    • Perform advanced text editing operations.
    • Add graphical elements to your presentation.
    • Modify objects in your presentation.
    • Add tables to your presentation.
    • Add charts to your presentation.
    • Prepare to deliver your presentation.
  • excel-2016

    Microsoft Office Excel 2016 Part 2

    $0.00 

    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 Expert Exam.

    Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

    Objectives:

    • Work with functions.
    • Work with lists.
    • Analyze data.
    • Visualize data with charts.
    • Use PivotTables and PivotCharts.
  • PowerPoint 2016

    Microsoft Office PowerPoint 2016 Part 2

    $0.00 

    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. Without the help of a robust set of tools, it would be nearly impossible. However, 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 do not consume all of your available time.

    Objectives:

    • Modify the PowerPoint 2016 environment.
    • Customize design templates.
    • Add SmartArt and math equations to a presentation.
    • Work with media and animations.
    • Collaborate on a presentation.
    • Customize a slide show.
    • Secure and distribute a presentation.
  • excel-2016

    Microsoft Office Excel 2016 Part 3

    $0.00 

    This courseware builds off of the foundational and intermediate knowledge presented in the Microsoft Office Excel 2016 Part 1 and Part 2 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 Expert Exam.

    Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

    Objectives:

    • Work with multiple worksheets and workbooks.
    • Use Lookup functions and formula auditing
    • Share and protect workbooks.
    • Automate workbook functionality.
    • Create sparklines and map data.
    • Forecast data.
  • word 2016

    Microsoft Office Word 2016 Part 1

    $0.00 

    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 courseware, you will 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.

    Objectives:

    • Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
    • Format text and paragraphs.
    • Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
    • Enhance lists by sorting, renumbering, and customizing list styles.
    • Create and format tables.
    • Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
    • Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
    • Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
  • outlook-2016

    Microsoft Office Outlook 2016 Part 1

    $0.00 

    This courseware 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 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.

    Objectives:

    • Navigate Outlook 2016 to read and respond to email.
    • Use the Address Book, and format and spell check new messages.
    • Attach files and insert illustrations to messages.
    • Customize read and response options.
    • Use flags, categories, and folders to organize messages.
    • Create and work with Contacts.
    • Create appointments and schedule meetings in Calendar.
    • Create and work with Tasks and Notes.
  • word 2016

    Microsoft Office Word 2016 Part 2

    $0.00 

    After you master the basics of using Microsoft Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, you are 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.

    The Microsoft Office Word 2016 Part 2 courseware focuses on Creating professional-looking documents that 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.

    Objectives:

    • Organize content using tables and charts.
    • Customize formats using styles and themes.
    • Insert content using quick parts.
    • Use templates to automate document formatting.
    • Control the flow of a document.
    • Simplify and manage long documents.
    • Use mail merge to create letters, envelopes, and labels.
  • outlook-2016

    Microsoft Office Outlook 2016 Part 2

    $0.00 

    This courseware 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 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.

    In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook 2016

    Objectives:

    • Modify messages and set global options.
    • Organize, search, and manage messages.
    • Manage your mailbox.
    • Automate message management.
    • Work with calendar settings.
    • Manage contacts and groups.
    • Manage activities by using tasks.
    • Share workspaces with others.
    • Manage Outlook data files.
  • word 2016

    Microsoft Office Word 2016 Part 3

    $0.00 

    Microsoft Office Word 2016 enables you to do far more than simple word processing. This courseware focuses on Microsoft Word advanced features including 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 Microsoft Office Word 2016 courseware is intended for anyone who want to use advanced capabilities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros.

    Objectives:

    • Use images in a document.
    • Create custom graphic elements.
    • Collaborate on documents.
    • Add reference marks and notes.
    • Secure a document.
    • Create and manipulate forms.
    • Create macros to automate tasks.
  • project-2016

    Microsoft Project 2016 Part 1

    $0.00 

    This courseware is designed to familiarize you with the basic features and functions of Microsoft Project 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 Microsoft Project Professional 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 Microsoft Project and share it with your supervisor (and others) for review and approval.

    Objectives:

    • Identify project management concepts and navigate the Project 2016 environment.
    • Create and define a new project plan.
    • Create and organize tasks.
    • Manage resources in a project plan.
    • Finalize a project plan.
  • PivotTables

    Microsoft Office Excel 2016/2019 Data Analysis with PivotTables

    $0.00 

    Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

    This courseware presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

    Objectives:

    • Prepare data for PivotTable reporting and create PivotTables from various data sources.
    • Analyze data by using PivotTables.
    • Work with PivotCharts.
  • project-2016

    Microsoft Project 2016 Part 2

    $0.00 

    This courseware 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.

    Upon successful completion of this course, you will be able to manage an existing Microsoft Project Professional project plan.

    Objectives:

    • Identify project management concepts and navigate the Project 2016 environment.
    • Create and define a new project plan.
    • Create and organize tasks.
    • Manage resources in a project plan.
    • Finalize a project plan.