Data Management, Manipulation and Analysis Using Excel
Select Other "city & date"
Data Management, Manipulation and Analysis Using Excel Course
Introduction:
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 experts in utilizing 50+ MS Excel functions, complex data management and diagramming procedures and advanced data analysis ability.
Course Objectives:
At the end of the Data Management, Manipulation and Analysis Using Excel Training course, participants will be able to:
- Be Familiar with 50+ Excel Functions
- Recognize the Right Chart for the Right Task
- Manipulate Both Textual and Numerical Data
- Analyze Data Using Appropriate Tools
- Analyze Relationships Amongst Variables and Generate Forecasts
- Analyze relations through information and data by MS Excel.
- The method you use to create a forecast.
- Arrange your company’s data in a more structured way.
- Analyze your data successfully by different MS Excel techniques.
- Choose the suitable chart for your data.
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
Course Outlines:
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.
