Microsoft Office Specialist: Associate (Office 365 and Office 2019): MO-200: Microsoft Excel (Excel and Excel 2019)

https://www.skillsoft.com/channel/microsoft-office-specialist-associate-office-365-and-office-2019-8851816d-0611-4e81-81a5-4afab84ed560?certificationexam=47611 https://www.skillsoft.com/channel/microsoft-office-specialist-associate-office-365-and-office-2019-8851816d-0611-4e81-81a5-4afab84ed560?certificationexam=47612 https://www.skillsoft.com/channel/microsoft-office-specialist-associate-office-365-and-office-2019-8851816d-0611-4e81-81a5-4afab84ed560?certificationexam=47613
  • 17 Courses | 13h 45m 3s
  • 5 Books | 42h 11m
  • 14 Courses | 9h 21m 14s
  • 1 Book | 4h 31m
  • 14 Courses | 11h 5m 52s
  • 2 Books | 6h 59m
Likes 176 Likes 176
 
Acquire knowledge of Office programs such as Excel, Word, and PowerPoint as you prepare to earn a Microsoft Office Specialist: Associate (Office 365 and Office 2019) certification.

GETTING STARTED

Getting Started

  • Playable
    1. 
    Finding & opening the application
    3m 14s
    NOW PLAYING
  • Playable
    2. 
    Exploring the application
    6m 43s
    UP NEXT

GETTING STARTED

Getting Started with PowerPoint

  • Playable
    1. 
    Finding & opening the application
    4m 28s
    NOW PLAYING
  • Playable
    2. 
    Using the application
    5m 21s
    UP NEXT

GETTING STARTED

Opening & Setting Up

  • Playable
    1. 
    Finding & opening the application
    3m 30s
    NOW PLAYING
  • Playable
    2. 
    Using the application
    4m 31s
    UP NEXT

COURSES INCLUDED

Getting Started
Get started with Excel 2019, the spreadsheet application included with the Microsoft Office 2019 Suite. During this course, you will familiarise yourself with the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Begin the course by learning how to find the application on the desktop and open it. To get the most out of Excel, you need to understand how the interface is laid out, so the course next explores the application. This leads into the zoom function, which can be used to adjust how to visualize the spreadsheet in Excel by making data entries larger or smaller. Discover how to examine mode views, which in Excel features three different preset view modes: Normal, Page Layout, and Page Break. Conclude the course by observing how to move between documents, allowing work on multiple documents simultaneously while using a number of tools to organize a workspace.
5 videos | 29m
has Assessment available Badge Certification PMI PDU
Creating & Saving Workbooks
Create a new spreadsheet and workbook, with Excel 2019. During this course, you will begin by learning how to create and open a document, and then learn how to use document templates. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. Next, observe how to save your worksheet or workbook as an Excel version or pdf; and recover unsaved documents. Learn how to insert headers and footers, useful if you have additional information to insert into a spreadsheet. Examine how to set your print area; adjust your print page layout, and then print your document. Discover how to check for compatibility issues; edit your document properties; and check for personal information in your document. The course concludes by showing how to create an accessible document, and how to protect your document or restrict all access with a password.
15 vid