Integrity Training – Microsoft Office 2016 Excel Intermediate

Integrity Training – Microsoft Office 2016 Excel Intermediate

The second course in a three-course series on Microsoft Office Excel 2016 that covers intermediate-level Microsoft Excel 2016 subjects is the Microsoft Excel 2016 L2 course. The more complex ideas, including functions, lists, data analysis, data visualization, and pivot tables, are covered in the course. Additionally, the course offers students a seamless transition chance to switch to Microsoft Office Excel 2016.

Students, office employees, CEOs, accountants, and financial analysts all need Microsoft Office Excel 2016. The applicants can use the most recent version of Microsoft Office Excel after taking this course. The course helps the applicants to get the information they need to effectively utilize Microsoft Office Succeed 2016’s capabilities in order to excel at daily chores.
Course Outline

Introduction

Start

Introduction (1:27) (1:27)

Start

Courseware (0:30) (0:30)

Start

Introduce the instructor (0:58)

Working with Functions in Chapter 1

Start

Utilizing Functions (1:10)

Start

A topic: Using ranges (0:49)

Start

Range and Cell Names (2:03)

Start

the Name Box and names (0:22)

Start

Dialog Box for New Name (0:51)

Start

The Command Create from Selection (0:58)

Start

Dialog Box for Name Manager (1:05)

Start

Range Naming and Editing Demo (6:34)

Start

Names of Cells and Ranges in Formulas (0:31)

Start

Utilization of the Formula Command Method (0:32)

Start

Formula AutoComplete Technique (0:35)

Start

Demonstration of Formulation Using Defined Names (2:37)

Start

Use specialized functions, topic B (0:34)

Start

Function Reference for Excel (1:41)

Start

Functional Grammar (1:20)

Start

Calculations of dates (1:19)

Start

Finding and Using Specialized Functions Demo (6:44)

Start

Working with logical functions is Topic C. (2:27)

Start

Operators for Comparison (0:59)

Start

When Function (IF) (2:25)

Start

The AND Operator (1:11)

Start

The OR Operator (0:25)

Start

The NOT Method (0:40)

Start

Demonstration of Using Logical Functions (6:33)

Start

Nesting (1:13) (1:13)

Start

Syntax for Nested Functions (3:51)

Start

Combining Functions Demo (3:45)

Start

Work with Date & Time Functions is Topic D. (0:20)

Start

THE TODAY PERFORMANCE (0:24)

Start

“NOW” Function (0:22)

Start

Date Function (0:50)

Start

NETWORKDAYS’s Purpose (1:05)

Start

A WEEKDAY Activity (0:52)

Start

The Function of WORKDAY (1:01)

Start

The function of ISOWEEKNUM (0:36)

Start

Demo: Use Date and Time Functions (2:36)

Start

Work with Text Functions, Topic E (0:25)

Start

RIGHT Function (1:56)

Start

The Correct Action (0:29)

Start

Wizard to Convert Text to Columns (0:55)

Start

What MID Does (0:49)

Start

Function CONCATENATE (0:41)

Start

Concatenation of text with the ampersand (0:25)

Start

Lower Function (0:19)

Start

Upper Function (0:13)

Start

The RIGHT Purpose (0:15)

Start

Working with Text Functions in a Demo (3:49)

Start

Section 1 Review (0:37)

Start

Test from Chapter 1

Working with Lists in Chapter 2

Start

Utilizing Lists (0:33)

Start

Topic A: Data Sorting (0:28)

Start

Sorting (2:13) (2:13)

Start

Sorting Multiple Columns and Rows (1:05)

Start

Fast Sorts (0:47)

Start

Dialog Box for Sorting (1:10)

Start

The Dialog Box for Sort Options (0:31)

Start

Demo – Data Sorting (3:12)

Start

Topic B: Data Filtering (0:30)

Start

Filtering (0:52) (0:52)

Start

AutoFilters (0:46) (0:46)

Start

The Dialog Box for Custom AutoFilter (0:52)

Start

Superior Filtering (0:59)

Start

The Range of Criteria (1:45)

Start

Demo – Data Filtering (4:02)

Start

Topic C: Using Database Functions to Query Data (0:19)

Start

DBMS Operations (1:40)

Start

SQL for Database Functions (2:21)

Start

Using Database Functions Demo (4:41)

Start

Outline and complete data for Topic D (0:39)

Start

Outlines (0:45) (0:45)

Start

A function called SUBTOTAL (2:00)

Start

The Totals Section (1:23)

Start

