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

Book Your Seat Now for Advanced Excel Course in Kolkata. To Book Call : 9614142256 or Apply Online

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)

Tally Accounts Course
CIT

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

!! Book Now !! Course Fees = Rs. 9,000/-

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 :

Ratings : 5 star
5/5

Student Progress:

Skill Developed 85%
Jobs 65%
Freelancing 78%
StartUp 92%

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.

In-Class Timing

Flexibilities :

  • Extra classes in case you miss few classes
  • Doubt Clarence classes
  • Practicals & assessments
  • Job and interview scheduling

Book Your Seat Now !!