Become a Help Desk Engineer

Microsoft Excel 2019

This lesson also goes into a detailed discussion of why Microsoft Excel 2019 is a good tool for Project Management.

Part 1 of 5: Get Acquainted with the Environment

This lesson details what Microsoft Excel 2019 is, its purpose, and how it functions. The discussion stresses that the spreadsheet software is ideal for data management, performing calculations on data, easily reviewing chart information, and sharing important data.

Part 2 of 5: Excel Basics

This lesson tackles the basic functions and tasks performed in Microsoft Excel 2019. The discussion includes the following topics:

1. How to create a workbook
2. How to enter data
3. Applying cell borders
4. How to Use AutoSum
5. Creating a Formula
6. Putting data in a table
7. Sorting data
8. Filtering data

Part 3 of 5: Working with Data

This lesson details how one can go about working with data through Microsoft Excel 2019. The discussions in the previous lesson, specifically the ones dealing with the use and input of data are elaborated upon and coupled with more complex processes:

1. The creation of more complex formulae for specific functions
2. Importing data and creation of data models
3. Extension of Data Model relationship
4. Creation of Map-based Power View Reports

This lesson is meant to help learners wanting to assume the role of a Project Manager to be comfortable with the application so that they can make the best out of Microsoft Excel 2019's data mash-up and analysis functions. This lesson, as the last point above implies helps learners create interactive reports through Power View.

This lesson also defines what Power View is, with great focus on its capability of creating interactive reports and how Project Managers using Microsoft Excel 2019 can benefit from usage of the software.

Part 4 of 5: Modifying Workbook

This lesson discusses how the learner can go about modifying or customizing Microsoft Excel 2019's default workbook format.

This details the creation of a new Excel Workbook template with consideration to the elements that can be modified such as Font style and size, page setup, print settings, among others.

This lesson also discusses:

1. Applying changes to multiple cells and worksheets
2. The process of saving new workbooks
3. Using the new default workbooks

Part 5 of 5: Printing and Sharing

This lesson is divided into two topics regarding Microsoft Excel 2019 files and workbooks: Printing and Sharing

1. Printing
   

   This segment deals with the process of printing Excel files and workbooks through a number of options that would render optimal printing conditions. This segment discusses the following in detail:

   1. Printing one or a number of worksheets or workbooks
   2. Printing an Excel table
   3. Printing a workbook to a file
2. Sharing

   This lesson will go into discussing how to share an Excel file through a local network, how access can be controlled for users, and how  possible conflicts in Excel files can be resolved. The discussion details:

   1. Sharing files and workbooks to a number of users
   2. Protecting change tracking
   3. Editing the shared workbook
   4. Merging copies of a shared workbook
   5. Removing users from the shared workbook
   6. Un-sharing a workbook
   7. Sharing workbooks through OneDrive
   8. Shared file limitations