Advanced MS Excel

myTectra offers Advanced MS Excel training in Bangalore using Class Room. myTectra offers Live Online Advanced MS Excel Training Globally.

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 >>

Comments

Post a Comment

Popular posts from this blog

SAP GRC Interview Questions and Answers

Image
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 modul
Read more

Zend Framework Interview Questions and Answers

Image
1.What is a  Framework ? In software development, a framework is a defined support structure in which another software project can be organized and developed. An abstract design  Set of common functionality  Developed for a particular domain   2.How to disable layout from controller? $this->_helper->layout()->disableLayout(); Disable Zend Layout from controller for Ajax call only if($this->getRequest()->isXmlHttpRequest()){ $this->_helper->layout()->disableLayout(); } 3.How to change the View render file from controller? function listAction(){ //call another view file file $this->render(“anotherViewFile”); } 4.How to protect your site from sql injection in zend when using select query? $select = $this->select() from(array(‘u’ => ‘users’), array(‘id’, ‘username’)) where(‘name like ?’,”%php%”) where(‘user_id=?’,’5′) where(‘rating<=?’,10); 5.How to check post method in zend framework? if($this->getRequest()-&g
Read more