Advanced MS Excel

Advanced MS Excel Training in Bangalore - Live Online & Classroom

Gain a strong foundational knowledge of Advanced MS Excel and become a certified ProAdvisor. Master the art of managing your clients' books in Advanced MS Excel and customizing it so you're equipped to fulfill the needs of any client. Getting certified in Advanced MS Excel is the best way to enhance your professional profile, showcase your expertise and attract new clients.

Chapter 1: Getting Started

Excel Overview

Excel Ribbon/Menu Commands

Basic Data Manipulations

Managing Workbooks & Worksheets

Formatting Basics

Excel Hierarchy

Chapter 2: Functions

Logical Functions

Arithmetic Functions

Date Functions

Aggregations

Strings

Chapter 3: Complex Formulas & Functions

Lookup Formulas

1. Vlookup

2. Hlookup

3. Nested Vlookup

Advanced referencing functions

1. Index

2. Match

3. Offset & etc

Chapter 4: What-if Analysis

Goal-Seek command

Using Data Tables

Scenarios

Merge scenarios from another worksheet

Chapter 5: Chart & Layouts

Creating Charts using chart wizard

Useful Graphs & Charts

1. One Axis Graphs

2. Two Axis Graphs & etc

Gantt Charts

Chapter 6: Pivot Tables

Steps to create Pivot Table

Arranging fields (Methodology –How & Why)

Formatting Pivot Table

Introducing Slicing Tool

Managing & Formatting Slices

>> Read more >>

SAP GRC Interview Questions and Answers

1.What is the use of  SAP GRC?

SAP Governance, Risk and Compliance solution enables organization to manage regulations and compliance and remove any risk in managing organizations key operations. As per changing market situation organizations are growing and rapidly changing and inappropriate documents, spreadsheets are not acceptable for external auditors and regulators.

2.What are the different activities that you can perform in SAP GRC?

SAP GRC helps organization to manage their regulations and compliance and you can perform following activities

• Easy integration of GRC activities into existing process and automating key GRC activities.
• Low complexity and managing risk efficiently.
• Improve risk management activities.
• Managing fraud in business processed and audit management effectively.
• Organizations perform better and companies can protect their values.
• SAP GRC solution consists of three main areas: Analyze, manage and monitor.

3.What are the different GRC modules you have worked on?

• SAP GRC Access Control
• SAP GRC Process Control
• SAP GRC Risk Management
• SAP GRC Audit Management
• SAP GRC Fraud Management
• GRC Global Trade Services

4.What are the key activities under SAP GRC Access Control?

To mitigate risk in an organization, it is required to perform risk control as part of compliance and regulation practice. Responsibilities should be clearly defined, managing role provisioning and managing access for super user is critical for managing risk in an organization.

5.How Process Control is different from Access Control in SAP GRC?

SAP GRC Process control is used to monitor task and reports in real time and you can generate compliance status of controls in place as per business processes and aligning business processes to perform risk prevention and mitigation.

6.What is the use of GRC Risk Management?

SAP GRC Risk management allows you to manage risk management activities. You can do advance planning to identify risk in business and implement measures to manage risk and allow you to make better decision that improves the performance of business.

7.What are the different types of Risk?

Risks come in many forms −

• Operational Risk
• Strategic Risk
• Compliance Risk
• Financial Risk

8.What is SAP GRC Audit management?

This is used to improve the audit management process in an organization by documenting artifacts, organizing work papers, and creating audit reports. You can easily integrate with other governance, risk and compliance solution and enables organizations to align audit management policies with business goals.

9.What is SAP GRC Fraud Management?

SAP GRC Fraud management tool helps organizations to detect and prevent frauds at early stage and hence reducing minimizing the business loss. Scans can be performed on huge amount of data in real time with more accuracy and fraudent activities can be easily identified.

10.What are the key capabilities of Fraud management module?

SAP Fraud management software can help organizations with following capabilities

• Easy investigation and documentation of fraud cases.
• Increase the system alert and responsiveness to prevent fraudent activities to happen more frequently in future.
• Easy scanning of high volumes of transactions and business data.

