Microsoft Office 365 Excel Advanced

: 8 Hours
: Instructor
: Advanced
: Request Booking

R1450,00

Guaranteed Safe Checkout

Welcome to the second part of our Microsoft 365 Excel courseware. This version of Excel 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.

 

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.

Prerequisites

 

This manual 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

 

Topics

 

Lesson 1: Creating Advanced Formulas

Lesson 2: Analyzing Data with Logical and Lookup Functions

Lesson 3: Organizing Worksheet Data with Tables

Lesson 4: Visualizing Data with Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

Lesson 6: Working with Graphical Objects

Lesson 7: Enhancing Workbooks

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shopping Cart
Learningit.today