-72%Hot
Click to enlarge
Previous product
ETF, CFD Trader GOLD - Mining The Markets - DVD 2009 by Daryl Guppy 42.00$
Back to products
Next product
Precision Pattern Trading by Daryl Guppy 22.00$

Integrity Training – Microsoft Excel 2010: Advanced

(1 customer review)

Original price was: 149.00$.Current price is: 42.00$.

Product Include:
File size:

Note: Digital download to email address
Add to Wishlist
Compare
Add to wishlist
Category: Tags: ,
Description

Integrity Training – Microsoft Excel 2010: Advanced

Description

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

    Preview Information: 
    Original Page
    Archive Page
    Integrity Training – Microsoft Excel 2010: Advanced Available now at Vincourse.com
    Integrity Training – Microsoft Excel 2010: Advanced Download, Integrity Training – Microsoft Excel 2010: Advanced Available Now, Integrity Training – Microsoft Excel 2010: Advanced Order, Integrity Training – Microsoft Excel 2010: Advanced Reviews, Integrity Training – Microsoft Excel 2010: Advanced Torrent, Integrity Training – Microsoft Excel 2010: Advanced Course Download, Integrity Training – Microsoft Excel 2010: Advanced ClubBuy, Integrity Training – Microsoft Excel 2010: Advanced Groupbuy
Reviews (1)

1 review for Integrity Training – Microsoft Excel 2010: Advanced

  1. Lord –

    This is Digital Download service, the course is available at Coursecui.com and Email download delivery.

Add a review

Your email address will not be published. Required fields are marked *

Related products

-84%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Wholesaling Lease Options Virtually – Full Day Workshop from Joe McCall

Original price was: 297.00$.Current price is: 47.00$.
-85%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Psychology Online Home Study Course by Traderscoach

Original price was: 498.00$.Current price is: 77.00$.
-82%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Blueprint to Voice Over Success Option 1 from Marc Scott

Original price was: 347.00$.Current price is: 62.00$.
-72%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Using Lease Options to Buy and Sell Property by John Schaub

Original price was: 149.00$.Current price is: 42.00$.
-88%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Lease Options by Bill Bronchick

Original price was: 597.00$.Current price is: 72.00$.
-81%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Intro & Advanced Real Estate Option Strategies Streaming Seminars by Jack Miller

Original price was: 297.00$.Current price is: 57.00$.
-84%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Root Canal Seminar from Gary Halbert

Original price was: 397.00$.Current price is: 62.00$.
-82%Hot
Add to cart
Quick view
Compare
Add to wishlist
Close

Content Marketing School from Cody Lister

Original price was: 337.00$.Current price is: 62.00$.