Microsoft Office Excel

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It structures calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications, which makes work easy for employees in companies.

Microsoft Excel is in form of grid, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.

In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It also contains different formula function like maths, logical, text, date-Time, Financial etc…….

Short cut keys for Excel:


Alt key press:

To display a tab on the Ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab’s buttons appear. Then, press the key for the button you want.

To get to the Ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.

To hide the Ribbon so you have more room to work, press Ctrl+F1. Repeat to display the Ribbon again.

Go to the access keys for the Ribbon

To go directly to a tab on the Ribbon, press one of the following access keys:

To do this Press
Open the Tell me box on the Ribbon and type a search term for assistance or Help content. Alt+Q, and then enter the search term.
Open the File page and use Backstage view. Alt+F
Open the Home tab and format text and numbers and use the Find tool. Alt+H
Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. Alt+N
Open the Page Layout tab and work with themes, page setup, scale, and alignment. Alt+P
Open the Formulas tab and insert, trace, and customize functions and calculations. Alt+M
Open the Data tab and connect to, sort, filter, analyze, and work with data. Alt+A
Open the Review tab and check spelling, add comments, and protect sheets and workbooks. Alt+R
Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. Alt+W

If you like this post then please share and like this post.

Visit us @

Call us @ 98256 18292.

To Learn More About Computer Course


Learn Computer – TCCI Coaching

TCCI-Tririd computer coaching institute offers  various programing courses like C,C++,HTML, CSS, Data Structure, Database Management System,Compiler Design,Python,Java,.Net ., Microsoft Word, Microsoft Excel, Power Point …..etc…….all computer course for BCA, MCA, BSC-MSc. IT, Diploma-Degree Engineering, school-students (any standard), and any person are taught at the institute by highly qualified and experienced faculties.

Computer Course In Ahmedabad.png

Contact us @ 98256 18292

Mail to

Get information from


Java Course-TCCI Coaching

Java is object oriented.Java Jcan run on many different operating systems. This makes Java platform independent. Java does this by making the Javacompiler turn code into Java bytecode instead of machine code. This means that when the program is executed, the Java Virtual Machine interprets the bytecode and translates it into machine code.

Java Course In Ahmedabad.jpg

  • It should be simple, object-oriented, distributed and easy to learn.
  • It should be robust and secure.

For More Information About Java Course, Java Course In Ahmedabad, Computer Course, Basic Computer Course, Computer Class

Contact us @ 98256 18292

Mail to

Get information from


HTML Course – TCCI Coaching

TCCI-Tririd computer coaching institute offers various computer courses to Degree, Diploma ,MCA,BCA,PGDCA,M.A.C.I.T., etc………. trough different learning method, which include theory with practical both.

HTML course In Ahmedabad.jpg

HTML is a mark-up language for describing web documents (web pages).TCCI provides best teaching to students in all programming language like c, c++,html, java, .net,dbms,data structure,word,excel,powerpoint,python etc….

To learn more about HTML Course, HTML Course In Ahmedabad, Basic Computer Course, Basic Computer Course In Ahmedabad

Contact us @ 98256 18292

Mail to

Get information from


Final Year Project Training – TCCI Coaching

TCCI-Tririd computer coaching institute provides an opportunity to Boos up student’s carrier successful in IT field through providing live project training in various Technologies. As the demand for new technology increases, so do career opportunities for professionals with technical and managerial expertise in computers.

Project Training.jpg

We provide Final year project training to BCA, MCA, Diploma, B.Sc. (IT), M.Sc. (IT) and Engineering students which are running around the globe with our reputed clients.

To Learn More About Live Project Training, Live project training in Ahmedabad, Computer Course

Contact us @ 98256 18292

Mail to

Get information from


College Computer Courses – TCCI Coaching

We are one of the most established names in the field of computer programming and training and we are looking to spread our services and refine and polish them even furtherThe stupendous achievements that we have made through student’s successful carrierso far have given us the incentive to reach out to all those students who have the talent to become the big names in the IT sector and make large contributions in the field of technology.

Computer Course.png

Learn following college computer course at TCCI:

C,C++,Java,Data Structure, Database Management System,.Net technology, Python, Compiler Design, Microsoft Word, Microsoft Excel, Power Point, HTML

To learn more about Computer Class, Computer Courses, Computer Classes, TCCI

Contact us @ 98256 18292

Mail to

Get information from


User Defined Function in C

What is User Defined Function?

A User Defined Function is a block of code developed by user to perform specific task.

Using user Defined Function we can divide a complex problem into smaller modules. So we can decrease complexity and lengthy.

C allows programmer to define functions according to their need. These functions are known as user-defined functions. For example:

Suppose, a program which includes addition, subtraction, division and multiplication of two numbers in same program. You can create user defined functions for each operation individually to solve this problem:

For example,

#include <stdio.h>

#include <conio.h>

Void add(int, int); // function prototype

Void sub (int, int); // function prototype

Void mul (int, int); // function prototype

Void div (int, int); // function prototype

