Signup as a Tutor

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

Excel Training

15 Reviews

Course type: Online Instructor led Course

Platform: Online

Course ID: 28456

Course type: Online Instructor led Course

Platform: Online

Students Interested 3 (Seats Left 0)

15 Reviews

About the Course

Advanced Excel Training which provides new features added to the Excel.


Topics Covered



  1. Working With Formulas:

    1. Cell Addressing Or Referencing Methods

    2. Absolute, Relative & Mixed Referencing

    3. Naming References and Range

    4. Referring To Other Sheets & Workbooks




 



  1. Working With Functions:

  2. Basic : Sum, Average, Max, Min, Count

  3. Statistical: CountA, Countblank, Sumif, SumIfs, AverageIf, AverageIfs, CountIf and CountIfs

  4. Logical: Working With If, IfError, IsNa, And, Or, Not, NestIfs Functions

  5. Look Up & Reference: VLookup, HLookup, Match, Index, INDIRECT, Choose

  6. Text Function

  7. DateTime


 


 



  1. Database Management In Excel

    1. Building An Excel Database, Basic Database Concepts

    2. Performing Single / Multi-Level Sorts

    3. Filters – Auto, Custom and Advanced

    4. Subtotals

    5. Text to Column

    6. Remove Duplicates

    7. Import and Export data

    8. Flash fill




 


 



  1. Working With Charts

    1. Creating Excel Charts

    2. Working With Different Types

    3. Formatting Charts

    4. Working With Design And Layout Of The Chart

    5. Creating And Applying & Removing Chart Template

    6. Pivot chart

    7. Sparkline

    8. Dynamic charts




 


 



  1. Speed Up Your Day To Day Work In Excel Using Keyboard Short Cuts


 



  1. Working With Pivot Tables

    1. Creating and Editing Pivot table

    2. Formatting A Pivot Table

    3. Working With Summary Functions

    4. Sorting Items In A Pivot Table

    5. Grouping Data

    6. Working With Field Settings

    7. Creating Calculated Field and A Calculated Item

    8. Working with Slicer and Timeline




 


 



  1. Cell And Workbook Protections

    1. Protecting Cells, Protecting Sheets, Protecting Workbooks




 



  1. Working With More Formatting Features

    1. Conditional Formatting

    2. Formatting Data as table




 



  1. Data Validation

    1. Creating Data Validation

    2. Working With List & Dependent List

    3. Creating List with Dynamic Ranges

    4. Creating Custom Validation

    5. Handling Input And Error Alerts




 



  1. Excel Dashboard

    1. Dashboard Overview

    2. Dashboard Layout

    3. Dashboard Designing

    4. Examples




Who should attend


Any one interested to learn Excel Advanced feature. Ideal for the Working Professionals.


Pre-requisites


Internet Connection with Good Band Width


What you need to bring


Nothing


Key Takeaways


How to use Excel features effectively in the Day to Day Work Life.

Date and Time

Not decided yet.

About the Trainer

Vijayalakshmi G M picture

4.88 Avg Rating

145 Reviews

153 Students

7 Courses

Vijayalakshmi G M

M.Sc [Computer Science]

15 Years of Experience

IT Professional Trainer with 19+ Experience in Technical Training.

Student Feedback

4.0

Average Rating

87%
13%
0%
0%
0%

Reviews

H

Hetal Lakhani

Vijaylakshmi Mam has thought us from the basics and helped in understanding all the key concepts. The notes provided by her were very useful and all the concepts were very clear.

K

Krutika Vastrad

Vijayalakshmi Madam is very professional but the pace was bit high for me as a fresher.Excel and SQL training was very good and i am happy with the way of teaching.As i was never exposed to java language it was little difficult for me to follow.Overall i liked the way of teaching and i will surely recommend my friends to get trained from Vijayalakshmi Madam.

A

Ashwin

An absolute professional, Ms. Vijaylaxmi was a fantastic teacher. As I was an absolute beginner, she put me at ease and started extremely patiently from scratch. She really believes in proceeding at your pace and will take as long as necessary for you to feel confident. She is very flexible with scheduling the class, which was very helpful in undertaking other commitments. Her classes are one on one and very student focused. She is not rigid in her approach at all. Crucially, she is extremely knowledgeable about the softwares at hand, having decades of experience. She's really a very approachable, tolerant and humble person, and full of interesting facts! My house was quite far from her class, but it was definitely worth the long journey, and I would definitely recommend her to anyone. Thank you Ms. Vijaylaxmi.

C

Chaithra

Excellent coaching in sql and excel in just 1 week and we could master both the things. Clears all the doubts and very punctual and systematic way of teaching. Plenty of examples were solved in the class which helped us to explore industry level problems. Lots of assignment questions given which made us strong in basics and lots of examples were covered in wide range and lot of inputs were given in terms of interview preparation and many documents were given for further exploration of subjects and interview preparation.

R

Rakshith

I was very much satisfied by the training provided by her. She has vast knowledge about the subjects and is ready to help the students at any point even after the training gets completed.

V

Vrushali

Quality Training in short duration helped upskill my knowledge in Excel, Macros and SQL. The training and Study material are really helpful and the Assignments and Surprise Tests conducted by Vijayalakshmi ma'am helped us study regularly and helped build confidence.

A

Ashwini R Nair

Ma'am has a very beautiful teaching method. Though limited days were provided she made sure she finished all the topics and all the students understood what she taught. Study materials provided by ma'am were very helpful. We enjoyed your class ma'am. Thanks for making class so interesting :)

A

Arvind Jayaprakash

Thank you for the classes. Very good classes. We got hands on practical experience. Really good study material too.

N

Nikhil Aivalli

The way of teaching was different ,the session was never boring. Full of practicals and study materials provided are very good and needful.

D

Devaraja.V.S

VIjayalakshmi is very good trainer, she has very good knowledge on the process, she tried her best to download the require knowledge to Triness. All the best Madam.

J

Joseph isaiah

She is loud and the entire classroom resonates with her voice, she moves on with the topics with the right pace, her teaching methodologies are well suited to learn technologies like excel, VBA , macros, SQL etc.

Murali

First she understand the ability of learner and teach with her Unique style of teaching depending upon the student requirements with good examples. The study materials is excellent and easy to learn with good exercise. Hearty I recommend to join for training.

V

Vidhya R

I took excel training from Vijayalakshmi madam. Recently, madam was very helpful making me to understand excel from basics. Thanks for your patience madam. I felt mam's training was very useful as she was explaining the concepts with effective examples and kind enough to repeat difficult scenarios. Now i am confident that i would apply for jobs. I would sure recommend her for other students as well. Thanks.

S

Shruthi S

Vijayalakshmi Mam is an amazing tutor with a great level patience. She makes you very comfortable with the subject and has extensive knowledge about various technologies. I am very happy and satisfied with her teaching methodology and would recommend her to any one who is planning to join a technical courses

D

Dheeraj

She is just Amazing in training people. Had a great experience.

Discussions

Students Interested 3 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for IT Courses Post your requirement now

Enquire

Submit your enquiry for Excel Training

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

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 the OTP sent to your registered mobile number.

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more