What are the best time-saving tips for Excel?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Excel by Microsoft was mainly created to maintain massive amounts of data in an orderly manner and perform calculations on them. There are hundreds of shortcut keys in MS Excel, which are used mainly to make the task easier and save time. Some of them are: Ctrl + A: To select all the data Ctrl + C: It...
read more
Excel by Microsoft was mainly created to maintain massive amounts of data in an orderly manner and perform calculations on them. There are hundreds of shortcut keys in MS Excel, which are used mainly to make the task easier and save time. Some of them are: Ctrl + A: To select all the data Ctrl + C: It will copy all the selected data Ctrl + V: It will paste the selected data Ctrl + End: It will take you to the clast cell of the sheet Ctrl + Home: It will take you to the first cell of the sheet Ctrl + Up Arrow: It will take you to the first colour you're working on Ctrl + Down Arrow: It will take you to the last cell of the column you're working on Shift + Space: It will select the row(s) of your active cell(s) Ctrl + Space: It will select column(s) of your active cell(s) Shift + Space: It will select row(s) of your active cell(s)v Ctrl + minus sign: It will give you Delete options Apart from these, there are other tasks which can be performed in Excel: -Copy Formula Down - Copying values or formulas - Total a Column or a Row - Delete Duplicate Rows - Add Leading Zeros - Repeat Header for Print - Create Named Ranges If you're looking for a position of a Banking Analyst, then you'll have to learn Advanced Excel to make your tasks simpler. read less
Comments
Dislike Bookmark

Related Questions

What is the fee for advance excel course?
It's depend how advanced excel you want to learn, only advanced 2k, Micro with vba 5k
Prabir
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
What is the difference between an MS word, an MS Excel, and an MS PowerPoint?
All three are applications of Microsoft office. MS Word is a word processing application, where you can type anything you want, primarily used for creating documents, brochures etc. MS Excel is a spreadsheet...
Krishna
0 0
View Comments5
What are the 5 most essential excel tools to master?
tools? Is that right, is that what you wanna know? there is no such thing as tools inbuilt in excel. Tools are specifically designed for a set of people or a company for a specific purpose to be added...
Yashraj
0 0
View Comments6
Dear sir,how to convert number to text in excel by formula?
To get a range of time, you first need to convert the time in Text format and then merge them. You can use the following TEXT Formula: = TEXT( B4, “hh:mm” ) & ( ” – ”...
BINAYAK
0 0
View Comments8

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

Ask a Question

Related Lessons

Newspaper columns
One of the many wonderful features included in MS Word is newspaper columns. With the help of Drop Cap, Multi column features and with Section breaks one can create wonderful articles just as it appears in a Newspaper.

Ramesh Kn

0 0
View Comments0
What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...

Itech Analytic Solutions

0 0
View Comments0
HTML (Hypertext Markup Language)
HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...

Itech Analytic Solutions

1 0
View Comments0
Mail Merge In Word
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used...

Itech Analytic Solutions

0 0
View Comments0
Chart
A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...

Itech Analytic Solutions

0 0
View Comments0

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 >

8 Hottest IT Careers of 2014!

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 >

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 >

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 >

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

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