Analytics Training Institute

Can you provide me the curriculum of Analytics 360 course under Basic Excel offered by Analytics Training Institute? Provide me the contact detail of the Institute as well?

[Kiran Chandar]

The vision Analytics Training Institute is to empower every individual and Organization with power, to enable them to make smarter decisions.

Basic Excel

Excel is by far the most popular spreadsheet in the world. It is used pretty much everywhere in the business world especially in areas where people are adding up numbers a lot, like marketing, business development, sales, finance, etc.

Thus, Excel in its universality is now a must have skill in every business environment.

Analytics 360

Duration: 12 Hours

Module 1: Introduction to Excel
Overview
Home Tab
Conditional Formatting
Paste special
Go to special

Module 2: Data Tab
Overview
Simple sort and filter
Advanced Sort and Filter
What if Analysis
Data Validation
Data Validation

Module 3: Functions
Overview
Text Functions like CONCATENATE, TRIM, SEARCH, SUBSTITUTE
Logical Functions like IF, AND, OR
Lookup Functions like VLOOKUP, HLOOKUP, REFERENCE, INDEX,MATCH
Advanced Functions like DCOUNT, DSUM

Module 1: Dynamic Charts & Pivot Tables
Overview
Create charts
Use Dynamic charts
Connecting to Form Controls
Simple Pivot Tables
Functions in Pivot Tables
Integrating Charts with Tables

Contact Detail:
Analytics Training Institute
88, 1st Floor, KK Centre, Jyothi Nivas College Road, Industrial Layout, 5th Block, Koramangala, 5th Block, Koramangala, Bengaluru, Karnataka 560095