>> Read more >>

Django Interview Questions and Answers

Q1).Explain what is Django?
Ans1: Django is a web framework in python to develop a web application in python.
Django is a free and open source web application framework, written in Python.
Q2).Mention what are the features available in Django?
Ans2: Features available in Django are

• Admin Interface (CRUD)
• Templating
• Form handling
• Internationalization
• Session, user management, role-based permissions
• Object-relational mapping (ORM)
• Testing Framework
• Fantastic Documentation

Q3).Mention the architecture of Django architecture?
Ans3: Django architecture consists of

• Models: It describes your database schema and your data structure
• Views: It controls what a user sees, the view retrieves data from appropriate models and execute any calculation made to the data and pass it to the template
• Templates: It determines how the user sees it. It describes how the data received from the views should be changed or formatted for display on the page
• Controller: The Django framework and URL parsing

Q4).Why Django should be used for web-development?
Ans4:

• It allows you to divide code modules into logical groups to make it flexible to change
• To ease the website administration, it provides auto-generated web admin
• It provides pre-packaged API for common user tasks
• It gives you template system to define HTML template for your web page to avoid code duplication
• It enables you to define what URL be for a given function
• It enables you to separate business logic from the HTML
• Everything is in python

Q5). Explain how you can create a project in Django?
Ans5: To start a project in Django, you use command $ django-admin.py and then use the command
Project
_init_.py
manage.py
settings.py
urls.py

Q6). Explain how you can set up the Database in Django?
Ans6: You can use the command edit mysite/setting.py , it is a normal python module with module level representing Django settings.
Django uses SQLite by default; it is easy for Django users as such it won’t require any other type of installation. In the case your database choice is different that you have to the following keys in the DATABASE ‘default’ item to match your database connection settings

• Engines: you can change database by using ‘django.db.backends.sqlite3’ , ‘django.db.backeneds.mysql’, ‘django.db.backends.postgresql_psycopg2’, ‘django.db.backends.oracle’ and so on
• Name: The name of your database. In the case if you are using SQLite as your database, in that case database will be a file on your computer, Name should be a full absolute path, including file name of that file.

If you are not choosing SQLite as your database then setting like Password, Host, User, etc. must be added.

Q7). Give an example how you can write a VIEW in Django?
Ans7: Views are Django functions that take a request and return a response.  To write a view in Django we take a simple example of “Guru99_home” which uses the template Guru99_home.html and uses the date-time module to tell us what the time is whenever the page is refreshed.  The file we required to edit is called view.py, and it will be inside mysite/myapp/

Copy the below code into it and save the file
       from datatime import datetime
      from django.shortcuts import render
     def home (request):
return render(request, ‘Guru99_home.html’, {‘right_now’: datetime.utcnow()})
Once you have determined the VIEW, you can uncomment this line in urls.py
# url ( r ‘^$’ , ‘mysite.myapp.views.home’ , name ‘Guru99’),
The last step will reload your web app so that the changes are noticed by the web server.

Q8).Explain how you can setup static files in Django?
Ans8: There are three main things required to set up static files in Django

• Set STATIC_ROOT in settings.py
• run manage.py collectsatic
• set up a Static Files entry on the PythonAnywhere web tab

Q9).Mention what does the Django templates consists of?

Ans9: The template is a simple text file.  It can create any text-based format like XML, CSV, HTML, etc.  A template contains variables that get replaced with values when the template is evaluated and tags (% tag %) that controls the logic of the template.

Q10). Explain the use of session framework in Django?
Ans10: In Django, the session framework enables you to store and retrieve arbitrary data on a per-site-visitor basis.  It stores data on the server side and abstracts the receiving and sending of cookies.  Session can be implemented through a piece of middleware.

>> Read more >>

Git interview Questions and Answers

1)What is GIT?

GIT is a distributed version control system and source code management (SCM) system with an emphasis to handle small and large projects with speed and efficiency.

2)What is a repository in GIT?

A repository contains a directory named .git, where git keeps all of its metadata for the repository. The content of the .git directory are private to git.