The Dialog Box for Subtotal (0:35)

Start

Demo: Summarizing Data using Subtotals (3:04)

Start

Section 2 Review (0:23)

Start

Quiz for Chapter 2

Chapter 3: Data Analysis

Start

Examining Data (0:43)

Start

Topic A: Making and Changing Tables (0:41)

Start

Tables (0:52) (0:52)

Start

Table Elements (1:18)

Start

The Dialog Box to Create a Table (0:32)

Start

The Contextual Tab for Table Tools (0:52)

Start

Quick styles and table styles (0:23)

Start

Table Style Dialog Box, New (0:45)

Start

Quick Evaluation (1:08)

Start

Demonstration of Making and Changing Tables (5:00)

Start

Demo: Using Table Summary Functions (3:27)

Start

Apply intermediate conditional formatting in Topic B (0:22)

Start

The dialog box for the new formatting rule (1:42)

Start

The dialog box for the conditional formatting rules manager (0:36)

Start

Rule Priority (0:24)

Start

Application of Intermediate Conditional Formatting in Demo (3:44)

Start

Apply advanced conditional formatting in Topic C (0:20)

Start

The Formula Rule for Selecting Which Cells to Format (1:08)

Start

Demo: Applying Conditional Formatting Using Logical Functions (3:19)

Start

Section III Review (0:53)

Start

Test from Chapter 3

Chapter 4: Using Charts to Visualize Data

Start

Charting Data to Visualize It (1:07)

Start

A. Topic: Making Charts (0:32)

Start

Charts (1:02) (1:02)

Start

Basics of Charts (1:45)

Start

Chart Formats (2:08)

Start

Suitable Charts (0:40)

Start

The Chart Dialog Box for Insert (0:39)

Start

Demo – Chart Creation (5:21)

Start

Modify and Format Charts (Topic B) (0:41)

Start

Chart alterations (0:49)

Start

Formatting a chart (0:32)

Start

Chart components (1:38)

Start

Tab for Design (1:09)

Start

Tab for Format (0:38)

Start

Task Pane for Formatting (1:08)

Start

The buttons for the chart tools (0:49)

Start

Choosing a data source in the dialog box (0:33)

Start

Demo: Chart Editing and Formatting (4:14)

Start

Use advanced chart features (Topic C) (1:04)

Start

Charts with two axes (1:08)

Start

Trendlines (1:24) (1:24)

Start

The Task Pane for Format Trendline (0:43)

Start

Making a Dual-Axis Chart in Demo (4:08)

Start

Graphing Templates (0:57)

Start

Demo: Making a Template for a Chart (1:52)

Start

Section 4 Review (1:10)

Start

Test from Chapter 4

Using PivotTables and PivotCharts in Chapter 05

Start

Making use of pivot tables and charts (1:28)

Start

Create a PivotTable is Topic A. (0:28)

Start

Pivoting (2:18) (2:18)

Start

PivotTables (1:32) (1:32)

Start

Data Transactions (1:10)

Start

The Dialog Box to Create PivotTable (0:33)

Start

The Task Pane for PivotTable Fields (1:27)

Start

Making a PivotTable in a Demo (4:29)

Start

Topic B: Examine Data from PivotTables (0:04)

Start

Analyze Tab (3:13)

Start

Tab for Design (0:25)

Start

Dialog Box for Value Field Settings (0:48)

Start

Only the SUM Function (0:41)

Start

proportion of the total (0:28)

Start

Contrary to Option (0:40)

Start

The function GETPIVOTDATA (1:29)

Start

Demo: PivotTable Data Analysis (4:07)

Start

Topic C: Use PivotCharts to Present Data (0:05)

Start

PivotCharts (0:44) (0:44)

Start

The Task Pane for PivotChart Fields (0:31)

Start

Filters for PivotChart (0:36)

Start

Demo: PivotCharts for Data Presentation (5:38)

Start

Topic D: Use Timelines and Slicers to Filter Data (0:05)

Start

Slicers (2:04) (2:04)

Start

The Slicers Dialog Box for Insert (0:21)

Start

Contextual Slicer Tools Tab (0:56)

Start

The Dialog Box for Report Connections (0:51)

Start

Timelines (0:34) (0:34)

Start

The Dialog Box for Inserting Timelines (0:18)

Start

The Contextual Timeline Tools Tab (0:35)

Start

Data Filtering Using Slicers and Timelines in a Demo (3:26)

Start

Chapter 05 Summary (0:40)

Start

Quiz for Chapter 05

Start

Close of Course (1:28)