void main ()



            printf(“enter the value of a and b);

            scanf(“%d %d”,&a,&b);

            clrscr ();

            add (a,b);

            sub (a,b);

            mul (a,b);

            div (a,b);


Void add (int x,int y)


            Int c;




void sub ()


Int c;


            printf (“sub=%d”,c)


Void mul ()


            int c;

            C=x *y;

            printf (“%d”, c)


Void div ()


            int c;




User Defined Function has 3 sections:

Function Prototype

Function Call

Function Definition

Function prototype:

Syntax of function prototype :

returnTypefunctionName(type1 argument1, type2 argument2,…);

A function prototype is simply the declaration of a function that specifies function’s name, parameters and return type. It doesn’t contain function body. Parameters names are optional.

Function Call:

Syntax of Function Call:

Function name (argument1, argument2);

We can use only value also. i. e. add (5, 6);

Compiler starts compilation from main () function, so to jump control from main to user defined function, have to use function call. When this function call executes, control jumps from main to that particular user defined function.

Function Definition:

Syntax of Function Definition:

returnTypefunctionName(type1 argument1, type2 argument2,…)


            Body of function


When a function is called, the control of the program is transferred to the function definition. And, the compiler starts executing the codes inside the body of a function.

Passing arguments to a function:

In programming, argument refers to the variable passed to the function. In the above example, two variables a and b are passed during function call.

The parameters x and y accepts the passed arguments in the function definition. These arguments are called formal parameters of the function.

The type of arguments passed to a function and the formal parameters must match, otherwise the compiler throws error.

Return Statement :

The return statement terminates the execution of a function and returns a value to the calling function. The program control is transferred to the calling function after return statement.

To Learn More About C language Course In Ahmedabad, C Course

If you like this post then please share and like this post.

Call us @ 98256 18292.

Visit us @


TCCI GSBE,CBSE,ICSE,IB computer Syllabus – Coaching Class

Computing technology has made rapid advancements in the past few years, and it continues to get better.


Technology has struggled to find its way into the classroom in all sorts of ways, from projectors and televisions to computer labs and student laptops. Education has benefited from the inclusion of technology and computers by making it easier for students to keep up while helping teachers by improving the way lessons can be planned and taught. Students who use computers learn to use word processors for work, and subsequently they learn computer jargon and strengthen grammatical skills.

Computer improves the students’ performance.

So, now a day’s all school boards have included different computer languages like C, C++, Java, HTML, Database Management System , Open source, Basic Course… etc……

TCCI Computer coaching Institute teaches all these different computer courses to all school Board students.

Our High educated and 9 years experienced faculties always ready to motivate and guide the GSBE, CBSE, ICSE, IB school students.

Contact us @ 98256 18292

Mail to

Get information from


SQL course for CBSE school students – Coaching Class

SQL is a programming language for Relational Databases. It is designed over relational algebra and tuple relational calculus. SQL comes as a package with all major distributions of RDBMS. SQL is used to communicate with a database. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

SQL Course.jpg

TCCI-Tririd Computer Coaching Institute is focused on providing Quality education with practical sessions.Satisfaction of our student is our priority.

We teach following topic In SQL Course

Basics of SQL: We’ll teach you the basics of creating tables and selecting data in various different ways.

More advanced SQL queries: Learn how to perform more advanced SQL queries using AND/OR, IN, LIKE, HAVING, and more.

Relational Queries: Learn how to store related data in multiple tables and use joins to bring them together (inner joins, outer joins, and self joins).

Modifying Database: Learn how to update data, delete data, and change table schemas with SQL commands UPDATE, DELETE, ALTER, and DROP.

To Learn More About TCCI, sql course in bopal-ahmedabad, sql course in ahmedabad, sql course, CBSE

Contact us @ 98256 18292

Mail to

Get information from


Learning of Data Structure for ICSE students – Coaching Class


TCCI-Tririd computer coaching institute is a dynamic institution providing career-focused, high quality programs designed to enhance job opportunities for our graduates and provide a skilled workforce for the community.

Data Structure Course.jpg

Data structures play a central role in modern computer science. Its best way to store and represent data. Data structures provide a means to manage large amounts of data for use in databases and internet indexing services. Efficient data structures are key for designing efficient algorithms and obtaining maintainable software design.

We teach following topics:

  1. Introduction to Data Structure Course
  2. Types of Data Structure
  3. Array
  4. Stack
  5. Queue
  6. Link List
  7. Tree
  8. Graph
  9. Sorting
  • Bubble
  • Insertion
  • Selection
  • Quick
  • Heap
  • Merge

Time Complexity

Course duration: Daily/4 days/3 Days/2 Days.

Class Mode: Theory with Practical.

Lecture Timing: At student’s convenience.

To Learn More about Data Structure Course in Ahmedabad, Computer Class

TCCI Computer Coaching Institute teaches all computer subjects to GSEB, CBSE, ICSE, IB School Board students in Ahmedabad.

Call now 9825618292

Mail to

Get information from