Name: Integrity Training – Microsoft Excel 2010: Advanced
Brand: Tenlibrary
SKU: ITME2A
Availability: InStock
Rating: 4 (15 reviews)

-73%

The course covers the more complex concepts like VLOOKUP, MATCH, INDEX, data validation, macros and conditional formatting.

$40.00

Integrity Training – Microsoft Excel 2010: Advanced

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

SKU: ITME2A Category: Forex & Trading Tags: Integrity Training, Integrity Training – Microsoft Excel 2010: Advanced, Microsoft Excel 2010: Advanced

Integrity Training – Microsoft Excel 2010: Advanced

The Microsoft Excel 2010 Advance course is the third and last course in the three course series on Microsoft Office Excel 2010 that covers the advanced-level topics regarding Microsoft Excel 2010 and enables the students to master the Microsoft Office Excel 2010. The course covers the more complex concepts like VLOOKUP, MATCH, INDEX, data validation, macros and conditional formatting.

Microsoft Office Excel 2010 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 2010 to achieve excellence in the daily routine tasks.

Course Curriculum

Introduction

Start

Course Introduction (0:52)
Start

Instructor Introduction (0:23)
Start

Instructor Introduction (0:10)

Unit 01 – Logical & Statistical Functions

Start

Topic A: Logical Functions (0:12)
Start

The IF Function (0:37)
Start

Demo – A-1: Using the IF Function (1:53)
Start

Demo – A-2: Using a Formula to Apply Conditional Formatting (2:34)
Start

OR, AND, and NOT Functions (1:09)
Start

Demo – A-3: Using OR, AND, and NOT as Nested Functions (4:36)
Start

Nested IF Functions (1:11)
Start

Demo – A-4: Using Nested IF Functions (2:33)
Start

The IFERROR Function (0:34)
Start

Demo – A-5: Using the IFERROR Function (1:07)
Start

Topic B: Math and Statistical Functions (0:06)
Start

The SUMIF Function (0:49)
Start

Demo – B-1: Using SUMIF (2:49)
Start

The COUNTIF Function (0:45)
Start

Demo – B-2: Using COUNTIF (1:00)
Start

The AVERAGEIF Function (0:42)
Start

Demo – B-3: Using AVERAGEIF (1:27)
Start

SUMIFS, COUNTIFS, AVERAGEIFS (1:13)
Start

Demo – B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS (4:46)
Start

The ROUND Function (1:24)
Start

Evaluate Formula Dialog Box (1:11)
Start

Demo – B-5: Using ROUND (3:00)
Start

Unit 01 Review (0:11)
Start

Unit 01 Quiz

Unit 02 – Financial & Date Functions

Start

Financial & Date Functions (0:11)
Start

Topic A: Financial Functions (0:06)
Start

The PMT Function (1:37)
Start

Topic B: Date and Time Functions (0:10)
Start

Date Functions (1:19)
Start

Demo – B-1: Using Date Functions (6:18)
Start

Calculating Time (0:46)
Start

Demo – B-2: Using Time Functions (1:40)
Start

Topic C: Array Formulas (0:12)
Start

Array Formulas (0:33)
Start

Creating an Array Formula (0:38)
Start

Demo – C-1: Using an Array Formula (1:44)
Start

Applying Arrays to Functions (0:47)
Start

Demo – C-2: Applying Arrays to Functions (1:19)
Start

Modify an Array Formula (0:34)
Start

Demo – C-3: Modifying the Array Formula (3:29)
Start

Topic D: Displaying and Printing Formulas (0:06)
Start

Displaying Formulas in Cells (0:33)
Start

Hide Formulas from Users (0:37)
Start

Show Hidden Formulas (0:24)
Start

Demo – D-1: Showing, Printing, and Hiding Formulas (3:04)
Start

Automatic Recalculation (1:09)
Start

Edit Iteration Calculation Options (0:29)
Start

Demo – D-2: Setting Calculation Options (1:55)
Start

Unit 02 Review (0:06)
Start

Unit 02 Quiz

Unit 03 – Lookups and Data Tables

Start

Lookups and Data Tables (0:20)
Start

Topic A: Using Lookup Functions (0:08)
Start

The HLOOKUP Function (0:40)
Start

The VLOOKUP Function (0:34)
Start

Demo – A-1: Examining VLOOKUP (1:45)
Start

VLOOKUP for Exact Matches (0:31)
Start

Demo – A-2: Using VLOOKUP to Find an Exact Match (1:58)
Start

VLOOKUP for Approximate Matches (0:25)
Start

Demo – A-3: Using VLOOKUP to Find an Approximate Match (2:04)
Start

HLOOKUP for Exact Matches (0:24)
Start

Demo – A-4: Using HLOOKUP to Find Exact Matches (3:16)
Start

HLOOKUP for Approximate Matches (0:24)
Start

Demo – A-5: Using HLOOKUP to Find Approximate Matches (1:43)
Start

Topic B: Using MATCH and INDEX (0:05)
Start

The MATCH Function (0:51)
Start

Demo – B-1: Using the MATCH Function (2:37)
Start

The INDEX Function (0:52)
Start

Demo – B-2: Using the INDEX Function (1:57)
Start

Topic C: Creating Data Tables (0:04)
Start

