Siddhartha Mahapatra

Garia, Kolkata, India - 700096

Siddhartha Mahapatra photo

Siddhartha Mahapatra

Advance Excel And VBA Training

Garia, Kolkata, India - 700096.

4.2

UrbanPro Rating

Details verified of Siddhartha Mahapatra

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

I am working in IBM as a Lead Finance and Administration. I have gained exposure on financial reporting and advanced data analysis of various Project data and to create statistical reports with the help of Advance Excel and VBA Programming. I have experience mostly as a MS Excel and VBA Programmer for design specifications and development of automated Reports and Spreadsheets.

Key Skills : Basic project development concepts, MS-Excel and other MS-Office package application. In MS-Excel, have experience in modifying/formatting a worksheet including conditional formatting, performing calculations, customizing layout, creating templates, standard and custom charts (types used are column, bar, line, pie), working with graphic objects, calculating with advanced formulas by using various Excel functions, analyzing data, sorting and filtering data with use of custom and advanced filtering, working with multiple workbooks including sharing of workbook with protection features, data validation, goal seek, watch window to monitor formula cells, pivot tables and charts, convert text to columns, grouping/ ungrouping data and use of subtotals in calculation, use of hyperlinks, printing workbook contents and applying various print techniques like repeating rows or columns on a printout, customizing print report to make a wide report fit to one page wide by many pages tall, VBA and Macro programming for develop various Tracker to increase productivity and consume time.

Languages Spoken

Bengali

Oriya

Hindi

English

Education

WBUT 2008

Master of Computer Applications (M.C.A.)

Address

Garia, Kolkata, India - 700096

Verified Info

Phone Verified

Email Verified

Facebook Verified

Demo Class

No

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Microsoft Excel Training classes Overview

Microsoft Excel Training classes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft Excel Training classes

8

Teaches following Excel features

Advanced Excel, Basic Excel, Excel VBA & Macro Training

Reviews

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

Lessons (2)

MS Excel: Formulas and Functions: Listed by Category

MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....

24/02/2018
0 0
0
History Of Programming Languages

1800: Joseph Marie Jacquard teaches a loom to read punch cards, creating the first heavily multi-threaded processing unit. His invention was fiercely opposed by the silk-weavers who expected the birth...

16/02/2018
0 0
0

Answers by Siddhartha Mahapatra (29)

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

If you are using UNIX based system, you can use terminal commands with the help of the system() function. Try the below code example: #include "iostream" using namespace std; int main() { system("ls -lrt"); return 0; } system() in C/C++ system() is... ...more
If you are using UNIX based system, you can use terminal commands with the help of the system() function. Try the below code example: #include "iostream" using namespace std; int main() { system("ls -lrt"); return 0; } system() in C/C++ system() is used to invoke an operating system command from a C/C++ program. int system(const char *command); Note: stdlib.h or cstdlib needs to be included to call system. Using system(), we can execute any command that can run on terminal if operating system allows. For example, we can call system(“dir”) on Windows and system(“ls”) to list contents of a directory. Writing a C/C++ program that compiles and runs other program? We can invoke gcc from our program using system(). See below code written for Linux. We can easily change code to run on windows. // A C++ program that compiles and runs another C++ // program #include "bits/stdc++.h" using namespace std; int main () { char filename[100]; cout << "Enter file name to compile "; cin.getline(filename, 100); // Build command to execute. For example if the input // file name is a.cpp, then str holds "gcc -o a.out a.cpp" // Here -o is used to specify executable file name string str = "gcc "; str = str + " -o a.out " + filename; // Convert string to const char * as system requires // parameter of type const char * const char *command = str.c_str(); cout << "Compiling file using " << command << endl; system(command); cout << "\nRunning file "; system("./a.out"); return 0; } Thanks.
Answers 3 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

How do I get different compilers for different languages like C, CPP, Java, and Python in a single desktop... ...more
How do I get different compilers for different languages like C, CPP, Java, and Python in a single desktop application or website like Hacker Rank?

