Advanced Excel Training Course in Bangalore

Learn the essentials of Advanced Excel | File Formats and Manage Passwords

Study Advanced Excel Training Course in Bangalore, at IDreamKraft

Advanced Excel provides a good insight into the latest & advanced features that are available in MS Excel 2013. In a step-by-step manner it explains how to use a particular feature. To look impressive, Advanced Excel users know how to gather, structure & present their data. A good understanding is necessary to make awesome Excel workbooks, such as, the features like Power Query (Get & Transform Data), Tables, cell styles, formatting options.

Learn Advanced Excel Course From,

Advanced Excel Training Course in Bangalore

Advanced Excel Training Institute

The features of Advanced excel includes:

Format Charts, Chart Design, Leader Lines, New Functions.

The fundamental Data Analytics are:

Slicers, Flash Fill.

Powerful Data Analytics - 1 are:

Data Model, Power Pivot, Pivot Table Tools.

Powerful Data Analytics - 2 are: 

Power View, Visualizations, Pie Charts, Additional features, Power View Services, Format Reports, Handling Integers.

Other features are: 

Templates, File Formats, Inquire, Workbook Analysis, Manage passwords.

Advanced Excel Training Course Syllabus

Advanced Excel Training Course in Bangalore

Advanced Excel

Introduction to MS Excel and Understanding Basic Working with it

Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets and

Difference between Excel 2003, 2007, 2010 and 2013

Saving Excel File as PDF, CSV and Older versions

Using Excel Shortcuts with Full List of Shortcuts

Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet

Using Paste Special Options

Formatting Cells, Rows, Columns and Sheets

Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password

Page Layout and Printer Properties

Inserting Pictures and other objects in Worksheets

Working with Formulas/Functions

Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc.

Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc.

Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc.

Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc.

Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc.

Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc.

Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, FORECAST, MAX, MAXA, MIN, MINA, STDEVA etc.

Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc.

Conditional Formatting

Using Conditional Formatting

Using Conditional Formatting with Multiple Cell Rules

Using Color Scales and Icon Sets in Conditional Formatting

Creating New Rules and Managing Existing Rules

Data Sorting and Filtering

Sorting Data A-Z and Z-A

Using Filters to Sort Data

Advance Filtering Options

Pivot Tables, Creating Pivot Tables

Using Pivot Table Options

Changing and Updating Data Range

Formatting Pivot Table and Making Dynamic Pivot Tables,Pivot Charts,Creating Pivot Charts

Types of Pivot Charts and Their Usage

Formatting Pivot Charts and Making Dynamic Pivot Chart

 

COURSE REGISTRATION

COURSE REGISTRATION

Interested in this course? Ask for an admission about taking this course as part of Diploma / Advanced master Diploma / Short term certificate Course or walk - in today for free demo class.

Course Level: Diploma course
Eligibility: 10th / 12th / Graduates in any stream
Course: Advanced Excel
Course Code: EXCEL
Course Duration: 2 Months
Course Fee:  5,500/- 
Registration Fee: 3,500/-

*Registration fees are Non- Refundable after 5 days from the enrollment.

SYLLABUS

Advanced Excel

Module 1: Advanced Worksheet Functions
Session 1: Names
Session 2: Using Names
Session 3: Conditional & Logical Functions
Session 4: And, Or, Not
Session 5: Look Up Functions
Session 6: Other Useful Functions

Module 2: Data Consolidation
Module 2: Views, Scenarios, Goal Seek & Solver
Session 1: Views & Scenarios
Session 2: Goal Seek & Solving

Module 3: Using Excel To Manage Lists
Session 1: Excel, Lists, List Terminology
Session 2: Sorting Data
Session 3: Adding Sub Totals to A List
Session 4: Filtering A List
Session 5: List Statistics
Session 6: Pivot Tables
Session 7: Managing Pivot Tables

Module 4: Charts
Session 1: Introduction to Charting
Session 2: Formatting Charts

Module 5: Templates
Session 1: Introduction to Templates

Module 6: Auditing
Session 1: Auditing Features

Module 7: Other Formatting
Session 1: Formatting Cells

Module 8: Other Excel Features
Session 1: Inserting, Formatting, & Deleting Objects
Session 2: Reviewing
Session 3: Proofing Tools

SATISFACTORY COMPLETION

In order to be awarded the "ADVANCED EXCEL", students are supposed to give their Theory and Practical exams for each module. If the student fails to attend the exam on the given date, re-exam will be conducted. Its mandatory to give exam for each module as mentioned in the curriculum.

*(Please Note: Student failing to attend 80% of timetable program/ particular course will not be eligible to attend exams)

COURSE TIME TABLE

Classes are held Monday to Saturday, class will be scheduled as Practicals & Theory sessions in a week as (Monday, Wednesday, Friday) MWF & (Tuesday, Thursday, Saturday) TTHS cycle

Call Now