Advanced Excel Training
Advanced Excel Course:
Microsoft Excel is the most basic yet powerful tool to manage and analyze various types of Data. This training on Advanced Excel covers in-depth lessons on how to use various Excel formulas, Tables, and Charts for managing small to large scale business processes. The corporate training on Excel covers the not so obvious features of Excel that are used in Data analysis and data visualization. Basic Excel knowledge is the prerequisite of this Advanced Excel course. This Excel training helps your team increase productivity and convert manual business processes into an automated one with intuitive visualization. This Excel course takes a completely hands-on approach. Corporate training in Excel is customized based on the requirement of the clients. This Excel training is delivered by our experts at Bangalore as well at client locations across India and South-East Asia in cities such as Bangalore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Singapore, Hong Kong and many more.
Advanced Excel Course Curriculum
Cell styles
Formatting Cells - Working with data in Excel
Excel Conditional Formatting
Fast scrolling
Use multiple screens
Drop-down menus in Excel
Group rows and columns
Find & Replace
Create easily printable documents
The ROUND Function
TEXT
The LEN Function
Using REPLACE And LEN
Using IF
Using LEFT, RIGHT & MID
Using UPPER, LOWER & PROPER
Using VALUE
Drop Down
Using COUNTIF & COUNTA
Relative & Absolute
The PMT Function
More On Macros
Macro Notes
Creating a VLOOKUP Invoice
SUBTOTAL
Introduction To Pivot Tables
Pivot Charts
FV and PV
Net Present Value (NPV)
PMT
Date functions
Frequently Asked Questions
We provide classroom-based as well as online training. Since this is a hand-on training so batches generally does not contain more than 4 people.
We will provide web services specific study material as the course progresses. You will have lifetime access to all the code and basic settings needed for theseAdvanced Excel training through our github account and the study material that we share with you. You can use that for quick reference.
Feel free to drop a mail to us at [email protected] and we will get back to you at the earliest for your queries onAdvanced Excel course
We have tie ups with various companies and placement organizations to whom we connect our learners. EachAdvanced Excel training ends with career consulting
Minimum 2-3 projects of industry standards onAdvanced Excel will be provided
Yes, we provide our own course completion certificate to all students. EachAdvanced Excel training in bangalore ends with training and project completion certificate
You can pay by card (debit/credit), cash, cheque and net-banking. You can pay in two installments
We take immense pride to provide post training career consulting forAdvanced Excel training
Recommended Courses
|
ELK stack |
|
Elasticsearch |
|
Hashicorp Packer |
|
Helm |
More Courses
|
Mastering Git |
|
Rust |
|
Certified Ethical Hacking |
|
Chatbots using Deep Learning |
|
Agile Scrum Master |
|
Angular 8 |
|
SAP Foundation |
|
Certified Ethical Hacking |
|
Google Cloud Platform |
Read More
Recommended Courses
JavaScript
ELK stack
Elasticsearch
Feedback