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

Welcome-university

Suggest Course

Course Information arrow
Learn Microsoft Excel 2013 – Advanced

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 Ver...

Keywords: Learn Microsoft Excel 2013 Advanced Course, Microsoft Excel 2013 Advanced, simonsezit, simonsezit, Simon Sez It, Simon Sez It, microsoft skills training, microsoft skills, microsoft course, microsoft excel, Microsoft Excel course, microsoft excel 2013

Read More
Comments:

There are no comments left at this moment.
Included Modules:
  • chapter-1-prerequisites-of-excel-2013-advanced-course

    Chapter 1: Prerequisites of Excel 2013 Advanced Course

  • chapter-2-list-of-functions-common-types-of-arguments-basic-use-of-functions

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

  • chapter-2-advanced-aspects-of-functions-searching-for-a-function

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

  • chapter-2-autosum

    Chapter 2: AutoSum

  • chapter-3-payment

    Chapter 3: Payment

  • chapter-3-future-value

    Chapter 3: Future Value

  • chapter-3-principle-payment

    Chapter 3: Principle Payment

  • chapter-3-depreciations

    Chapter 3: Depreciations

  • chapter-4-how-dates-and-times-are-stored

    Chapter 4: How Dates and Times are Stored

  • chapter-4-dates-and-times-calculation

    Chapter 4: Dates and Times Calculation

  • chapter-4-exercise-on-date-and-time-functions-date-and-time-settings

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

  • chapter-5-average

    Chapter 5: Average

  • chapter-5-percentile

    Chapter 5: Percentile

  • chapter-5-regression

    Chapter 5: Regression

  • chapter-5-linest-function

    Chapter 5: LINEST Function

  • chapter-5-example-of-functions-for-inferential-statistics

    Chapter 5: Example of Functions for Inferential Statistics

  • chapter-6-text-function-case-study-1

    Chapter 6: Text Function Case Study - 1

  • chapter-6-text-function-case-study-2

    Chapter 6: Text Function Case Study - 2

  • chapter-7-lookup-and-reference-functions

    Chapter 7: Lookup and Reference Functions

  • chapter-8-logical-functions

    Chapter 8: Logical Functions

  • chapter-9-connecting-to-other-workbooks

    Chapter 9: Connecting to Other Workbooks

  • chapter-9-connecting-to-access-data

    Chapter 9: Connecting to Access Data

  • chapter-9-connecting-to-web-data

    Chapter 9: Connecting to Web Data

  • chapter-10-creating-a-table-and-changing-table-name-filter-removing-duplicates-total-row

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

  • chapter-10-inserting-columns-and-rows-resizing-tables

    Chapter 10: Inserting Columns and Rows; Resizing Tables

  • chapter-10-table-reference

    Chapter 10: Table Reference

  • chapter-10-table-styles

    Chapter 10: Table Styles

  • chapter-10-table-selection

    Chapter 10: Table Selection

  • chapter-11-basic-principles-of-pivot-tables

    Chapter 11: Basic Principles of Pivot Tables

  • chapter-11-presentational-side-of-pivot-tables

    Chapter 11: Presentational Side of Pivot Tables

  • chapter-11-filtering-in-pivot-tables-slices

    Chapter 11: Filtering in Pivot Tables; Slices

  • chapter-12-what-if

    Chapter 12: What If

  • chapter-12-scenario-manager

    Chapter 12: Scenario Manager

  • chapter-12-goal-seek

    Chapter 12: Goal Seek

  • chapter-12-solver

    Chapter 12: Solver Solver

  • chapter-13-area-charts

    Chapter 13: Area Charts

  • chapter-13-surface-charts

    Chapter 13: Surface Charts

  • chapter-13-stock-charts-part-1

    Chapter 13: Stock Charts Part 1

  • chapter-13-stock-charts-part-2

    Chapter 13: Stock Charts Part 2

  • chapter-13-radar-charts

    Chapter 13: Radar Charts

  • chapter-13-bubble-charts

    Chapter 13: Bubble Charts

  • chapter-14-regression-and-scatter-chart

    Chapter 14: Regression and Scatter Chart

  • chapter-15-creating-pivot-charts

    Chapter 15: Creating Pivot Charts

  • chapter-16-using-sparklines

    Chapter 16: Using Sparklines

  • chapter-17-creating-workbooks-using-a-web-app

    Chapter 17: Creating Workbooks using a Web App

  • chapter-17-sharing-your-workbook

    Chapter 17: Sharing your Workbook

  • chapter-18-closing

    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