The desktop application you are talking about has a name, and it is called as an IDE (Integrated Development Environment). This an application or a software that acts similar as text editors like sublime and atom. These IDE s contain advanced options than a simple text editor such as debugger,syntax... ...more
The desktop application you are talking about has a name, and it is called as an ‘IDE’ (Integrated Development Environment). This an application or a software that acts similar as text editors like sublime and atom. These IDE’s contain advanced options than a simple text editor such as debugger,syntax highlighter and many more. There are many IDE’s out there in the market.Among them some of my favorite are Eclipse,Netbeans and Codeblocks. It is better to try each of them and find the one that best suits you. Happy Coding :)
Answers 2 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

A simple priority queue will do the job. You can define each node in the queue to hold the task as well as the priority level. Enqueueing will be no different that regular queues and will happen at the rear. Dequeueing however, will not always take place at the front but will rather happen to the... ...more
A simple priority queue will do the job. You can define each node in the queue to hold the task as well as the priority level. Enqueueing will be no different that regular queues and will happen at the rear. Dequeueing however, will not always take place at the front but will rather happen to the node with least priority level in the queue, regardless of location. Have a look at priority queues, learn what they are and have fun implementing them. I assure you, it’s easy to do and you learn a lot! Round Robin Scheduling Each process is provided a fix time to execute called quantum. Once a process is executed for given time period. Process is preempted and other process executes for given time period. Context switching is used to save states of preempted processes. See below attached image1 for your reference. CODE: #include "stdio.h" main() { int n; printf("Enter the no. of processes: "); scanf("%d",&n); int id[n],bt[n],rt[n],wt[n],tat[n],st[n],ft[n],q,i,time=0,btsum=0; for(i=0;iq) { time+=q; bt[i]-=q; wt[i]=wt[i]+st[i]-ft[i]; ft[i]=time; } else if(bt[i]<=q && bt[i]!=0) { time+=bt[i]; wt[i]=wt[i]+st[i]-ft[i]; bt[i]=0; } } for(i=0;i
Answers 3 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

The C Program is written for implementation of STACK using Array, the basic operations of stack are PUSH(), POP() and DISPLAY(). PUSH function in the code is used to insert an element to the top of stack, POP function used to remove the element from the top of stack. Finally display function used to... ...more
The C Program is written for implementation of STACK using Array, the basic operations of stack are PUSH(), POP() and DISPLAY(). PUSH function in the code is used to insert an element to the top of stack, POP function used to remove the element from the top of stack. Finally display function used to print the values at any time. All stack functions are implemented in C Code. The same implementation of stack using c is written using pointers: Stack operations using pointers in c //stack using array #include "stdio.h" #include "conio.h" int stack[100],choice,n,top,x,i; void push(); void pop(); void display(); void main() { //clrscr(); top=-1; printf("\n Enter the size of STACK[MAX=100]:"); scanf("%d",&n); printf("\n\t STACK OPERATIONS USING ARRAY"); printf("\n\t--------------------------------"); printf("\n\t 1.PUSH\n\t 2.POP\n\t 3.DISPLAY\n\t 4.EXIT"); do { printf("\n Enter the Choice:"); scanf("%d",&choice); switch(choice) { case 1: { push(); break; } case 2: { pop(); break; } case 3: { display(); break; } case 4: { printf("\n\t EXIT POINT "); break; } default: { printf ("\n\t Please Enter a Valid Choice(1/2/3/4)"); } getch(); } } while(choice!=4); } void push() { if(top>=n-1) { printf("\n\tSTACK is over flow"); getch(); } else { printf(" Enter a value to be pushed:"); scanf("%d",&x); top++; stack[top]=x; } } void pop() { if(top<=-1) { printf("\n\t Stack is under flow"); } else { printf("\n\t The popped elements is %d",stack[top]); top--; } } void display() { if(top>=0) { printf("\n The elements in STACK \n"); for(i=top; i>=0; i--) printf("\n%d",stack[i]); printf("\n Press Next Choice"); } else { printf("\n The STACK is empty"); } } OUTPUT: Enter the size of STACK[MAX=100]:10 STACK OPERATIONS USING ARRAY -------------------------------- 1.PUSH 2.POP 3.DISPLAY 4.EXIT Enter the Choice:1 Enter a value to be pushed:12 Enter the Choice:1 Enter a value to be pushed:24 Enter the Choice:1 Enter a value to be pushed:98 Enter the Choice:3 The elements in STACK 98 24 12 Press Next Choice Enter the Choice:2 The popped elements is 98 Enter the Choice:3 The elements in STACK 24 12 Press Next Choice Enter the Choice:4 EXIT POINT
Answers 3 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

