Signup as a Tutor

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

Advanced Excel Training in Chennai

1 Reviews

Ramapuram, Chennai

Course ID: 5204

Ramapuram, Chennai

Students Interested 1 (Seats Left 0)

1 Reviews

Date and Time

Not decided yet.

Mohamed Yousuf

BCA,MBA ( Marketing )

About Mohamed Yousuf

Working as Freelance Corporate Excel Trainer in Chennai from Jun 2010 to till date
As a freelance excel trainer i undertaken 80+ corporate trainings and more than
5000 professionals attended my advanced excel training and MS Office training
programs. Apart from Chennai, I have been conducted corporate training program
in Delhi, Bangalore, Hyderabad, Ahmedabad, Trichy and Vishakhapatnam.
Few Corporates Names:
 TCS  Cognizant  ITC  L&T  Murugappa  TVS  World Bank  BNP Paribas
 Renault Nissian  Emerson  Logica  FLSmidth  Fedby  Mando India
? Worked as Marketing Support Specialist in ProdEx Technologies (eGrabber
Software), Chennai from Apr 2008 to Jun 2010.
N

Nikhil Patel

Attended Advanced Excel Training in Chennai

The trainer explained difficult concepts in an easy to understand manner & has a respectable level of knowledge about the subject matter. A highly recommended course as one will learn a lot of useful concepts & tricks from the course.

About the Course

Excel Prodigy for training corporate to best suit their schedule, budget, learning style and expertise. We are Microsoft Authorized Testing Center to conduct Microsoft Office Specialist Exam (MOS Certification) in Chennai.

Unlike other conventional training centers, we offer Beginner level, Intermediate level, Advanced level and Professional level courses based on your convenience and requirements.

Our training courses will show you how to use Excel better, faster and more efficiently. You will learn how to save time, access new features and work with confidence.

Our teaching methods ensure maximum comprehension in the shortest possible time. We provide a dynamic learning environment with lots of practical hands on exercises and real world examples.

Our instructors are knowledgeable, experienced and patient computer training professionals with both industry experienced and qualified.

Topics Covered

Excel Basics
The Excel Screen • Moving About the Workbook • Simple Data Entry • Selecting Ranges • Saving Workbook Formats

Copying & Filling
Using Fill for Quick Copying • Copying Cell(s) to One/Many Cells & Worksheets

Editing Data
Overwriting/Editing Cell Contents • Editing Formulae/Functions • Using Undo/Redo • Search & Replace

Adjusting a Worksheet
Inserting/Deleting Cells • Inserting/Deleting/Resizing Rows/Columns

Working With Worksheets
Copying/Moving/Renaming Worksheet(s) • Inserting/Deleting/Grouping Worksheets • Hiding & Unhiding Worksheets

Formulae
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function

Formatting in Excel
Formatting Numbers/Dates/Currency • Formatting for Effect Bolding/ Italics/ Underling • Cell/Background Colours • Cell Alignment

Working with Functions
Summing Non-Contiguous Ranges •Count/ Average/Maximum/Minimum Functions

Viewing Worksheets
Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows

Paste Special
Paste Special to Copy Formulae/Formats/Validations • Paste Special to Add/Multiple & Transpose

Fill Series
Filling a Series with formatting/without formatting • Filling a weekdays • Fill data using stop value

Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References

Define Names & Lables
Creating/Deleting Labels/ Names • Creating/Using Names in Formulas/ Across Workbooks

PivotTables
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart

LOOKUP Functions
The VLOOKUP/HLOOKUP Functions • MATCH with VLOOKUP Functions

Logical Functions
IF's and Nested IF Functions • Using AND/OR/NOT Functions

Statistical Functions
Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Date/Time Functions
Using The TODAY • NOW & DATE Functions • Using The DATEDIF/ NETWORKDAYS/ EOMONTH Functions.

Text Functions
Using The MID/ SEARCH/ LEFT/ RIGHT Functions • Using The TRIM/ CLEAN/ UPPER/ LOWER Functions.

Validations
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting

Chart Data Techniques
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series

Hyper / Data Linking
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application

Filters & Data Sorting
Applying & Using AutoFilter • Creating a Custom AutoFilter • Sorting On More Than One Column

Printing
Simple Printing/Previewing • Page Setup & Orientation • Creating and Formatting Page Headers/Footers • Custom views

Who should attend

Corporate Professionals
MBA Graduates

Pre-requisites

Excellent Keyboard Skills
Attitude to Learn
Good Logical Skills

What you need to bring

Keen attention to class

Key Takeaways

Outstanding knowledge in excel

Reviews (1) See all Reviews

N

Nikhil Patel

Attended Advanced Excel Training in Chennai

The trainer explained difficult concepts in an easy to understand manner & has a respectable level of...

Discussions

Students Interested 1 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
Enquire

Enquire

Submit your enquiry for Advanced Excel Training in Chennai

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 Prodigy

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