One-Variable Data Tables (0:40)
Start

Demo – C-1: Creating a One-variable Data Table (3:19)
Start

Two-Variable Data Tables (0:18)
Start

Demo – C-2: Creating a Two-variable Data Table (2:36)
Start

Unit 03 Review (0:20)
Start

Unit 03 Quiz

Unit 04 – Advanced Data Management

Start

Advanced Data Management (0:11)
Start

Topic A: Validating Cell Entries (0:05)
Start

Data Validation (0:32)
Start

Demo – A-1: Observing Data Validation (2:15)
Start

Setting Data Validation Rules (0:29)
Start

Demo – A-2: Setting Up Data Validation (2:25)
Start

Using Date Criteria (0:24)
Start

Demo – A-3: Setting Date and List Validations (2:01)
Start

Topic B: Exploring Database Functions (0:05)
Start

Structure of Database Functions (1:04)
Start

Demo – B-1: Examining the Structure of Database Functions (2:10)
Start

DSUM and DAVERAGE (0:58)
Start

Demo – B-2: Using the DSUM Function (2:29)
Start

Unit 04 Review (0:11)
Start

Unit 04 Quiz

Unit 05 – Exporting and Importing

Start

Exporting and Importing (0:16)
Start

Topic A: Exporting and Importing Text Files (0:05)
Start

Using the Save As Command (0:28)
Start

Demo – A-1: Exporting Excel Data to a Text File (2:02)
Start

Importing Data (0:21)
Start

Demo – A-2: Importing Data from a Text File into a Workbook (2:49)
Start

The Text Import Wizard (0:50)
Start

Converting Text to Columns (0:21)
Start

Demo – A-3: Converting Text to Columns (1:47)
Start

Removing Duplicates (0:43)
Start

Demo – A-4: Removing Duplicate Records (1:26)
Start

Topic B: Exporting and Importing XML Data (0:06)
Start

The XML Maps Dialog Box (0:48)
Start

The XML Source Pane (0:59)
Start

Importing XML Data (0:35)
Start

Exporting Data to an XML File (0:40)
Start

Deleting XML Maps (0:22)
Start

Topic C: Querying External Databases (0:06)
Start

Using Microsoft Query (1:40)
Start

Demo – C-1: Getting External Data from Microsoft Query (4:51)
Start

Web Query (0:34)
Start

Retrieving Data from a Web Page (0:40)
Start

Demo – C-2: Using a Web Query to Get Data from the Web (1:39)
Start

Unit 05 Review (0:15)
Start

Unit 05 Quiz

Unit 06 – Analytical Tools

Start

Analytical Tools (0:31)
Start

Topic A: Goal Seek and Solver (0:08)
Start

Using the Goal Seek Utility (0:21)
Start

Demo – A-1: Using Goal Seek to Solve for a Single Variable (3:46)
Start

Activating Add-Ins (0:46)
Start

The Add-Ins Dialog Box (0:29)
Start

The Solver Parameters Dialog Box (1:06)
Start

Demo – A-3: Using Solver to Solve for Multiple Variables (8:12)
Start

Topic B: The Analysis ToolPak (0:05)
Start

Analysis ToolPak (1:44)
Start

Using the Sampling Analysis Tool (0:42)
Start

Demo – B-1: Using the Sampling Analysis Tool (2:41)
Start

Topic C: Scenarios (0:05)
Start

Creating a Scenario (0:28)
Start

Demo – C-1: Creating Scenarios (4:20)
Start

Add a Scenario Manager Button (0:44)
Start

Merging Scenarios (0:22)
Start

A Sample Scenario Summary (0:18)
Start

Unit 06 Review (0:29)
Start

Unit 06 Quiz

Unit 07 – Macros and Custom Functions

Start

Macros and Custom Functions (0:19)
Start

Topic A: Running and Recording a Macro (0:08)
Start

Running Macros (0:22)
Start

Demo – A-1: Running a Macro (2:20)
Start

Recording Macros (0:44)
Start

Demo – A-2: Recording a Macro (3:34)
Start

Assigning Macros to Buttons (0:31)
Start

Demo – A-3: Assigning a Macro to a Button (0:57)
Start

Add Macro Buttons to the Ribbon (1:19)
Start

Insert a Button (1:15)
Start

Change Button Properties (1:01)
Start

Demo – A-4: Inserting a Macro Button (2:12)
Start

Create Auto_Open Macro (1:02)
Start

Demo – A-5: Creating an Auto_Open Macro (3:07)
Start

Topic B: Working with VBA Code (0:05)
Start

VBA Code (0:58)
Start

Observing VBA Code (0:17)
Start

Demo – B-1: Observing a VBA Code Module (3:47)
Start

Example of Editing VBA Code (0:26)
Start

Demo – B-2: Editing VBA Code (1:22)
Start

Topic C: Creating Functions (0:05)
Start

Function Procedures (0:27)
Start

Creating a Custom Function (1:25)
Start

Demo – C-1: Creating a Custom Function (3:34)
Start

Unit 07

Get Integrity Training – Microsoft Excel 2010: Advanced at tenco.pro

Reviews

There are no reviews yet.

Be the first to review “Integrity Training – Microsoft Excel 2010: Advanced” 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]