Master manipulating and analyzing data on Excel with this instructor led training designed for business professionals. Practice on seamless Cloud labs while learning with our industry expert. Gain practical working knowledge of advanced formula, charts and tables. Learn to manage advanced workbook options, data formats and layouts. Be equipped to create powerful Excel workbooks that your organization needs.
Excel has become one of the prerequisites for almost all jobs in the analytics and consulting sector. Through this course, you’ll learn the advanced functions that are used by analysts on a day to day basis. You’ll also get accustomed to even more advanced stages of excel use like Macros which further come handy. Throughout the course, you’ll be given hands-on assignments and case-studies to put the theoretical knowledge to practical.
This Advanced Excel training course is designed for those who need to know how to use the more advanced formulas and functions in Microsoft Excel such as IF and VLOOKUP. Upon completion of the course, participants will be able to sort and filter data, create Pivot Tables and create and edit Macros
Basic exposure to MS Excel and/or spreadsheet applications is recommended.
Expert Faculty: Recognized practitioner experienced in related field interacting with students. Apart from guiding students on concepts and its implementation, he will pose challenges to learners to think through all the topics leading to better learning and increased retention.
Study Material: Students will be provided with study materials developed by NIIT. Also students can refer to reference materials to obtain answers to queries generated during the learning process.
Hands-on Learning: Apart from classroom hours, learners will be provided with dedicated machine room hours to practice their learnings on MS Excel software.
Topics covered will be: Advanced Excel Formulas, Data Presentation using Charts, Data Analysis using Pivot Tables and Pivot Charts, Graphic Objects, Streamlining workflow, Multiple User Collaboration, Structuring workbooks with XML, Automating business operations etc.
Advanced MS Excel 2016 Course will help you master your Excel skills and kick it up a notch. This course is designed to equip you with skills to create and work on MS Excel capabilities like:
New features of 2016 to help you optimize the platform to the best of its ability
Master advanced functions and formulas to perform calculations, data tools to manipulate data, and use Macros to automate routine tasks in Excel
Use advanced charts, graphs, and Pivot tables to perform advanced data analysis
Provide data protection solution using data security capabilities
There are as such no pre-requisites for enrolments except the eligibility criteria
At the end of this programme, the learner will be able to:
Sr. Design & Application ENGINEER
Training was organized well
The training was very Good
Good Knowledge + Examples covered a Lot of materials as well
Cards Portfolio Manager- Marketing Department
Trainer above expectation
AVP and Unit Head of General Administration & Logistics at BRAC Bank Limited
The training was experienced. Overall Good experience
Mahmoud Ahmed Sabry
I think this only thing I feel your way is very good
Trainer was good & shared lots of information with regards to the main areas of the Course
Sr. Manager-Technical Publications
Overall Good Experience
Project & Planning Specialist
It was nice to be part of course and good learning experience
Sales and Project Manager
Lecture is very helpful