Name: Integrity Training – Microsoft Office 2016 Excel Intermediate
Brand: Tenlibrary
SKU: ITMO2EI
Availability: InStock
Rating: 4 (15 reviews)

-73%

opportunity to students to upgrade to Microsoft Office Excel 2016.

$40.00

Integrity Training – Microsoft Office 2016 Excel Intermediate

Product Delivery : You will receive a receipt with download link through email

SKU: ITMO2EI Category: Forex & Trading Tags: Integrity Training, Integrity Training – Microsoft Office 2016 Excel Intermediate, Microsoft Office 2016 Excel Intermediate

Integrity Training – Microsoft Office 2016 Excel Intermediate

The Microsoft Excel 2016 L2 course is the second course in a three course series on Microsoft Office Excel 2016 that covers the intermediate-level topics regarding Microsoft Excel 2016. The course covers the more advanced concepts like functions, lists, data analysis, data visualization and pivot tables. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2016.

Microsoft Office Excel 2016 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2016 to achieve excellence in the daily routine tasks.

Course Curriculum

Introduction

Start

Introduction (1:27)
Start

Courseware (0:30)
Start

Instructor Introduction (0:58)

Chapter 01 – Working with Functions

Start

Working with Functions (1:10)
Start

Topic A: Work with Ranges (0:49)
Start

Cell and Range Names (2:03)
Start

Names and the Name Box (0:22)
Start

The New Name Dialog Box (0:51)
Start

The Create from Selection Command (0:58)
Start

The Name Manager Dialog Box (1:05)
Start

Demo – Naming and Editing Ranges (6:34)
Start

Cell and Range Names in Formulas (0:31)
Start

The Use in Formula Command Method (0:32)
Start

The Formula AutoComplete Method (0:35)
Start

Demo – Using Defined Names in a Formula (2:37)
Start

Topic B: Use Specialized Functions (0:34)
Start

The Excel Function Reference (1:41)
Start

Function Syntax (1:20)
Start

Date Calculations (1:19)
Start

Demo – Locating and Using Specialized Functions (6:44)
Start

Topic C: Work with Logical Functions (2:27)
Start

Comparison Operators (0:59)
Start

The IF Function (2:25)
Start

The AND Function (1:11)
Start

The OR Function (0:25)
Start

The NOT Function (0:40)
Start

Demo – Working with Logical Functions (6:33)
Start

Nesting (1:13)
Start

Nested Function Syntax (3:51)
Start

Demo – Combining Functions (3:45)
Start

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

The TODAY Function (0:24)
Start

The NOW Function (0:22)
Start

The DATE Function (0:50)
Start

The NETWORKDAYS Function (1:05)
Start

The WEEKDAY Function (0:52)
Start

The WORKDAY Function (1:01)
Start

The ISOWEEKNUM Function (0:36)
Start

Demo – Work with Date & Time Functions (2:36)
Start

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

The LEFT Function (1:56)
Start

The RIGHT Function (0:29)
Start

Convert Text to Columns Wizard (0:55)
Start

The MID Function (0:49)
Start

The CONCATENATE Function (0:41)
Start

Text Concatenation with the Ampersand (0:25)
Start

The UPPER Function (0:19)
Start

The LOWER Function (0:13)
Start

The PROPER Function (0:15)
Start

Demo – Working with Text Functions (3:49)
Start

Chapter 01 Review (0:37)
Start

Chapter 01 Quiz

Chapter 02 – Working with Lists

Start

Working with Lists (0:33)
Start

Topic A: Sort Data (0:28)
Start

Sorting (2:13)
Start

Multiple Column/Row Sorting (1:05)
Start

Quick Sorts (0:47)
Start

The Sort Dialog Box (1:10)
Start

The Sort Options Dialog Box (0:31)
Start

Demo – Sorting Data (3:12)
Start

Topic B: Filter Data (0:30)
Start

Filtering (0:52)
Start

AutoFilters (0:46)
Start

The Custom AutoFilter Dialog Box (0:52)
Start

Advanced Filtering (0:59)
Start

The Criteria Range (1:45)
Start

Demo – Filtering Data (4:02)
Start

Topic C: Query Data with Database Functions (0:19)
Start

Database Functions (1:40)
Start

Database Function Syntax (2:21)
Start

Demo – Using Database Functions (4:41)
Start

Topic D: Outline and Subtotal Data (0:39)
Start

Outlines (0:45)
Start

The SUBTOTAL Function (2:00)
Start

The Subtotals Feature (1:23)
Start

The Subtotal Dialog Box (0:35)
Start

Demo – Using Subtotals to Summarize Data (3:04)
Start

Chapter 02 Review (0:23)
Start

Chapter 02 Quiz

Chapter 03 – Analyzing Data

Start

Analyzing Data (0:43)
Start

