Course description
Most people use Excel for basic data manipulation and analysis and are not aware of its sophisticated data management and charting techniques and advanced data analysis capability. Excel is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning.
Data Management, Manipulation and Analysis Using Excel course is perfect for experts who have, or will next have, duty regarding managing and controlling data utilizing MS Excel on an everyday basis.
The course requires zero background, starts with an introduction to the Excel environment and finishes with learners being expert in utilizing 50+ MS Excel functions, complex data management and diagramming procedures and advanced data analysis ability.
Upcoming start dates
Suitability - Who should attend?
Data Management, Manipulation and Analysis Using Excel Training course, is ideal for :
- Anyone with Line Manager Responsibility
- HR Professionals
- Oil and Gas, Energy and Telecom Team Engineers
- Senior Finance Professionals
- Board Level Executives and Non-Executives
Outcome / Qualification etc.
t the end of thr Data Management, Manipulation and Analysis Using Excel Training course , participants will be able to :
- Be Familiar with 50+ Excel Functions
- Recognise the Right Chart for the Right Task
- Manipulate Both Textual and Numerical Data
- Analyse Data Using Appropriate Tools
- Analyse Relationships Amongst Variables and Generate Forecasts
- Analyse relations through information and data by MS Excel.
- The method you use to create a forecast.
- Arrange your companies data in a more structured way.
- Analyse your data successfully by different MS Excel techniques.
- Choose the suitable chart for your data.
Training Course Content
Day 1
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.
Day 2
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.
Day 3
Intermediate MS Excel Functions
- Utilizing of VLOOKUP() and HLOOKUP().
- Date functions, YEAR(), MONTH(), DAY(), YEARFRAC().
- Choosing suitable charts.
- Introduction to Pivot tables.
Day 4
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.
Day 5
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.
- 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.
Request info
London Premier Centre
London Premier Centre is a UK leading training provider based in London and specialises in international short courses. Our inspiring, comprehensive portfolio of more than 400 professional development courses and seminars covers a wide range of professions from Administration, Leadership,...