What are some cool Microsoft Excel tricks?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

After the update released by Microsoft Excel in 2010, it has introduced some new and cool features to deal with the Big Data. - One-click to select all: We all know how to select all by using ctrl+A, but there is a small-sized button on the top left of the cell. BY clicking on it, you can select all...
read more
After the update released by Microsoft Excel in 2010, it has introduced some new and cool features to deal with the Big Data. - One-click to select all: We all know how to select all by using ctrl+A, but there is a small-sized button on the top left of the cell. BY clicking on it, you can select all the data at once. - Open Excel Files in Bulk: When you're working with various files, it is a time-consuming task to open one by one. Instead, in the new feature, you can open all the files by selecting the files and clicking on the enter button. - Shifting between different files: When you're working with various projects at the same time, you'll have a problem with shifting between the files. For this, you can use ctrl+tab. This is going to make t easier for you to shift between the files so that you do not mess up anything. - Creating a shortcut menu: Generally, there are three basic shortcuts in Excel- save, undo typing and repeat typing. But, if you want to customize it by adding your own shortcuts, like copy and paste, then you have the liberty of doing that as well. These are some of the shortcuts you can consider; there are hundreds of other shortcuts as well. read less
Comments
Dislike Bookmark

Related Questions

It Can Be Possible To Be Prepare In a week Excel.
Yes.
Afshan
What is Microsoft Excel?
It is an Application which consist of Spread Sheet for creating Document based on requirement
Swati
0 0
5
How to become an expert or tutor in UrbanPro ?
You need to register as tutor, and you can choose which skill you expert I mean which you want to teach and give all the information.
Jenil
What are the benefits of using Excel in business?
Excel is mostly and widely used tool of Microsoft for business purposes, to maintain data, to maintain records as well as to have efficient result through calculations. Excel provides a bunch of formulas...
Vijay
0 0
8
can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Abdul

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

Ask a Question

Related Lessons

Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Phanitha P.

0 0
0
VBA Function - INSTR
INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

Karthik Dale

0 0
0
Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0
0
SQL Union Vs Union ALL
SQL UNION vs UNION ALL Operator Usage UNION: UNION combines the result set of two or more queries into a single result set. UNION removes duplicate records (where all columns in the results are the same). UNION...

Umasankar Natarajan

0 0
0
SQL Join Types
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

Itech Analytic Solutions

0 0
0

Recommended Articles

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Learn Hadoop and Big Data

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 >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Hyderabad
MS Office Software Training in Mumbai
MS Office Software Training in Bangalore
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you