Certification in Advanced Excel

  • English
  • (921 Rating)

About This Course

Advanced Excel enables you to produce graphs and tables, use spreadsheets efficiently, perform calculations and implement automation to process large volumes of data. This course is specially designed for students and working professionals, who want to excel in the industry or job profiles which consist of analyzing and interacting with large amounts of data. Advanced Excel is commonly used in all big companies and MNCs on day-to-day basis.

What You’ll Learn?
  • Lookup/Reference functions
  • Statistical functions
  • Formula-based formatting
  • Date & Time functions
  • Logical operators
  • Dynamic Array formulas
  • Text functions
  • Indirect & Hyperlink

Requirements

  • Enrolling candidates should have Certification in MS Office or Certification in Computer Application.
  • If a candidate is not certified, he/she should have at least 6 months of working experience in MS Excel.

Target Audience

  • Anyone who wants to take his/her MS Excel skills from Basic to Advanced.

  • Links and External References
  • 3-D References
  • Consolidate Data
  • Lookup Functions
  • VLOOKUP & HLOOKUP
  • INDEX & MATCH
  • Excels Text Based Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Collaborate Workbook
  • Protect Worksheets and Workbooks
  • Automating Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data & Errors
  • Macros Introduction (Basic)
  • Automating Daily Tasks
  • Create Sparklines
  • Map Data
  • Forecasting Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Goal Seek Feature
  • Forecasting Data Trends
  • Working With Charts
  • Column Chart Type
  • Bar Chart Type
  • Line Chart Type
  • Pie Chart Type
  • Area Chart Type
  • XY (Scatter) Chart Type
  • Stock Chart
  • Surface Chart Type
  • Doughnut Chart Type
  • Bubble Chart Type
  • Radar Chart Type

Student Feedback

4.90 average rating based on 921

4.9
(921 Review)
5
831
4
31
3
25
2
23
1
11
Anjali Malhotra
Oct 24, 2022

I am a professional excel user and I can confidently say that the Institute of Computing and Technoscience is one of the most advanced excel courses. It has helped me immensely with my skillset as well as my career.

Ankit Joshi
Oct 08, 2022

I attended the Institute of Computing and Technoscience's advanced excel course and it was a great experience. They did a thorough and in-depth training on all the different features of excel and I learned a lot from them. Highly recommend this course for anyone who wants to learn about microsoft excel!

Ankush Kapadia
Sep 21, 2022

I've been taking the Advanced Excel course for 15 days now and I'm really enjoying it. The professors are great, they're always available to answer any questions that we have, and they are very knowledgeable about the subject. The course is also very well organized and structured so that you can easily follow along with each lesson.

Courses

Course Includes:

  • Duration: 1 Month
  • Enrolled: 1083 students
  • Language: English
  • Certificate: Yes
Enquire Now