Constructor: A constructor is a special member function used in a class in order to Initialize the objects of a class. The name of the constructor should be same as that of the class name. Constructors does not have any return type not even void In Object oriented programming we have 3 types... ...more
Constructor: A constructor is a special member function used in a class in order to Initialize the objects of a class. The name of the constructor should be same as that of the class name. Constructors does not have any return type not even void In Object oriented programming we have 3 types of constructors they are: 1. default constructor: The constructor which does not have any arguments are known as default constructors. Syntax: Class_name() { --------------//arguments } 2. parameterized constructor: The constructors which passes arguments is known as a parameterized constructor. Syntax: Class_name(parameters) { -------------------//arguments } 3. copy constructor: The constructor which creates an object by initializing it with an object of the same class which was created prior is known as a copy constructor. Now let us see a program to generate a Fibonacci serious using constructor to in Action l an object. #include "iostream" using namespace std; class fib //class declaration { int n; public: //access specifier fib() //default constructor { cout<<"enter the number until which you want the fibonacci series to come"<>n; } int fib_op(int x) // function declaration and definition { if(x==0) return 0; else if(x==1) return 1; else return(fib_op(x-1)+fib_op(x-2)); } void display() //function to display the output { for(int i=0;i<=n;i++) { cout<
Answers 3 Comments
Dislike Bookmark

Siddhartha MahapatraDirections

x
Microsoft Excel Training classes 4.2

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft Excel Training classes

8

Teaches following Excel features

Advanced Excel, Basic Excel, Excel VBA & Macro Training

Microsoft PowerPoint Training classes 4.2

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Microsoft PowerPoint Training classes

8

Computer Course classes 4.2

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Computer Course classes

8

Type of Computer course taken

Software Programming, Basics of Computer usage, Training in Software application usage, Training in Computer tools usage

C Language Classes 4.2

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in C Language Classes

8

BTech Tuition 4.2

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in BTech Tuition

8

BTech Biotechnology subjects

Analytical Methods And Instrumentation

BTech Computer Science subjects

Database Management Systems, Data Structures and Algorithms

BTech Branch

BTech Computer Science Engineering, BTech Biotechnology Engineering, BTech Information Science Engineering

BTech Information Science subjects

Operating Systems, Database Systems, Data Structures and Algorithms

Type of class

Crash Course

Class strength catered to

One on one/ Private Tutions

Taught in School or College

Yes

BCA Tuition 4.2

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in BCA Tuition

8

BCA Subject

Software Engineering , Data structures, C Language Programming

Type of class

Crash Course

Class strength catered to

One on one/ Private Tutions

Taught in School or College

Yes

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

No Reviews yet! Be the first one to Review

Answers by Siddhartha Mahapatra (29)

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

If you are using UNIX based system, you can use terminal commands with the help of the system() function. Try the below code example: #include "iostream" using namespace std; int main() { system("ls -lrt"); return 0; } system() in C/C++ system() is... ...more
If you are using UNIX based system, you can use terminal commands with the help of the system() function. Try the below code example: #include "iostream" using namespace std; int main() { system("ls -lrt"); return 0; } system() in C/C++ system() is used to invoke an operating system command from a C/C++ program. int system(const char *command); Note: stdlib.h or cstdlib needs to be included to call system. Using system(), we can execute any command that can run on terminal if operating system allows. For example, we can call system(“dir”) on Windows and system(“ls”) to list contents of a directory. Writing a C/C++ program that compiles and runs other program? We can invoke gcc from our program using system(). See below code written for Linux. We can easily change code to run on windows. // A C++ program that compiles and runs another C++ // program #include "bits/stdc++.h" using namespace std; int main () { char filename[100]; cout << "Enter file name to compile "; cin.getline(filename, 100); // Build command to execute. For example if the input // file name is a.cpp, then str holds "gcc -o a.out a.cpp" // Here -o is used to specify executable file name string str = "gcc "; str = str + " -o a.out " + filename; // Convert string to const char * as system requires // parameter of type const char * const char *command = str.c_str(); cout << "Compiling file using " << command << endl; system(command); cout << "\nRunning file "; system("./a.out"); return 0; } Thanks.
Answers 3 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

How do I get different compilers for different languages like C, CPP, Java, and Python in a single desktop... ...more
How do I get different compilers for different languages like C, CPP, Java, and Python in a single desktop application or website like Hacker Rank?

The desktop application you are talking about has a name, and it is called as an IDE (Integrated Development Environment). This an application or a software that acts similar as text editors like sublime and atom. These IDE s contain advanced options than a simple text editor such as debugger,syntax... ...more
The desktop application you are talking about has a name, and it is called as an ‘IDE’ (Integrated Development Environment). This an application or a software that acts similar as text editors like sublime and atom. These IDE’s contain advanced options than a simple text editor such as debugger,syntax highlighter and many more. There are many IDE’s out there in the market.Among them some of my favorite are Eclipse,Netbeans and Codeblocks. It is better to try each of them and find the one that best suits you. Happy Coding :)
Answers 2 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

