Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Course Information arrow

Price Discounts

  • Qty

    Price

  • 1

    $29.00

  • 0

    $29.00

  • 0

    $29.00

  • 0

    $29.00

  • 0

    $29.00

  • 0

    $29.00

Syndication Option

Resell Course
Resold modules appear on your website. You earn syndication share from each purchase.


Create Custom Widget
Select a display format that best suits your website, then add courses and customize your widget. We'll provide the HTML for you to use on your site.

74823

Learn Microsoft Excel 2013 – Advanced

Author: Simon Sez IT

Category: Online Software Training > Microsoft Office

Master Excel's Powerful Data Functions in this Information-Packed 9-hour Video Training. Personal and Professional Financial Functions Statistical Functions for Description, Prediction and Interference Connecting to External Data Tables, Charts and Pivots Data Analysis The Versatili...

Keywords: Learn Microsoft Excel 2013 Advanced Course, Microsoft Excel 2013 Advanced

Read More
Buy this course
$29.00

Per License

Enter no. of units to buy
Total Payment Required$29.00 Add to Cart
Included Modules:
  • 74770

    Chapter 1: Prerequisites of Excel 2013 Advanced Course

  • 74772

    Chapter 2: List of Functions; Common Types of Arguments; Basic Use of Functions

  • 74771

    Chapter 2: Advanced Aspects of Functions; Searching for a Function

  • 74773

    Chapter 2: AutoSum

  • 74774

    Chapter 3: Payment

  • 74775

    Chapter 3: Future Value

  • 74776

    Chapter 3: Principle Payment

  • 74777

    Chapter 3: Depreciations

  • 74778

    Chapter 4: How Dates and Times are Stored

  • 74779

    Chapter 4: Dates and Times Calculation

  • 74780

    Chapter 4: Exercise on Date and Time Functions; Date and Time Settings

  • 74781

    Chapter 5: Average

  • 74782

    Chapter 5: Percentile

  • 74783

    Chapter 5: Regression

  • 74785

    Chapter 5: LINEST Function

  • 74786

    Chapter 5: Example of Functions for Inferential Statistics

  • 74788

    Chapter 6: Text Function Case Study - 1

  • 74789

    Chapter 6: Text Function Case Study - 2

  • 74790

    Chapter 7: Lookup and Reference Functions

  • 74791

    Chapter 8: Logical Functions

  • 74792

    Chapter 9: Connecting to Other Workbooks

  • 74793

    Chapter 9: Connecting to Access Data

  • 74794

    Chapter 9: Connecting to Web Data

  • 74796

    Chapter 10: Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row

  • 74797

    Chapter 10: Inserting Columns and Rows; Resizing Tables

  • 74822

    Chapter 10: Table Reference

  • 74799

    Chapter 10: Table Styles

  • 74800

    Chapter 10: Table Selection

  • 74801

    Chapter 11: Basic Principles of Pivot Tables

  • 74802

    Chapter 11: Presentational Side of Pivot Tables

  • 74803

    Chapter 11: Filtering in Pivot Tables; Slices

  • 74804

    Chapter 12: What If

  • 74805

    Chapter 12: Scenario Manager

  • 74806

    Chapter 12: Goal Seek

  • 74807

    Chapter 12: Solver Solver

  • 74808

    Chapter 13: Area Charts

  • 74810

    Chapter 13: Surface Charts

  • 74811

    Chapter 13: Stock Charts Part 1

  • 74813

    Chapter 13: Stock Charts Part 2

  • 74814

    Chapter 13: Radar Charts

  • 74815

    Chapter 13: Bubble Charts

  • 74816

    Chapter 14: Regression and Scatter Chart

  • 74817

    Chapter 15: Creating Pivot Charts

  • 74818

    Chapter 16: Using Sparklines

  • 74819

    Chapter 17: Creating Workbooks using a Web App

  • 74820

    Chapter 17: Sharing your Workbook

  • 74821

    Chapter 18: Closing

Attachments
  • Icon-pdf
  • Example 1

  • 8.86 KB
  • Icon-pdf
  • Example 2

  • 10.31 KB
  • Icon-pdf
  • Example 3

  • 10.6 KB
  • Icon-pdf
  • Example 4

  • 8.91 KB
  • Icon-pdf
  • Example 5

  • 9.23 KB
  • Icon-pdf
  • Example 6

  • 9.15 KB
  • Icon-pdf
  • Example 7

  • 9.64 KB
  • Icon-pdf
  • Example 8

  • 15.86 KB
  • Icon-pdf
  • Example 9

  • 16.06 KB
  • Icon-pdf
  • Example 10

  • 11.66 KB
  • Icon-pdf
  • Example 11

  • 17.28 KB
  • Icon-pdf
  • Example 12

  • 17.26 KB
  • Icon-pdf
  • Example 13

  • 11.05 KB
  • Icon-pdf
  • Example 14

  • 9.18 KB
  • Icon-pdf
  • Example 15

  • 9.69 KB
  • Icon-pdf
  • Example 16

  • 17.12 KB
  • Icon-pdf
  • Example 17

  • 8.5 KB
  • Icon-pdf
  • Example 18

  • 14.22 KB
  • Icon-pdf
  • Example 19

  • 10.54 KB