Microsoft Excel for Data Analyst Online self-learning course

Rapid Skillz
Online

Precio a consultar

Información importante

  • Short course
  • Beginner
  • Online
  • Duración:
    1 Year
  • Cuándo:
    A definir
Descripción

This training would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration. This interactive training targets specific business situations, and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report., This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.

Información importante
¿Qué objetivos tiene esta formación?

The Objective of this course is that participants would learn/use/acquire the following techniques/knowledge: Excel Advancements – some amazing features incorporated only in last 5 years, Using Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH, Advanced Data Sorting and Filtering techniques, Generating Pivot Tables and Charts from complex datasets, instantly, Implementing Slicers and Sparklines to build interactive dashboards, Exploring Data Validation techniques and creating dynamic listsm, Using ‘What-If-Analysis’ and Data representation techniques.

Requisitos: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.

Sedes

Dónde se enseña y en qué fechas

inicio Ubicación
A definir
Online

¿Qué aprendés en este curso?

Excel
IT
Microsoft Excel
Microsoft excel training
MS Excel

Temario

This Course Consists of the following contents carrying 12 Chapters-Chapter1 -Starting Microsoft Excel, Chapter2 -Intro to Excel as Data Analysis tool, Chapter3 -Mastering Conditional Functions, Chapter4 -Data Operations in MS Excel, Chapter5 -Data Visualization Concepts, Chapter6 -Data Formatting Tools and Techniques, Chapter7 -Performing complex calculations efficiently, Chapter8 -Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis), Chapter9 -Advanced Data Validation and Analysis (What-If-Analysis), Chapter10 -Performing Analytics steps using data (basics of Predictive Analysis), Chapter11 -Automation using Macros - Recorded version, Chapter12 -Automation using Macros - Coded version (basics). 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.

Información adicional

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, Maximum organization will use the excel, It requires day to day activities to manage & analyse the data.