true

Microsoft Excel Beginner to Expert

LIVE
4 reviews
Ongoing

Course offered by Sankalp Korde

29 reviews
This class is basically a wonderful for those who have to work on reports, charts, Analysis on daily basis. It is an excellent for anyone who wish to learn it even at personal level.

## Topics Covered

1. Basic Excel structure (Cells, Rows, Columns) 2. Basic Excel Functions (Sum, Min, Max, Average, Count) 3. Conditional Formatting 4. Sorting and Filtering Data 5. Inserting Shapes, Charts (Bar, Column, Pie, Line, Area, Scatter), Picture, Clip Arts, Smart Arts) 6. Inserting Hyperlinks (Internal and External) 7. Inserting Word Arts, Headers and Footers 8. Adding Digital Signatures to the Document 9. Lookup and References (HLOOKUP and VLOOKUP) 10. Page Setup (Margins, Page Size, Print Area) 11. Importing and Exporting Data in various formats (PDF, Text, Web) 12. Data Validation 13. What-If Analysis (Goal Seek) 14. Text-To-Columns 15. Protect Worksheet and Workbook 16. Sharing Workbook 17. Freeze Panes 18. Work Spaces 19. TEXT Functions (LEN, UPPER, LOWER, CONCATENATE, CHAR, CODE, LEFT, RIGHT, REPLACE, PROPER, EXACT) 20. DATE Functions (NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND) 21. Mathematical Functions (ABS, MOD, CEIL, FLOOR, POWER, RAND, RANDBETWEEN, SQRT, SUMIF, COUNTIF, AVERAGEIF) 22. Formula Auditing (Error Checking, Trace Precedent, Trace Dependent, Watch Window, Show/Hide Formula) 23. Working with Macros 24. Mail Merge

## Who should attend

1. Students pursuing courses in Commerce, Economics, BFA (Bachelor of Finance and Accounts), Management, CS 2. Chartered Accountants (CA) 3. Data Analysts 4. Employers, Human Resource 5. Clerks, Back office staff 6. Working Professionals 7. Data Entry Operators

## Pre-requisites

Basic knowledge of computers that's it. Rest leave it to me.

## What you need to bring

Pen and notebook, Pen drive (for e-books)

## Key Takeaways

1. Excellent knowledge in Microsoft Excel 2. Support for Microsoft International Certification (MOS - Microsoft Office Specialist)

Gallery (21)

+14 more

4.7 Avg Rating

29 Reviews

40 Students

6 Courses

Sankalp Korde

B.Sc.I.T., GNIIT (Software Engineering), MCTS - Microsoft Certified Technology Specialist, MS - Microsoft Specialist

5 Years of Experience

I have completed my Graduation from University of Mumbai (B.Sc.I.T.) and concurrently GNIIT (Software Engineering) from NIIT. Looking after my projects, NIIT appointed me as a faculty in the month of May 2011. Since then, I have been teaching all the subjects related to computer programming. I was promoted as a Senior faculty in June 2012. Currently I am working with one of the Reputed ICSE school in Mumbai as a Computer Teacher and HOD (Computer Department) where my job role is to design the curriculum for the students of Grade I - VIII. As well as maintaining the school's website and other technical stuff. I also take tuition for the students of Grade IX and X (Computer Applications), as well as .NET courses. My next goal is of becoming MCT (Microsoft Certified Trainer) which is the most prestigious qualifications in the IT Training Industry, whereby I can officially represent Microsoft as an ambassador.

## Reviews (4)

5 out of 5 4 reviews

SANKALP K. https://p.urbanpro.com/tv-prod/member/photo/424751-small.jpg Vile Parle East
5.0054
SANKALP K.
M

"I am deeply honored to write a review for Sankalp Sir & thankful to Urban -Pro for suggesting me his name. I learned MS Excel course from him. I have been gifted in my life with many great teachers and Sankalp Sir is one of them. I had a specific requirement & I got many suggestions from urban pro, but the course content which was shared to me by Sankalp Sir was very comprehensive. He has enormous knowledge of the subject & very good teaching qualities which has created a precise leaning experience for me. I am now very much confident in Excel now, truly a delighted experience, Thanks Sir ! "

SANKALP K.
V

"Sankalp is a professional teacher with good command on excel . His teaching has helped me to deal confidently with excel and explore its usage for my day to day work. I thank Sankalp for his lessons and wish him all the very best for his career! "

SANKALP K.
A

"Sankalp is a very professional teacher and he has helped me learn Excel from scratch his concept and teaching method is good.I would gladly recommend him to anyone. "

SANKALP K.
N

"I would like to take this opportunity to Thanks Sankalp for helping me enhanced my skills exactly to what I required... I always knew the basic stuff but always struggled in applying formulas and start quick formatting. Sankalp, helped me understand those little stricks for implementing excel in my construction profession for progress reporting. I would strongly recommend him to all who are know the basic excel but one to take one step further...... "

View All
Have you attended any class with Sankalp?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 4 reviews

SANKALP K. https://p.urbanpro.com/tv-prod/member/photo/424751-small.jpg Vile Parle East
5.0054
SANKALP K.
M

"I am deeply honored to write a review for Sankalp Sir & thankful to Urban -Pro for suggesting me his name. I learned MS Excel course from him. I have been gifted in my life with many great teachers and Sankalp Sir is one of them. I had a specific requirement & I got many suggestions from urban pro, but the course content which was shared to me by Sankalp Sir was very comprehensive. He has enormous knowledge of the subject & very good teaching qualities which has created a precise leaning experience for me. I am now very much confident in Excel now, truly a delighted experience, Thanks Sir ! "

SANKALP K.
V

"Sankalp is a professional teacher with good command on excel . His teaching has helped me to deal confidently with excel and explore its usage for my day to day work. I thank Sankalp for his lessons and wish him all the very best for his career! "

SANKALP K.
A

"Sankalp is a very professional teacher and he has helped me learn Excel from scratch his concept and teaching method is good.I would gladly recommend him to anyone. "

SANKALP K.
N

"I would like to take this opportunity to Thanks Sankalp for helping me enhanced my skills exactly to what I required... I always knew the basic stuff but always struggled in applying formulas and start quick formatting. Sankalp, helped me understand those little stricks for implementing excel in my construction profession for progress reporting. I would strongly recommend him to all who are know the basic excel but one to take one step further...... "

Have you attended any class with Sankalp?

1500/1500

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

You have successfully registered

Microsoft Excel Beginner to Expert by Sankalp Korde

LIVE
(4 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Microsoft Excel Beginner to Expert by Sankalp Korde

LIVE
(4 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Update

Please enter 10 digit phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend