IT Courses
Microsoft 365 Excel: Core
Get ready to improve your Core Data Analysis, Manipulation, and Presentation skills by learning the core skills to succeed with Microsoft Excel 2019.
Get ready to improve your Core Data Analysis, Manipulation, and Presentation skills by learning the core skills to succeed with Microsoft Excel 2019.
What You will Learn?
At the end of this workshop, participants should be able to:
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Change views and configurations
- Print and distribute worksheets and workbooks
- Manage data cells and ranges
- Create tables, charts and objects
- Perform operations with formulas and functions
Topics for this course
-
Module 1: Create and Manage Worksheets and Workbooks
Worksheets live in workbooks in Excel and create the building blocks of documenting, analyzing, manipulating, and presenting data. This module will help you get started by creating worksheets and workbooks. You’ll also learn how to navigate your way around Excel worksheets and workbooks. We’ll take a look at formatting both worksheets and workbooks. Then you’ll learn how to customize your options and views while working within Excel. Finally, we’ll take a look at distributing your worksheets and workbooks via printing or sharing.
-
Module 2: Manage Data Cells and Ranges
Now let’s get more detailed by working with the data on your worksheets. This module introduces you to the tools you need to insert, format, summarize and organize your data.
-
Module 3: Create Tables
Tables help you sort, filter, and summarize data. Tables data is managed independently from data in the other rows and columns on the worksheet. In this module, you’ll learn to create and manage tables, apply styles and configure table style options, and work with filtering and sorting strategies.
-
Module 4: Perform Operations with Formulas and Functions
Excel’s power lies in its ability to make calculations that help you analyze data. This module explains how to build the formulas and use the functions that can help you make your calculations. You’ll learn about formulas, basic functions, conditional functions and using functions to format and modify text.
-
Module 5: Use Quick Analysis, Charts and Objects
Quick Analysis includes a number of formatting, charts, and totals shortcuts to help you visualize your data. Recommended Charts are another way of quickly visualizing your information. This module looks at these shortcuts, as well as creating and formatting your own charts and using and formatting other types of objects.