Courses

Advance Excel

Microsoft Excel is widely used by businesses all over the world, and its extensive capabilities have made it a essential skill for people to learn. Our course aims to impart the basic and advanced techniques of Excel to acquaint users with the latest technology as well as lessen their work load.

If you have only explored Excel on a surface level, you may be under the impression that it is only software for charts and tables. However, Excel is much more than that, and if you learn to use it to its full potential, you will be amazed at all the different ways it can be used to your benefit.

There are several Excel skills that are considered essential for business success. Learning how to use these features and techniques can give you a significant advantage in the job market, as well as in your career growth. If you're looking to get ahead in almost any sector, learning Excel is an indispensable step.

Course Outline
  • Introduction to Excel.
  • Cell Referencing outside of the WorkBook, Subtotals, Protection of Cell, Sheet, WorkBook, Excel File.
  • Compute and Analyze data with certain Functions.
  • Extract and Compute data with certain Functions.
  • Logical, String, Financial, Information and Numeric Functions
  • Predicting trend with Statistical functions.
  • Searching Data with Lookup, Vlookup, Hlookup
  • Manipulating Date and Time using Functions
  • Predicting trend and Dsum Functions
  • What If Functions and Data Importation
  • Pivot Tables and Charts
  • Power Query Function
  • Filtering, Sorting & Subtotalling Lists
  • Macro and Printing Excel Data
Course Duration

2 months (3 days/week - 2 hrs/class)

Course Fees

Rs 4000 + 18% GST (Flexible Payment Options available)

Chat with us

Why Train with Us

Experience

21 years experience in IT Education and making sttudents Job ready.

Quality

We have an excellent team of highly skilled and experienced trainers.

Curriculum

Our course curriculum is in tune with the industry requirements.

Placement

We offer 100% Placement Assistance along with Soft Skills training.

Course Brochure
Get Brochure
Career Options
Analytics Specialist
Backoffice Executive
Business Analyst
Data Analyst
MIS Executive
Research Analyst
Get in touch

Quick Query

Advance Excel


Reviews

I have taken admission in Diploma in Computerized Financial Accounting at Tally Institute of Learning, Baguiati. It is a great place to develop your expertise for course that are related to accounting. Thank you.

Debayan Biswas

One of the reason I choose tally institute of learning at baguiati is because of their good reputation and the fact they provide job placements and target certification from tally Bangalore

Faria Sultana

Sign Up for Special Offer on Course Fee

Want to get discount for your course from us? Leave your email and sign up for our newsletter to avail special offer on course fees.