Exploring the Analytics aspect of Excel using simple examples

Informazione importanti

Short course

Beginner

Online

Durata:1 Year

Quando:Da definire

Descrizione

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum. This Course emphasizes on ‘Analytics’ approach of Excel using simple examples. The forecasting techniques and data visualization explained in this course offer executives and other knowledge personnel, new approaches to dramatically improve their ability to grasp information hiding in their data.

Informazione importanti

Quali sono gli obiettivi della formazione?

The Objective of this course is to enable understudies to understand and Appreciate data exploration utilities in Excel, Use ‘What-If-Analysis’ and Data representation techniques, Understand data co-relation for any given data set, Demonstrate forecasting techniques using Excel functions, Understand terms used in simple regression.

Requisiti: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment

Sedi

Dove e quando

Inizio

Luogo

Da definire

Online

Cosa impari in questo corso?

Excel

Forecasting

IT

MS Excel

Programma

This Course Consists of the following contents- 1.Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Manager, 2.Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013), 3.Understanding terms using in Analytics - R squared, Co-efficient, Slope, etc., 4.Finding co-relation in any given data set - drawing trend line, 5.Using Excel Forecasting techniques to demonstrate regression, 6.Displaying regression equations on Chart. Studying these subjects and topics will bring you to understand how this position works and which skills you should develop in order to fulfil your responsibilities. Even if you have a busy day to day live, this course adapts itself to your routine. Should you have any doubts, please do not hesitate to ask for more information through Emagister, leading educational portal.

Ulteriori informazioni

This Course is made for students to become able to manage data independently, User will be able to do reports (eg: Financial, Banking, Insurance, Pharmaceutical, Retail, Educational, small shops etc), User will become data analyst, User will able to do MIS reports, Able to explore the Automation techniques of Excel using Macros and VBA.