|
|
|
MSEXE07 - Microsoft Excel 2007 for Economists
This course is intent on economic functions and calculations in Microsoft Excel. You should already know Microsoft Excel on “Microsoft Excel - practical use” level.
Who the course is forThis 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 youYou 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 methodsProfessional explanation with practical samples and
examples.
Teaching materialsGopas guide book for this course.
Course syllabus
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
Back solvate
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
Recommended prior courses
MSEX107 - Microsoft Excel 2007 – Basic Course
MSEX207 - Microsoft Excel 2007 – In Practice
MSSA - Microsoft Office 2007 – Application Co–operation
PCWI - PC and Windows – For Beginners
Recommended subsequent courses
MSEX4 - Microsoft Excel – Application Development
MSMAK107 - Using Microsoft Office 2007 Macros
Catalog price of course and handbook
| Praha |
7000 Kč
|
--
|
0 items
|
| Brno |
6200 Kč
|
--
|
0 items
|
Course dates
|
