Advanced Excel Course - Best Excel training Institute of All levels

Recent News

Contact us

Sector-3 , Near Tagore Academy Public School Ballabgarh.
clearninginstitute@gmail.com
8595210430
Mon to Sat - 9:00 to 8:30
(Sunday Closed)

2023 Brochure

C Learning Institute is an Online and Offline Advance Excel Institute. We provide Top Class Advance Excel course training in our C learning Institute. If, You are searching for Best Institute for Advance Excel courses. Then You are in Right Place. Enroll now or Contact us for More information about our Advance Excel course. After the Course Completion of Advance Excel Training, Candidates will also get Certification from Our Reputed Institute. We at C Learning Institute Provide Job-Oriented training in Advance Excel courses. We have Advance Excel Experts who provide you with the best Advance Excel course training. We also provide study material, Live recordings of classes, Doubt Sessions, Punctuality, On time classes, etc. Our Advance Excel Course Content is different from other institutes. We offer 3 Days of a Free Real-time Demo Class of the Advance Excel Course.

Advance Excel Course Syllabus

01. Lets Start With Intro of Advance Excel?

02. In how many Chapter in Advanced Excel Course?

▪ Math Table
▪ Table Formatting
▪ Custom Data Insert for Using Rand Array Function
▪ VLOOKUP Function
▪ Dget Function
▪ HLOOKUP Function
▪ XLOOKUP Function
▪ Sales Report
▪ Count Function
▪ Sumif & Sumif’ s
▪ Macro Using for VB
▪ Income Tax with Profit & Loss
▪ Excel Tricks
▪ Pivot Sheet

03. Rand Function for using Custom Data Insert?

▪ RAND ()
▪ RANDBETWEEN ()
▪ RANDARRAY ()

04. LOOKUP’S FUNCTION

▪ VLOOKUP Function
▪ Dget Function
▪ HLOOKUP Function
▪ XLOOKUP Function

05. VLOOKUP FUNCTION

▪ VLOOKUP Function
▪ Condition VLOOKUP Function
▪ Range VLOOKUP
▪ VLOOKUP Function
▪ Condition VLOOKUP Function
▪ Range VLOOKUP
▪ Approximate VLOOKUP
▪ Exact Match VLOOKUP
▪ Dynamic VLOOKUP
▪ VLOOKUP + Match Function
▪ Remove Error with the help VLOOKUP
▪ Concatenation VLOOKUP
▪ Multipage VLOOKUP
▪ Multi Sheet VLOOKUP Approximate VLOOKUP
▪ Exact Match VLOOKUP
▪ Dynamic VLOOKUP
▪ VLOOKUP + Match Function
▪ Remove Error with the help VLOOKUP
▪ Concatenation VLOOKUP
▪ Multipage VLOOKUP
▪ Multi Sheet VLOOKUP

06. Dget Function

▪ DGET Function
▪ Dynamic DGET
▪ Concatenation DGET
▪ Dynamic DGET
▪ Remove Error with the help of DGET

07. HLOOKUP FUNCTION

▪ HLOOKUP Function
▪ HLOOKUP + Match Function.
▪ Dynamic HLOOKUP.
▪ Remove Error with the help of HLOOKUP.

08. XLOOKUP FUNCTION

▪ Simple XLOOLUP Function
▪ Condition XLOOKUP
▪ Dynamic XLOOKUP
▪ XLOOKUP + Match Function
▪ XLOOKUP + Add Columns
▪ Search Mode XLOOKUP
▪ Match Mode XLOOKUP
▪ XLOOKUP V/S HLOOKUP
▪ Two-Way LOOKUP
▪ Multiple Lookup Value

09.TEXT FUNCTION

Left, Right, MID
▪ Find, Search
▪ Concatenate
▪ Trim
▪ Lower, Upper and proper
▪ Replace

10. Excel Worksheet Management

▪ Inserting & Deleting row and column
▪ Moving & coping row and column
▪ Changing the width & height of the cell
▪ Hiding & unhiding row & column

11. Count Function

▪ COUNT
▪ COUNTA
▪ COUNTIF
▪ COUNTIFS
▪ COUNTBLANK

12. Working With Formula on MS Excel

▪ How to write formulas in Excel
▪ AutoSum
▪ SUMIFS
▪ SUMIFS
▪ MIN
▪ MAX
▪ Average

Our Features:

Demo Class

Computer Learning Institute provides you demo classes.

Certificate

Computer Learning Institute also provide you certificate after completion of your course.

Live Project training

Projects are also made in your course so that you can clear the concepts very well and further this project helps you in your job.

Recording Classes

Computer Learning Institute also provides you the recording of the topic so that you do not have any problem in practicing at home and you can do your practice easily.