3)What is the command you can use to write a commit message?

The command that is used to write a commit message is “git commit –a”.  The –a on the command line instructs git to commit the new content of all tracked files that have been modified. You can use “git add<file>” before git commit –a if new files need to be committed for the first time.

4) What is the difference between GIT and SVN?

The difference between GIT and SVN is

1. a)      Git is less preferred for handling extremely large files or frequently changing binary files while SVN can handle multiple projects stored in the same repository.
2. b)      GIT does not support ‘commits’ across multiple branches or tags.  Subversion allows the creation of folders at any location in the repository layout.
3. c)        Gits are unchangeable, while Subversion allows committers to treat a tag as a branch and to create multiple revisions under a tag root.

5)What are the advantages of using GIT?

1. a)      Data redundancy and replication
2. b)      High availability

1. c)       Only one.git directory per repository
2. d)      Superior disk utilization and network performance
3. e)      Collaboration friendly
4. f)       Any sort of projects can use GIT

6)What language is used in GIT?

GIT is fast, and ‘C’ language makes this possible by reducing the overhead of runtimes associated with higher languages.

7)What is the function of ‘GIT PUSH’ in GIT?

‘GIT PUSH’ updates remote refs along with associated objects.

8)Why GIT better than Subversion?

GIT is an open source version control system; it will allow you to run ‘versions’ of a project, which show the changes that were made to the code overtime also it allows you keep the backtrack if necessary and undo those changes.  Multiple developers can checkout, and upload changes and each change can then be attributed to a specific developer.

9)What is “Staging Area” or “Index” in GIT?

Before completing the commits, it can be formatted and reviewed in an intermediate area known as ‘Staging Area’ or ‘Index’.

10)What is GIT stash?

GIT stash takes the current state of the working directory and index and puts in on the stack for later and gives you back a clean working directory.  So in case if you are in the middle of something and need to jump over to the other job, and at the same time you don’t want to lose your current edits then you can use GIT stash.

>> Read more >>

Python Real Time Interview Questions and Answers

Q1).What is Python?
Ans1: Python is a high-level, interpreted, interactive and object-oriented scripting language. Python is designed to be highly readable. It uses English keywords frequently where as other languages use punctuation, and it h
as fewer syntactical constructions than other languages.

Q2).Name some of the features of Python.
Ans2: Following are some of the salient features of python

• It supports functional and structured programming methods as well as OOP.
• It can be used as a scripting language or can be compiled to byte-code for building large applications.
• It provides very high-level dynamic data types and supports dynamic type checking.
• It supports automatic garbage collection.
• It can be easily integrated with C, C++, COM, ActiveX, CORBA, and Java.

Q3).Do you have any personal projects?
Really?
Ans3:This shows that you are willing to do more than the bare minimum in terms of keeping your skillset up to date. If you work on personal projects and code outside of the workplace then employers are more likely to see you as an asset that will grow. Even if they don’t ask this question I find it’s useful to broach the subject.

Q4).Is python a case sensitive language?
Ans4: Yes! Python is a case sensitive programming language.

What are the supported data types in Python?
Python has five standard data types −

• Numbers
• String
• List
• Tuple
• Dictionary

Q5).What is the output of print str if str = ‘Hello World!’?
Ans5: It will print complete string. Output would be Hello World!.
Q6).What is the output of print str[0] if str = ‘Hello World!’?
Ans6: It will print first character of the string. Output would be H.
Q7).What is the output of print str[2:5] if str = ‘Hello World!’?
Ans7: It will print characters starting from 3rd to 5th. Output would be llo.
Q8).What is the output of print str[2:] if str = ‘Hello World!’?
Ans8: It will print characters starting from 3rd character. Output would be llo World!.
Q9).What is the output of print str * 2 if str = ‘Hello World!’?
Ans9: It will print string two times. Output would be Hello World!Hello World!.
Q10).What is the output of print str + “TEST” if str = ‘Hello World!’?
Ans10: It will print concatenated string. Output would be Hello World!TEST.

>> Read more >>