Learn Advanced Excel Training In Chennai At GREENS TECHNOLOGY – No Advanced Excel Training Institute In Chennai. Call @ 89399 25577 For More Details. Register today for learning basic Advanced Excel Training to go for advanced Advanced Excel Training in Chennai.
Advanced Excel Training in OMR Chennai
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.
About The Trainer
Karthik has delivered customised training courses for many of the world’s best-known brands – and would be happy to consider delivering training for your business, too.
We will cover all major business and technology trends, including Big Data, Machine Learning, the Internet of Things (IoT), Artificial Intelligence (AI), Augmented Reality, Blockchains, Virtual Reality (VR) and
robotics, the sharing economy, the rise of platform business models, crowd sourcing, and the ‘as a service’ business model.
Flexible Timings / Weekend classes Available.
Talk to the Trainer @ +91-8939915577
Advanced Excel Training Course Content
Course Description
- Advanced Excel 2016 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions, Logical functions, Formula Auditing, Data validation, What-if Analysis, Pivot tables, Pivot charts, Advanced Filters, Sparklines, Macros, and Data Security.
After the completion of this training, you will be able to:
- Learn new features in MS Excel 2016 and implement advanced excel concepts
- Customize Quick Access toolbar and apply conditional formatting to personalize the sheet
- Apply advanced functions and formulas to enhance Excel’s productivity
- Perform What-if analysis command to experiment with data
- Apply data validation to restrict data input
- Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
- Use Macros to automate routine tasks in Excel
- Integrate passwords to protect Excel files
- Use Excel shortcuts wherever applicable
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
The following professionals can take up this VBA in Excel course:
- Data Analyst
- Financial Analyst
- Advanced Excel User
- Fresher seeking jobs in Analytics/Consulting job streams
- There are no prerequisites for this course. However, a basic understanding of Microsoft Excel will be supportive.
Course Curriculum
Learning Objectives: In this module, you will get introduced to new features in MS Excel 2016. It also discusses advanced MS Excel 2016 concepts.
Topics:
- What’s New in MS Excel 2016
- Advanced Concepts
Skills:
- Introduction to new features in MS Excel 2016
- Familiarization to Advanced MS Excel 2016 concepts
Hands-On:
- Hands-on on basic excel functions to get you started
- How to access shortcuts in excel
Learning Objectives: In this module, you will learn about custom and conditional formatting. This module covers topics on customizing Quick Access Toolbar. It also explains various conditional formatting available in MS Excel 2016.
Skills:
- Customization of Quick Access Toolbar
- Application of Conditional Formatting
Topics:
- Customizing Quick Access Toolbar
- Conditional Formatting
Hands-On:
- Customizing Quick Access Toolbar
- Conditional Formatting
Learning Objectives: In this module, you will learn how to apply advanced functions and formulas. This module covers topics on advanced logical, text, lookup and reference functions. It also discusses how to trace errors and evaluate formulas.
Skills:
- Application of advanced functions and formulas
- Tracing errors and evaluating formulas
Topics:
- Logical Functions
- Text Functions
- Lookup and Reference Functions
- Formula Auditing
- Randbetween
- Name Ranges and application
Hands-On:
- Using logical functions, lookups in excel
Learning Objectives: In this module, you will learn how to work with advanced data tools. This module covers topics on advanced data tools like converting text to columns and data validation. It also discusses how to implement what-if tools.
Skills:
- Understand advanced data tools
Topics:
- Text to Column
- Data Validation
- What-If Analysis
- Duplicate Removal
- Data Sanitation through excel – Sorting, Filtering
Hands-On:
- Data Validation through excel using the given assignment
Learning Objectives: In this module, you will learn how to use pivot tables and charts to analyze data. This module covers topics on pivot tables, pivot chart, sparklines. It also demonstrates the application of advanced filters.
Skills:
- Implementation of Pivot tables and charts
- Application of advanced filters
Topics:
- Data analysis using normal charts, formatting of charts, secondary axis use, scatter plots
- Data analysis using a Pivot table and pivot charts, sparklines
- Running Regression in excel, ANOVA, etc.
- Cover basic stats through excel – Functions like correlation, stddev, average, regression functions
Hands-On:
- Data analysis through excel using Pivots, charts, regression
Learning Objectives: In this module, you will be introduced to recording and using Macros. This module covers topics on how to record and run Macros. It also discusses how to edit Marcos.
Skills:
- Comprehension of Macros
- Application of Macros
Topics:
- Introduction to Macros
- Record Macros
- Run Macros
- Edit Macros
Hands-On:
- Recording, editing and running Macros
Learning Objectives: In this module, you will learn how to restrict and protect your data. This module covers topics on protecting cells, sheets, and workbooks. It also discusses how to assign edit range function.
Skills:
- Protection of Cells, Sheets, and Workbook
- Customization of ranges for individual users
Topics:
- Protect Cells
- Protect Sheet
- Protect Workbook
- Protect Ranges
Hands-On:
- Protecting cells, sheets, workbook and ranges on the workbook created in Module 7
Learning Objectives: This is a training module to get you ready for the certification project
Skills:
- Perform and implement advanced tools and techniques in Excel 2016
Topics:
- Implement Excel 2016 abilities and techniques
Student Testimonials
“
Best Oracle Training
I did my oracle training in greens technology, Chennai. Now I got placed in Virtusa. I really thank Dinesh for his involvement in my training. His way of teaching is really awesome. I never saw such quality teaching and placements were so fast.
Varsha
Software Engineer Virtusa
“
Best Selenium Training in Chennai
Dear Velmurugan, Selenium training has been outstanding. You have covered every aspect of the Selenium which would boost the confidence of the attendee to dive into greater depths and face the interviews subsequently. I feel confident after attending the selenium course.
Vivek Nathan
Software Engineer Hexaware
“
Best AWS Training institute
Karthik! I am really delighted about the AWS course and i am surprised to see the depth of your knowledge in all aspects of the Cloud. I see that many Architects with over 15+ yrs experience doesn’t have the knowledge that you have.I really enjoyed your sessions, definitely look forward to learn more from you in the future.
Dhanush Kumar
Cloud Solution Engineer CSC
“
DevOps Training in Chennai
I want to thank you for your incredible efforts and sharing your vast knowledge. I am feeling lucky to have attended your great batch. You are awesome Gani, I am not sure when i will be able to attain 50% of your knowledge but i got a lot inspired by you.
Sujatha
DevOps Engineer G2 Solutions
Etiam magna arcu, ullamcorper ut pulvinar et, ornare sit amet ligula. Aliquam vitae bibendum lorem. Cras id dui lectus. Pellentesque nec felis tristique urna lacinia sollicitudin ac ac ex. Maecenas mattis faucibus condimentum. Curabitur imperdiet felis at est posuere bibendum. Sed quis nulla tellus.
ADDRESS
63739 street lorem ipsum City, Country
PHONE
+12 (0) 345 678 9
info@company.com