Quotes

View Basket “Microsoft Office Access 2016: Part 1” has been added to your basket.

Showing 157–168 of 203 results

  • blue

    Microsoft Visio 2016: Part 1 [Beta Courseware]

    Description

    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.*In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

    Dislike (0)
    Additional Information
    Exam Number

    Course Code

    ELK91-071

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Visio 2016*Lesson 2: Working with Workflow Diagram Tools*Lesson 3: Building Organization Charts*Lesson 4: Designing a Floor Plan*Lesson 5: Building a Cross-Functional Flowchart*Lesson 6: Designing a Network Diagram*Lesson 7: Styling a Diagram*Appendix A: New Features in Visio 2016

    Learning Objectives

    Identify the basic elements of Visio and their use.*Create a workflow diagram.*Build organization charts.*Design a floor plan.*Build a cross-functional flowchart.*Design a network diagram.*Style a diagram.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/05/olELK91-071_r0.95-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-071

    Course Time: 1.0 Day

    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.*In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Excel 2016: Data Analysis with Power Pivot

    Description

    We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

    Dislike (0)
    Additional Information
    Exam Number

    Course Code

    ELK91-067

    Course Time

    0.5 Day

    Course Outline

    Lesson 1: Getting Started with Power Pivot*Lesson 2: Visualizing Power Pivot Data*Lesson 3: Working with Advanced Functionality in Power Pivot*Appendix A: Commonly Used DAX Functions

    Learning Objectives

    Get started with Power Pivot.*Visualize Power Pivot data.*Work with advanced functionality in Power Pivot.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-067_rev0.96-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-067

    Course Time: 0.5 Day

    We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Excel 2016: Data Analysis with PivotTables

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    Course Code

    ELK91-066

    Course Time

    0.5 Day

    Course Outline

    Lesson 1: Preparing Data and Creating PivotTables*Lesson 2: Analyzing Data Using PivotTables*Lesson 3: Working with PivotCharts

    Learning Objectives

    Prepare data for PivotTable reporting and create PivotTables from various data sources.*Analyze Data Using PivotTables.*Work with PivotCharts.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-066_rev1.0-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-066

    Course Time: 0.5 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office OneNote: 2016

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    Course Code

    ELK91-065

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with OneNote*Lesson 2: Adding and Formatting Notebook Content*Lesson 3: Embedding and Attaching Files*Lesson 4: Organizing and Searching Notebooks*Lesson 5: Finalizing a Notebook*Lesson 6: Managing Notebook Files*Lesson 7: Sending and Sharing OneNote Content*Appendix A: Microsoft OneNote 2016 Common Keyboard Shortcuts

    Learning Objectives

    Navigate and customize the OneNote interface and environment.*Add and format text, images, audio, links, and drawing objects to a notebook.*Embed Excel spreadsheets and attach other files to a notebook.*Categorize, organize, and search notebook content.*Check spelling in, print, and password-protect notebooks.*Use Outlook and OneDrive to send and share notebook content.*Export notebook content and manage notebook history and backups.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-065_rev1.0-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-065

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Project 2016: Part 2

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    Course Code

    ELK91-063

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Executing a Project*Lesson 2: Monitoring Project Progress*Lesson 3: Controlling a Project Plan*Lesson 4: Reporting on Progress*Lesson 5: Customizing the Application*Appendix A: Extending Project with Macros and Apps

    Learning Objectives

    Update a project plan to reflect progress as you execute the project.*Monitor project progress in the project plan.*Adjust the project plan to control constraints.*Create project reports to share a project’s status.*Customize project settings and share customizations with other projects.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-063_r1.0-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-063

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Project 2016: Part 1

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    Course Code

    ELK91-062

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Microsoft Project*Lesson 2: Defining a Project*Lesson 3: Creating and Organizing Tasks*Lesson 4: Managing Project Plan Resources*Lesson 5: Finalizing a Project Plan

    Learning 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.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-062_r1.1-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    -ELK91-062

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office PowerPoint 2016: Part 2

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    77-422

    Course Code

    ELK91-061

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Modifying the PowerPoint Environment*Lesson 2: Customizing Design Templates*Lesson 3: Adding SmartArt and Math Equations to a Presentation*Lesson 4: Working with Media and Animations*Lesson 5: Collaborating on a Presentation*Lesson 6: Customizing a Slide Show*Lesson 7: Securing and Distributing a Presentation*Appendix A: Microsoft Office PowerPoint 2016 Exam 77-422*Appendix B: Microsoft PowerPoint 2016 Common Keyboard Shortcuts

    Learning Objectives

    Modify the PowerPoint 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.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-061_rev1.0-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-422ELK91-061

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office PowerPoint 2016: Part 1 (Desktop/Office 365™)

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    77-422

    Course Code

    ELK91-060

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with PowerPoint*Lesson 2: Developing a PowerPoint Presentation*Lesson 3: Performing Advanced Text Editing Operations*Lesson 4: Adding Graphical Elements to Your Presentation*Lesson 5: Modifying Objects in Your Presentation*Lesson 6: Adding Tables to Your Presentation*Lesson 7: Adding Charts to Your Presentation*Lesson 8: Preparing to Deliver Your Presentation*Appendix A: Microsoft Office PowerPoint 2016 Exam 77-422*Appendix B: Microsoft PowerPoint 2016 Common Keyboard Shortcuts

    Learning 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.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-060_rev3.0-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-422ELK91-060

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Outlook 2016: Part 2

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    77-731

    Course Code

    ELK91-059

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Modifying Messages and Setting Global Options*Lesson 2: Organizing, Searching, and Managing Messages*Lesson 3: Managing Your Mailbox*Lesson 4: Automating Message Management*Lesson 5: Working with Calendar Settings*Lesson 6: Managing Contacts*Lesson 7: Managing Activities by Using Tasks*Lesson 8: Sharing Workspaces with Others*Lesson 9: Managing Outlook Data Files*Appendix A: Microsoft Office Outlook 2016 Exam 77-731* Appendix B: Configuring Email Message Security Settings*Appendix C: Microsoft Outlook 2016 Common Keyboard Shortcuts

    Learning 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.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-059_rev1.01n-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-731ELK91-059

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Outlook 2016: Part 1 (Desktop/Office 365™)

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    77-731

    Course Code

    ELK91-058

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Getting Started with Outlook 2016*Lesson 2: Formatting Messages*Lesson 3: Working with Attachments and Illustrations*Lesson 4: Customizing Message Options*Lesson 5: Organizing Messages*Lesson 6: Managing Your Contacts*Lesson 7: Working with the Calendar*Lesson 8: Working with Tasks and Notes*Appendix A: Microsoft Office Outlook 2016 Exam 77-731*Appendix B: Microsoft Outlook 2016 Common Keyboard Shortcuts

    Learning 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.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-058_rev3.0-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-731ELK91-058

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Excel 2016: Part 3

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    77-727 and 77-728

    Course Code

    ELK91-057

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Working with Multiple Worksheets and Workbooks*Lesson 2: Using Lookup Functions and Formula Auditing*Lesson 3: Sharing and Protecting Workbooks*Lesson 4: Automating Workbook Functionality*Lesson 5: Creating Sparklines and Mapping Data*Lesson 6: Forecasting Data*Appendix A: Microsoft Office Excel 2016 Exam 77-727*Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728*Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts*Appendix D: Cube Functions*Appendix E: Importing and Export Data*Appendix F: Internationalizing Workbooks*Appendix G: Working with Power Pivot*Appendix H: Advanced Customization Options*Appendix I: Working with Forms and Controls

    Learning 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.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-057_r1.1-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-727 and 77-728ELK91-057

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

  • blue

    Microsoft Office Excel 2016: Part 2

    Description

    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.

    Dislike (0)
    Additional Information
    Exam Number

    77-727 and 77-728

    Course Code

    ELK91-056

    Course Time

    1.0 Day

    Course Outline

    Lesson 1: Working with Functions*Lesson 2: Working with Lists*Lesson 3: Analyzing Data*Lesson 4: Visualizing Data with Charts*Lesson 5: Using PivotTables and PivotCharts*Appendix A: Microsoft Office Excel 2016 Exam 77-727*Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728*Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts*Appendix D: Financial Functions*Appendix E: Working with Graphical Objects*Appendix F: Using Array Formulas

    Learning Objectives

    Work with functions.*Work with lists.*Analyze data.*Visualize data with charts.*Use PivotTables and PivotCharts.

    Download Course

    https://masterskill.co.za/edu_content/uploads/2017/04/olELK91-056_r1.1-pdf.pdf

    suppliers

    Logical Operations

    Reviews (0)
    Exam NumberCourse Code
    77-727 and 77-728ELK91-056

    Course Time: 1.0 Day

    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.

      Course Description

      Learning Objectives

      Course Outline

      Download Course Overview

1 2 3 11 12 13 14 15 16 17
1 item