Course Details
Course Outline
5 days course
An Introduction to the MS Excel Environment
- Cell referencing, cell formatting and entering formula.
- Workbooks vs. Worksheets.
- Copy and pasting.
- Left click vs. right click.
- Paste particular.
- Introductory charts.
Using MS Excel Functions for Fundamental Data Analysis
- Utilize of text function, FIND(), LEN(), LEFT(), RIGHT() and &
- Utilize of count functions, COUNTA(), COUNTIF(), COUNTIFS() and SUMIF()
- Main statistical functions, Max and Average.
- Sorting, Filtering and use of conditional formatting.
- Scatter diagrams.
Intermediate MS Excel Functions
- Utilizing of VLOOKUP() and HLOOKUP().
- Date functions, YEAR(), MONTH(), DAY(), YEARFRAC().
- Choosing suitable charts.
- Introduction to Pivot tables.
Carrying out Statistical Analysis using MS Excel
- Learn how to use MS Excel to calculate median, mode and mean.
- The distinction among the many standard deviation and variance function in MS Excel.
- Utilizing MS Excel to check inter-dependency.
- Designing histograms in MS Excel.
- Introduction to Data Analysis functions.
What if and Scenario Analysis Using MS Excel
- Naming cells in MS Excel.
- Linking cells together to conduct scenario analysis.
- Introduction to solver.
- Advanced charting.
- participate MS Excel result with other office formats.
