Course code: MSEXE13« Back

Microsoft Excel 2013 – for Economists

This course Microsoft Excel 2013 – for Economists is intent on economic functions and calculations in Microsoft Excel. You should already know Microsoft Excel on “Microsoft Excel - practical use” level.

This training is replaced by training MSEXE16 from autumn 2016.

This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 8 000 CZK included in course price 0
Brno2 7 200 CZK included in course price 0
Bratislava2 250,00 EUR included in course price 0

User intensity level

Who is the course for

This course is assigned for advanced users mainly from economic branch, who work in Excel and use common tools (filters, basic functions and formulas, table formatting, etc.). We will show you new tools and functions used for different models, outlines and analysis.

What we teach you

You will learn to use tools and functions for effective data analysis, complicated models and outlines output.

Required skills

  • Microsoft Excel - elementary level
  • Microsoft Excel - practical use

    Teaching methods

    Professional explanation with practical samples and examples.

    Teaching materials

    Gopas guide book for this course.

    Course Outline

    Extension possibilities pivot tables

    • Recapitulation basic procedure
    • Creating anothers subtotals
    • Creation personal computational field, sum
    • Possibilities formatting KT
    • Grouping data in KT
    • Inbuilt summary function for data analysis
    • Pivot graph

    Lookup function - data research

    • VLOOKUP, HLOOKUP
    • MATCH
    • Index
    • CHOOSE

    Conditional formatting data

    • With reference to values
    • With reference to issue formula

    Possibilities verifacation enter data - limitation data input

    • To values
    • Longitude set text
    • On integer
    • Date in interval

    Graph

    • Monitoring process - completion trend to the graph, predicate future state, comparison different trend
    • Mistake abscissae - collation plan-reality
    • extirpation course running average

    Basic statistical function for calculation judgment

    • FORECAST
    • LINTREND (TREND)
    • LINREGRESE (LINEST)

    Production variant tables - scenarios

    • Creation scenario
    • Exit from scenario - total news
    • Work manager scenario

    GOAL SEEK

    Nesting controls on leaf

    • List box, Combo box
    • Check box
    • Option button
    • Counter

    Generating group and outline

    • Auto outline
    • Group and ungroup

    Possibilities unloaded text file to the Excel

    • Opening text file
    • Import text file
    • Analysis text to the column

    One generic function exemplary

    • IF, next logical function - AND, OR
    • VALUE - transmission text on issue
    • SUMIF, COUNTIF - contingent calculation
    • function supplying average - MOOD, MEDIAN
    • SUMPRODUCT
    • basic date-stamp function - today, DAY, MONTH, YEAR
    • date-stamp function for work with weekdays - NETWORKDAYS, WORKDAY
    • choice text function - PART, CLEAR

    Finance functions exemplary

    • Function counting with annuity
    • Function cash flow - time-sharing, one-shot cash flow

    Complex example - analysis pay-roll

    • Formatting tables
    • Completion simple calculated field - averages, contingent calculation by the help of function when
    • Production totality
    • Creation and formatting kontingencni tables, graph
    • Creation personal computational field
  • Příručka MS Excel 2013 pro ekonomy [Cz/Cz]

    Price:
    included in course price
    Příručka MS Excel 2013 pro ekonomy [Cz/En]

    Price:
    included in course price
    The prices are without VAT.