Statistical tools will be explained in the next session and topics such as central tendency, dispersion, correlation and regression, histogram, etc. They will learn about advanced data sorting, conditional formatting and cell referencing, v-lookup, h-lookup, cell referencing and so on. Learners will come across various excel functionalities that are useful for a data analyst. In the next segment, a case study will be discussed based on the performance rating of employees using excel. The session will be conducted on the power pivot, wherein learners will get to know about pivot charts, pivot tables, pie charts and slicers. Then, a much more advanced lecture on pivot tables will take place, where we will discuss data summarization, data filtering, table formatting, pivot charts, pivot printing, macros, power pivot, DAX, etc. We will understand how can business intelligence be achieved through excel, by deploying its various features and tools.Īn introductory lecture will be delivered on pivot tables to explain its features and formatting. Here, we will discuss shortcut functions, excel functions, vertical lookups, financial functions and average-if function. In doing so, we will cover concepts like functions, pivot tables, evaluation, date and time format, v-lookup, future value function, business information, etc.Ī detailed tutorial will be there to discuss excel reports. We will develop our understanding of power excel. In this session, topics such as pictures and clip arts, excel chart and data table, pie charts and line charts, bubble charts, surface charts, pyramid charts and so on.
TRAINING NEEDS ANALYSIS FOR MICROSOFT EXCEL SERIES
Learners will gain an understanding of Gantt charts and data series in those graphs.Ī session will be carried out on excel charts and smart-art graphics. The training will then move forward to cover advanced excel functions of the 2010 version such as useful excel functions, data functions, what-if-analysis, text functions, auditing formulas, charts, form controls, etc. Concepts such as data entry, calculations, formulas, formatting, updating calculations, conditional formatting, graphs, charts, sorting, and filter, etc. Let us have a quick look at the overall coverage of this excel course.Ī beginners’ session will be conducted to cover the basic concepts of MS Excel 2010. These link can be included in your resume/Linkedin profile to showcase your enhanced skills Yes, you get verifiable certificates for each course with a unique link. You would understand Descriptive Statistics, Central Tendency, Mean Mode Median, Dispersion, Standard Deviation, Data Analysis Tool, Central Tendency and Dispersions using Data Analysis, Correlation, and regression, Histogram using Data Analysis, Moving Averages using Data AnalysisĪnyone serious about learning Excel for data analysisĬertificate of Completion for each of the 15 courses, 8 Projects You do not need to purchase each course separately. You get access to all the 15 courses, 8 Projects. Project - Case Paper using Excel VBA and Macros Project - Building Dynamic Heat Map in Microsoft Excel 2016 Pivot Table Case Study - Performance Ratings of Employees Pivot Table Project - Problem Handling and Automation Project - Microsoft Excel Simulations Trainingīusiness Intelligence using Microsoft Excel Microsoft Excel Charts and SmartArt Graphics Advanced Excel 2019: Essentials for the Real World
0 kommentar(er)
