We will discuss pictures and clip arts, excel charts and data tables, pie charts and line charts, etc. The next subject area in the training will be excel charts and smart-art graphics. The tutorial will be there to discuss shortcuts in excel, excel functions, vertical lookups, financial functions and average if function. Topics such as functions, pivot tables, evaluation, date and time format, statement and vlookup, future value function and so on. Training will be conducted on power excel.
Moving on with power pivot, we will get to know as to how to download and install it and organize and format data. The session will be covered on power pivot in Excel 2016 where we will discuss pivot charts, pivot tables, pie charts and slicers. Then we will resume the session on the pivot table and gain an understanding of other advanced concepts relating to it such as data summarization in the pivot table, pivot charts, printing, macros, power pivot, DAX, etc. We will then focus our energies on data and time functions in excel.Ī beginners’ session will be conducted for providing clarity on pivot tables, its features and its formatting. We will continue with the above session and learn about the remaining advanced concepts of excel such as shortcuts, excel controls, cell comments, named ranges and advanced formulas. Learners will go through intense training on MS Excel 2016 wherein they will learn about data functions, what-if-analysis, arrays, functions, text functions, pivot tables, advanced charts, etc. Here is a highlight of the coverage of the project. These link can be included in your resume/Linkedin profile to showcase your enhanced Excel skills Yes, you get verifiable certificates for each course with a unique link. You do not need to purchase each course separately.Īdvanced Excel Functions, Pivot Tables, Power Pivot, Excel Reports, Excel Charts and Graphs, Excel Simulations, VBA & Macros, Dashboard creationĪnyone serious about mastering Microsoft ExcelĬertificate of Completion for each of the 15 courses, 23 Projects You get access to all the 15 courses, 23 Projects. Pivot Table Case Study - Performance Ratings of Employees Pivot Table Project - Problem Handling and Automation Project - Case Paper using Excel VBA and Macros Project - Microsoft Excel Dashboard Training Project on VBA - Financial Modeling using VBA Project on VBA - Project Schedule Indexes
Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA Project on VBA Macros - Create a Login-Logout Tracker Project - Creating Interactive Dashboards using VBA Project on VBA - Project Management Tool with TreeView and ListView Project - Interactive Dashboards using Microsoft Excel VBA Project - Creating Sales Dashboard using Microsoft Excel Project - Advanced Sales Productivity Dashboard Project on Excel VBA - Attendance Register using Microsoft Excel VBA Project on VBA Macros - Automation using Loop Project - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express Project - Building Dynamic Heat Map in Microsoft Excel 2016 Project - Microsoft Excel Simulations Training Microsoft Excel Charts and SmartArt Graphicsįinancial Functions In Excel - Microsoft Excel 2013 Course
Advanced Excel 2016 - Some Important Features