MICROSOFT EXCEL 365: PART 2

MICROSOFT EXCEL 365: PART 2

MICROSOFT EXCEL 365: PART 2

Intermediate Excel Skills

Who should take this course

Novice computer Users

Outlines

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

$265

Certificate

Awareness and accomplished attendance

Prerequisites

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 Microsoft Excel 365: Part 1 https://itechskills.ca/courses/microsoft-excel-level-1/

Course Details

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.

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.