Signup as a Tutor

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

Advance Microsoft Excel

4 Reviews

Munirka, Delhi

Course ID: 42313

Munirka, Delhi

Students Interested 0 (Seats Left 0)

4 Reviews

About the Course



Introduction to MS Excel and Understanding Basic Working with it




 Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar


 Saving Excel File as CSV, Macro Enable Sheet, PDF and Older Versions


 Using Excel Shortcuts with Full


List of Excel shortcuts:


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


 Using Paste Special Options


 Formatting Cells, Rows, Columns and Sheets


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


 Page Layout, Themes, Background and Printer Properties


 Inserting Pictures, Hyperlinks, Header/Footers, Shapes 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 by Values, Colors, etc


 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 Charts





 


VBA Macro




 Introduction to VBA Macro


 Recording Macro & Understanding Code Behind


 Editing, Writing VBA Code and Saving as Macro or Add-In


 Adding Add-Ins in Excel



Date and Time

Not decided yet.

About the Trainer

4.88 Avg Rating

41 Reviews

42 Students

1 Courses

Neetu Kumari

MBA-HR, B.Sc Maths

She is having more than 4 years of giving professional training on MS Advance Excel to multiple professional to enhance their professional skills as per their expert areas.

Student Feedback

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

V

Vipin Saini

Best training institute in basic computer and advanced tally accounting in South Delhi. Improve your skills by joining of Drona Training Academy and boost up your career in advanced Tally with GST.

M

Md Aslam Ansari

It was a good experience with Drona Training Academy. They provided me a very good platform to learn and gain enough knowledge in Basic Computer. Their trainer was good and had enough knowledge. I would definitely suggest it for the enthusiast who is willing to gain knowledge in basic computer. Highly Recommended.

O

Ojasvi Chugh

It is a Best Institute for Advanced Excel Training Course, provides a good and creative environment for students. Their faculty was really helpful and educated having years of experience, being really supportive and expressive. Overall it was a good experience to study here.

R

Rubi Rajput

Best for Basic Computer Course, I've joined for basic computer course. As per my learning experience I am very happy with their teaching approach and support. Always recommended.

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

Enquire

Submit your enquiry for Advance Microsoft Excel

Please enter valid question or comment

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 Drona Training Academy

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