ADVANCE EXCEL 2016

In this course, We teach you a Whole Excel Packet course with of Professional experts. We offer you to learn an Advance Excel 2016. 

1
Students
1
Chapters
1
Teachers
1
Passout Students

WhAT You WILL LEARN ???

Excel Professional 2016

  • Introduction
  • Mark sheet (Sum, Average, Max, Min, Len, Count, Upper, Lower function, Remark, Grade)
  • Chart Creation & It’s Options (Design & Layout)
  • Cells (Insert cell, Delete Cell,
  • Formatting (Rename the Sheet,
  • Change the column width,
  • Editing (Sorting, Custom Sort, filter
  • Alignment (Horizontal, Vertical),
  • Fill (Pattern Style) Pivot table,
  • Goal Seek, Protect Sheet
  • V lookup & H Lookup
  • Pivot Table, Filter
  • Conditional formatting



Form & Mis Report

  • Cell Referencing & Logical Functions
  • Data Validation, Pivot Tables & charts
  • Cell Reference, Simple Cell Referencing & Logical Functionsif Statements & nested

  • If Statements, if statement with logical function
  • AND, OR Income Tax Calculation
  • FUNCTIONS
  • Month, Year, Weekday, Day 360,  PPMT, PMT, IPM

  • LOOKUP FUNCTIONS
  • Lookup, VLOOKUP, HLOOKUP, Nested Lookup
  • LIST, SORT & FILTER
  • Insert list, create Custom list, Quick sort,
  •  Multilevel sort, Custom sort, Subtotals

* Student Reviews *

"it was a good experience that i was in Excellent Computer institute to learn Tally. They have helped clear all the concepts and offered practical insights regarding the role of Courses in the corporate industry. I highly recommend Excellent Computer Institute to all those who wish to give a boost to their careers.
Sana Parveen
Designer
"I am extremely with the course content, teaching method and style. The classes are fun which makes it easy to grasp new knowledge. My favorite were the Digital marketing classes on monetization methods which now help me make and grow my own blog."
Sayyed Shadma
Blogger
"I have made correct decision joining Excellent Computer institute to learn digital MS Office Professional.Excellent course structure, best faculty, daily revision on completed topics, training in a simple way so everyone can understand, they provide many ways to make money online and also career guidance. "
Shaikh Faris
Security Admin
"My practical experience with Staff is extremely Significant, from the perspective to learn MS Office and Tally with GST. Faculty is definitely an Expert and by my heart I really mean it. He has got plenty of persistence and also he gets the one step further to make you understand the Basics of the Topic."
Mohsin Ali
SEO Executive
Location

Gajanan Colony, Plot No.1, Lane No.1, Shop No.07, Behind Patel Shoe, Opp. Shiwaji Nagar Signal Highway, Govandi, Mimbai-400043.

Our hours

09:00 AM – 09.00 PM
Monday – Saturday

Contact us

Office No : +91 8655786515

Shahid Sir : +91 9004699657

Saif Sir : +91 9823300308

Email: Info@excellentcomputer.net