Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Enquire

Submit your enquiry for Ms Excel Training in Chennai (Basic, Intermediate and Advanced Level)

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Excel Sense

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Ms Excel Training in Chennai (Basic, Intermediate and Advanced Level)

Ms Excel Training in Chennai (Basic, Intermediate and Advanced Level)

Nungambakkam, Chennai

3,500

No Reviews Yet
0 Interested

About the Course


Excel Sense is a start up ms excel training institute. We offer Professional and advance Excel training and Macro training using VBA to students / learners at graduate, postgraduate and professional levels.

We can also tailor MS Excel training to your needs, or to your company project requirements, taking you from first principles to whatever level you want to achieve.

Topics Covered

BEST MS EXCEL TRAINING (Basic & Intermediate)
Overview:
This will build on your current Excel skills. This course will cover all aspects of creating Spreadsheets, Performing calculations,Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index etc. It also guides you on data presentation using Conditional Formatting, Excel-Charts, Formatting and using page setup for printing. Our professional Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate's knowledge level, their problems and adjust our training to their specific needs. Getting Excel to make decisions using the ‘IF’ function, You’ll learn how to create templates for commonly used worksheets. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper MS Excel tools to create a unique solution. This training will also enable you to create, build and customise graphs. Existing MS Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel. We also have an Advanced MS Excel training course. For people from companies, we provide corporate training on MS Excel.

Class
Syllabus
Training Details
Session - 1
EXCEL BASIC OPTIONS
An overview of the Screen, Navigation and Basic Spreadsheet concepts
Understand Excel terminology Workbooks, Worksheets, Rows, Columns and Cells
Various Selection techniques
Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
Methods to Move, Copy & Paste data
All the Options in Paste Special and Go To
Insert, Delete and Hiding Rows & Columns
Inserting and Deleting ranges
Insert, Delete and Move Cells
Various Navigation techniques
Sheet tab formatting and Renaming
Copy and Clear Formats and Merge Cells
Find, Replace and AutoCorrect
Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments
Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
Uses Conditional Formatting and Auto Formatting
All Formate Cells Options
Uses of Toolbars and Formula Bar
Viewing, Adding, Editing and Deleting Comments
Auditing features and Tracing Formula errors
Protecting and Sharing Workbook, Worksheet and Cell ranges
Using Freeze Panes
Worksheets and Workbooks Calculation method
Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks
Methods to Move and Copy sheets
Uses of Hyperlinks and Define Name
Session - 2
Session - 3
EXCEL BASIC FUNCTIONS
Uses of Basic Excel Formulas
SUM, SUBTOTAL, ADDRESS, AVERAGE, CHAR, CHOOSE, COLUMN, COLUMNS, CONCATENATE, COUNT, COUNTA, COUNTBLANK, DAVEVALUE, DCOUNT, DCOUNTA, EFFECT, EXACT, GETPIVOTDATA, HYPERLINK, ISBLANK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, PROPER, MAX, MAXA, DATE, DAY, MONTH, YEAR, FIND, REPLACE, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, SUBSTITUTE, TODAY, TRANSPOSE, TRIM etc

Session - 4
EXCEL ADVANCE FUNCTIONS
Uses of Advance Excel Formulas
VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, OR, AND, SEARCH, INDEX, MATCH etc

Session - 5
EXCEL OPTIONS
Various Methods and Options of Pivot Table
Various Methods of Filter and Advance Filter options
Creating and Updating Subtotals
Various Methods of Text to Column options
Uses of Data Grouping and Consolidation options
Uses of Goal Seek and Scenarios Manager
Various Method of Sorting Data
Creating, Formatting and Modifying Chart
Data Validation, Creating drop down lists using different data sources
Linking Workbooks and Uses of Edit Link options
Excel Options, Customizing the Quick Access Tool Bar
Formula Auditing features and Trace formula error
Session - 6
ACCESS DATABASE & RECORD MACRO
Create a New Table and Database in MS Access
Load the Data into Access Database
Create a Query in Access Database
Create Single and Multiple Mapping Tables
Filter Single and Multiple criteria using Access Query
Create Query for Data Grouping
Create Query to Select required Columns
Retrive specific data using Logical Access Query
Create Access Query to Update, Change and Delete the Information in Access
Recording, Viewing and Editing Macro VBA code



ADVANCED MS EXCEL TRAINING (Intermediate and Advanced)
Overview:
Our Advanced Excel training will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, advanced IF conditions formulas, dashboards, pivot tables, pivot charts, goal seek, nesting, data manipulation and protect data using the security features. If you want a more basic version, try our Basic and internediate excel training programme You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. We also teach you how to develop these advanced solutions on the worksheet and to assemble the proper Excel tools in ways you have never thought of before. Find out how you can utilise advanced ‘IF’ statements.

Class
Syllabus
Training Details
Session - 1
ADVANCED EXCEL FUNCTIONS
Uses of Advance Excel Formulas
VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, OR, AND, SEARCH, INDEX, MATCH etc

