Affordable Course Fees + Best Education = CIT
Advanced Excel Course
in Kolkata
One of the Best Accounts & Taxation training in kolkata for all of you
Low Course Fees | Life Time Support | Real Life Case Studies | 100% Job & Income Opportunity
Advanced Excel Course
We Provide Affordable Advanced Excel Course Fees for all
Affordable Course Fees + Best Education = CIT
48 Hrs (24CL)
Course Duration
Rs. 9,000/-
10+2 (pass)
Course Eligibility
51+
Course Module
Online Support
Book, Videos & Lifetime Support
Why Should You Choose Advanced Excel ?
Advanced Excel Course is a great things which can help you to achieve your career goal or a business goal.
Advanced excel course helps in office work.Advanced Excel course also enables the Professionals to be more efficient. The advance features taught in this course is an office environment with maximum efficiency.
In this path you can build your own career in a good way (job or freelancing for both)


Why CIT is the Best Option for your Education ?
Being A Training Institute In Kolkata, We Offered Best Quality Education & Support, So That Everyone Can Grow And Achieve Their Goals Easily.
10+ Years of Experience
Updated, Experienced & Professional Teachers
7 Days Opened with Flexible Class Timing
Live Projects & Workshop Facilities
Lifetime Support & Hand holding
Affordable Course Fees + Best Education = CIT
100% Income Opportunity | 100% Job Guaranteed
Course Module of Advanced Excel Course :
Our Advanced Excel Course Curriculum or Course Module is designed for all category of students, business man, Accountant and any other persons who wants to learn that.
Advanced excel course helps in office work.Advanced Excel course also enables the Professionals to be more efficient. The advance features taught in this course is an office environment with maximum efficiency.
- Intro Excel
- Navigation and basic spreadsheet concepts
- Auto Complete Option
- Custom List & Fill Series
- Different methods of selecting Range
- Shortcuts Key
- Special Formats – Numbers & Dates
- Different File Format (XLS, XLSX, XLSM,PDF)
- Sum, Average, Max,Min, Count, Counta
- Absolute, Mixed and Relative Referencing
- Change worksheet tab color
- Rename a worksheet
- Change worksheet order
- Insert and delete columns or rows
- Change workbook themes
- Adjust row height and column width
- Insert headers and footers
- Hide or unhide worksheets
- Hide or unhide columns and rows
- Customize the Quick Access toolbar
- Modify document properties
- Display formulas
- Formatting Cells with Number formats,
- Font formats
- Alignment
- Borders etc
- Setting Up Print Area
- Customizing Headers & Footers
- Designing the structure of a template
- Print Titles –Repeat Rows / Columns
- Customizing the Ribbon
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
- Insert, Delete & Rename Sheets
- Copy and Move Sheets
- Worksheet Groups
- Using the Clipboard Group
- Using Paste Special
- Basic IF statement
- Nested IF statements
- Combining IF with AND, OR, NOT
- IFERROR
- Count, Counta, Countblank
- Countif, Sumif, Averageif
- Countifs, Sumifs, Averageifs
- Upper, Lower, Proper
- Left, Mid, Right
- Trim, Len, Exact
- Concatenate
- Find, Substitute
- Today, Now
- Day, Month, Year
- Date, Date if, DateAdd
- EOMonth, Weekday
- Filtering on Text, Numbers & Colors
- Sorting Options
- Advanced Filters on 15-20 different criteria(s)
- Various Charts – Bar Charts / Pie Charts / Line Charts
- Combo Chart – Columns & Line
- Using SLICERS, Filter data with Slicers
- Manage Primary and Secondary Axis
- Create & modify charts
- Different Chart Types
- Adding data to existing chart
- Secondary Axis Chart
- Vlookup / HLookup
- VLOOKUP – Approximate Match
- VLOOKUP – Exact Match
- VLOOKUP – Match
- VLOOKUP – & Indirect
- Index and Match
- Creating Smooth User Interface Using Lookup
- Nested VLookup
- Reverse Lookup using Choose Function
- Worksheet linking using Indirect
- Vlookup with Helper Column
- PivotTable layout
- Rearranging data
- Filtering a report
- Adding fields
- Field settings
- Refreshing data
- Formatting a PivotTable
- Showing detail
- Create a calculated field
- Advanced data field settings
- Creating a PivotChart
- Creating PivotChart Reports from scratch
- Adding fields to a PivotChart
- What are the Array Formulas, Use of the Array Formulas?
- Basic Examples of Arrays (Using ctrl+shift+enter).
- Array with if, len and mid functions formulas.
- Array with Lookup functions.
- Advanced Use of formulas with Array
- Custom & Multiple Sort
- Subtotals
- Advanced Filtering
- Create automatic Subtotals
- Text to Columns
- Use the Group and Outline feature
- Number, Date & Time Validation
- Text and List Validation
- Custom validations based on formula for a cell
- Dynamic Dropdown List Creation using Data Validation – Dependency List
- Limiting the range of values
- Drop down lists
- Error alerts
- Goal Seek
- Scenario Analysis
- Data Tables (PMT Function)
- Solver Tool
- Data Table
- Tracing precedent & dependants
- Display/Hide formulas
- Error Checking
- Evaluate Formulas
- Fixing Formulas Errors
- Highlight & Remove Duplicate
- Compare Reports
- Converting Text to Number/Date
- Find & Replace
- Go To (Special) Options
- Slicer
- Spark Lines
- Protecting cells/Range
- Hide Formulas
- Protecting Worksheet
- Protecting Workbook
Introduction to MySQL. Installation of MySQL server.
Writing Basic SQL
Topics:
- Basic SELECT Statement
- Selecting All Columns
- Selecting Specific Columns
- Writing SQL Statements
- Column Heading Defaults
- Arithmetic Expressions
- Using Arithmetic Operators
- Defning a Null
- Defning a Column Alias
- Duplicate Rows
- Eliminating Duplicate Rows
- Delete database
- Manage Database
- What is VBA or Macros?
- What it can be used for
- Activate the Developer Tab
- Macro Security Settings
- Naming & Recording a simple Macro
- Recording using Relative & Absolute References
- Editing a Recorded Macro in the VBA Editor
- Saving the File as Macro Enabled Workbook
- Running a Macro using a Toolbar
- Assigning a Macro to a Button or Drawn Object on a Sheet
- Assigning a Macro to a Quick Access Toolbar
- Creating a Short-Cut Key to Run a Macro
- Opening and Closing the VBA Editor
- Using the Project Explorer
- Inserting a Module
- Working with the Properties and Code Windows
- Module, Procedures, Functions
- Object, Property, Methods
- Application, Workbook, Worksheet, Range
- Creating a Sub Routine
- Understanding the code structure
- Commenting Statements
- Calling procedures
- Creating an Interactive Message Box
- Creating a Custom Input Box
- Advantage of Application.Inputbox
- Simple IF (IF…THEN)
- IF Else (IF…THEN…ELSE)
- IF & Logical Operators (IF AND/OR…THEN)
- Nested IF (IF…THEN…ELSEIF)
- SELECT CASE
- CASE ELSE
- Declaring a Variable’s Data Type
- Working with Object Variables
- Option Explicit
- Constants
- For Loop (FOR…NEXT)
- For Each Loop (FOR EACH…NEXT)
- Do Until Loop (DO UNTIL…LOOP)
- Do While Loop (DO WHILE…LOOP)
- Referring to a Range
- Entering Values and Formulas
- Formatting Cells and Values
- With…Statement
Using - CurrentRegion Property
- Accessing a range using UsedRange Property
- The End Property
- Offset
- Select Special Cells
- Sort & Filter
- Rows and Columns (Insert/Delete/Autofit/Hide)
- Activate Worksheet
- Add/Delete/Rename a Worksheet
- Copy/Move a Worksheet
- Working with Group Worksheets
- Hide/ Protect Worksheets
- Open/Close Workbook
- Save/Protect Workbook
- This Workbook
- Screen updating/ Display Alerts
- Cut copy Mode/ Username/ Speech
- Using Excel Worksheet Functions in VBA
- VBA Function
- Creating User-Define Functions
- Using Range and declaring variables in User defined functions
- Creating a custom form
- Adding text boxes to forms
- Moving controls
- Adding label controls to forms
- Changing text box and label properties
- Combo box, option, command
- Sequences of Events
- Events Associated with Worksheets
- Events Associated with a Workbook
- Understanding different Error Types
- Debugging: Stepping through Code and Breakpoint
- On Error Goto Statement
- Resume Next Syntax
Extra Course Features by CIT:
Course Materials: Students Will Get Course Documents, Books, E-boks & Online Support.
Course Rating :
Student Progress:
Course Enrollment :
Future Scope (Job & Income)
TAX Consultant (Assistance)
Course Required : Tally GST E-Filing + IT E-Filing
TAX Consultant (Professional)
Course Required : Tally GST E-Filing (Expert) + IT Manual E-Filing
TAX Consultant (Senior)
Course Required : Tally GST E-Filing (Expert) + IT Manual E-Filing
GST Consultant (Assistance)
Course Required : Tally GST E-Filing
GST Consultant (Professional)
Course Required : GST with E-Filing
GST Consultant (Senior)
Course Required : GST with E-Filing + ROC
Accountant (Assistance)
Course Required : Tally GST E-Filing
Accountant (Professional)
Course Required : Tally GST E-Filing (Expert)
Accountant (Senior)
Course Required : Tally GST E-Filing (Expert)
Office Clerk / Billing
Course Required : Tally GST E-Filing
Data Entry Operator (Purchase & Sell)
Course Required : Tally GST E-Filing
Job Costing / Service Costing
Course Required : Tally GST E-Filing (Expert)
Note :
* Yes! We (CIT) provide 100% Job Assurance for all Job Seekers. We also provide Business Partnership with our Eligible Students to grow their future with Us.
** We (CIT) provide Practical Files after Examination to all of our Eligible Students.
Teachers
10+ Years of Experience in Tally, Accounts, GST, E-Filing, IT, ROC, Business Growth, Advanced Excel and many more.






Course Available in Branches :
In-Class Timing
Flexibilities :
- Extra classes in case you miss few classes
- Doubt Clarence classes
- Practicals & assessments
- Job and interview scheduling