What is the most underutilized feature or trick in Microsoft Excel?

Asked by Last Modified  

4 Answers

Follow 2
Answer

Please enter your answer

IT Corporate Trainer with 9 years of experience in Edu tech

FORMAT PAINTEROne of the most underused formatting features, Format Painter allows you to copy formatting from one cell or group of cells to another.
Comments

Software Engineer with 10+ years of experience in IT industry

Some of the formulas like VLOOKUP, HLOOKUP are very useful but often underutilized. VLOOKUP is used to lookup values in a table vertically whereas HLOOKUP searches for values horizontally.
Comments

Quick tool button
Comments

I am online Quran teacher 7 years

Quick tool button
Comments

View 2 more Answers

Related Questions

Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Profile Photo
Ramkumar
0 0
View Comments7
What should I learn other than excel VBA training?
Excel VBA is a Very vast topic. Once you will start working on real life projects you will find your knowledge is always short. You can always learn VBA with Excel, Word, Powerpoint, Access, AutoCad, Soldiworks....
Profile Photo
Vishal
What is exact number of days required to learn basic & advanced excel?
10-15 days sufficient but you need practice on that.
Profile Photo
Anusha
I am looking to learn immediately Advanced Excel & VBA Macros. Please provide the Institute contact details and tutor availability in week ends ( Sat- Sun) .
Hi Pratap, Would you please let me know your educational background as to know VBA Macros , you must have good hands on Programming...and if you are novice or not from it background then I suggest you...
Profile Photo
Prathap

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.
In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...
Profile Photo

Auto calculation using IF and SUMIFS
https://vz-3ad30922-ba4.b-cdn.net/349b6f4a-22df-47fd-ba77-0ca6490db39f/play_480p.mp4
Profile Photo

Space Base

0 0
View Comments0

Generate Employee Payslip using Excel & VBA Macros
yes we can generate the Payslips for each employee from a huge data in the excel. We can generate a separate Excel sheet for each employee and also can create Payslip Excel files with the names of the...
Profile Photo

HERE TODAY WE WILL USE THE SUMIF FUNCTION
A B C 1 PRODUCT NAME TOTAL AMOUNT 2 WASHING MACHINE 3616 3 MI PHONE 4978 4 SAMSUNG MOBILE 3825 5 NOKIA PHONE 3902 6 T.V 3759 6 L.G REFRIGERATOR 3693 7 BOTTLE 4191 ...
Profile Photo

Exploring Excel HLOOKUP Formula
Let's break down HLOOKUP in detail. What is HLOOKUP? HLOOKUP (Horizontal Lookup) is an Excel function that searches for a specific value in the first row of a table and returns a value...
D

Deleted U.

0 0
View Comments0

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you