A PHP Error was encountered
Severity: Notice
Message: Undefined index: geoplugin_countryName
Filename: include/top_header.php
Line Number: 39
Backtrace:
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/include/top_header.php
Line: 39
Function: _error_handler
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/CourseDetails.php
Line: 12
Function: include
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/controllers/Hachion.php
Line: 510
Function: view
File: /home/laxmiveena/public_html/test.hachtechnologies.com/index.php
Line: 315
Function: require_once
+1-732-485-2499 | A PHP Error was encountered
Severity: Notice
Message: Undefined index: geoplugin_countryName
Filename: include/top_header.php
Line Number: 94
Backtrace:
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/include/top_header.php
Line: 94
Function: _error_handler
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/CourseDetails.php
Line: 12
Function: include
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/controllers/Hachion.php
Line: 510
Function: view
File: /home/laxmiveena/public_html/test.hachtechnologies.com/index.php
Line: 315
Function: require_once
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: recent_country
Filename: include/top_header.php
Line Number: 111
Backtrace:
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/include/top_header.php
Line: 111
Function: _error_handler
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/CourseDetails.php
Line: 12
Function: include
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/controllers/Hachion.php
Line: 510
Function: view
File: /home/laxmiveena/public_html/test.hachtechnologies.com/index.php
Line: 315
Function: require_once
A PHP Error was encountered
Severity: Notice
Message: Undefined index: geoplugin_countryName
Filename: views/CourseDetails.php
Line Number: 41
Backtrace:
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/CourseDetails.php
Line: 41
Function: _error_handler
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/controllers/Hachion.php
Line: 510
Function: view
File: /home/laxmiveena/public_html/test.hachtechnologies.com/index.php
Line: 315
Function: require_once
Course Description
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.
Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.
Course Schedule
Upcoming course schedule will be updated soon
Choose the best training mode which suits to your requirement
Live online training
- Live interactive online training
- Daily Assignments and Lab exercises
- Resume and certification guidance
- Mock interview and live project assistance
- Resume marketing and job assistance
Mentoring mode training
- Recorded videos and Trainer support
- Topic wise assignments and lab exercises
- Resume and certification guidance
- Mock interview and live project assistance
- Resume marketing and job assistance
Live online training and internship
- Recorded videos and Trainer support
- Daily assignments and lab exercises
- Resume and certification guidance
- Project internship and certification
- Resume marketing and job assistance
Course Content
- In this module, you will get introduced to new features in MS Excel 2016. It also discusses advanced MS Excel 2016 concepts.
- What’s New in MS Excel 2016
- Advanced Concepts
- Introduction to new features in MS Excel 2016
- Familiarization to Advanced MS Excel 2016 concepts
- Hands-on on basic excel functions to get you started
- How to access shortcuts in excel
- 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.
- Customization of Quick Access Toolbar
- Application of Conditional Formatting
- Customizing Quick Access Toolbar
- Conditional Formatting
- Customizing Quick Access Toolbar
- Conditional Formatting
- 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.
- Application of advanced functions and formulas
- Tracing errors and evaluating formulas
- Logical Functions
- Text Functions
- Lookup and Reference Functions
- Formula Auditing
- Randbetween
- Name Ranges and application
- Using logical functions, lookups in excel
- 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.
- Understand advanced data tools
- Text to Column
- Data Validation
- What-If Analysis
- Duplicate Removal
- Data Sanitation through excel - Sorting, Filtering
- Data Validation through excel using the given assignment
- 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.
- Implementation of Pivot tables and charts
- Application of advanced filters
- 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
- Data analysis through excel using Pivots, charts, regression
- 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.
- Comprehension of Macros
- Application of Macros
- Introduction to Macros
- Record Macros
- Run Macros
- Edit Macros
- Recording, editing and running Macros
- 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.
- Protection of Cells, Sheets, and Workbook
- Customization of ranges for individual users
- Protect Cells
- Protect Sheet
- Protect Workbook
- Protect Ranges
- Protecting cells, sheets, workbook and ranges on the workbook created in Module 7
- This is a training module to get you ready for the certification project
- Perform and implement advanced tools and techniques in Excel 2016
- Implement Excel 2016 abilities and techniques
Advanced Excel Training Training FAQs
Related Courses
Grab a chance to work with one of my reputed partner in IT Industry
A PHP Error was encountered
Severity: Notice
Message: Undefined index: geoplugin_countryName
Filename: include/footer.php
Line Number: 12
Backtrace:
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/include/footer.php
Line: 12
Function: _error_handler
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/views/CourseDetails.php
Line: 2276
Function: include
File: /home/laxmiveena/public_html/test.hachtechnologies.com/application/controllers/Hachion.php
Line: 510
Function: view
File: /home/laxmiveena/public_html/test.hachtechnologies.com/index.php
Line: 315
Function: require_once
