|
Microsoft Excel 365: Part 2
Code:
MS Excel 365 P2
Duration:
1 Day
|
$295
USD
|
Excel Part 2 incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.
This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.
Most of the features Microsoft incorporated in Office 2019 already exist in Office 365. Office 365 is a great solution for those looking for Office 2019 Training.
This course is available in the following formats:
Duration: 1 Day
Duration: 1 Day
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
|
|
Delivery Format: Virtual Classroom
|
$ 295 |
- Creating Advanced Formulas
- Analyzing Data with Logical and Lookup Functions
- Organizing Worksheet Data with Tables
- Visualizing Data with Basic Charts
- Analyzing Data with PivotTables, Slicers, and PivotCharts
- Working with Graphical Objects
- Enhancing Workbooks
Lesson 1: Creating Advanced Formulas
- Topic A: Apply Range
- Topic B: Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
- Topic A: Use Text Functions
- Topic B: Use Logical Functions
- Topic C: Use Lookup Functions
- Topic D: Use Date Functions
- Topic E: Use Financial Functions
Lesson 3: Organizing Worksheet Data with Tables
- Topic A: Create and Format Tables
- Topic B: Modifying Tables
- Topic C: Table References
Lesson 4: Visualizing Data with Basic Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Create a Trendline
- Topic D: Create Advanced Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Filter Data Using Slicers
- Topic C: Analyze Data with PivotCharts
Lesson 6: Working with Graphical Objects
- Topic A: Insert and Modify Graphic Objects
- Topic B: Layer and Group Graphic Objects
- Topic C: Incorporate SmartArt
Lesson 7: Enhancing Workbooks
- Topic A: Customize Workbooks
- Topic B: Manage Themes
- Topic C: Protect Files
- Topic D: Preparing a Workbook for Multiple Audiences
Lesson 1: Creating Advanced Formulas
- Topic A: Apply Range
- Topic B: Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
- Topic A: Use Text Functions
- Topic B: Use Logical Functions
- Topic C: Use Lookup Functions
- Topic D: Use Date Functions
- Topic E: Use Financial Functions
Lesson 3: Organizing Worksheet Data with Tables
- Topic A: Create and Format Tables
- Topic B: Modifying Tables
- Topic C: Table References
Lesson 4: Visualizing Data with Basic Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Create a Trendline
- Topic D: Create Advanced Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Filter Data Using Slicers
- Topic C: Analyze Data with PivotCharts
Lesson 6: Working with Graphical Objects
- Topic A: Insert and Modify Graphic Objects
- Topic B: Layer and Group Graphic Objects
- Topic C: Incorporate SmartArt
Lesson 7: Enhancing Workbooks
- Topic A: Customize Workbooks
- Topic B: Manage Themes
- Topic C: Protect Files
- Topic D: Preparing a Workbook for Multiple Audiences
Students should have a base knowledge working with formulas and functions, modifying worksheets, printing workbook contents, managing workbooks and customizing the Excel environment.
This course assumes the user has completed the first part of the Microsoft 365 Excel courseware or has an understanding of the information presented in that course, including:
- Getting started with the app
- Working with formulas and functions
- Modifying worksheets
- Printing workbook contents
- Managing workbooks
- Customizing the Excel environment