Microsoft Excel for Data Analyst Online self-learning course

Rapid Skillz

Preço a consultar

Informação importante

  • Short course
  • Beginner
  • Online
  • Duração:
    1 Year
  • Quando:
    à escolha

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.

Informação importante
Quais são os objetivos da formação?

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.


Instalações e datas

Início Localização
à escolha

O que se aprende nesse curso?

Microsoft Excel
Microsoft excel training
MS Excel


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.

Informação 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.