Session - 2
ADVANCED EXCEL FUNCTIONS
Session - 3
ADVANCED EXCEL FUNCTIONS
Various Methods and Uses of IF Conditions
When should use the "IF" Conditions?
Creation of Multiple IF Conditions in One Cell
Use the IF Conditions with the Other Advance Functions
How to use nested IF statements in Excel with AND, OR Functions
Session - 4
ADVANCED EXCEL OPTIONS
Various Methods of Filter and Advance Filter options
Creating and Updating Subtotals
Various Methods of Text to Column options
Uses of Data Grouping and Consolidation options
Uses of Goal Seek and Scenarios Manager
Various Method of Sorting Data
Creating, Formatting and Modifying Chart
Data Validation, Creating drop down lists using different data sources
Linking Workbooks and Uses of Edit Link options
Excel Options, Customizing the Quick Access Tool Bar
Formula Auditing features and Trace formula error
Session - 5
ADVANCED EXCEL OPTIONS
Pivot Tables
Various Methods and Options of Pivot Table
Using the Pivot Table Wizard
Changing the Pivot Table Layout
Subtotal and Grandtotal Options
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Select, Move & Clear Pivot data
Creating and Modifying a PivotChart
Session - 6
ACCESS DATABASE & RECORD MACRO
Create a New Table and Database in MS Access
Load the Data into Access Database
Create a Query in Access Database
Create Single and Multiple Mapping Tables
Filter Single and Multiple criteria using Access Query
Create Query for Data Grouping
Create Query to Select required Columns
Retrive specific data using Logical Access Query
Create Access Query to Update, Change and Delete the Information in Access
Recording, Viewing and Editing Macro VBA code

Who should attend

Advanced Excel Training for Finance, Audit & MIS reporting
In today’s fast-paced business climate, it is vital that decisions are made quickly and accurately. This course will help you improve your existing skill sets, and teach you Excel techniques to build sophisticated spreadsheets and better ways of overcoming Excel related problems.
Learning this powerful business software will set you apart from your co-workers and make you more valuable in the job market.
Excel is an important skill to have for any job. Excel can be used for a variety of different tasks in the workplace. Whether you work in the Accounting, Finance, HR, Sales and Marketing, Admin or even IT department, you have to use Excel for Data Management and Data Analysis.
Having the skill to use Excel will also open up new career options for you, often giving you new job possibilities and the potential for a higher salary. Becoming an advanced user of Excel will get you places in the corporate world.

Pre-requisites

Should have basic computer knowledge

What you need to bring

Notebook and pen

Key Takeaways

his will build on your current Excel skills. This course will cover all aspects of creating Spreadsheets, Performing calculations,Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index etc. It also guides you on data presentation using Conditional Formatting, Excel-Charts, Formatting and using page setup for printing. Our professional Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate's knowledge level, their problems and adjust our training to their specific needs. Getting Excel to make decisions using the ‘IF’ function, You’ll learn how to create templates for commonly used worksheets. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper MS Excel tools to create a unique solution. This training will also enable you to create, build and customise graphs.

Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 10 of 21
A

Ar 28/03/2014

Hi Jayashree,

I'm very much interested in this course pls contact me

0 0

Answer

You can add upto 6 Images

U

Jayashree 28/03/2014

Hi ,

Please mail me your contact details for further enquiry on Excel Basic & Intermediate course.

Regards,
Jayashree

0 0

Answer

You can add upto 6 Images

U

M.Ramachandran 24/01/2014

excel training required,

0 0

Answer

You can add upto 6 Images

U

Ponnudurai 11/11/2013

Am interested to learn Advanced Excel and macros. Please provide ur contact number

0 0

Answer

You can add upto 6 Images

U

Subramanian MR 02/09/2013

I gone through your course details and which suitable for my work skills in day today activities. So please provide your contact details to my nearest http://www.locations.interested to learn Advanced Excel and macros and contact no & fees details hw months course details  more » I gone through your course details and which suitable for my work skills in day today activities. So please provide your contact details to my nearest http://www.locations.interested to learn Advanced Excel and macros and contact no & fees details hw months course details
«less

0 0

Answer

You can add upto 6 Images

U

RAJINIKANTH 04/08/2013

Hi,
I gone through your course details and which suitable for my work skills in day today activities. So please provide your contact details to my nearest locations,

0 0

Answer

You can add upto 6 Images

U

Rajan M Nair 29/07/2013

interested to intermediate Excel(vlookup,pivot table etc. pls. contact no or fees details

0 0

Answer

You can add upto 6 Images

U

Thiyag 04/07/2013

Please contact me regarding Advance VBA. Thanks!

0 0

Answer

You can add upto 6 Images

U

T.N.NITHISH 19/06/2013

interested to learn Advanced Excel. pls. contact no or fees details

0 0

Answer

You can add upto 6 Images

P

Pinky 23/04/2013

I would like to organise a training program for my collegues in office on Microsoft excel and powerpoint. Can you please give me details on faculty profile, course duration and cost

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Jagan

MBA


Course trainer has over 7 years of experience in Financial environment and He has automated so many reports and files in various organisation.
Seats Left-

Students Interested 0

Course Id: 4470