A simple priority queue will do the job. You can define each node in the queue to hold the task as well as the priority level. Enqueueing will be no different that regular queues and will happen at the rear. Dequeueing however, will not always take place at the front but will rather happen to the... ...more
A simple priority queue will do the job. You can define each node in the queue to hold the task as well as the priority level. Enqueueing will be no different that regular queues and will happen at the rear. Dequeueing however, will not always take place at the front but will rather happen to the node with least priority level in the queue, regardless of location. Have a look at priority queues, learn what they are and have fun implementing them. I assure you, it’s easy to do and you learn a lot! Round Robin Scheduling Each process is provided a fix time to execute called quantum. Once a process is executed for given time period. Process is preempted and other process executes for given time period. Context switching is used to save states of preempted processes. See below attached image1 for your reference. CODE: #include "stdio.h" main() { int n; printf("Enter the no. of processes: "); scanf("%d",&n); int id[n],bt[n],rt[n],wt[n],tat[n],st[n],ft[n],q,i,time=0,btsum=0; for(i=0;iq) { time+=q; bt[i]-=q; wt[i]=wt[i]+st[i]-ft[i]; ft[i]=time; } else if(bt[i]<=q && bt[i]!=0) { time+=bt[i]; wt[i]=wt[i]+st[i]-ft[i]; bt[i]=0; } } for(i=0;i
Answers 3 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

