Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the selection domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the woocommerce-bookings domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the woocommerce domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the the-events-calendar domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the updraftplus domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the the-events-calendar-category-colors domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114
Microsoft Excel 365 (Level 3) - Totbox Productivity Solutions

Microsoft Excel 365 (Level 3)

In this course, you will learn how to create tables in Excel, which are useful for organizing and storing your data. You will also learn how to sort and filter your data using different criteria and options. Moreover, you will discover how to use PivotTables, which are powerful tools for summarizing and analyzing your data in various ways. Finally, you will explore how to use database functions, which are formulas that can perform calculations on a specific range of cells that match certain conditions.

Upon completion of the course, you’ll be able to:

Create and use Excel tables.
Add, edit and search for records in tables, and look up data.
Sort records in a table using a variety of methods.
Filter data in a table using a variety of methods.
Create and work with subtotalled lists.
Work with PivotTables, PivotCharts, and Slicers.

Unit 1: Maintaining data

Data List and Excel Table Concepts
Working with Tables
Using Lookup Tables
Using Data Forms

Unit 2: Sorting Lists

Sorting Concepts
Sorting Lists
Custom Sort Orders

Unit 3: Filtering Lists

Filtering Concepts
Using AutoFilter
Using Advanced Filters
Working with Filtered Data

Unit 4: Summarizing Data

Automatic Subtotals
Working with Subtotalled Lists
Using Functions to Summarize Data

Unit 5: Working with PivotTables

PivotTable Concepts
Creating PivotTables
Modifying PivotTable Layouts
Working with PivotTables
PivotCharts
Slicers

Unit 6: Supplemental - Dynamic Array Formulas

Dynamic Array Formula Concepts
Creating Unique Dynamic Lists
Sorting Dynamic Arrays
Filtering Dynamic Arrays

Unit 7: Supplemental - Macros Overview

Planning Macros
Recording Macros
Executing Macros
Maintaining Macros
Adding Macros to the Quick Access Toolbar

UPCOMING SESSIONS

TOP