Topic A: Create and Modify Tables (0:41)
Start

Tables (0:52)
Start

Table Components (1:18)
Start

The Create Table Dialog Box (0:32)
Start

The Table Tools Design Contextual Tab (0:52)
Start

Table Styles and Quick Styles (0:23)
Start

The New Table Style Dialog Box (0:45)
Start

Quick Analysis (1:08)
Start

Demo – Creating and Modifying Tables (5:00)
Start

Demo – Using Summary Functions in Tables (3:27)
Start

Topic B: Apply Intermediate Conditional Formatting (0:22)
Start

The New Formatting Rule Dialog Box (1:42)
Start

The Conditional Formatting Rules Manager Dialog Box (0:36)
Start

Rule Precedence (0:24)
Start

Demo – Applying Intermediate Conditional Formatting (3:44)
Start

Topic C: Apply Advanced Conditional Formatting (0:20)
Start

The Use a Formula to Determine Which Cells to Format Rule (1:08)
Start

Demo – Using Logical Functions to Apply Conditional Formatting (3:19)
Start

Chapter 03 Review (0:53)
Start

Chapter 03 Quiz

Chapter 04 – Visualizing Data with Charts

Start

Visualizing Data with Charts (1:07)
Start

Topic A: Create Charts (0:32)
Start

Charts (1:02)
Start

Chart Basics (1:45)
Start

Chart Types (2:08)
Start

Recommended Charts (0:40)
Start

The Insert Chart Dialog Box (0:39)
Start

Demo – Creating Charts (5:21)
Start

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

Chart Modifications (0:49)
Start

Chart Formatting (0:32)
Start

Chart Elements (1:38)
Start

The Design Tab (1:09)
Start

The Format Tab (0:38)
Start

The Format Task Pane (1:08)
Start

The Chart Tools Buttons (0:49)
Start

The Select Data Source Dialog Box (0:33)
Start

Demo – Modifying and Formatting Charts (4:14)
Start

Topic C: Use Advanced Chart Features (1:04)
Start

Dual-Axis Charts (1:08)
Start

Trendlines (1:24)
Start

The Format Trendline Task Pane (0:43)
Start

Demo – Creating a Dual-Axis Chart (4:08)
Start

Chart Templates (0:57)
Start

Demo – Creating a Chart Template (1:52)
Start

Chapter 04 Review (1:10)
Start

Chapter 04 Quiz

Chapter 05 – Using PivotTables and PivotCharts

Start

Using PivotTables and PivotCharts (1:28)
Start

Topic A: Create a PivotTable (0:28)
Start

Pivoting (2:18)
Start

PivotTables (1:32)
Start

Transactional Data (1:10)
Start

The Create PivotTable Dialog Box (0:33)
Start

The PivotTable Fields Task Pane (1:27)
Start

Demo – Creating a PivotTable (4:29)
Start

Topic B: Analyze PivotTable Data (0:04)
Start

The Analyze Tab (3:13)
Start

The Design Tab (0:25)
Start

The Value Field Settings Dialog Box (0:48)
Start

SUM Function Only (0:41)
Start

Percentage of Total (0:28)
Start

Difference From Option (0:40)
Start

The GETPIVOTDATA Function (1:29)
Start

Demo – Analyzing PivotTable Data (4:07)
Start

Topic C: Present Data with PivotCharts (0:05)
Start

PivotCharts (0:44)
Start

The PivotChart Fields Task Pane (0:31)
Start

PivotChart Filters (0:36)
Start

Demo – Presenting Data with PivotCharts (5:38)
Start

Topic D: Filter Data by Using Timelines and Slicers (0:05)
Start

Slicers (2:04)
Start

The Insert Slicers Dialog Box (0:21)
Start

The Slicer Tools Contextual Tab (0:56)
Start

The Report Connections Dialog Box (0:51)
Start

Timelines (0:34)
Start

The Insert Timelines Dialog Box (0:18)
Start

The Timeline Tools Contextual Tab (0:35)
Start

Demo – Filtering Data by Using Slicers and Timelines (3:26)
Start

Chapter 05 Review (0:40)
Start

Chapter 05 Quiz
Start

Course Closure (1:28)

Get Integrity Training – Microsoft Office 2016 Excel Intermediate at tenco.pro

Reviews

There are no reviews yet.

Be the first to review “Integrity Training – Microsoft Office 2016 Excel Intermediate” Cancel reply

You must be logged in to post a review.

After receive your order, It will take 0-12 hours to be download available.

The Course is digital products included PDFs,Videos (MP4,TS,AVI files), Audio (MP3,M4A), Document (Word, Exel,Power Point..)

We will provide the download link accordingly with the Email address on your “Order Reciep”.

Contact Email : [email protected]
Skype : [email protected]