The C Program is written for implementation of STACK using Array, the basic operations of stack are PUSH(), POP() and DISPLAY(). PUSH function in the code is used to insert an element to the top of stack, POP function used to remove the element from the top of stack. Finally display function used to... ...more
The C Program is written for implementation of STACK using Array, the basic operations of stack are PUSH(), POP() and DISPLAY(). PUSH function in the code is used to insert an element to the top of stack, POP function used to remove the element from the top of stack. Finally display function used to print the values at any time. All stack functions are implemented in C Code. The same implementation of stack using c is written using pointers: Stack operations using pointers in c //stack using array #include "stdio.h" #include "conio.h" int stack[100],choice,n,top,x,i; void push(); void pop(); void display(); void main() { //clrscr(); top=-1; printf("\n Enter the size of STACK[MAX=100]:"); scanf("%d",&n); printf("\n\t STACK OPERATIONS USING ARRAY"); printf("\n\t--------------------------------"); printf("\n\t 1.PUSH\n\t 2.POP\n\t 3.DISPLAY\n\t 4.EXIT"); do { printf("\n Enter the Choice:"); scanf("%d",&choice); switch(choice) { case 1: { push(); break; } case 2: { pop(); break; } case 3: { display(); break; } case 4: { printf("\n\t EXIT POINT "); break; } default: { printf ("\n\t Please Enter a Valid Choice(1/2/3/4)"); } getch(); } } while(choice!=4); } void push() { if(top>=n-1) { printf("\n\tSTACK is over flow"); getch(); } else { printf(" Enter a value to be pushed:"); scanf("%d",&x); top++; stack[top]=x; } } void pop() { if(top<=-1) { printf("\n\t Stack is under flow"); } else { printf("\n\t The popped elements is %d",stack[top]); top--; } } void display() { if(top>=0) { printf("\n The elements in STACK \n"); for(i=top; i>=0; i--) printf("\n%d",stack[i]); printf("\n Press Next Choice"); } else { printf("\n The STACK is empty"); } } OUTPUT: Enter the size of STACK[MAX=100]:10 STACK OPERATIONS USING ARRAY -------------------------------- 1.PUSH 2.POP 3.DISPLAY 4.EXIT Enter the Choice:1 Enter a value to be pushed:12 Enter the Choice:1 Enter a value to be pushed:24 Enter the Choice:1 Enter a value to be pushed:98 Enter the Choice:3 The elements in STACK 98 24 12 Press Next Choice Enter the Choice:2 The popped elements is 98 Enter the Choice:3 The elements in STACK 24 12 Press Next Choice Enter the Choice:4 EXIT POINT
Answers 3 Comments
Dislike Bookmark

Answered on 29/08/2017 IT Courses/Programming Languages/C Language

Constructor: A constructor is a special member function used in a class in order to Initialize the objects of a class. The name of the constructor should be same as that of the class name. Constructors does not have any return type not even void In Object oriented programming we have 3 types... ...more
Constructor: A constructor is a special member function used in a class in order to Initialize the objects of a class. The name of the constructor should be same as that of the class name. Constructors does not have any return type not even void In Object oriented programming we have 3 types of constructors they are: 1. default constructor: The constructor which does not have any arguments are known as default constructors. Syntax: Class_name() { --------------//arguments } 2. parameterized constructor: The constructors which passes arguments is known as a parameterized constructor. Syntax: Class_name(parameters) { -------------------//arguments } 3. copy constructor: The constructor which creates an object by initializing it with an object of the same class which was created prior is known as a copy constructor. Now let us see a program to generate a Fibonacci serious using constructor to in Action l an object. #include "iostream" using namespace std; class fib //class declaration { int n; public: //access specifier fib() //default constructor { cout<<"enter the number until which you want the fibonacci series to come"<>n; } int fib_op(int x) // function declaration and definition { if(x==0) return 0; else if(x==1) return 1; else return(fib_op(x-1)+fib_op(x-2)); } void display() //function to display the output { for(int i=0;i<=n;i++) { cout<
Answers 3 Comments
Dislike Bookmark

Enquire

Load More

Lessons (2)

MS Excel: Formulas and Functions: Listed by Category

MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....

24/02/2018
0 0
0
History Of Programming Languages

1800: Joseph Marie Jacquard teaches a loom to read punch cards, creating the first heavily multi-threaded processing unit. His invention was fiercely opposed by the silk-weavers who expected the birth...

16/02/2018
0 0
0

Siddhartha Mahapatra describes himself as Advance Excel And VBA Training. He conducts classes in BCA Tuition, BTech Tuition and C Language. Siddhartha is located in Garia, Kolkata. Siddhartha takes Regular Classes- at his Home. He has 8 years of teaching experience . Siddhartha has completed Master of Computer Applications (M.C.A.) from WBUT in 2008. He is well versed in Bengali, Oriya, Hindi and English.

X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Siddhartha Mahapatra

Let Siddhartha Mahapatra know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more