What are some effective Microsoft Excel tips?

Asked by Last Modified  

2 Answers

Learn Microsoft Excel Training +2 Basic Excel Advanced Excel

Follow 3
Answer

Please enter your answer

Debarpan Sarkar

Tutor

Try to learn short cut key of excel . It will reduce your time during work in future
Comments
Dislike Bookmark

Only use keyboard for working on excel. You need to be efficient while doing anything on MS Excel. Some basic keyboard shortcuts are listed here https://support.office.com/en-us/article/keyboard-shortcuts-in-excel-for-windows-1798d9d5-842a-42b8-9c99-9b7213f0040f
Comments
Dislike Bookmark

Related Questions

What is shortcut to rename the spreadsheet name?
Alt+H+O+R
Umang
Is MS Advanced Excel training very costly?
cost of learning basic and advance excel will be around 7000 to 12000 rs. but you should also focus on quality education where it will be worth of paying. It will be better to discuss on UrbanPro with tutors and get idea.
Pritty
0 0
5
My name is Kartik, I have 6 years of experience in Data analysis. I have experience on BI, Trackwise, Siebel and Oracle, Ms Access for fetching reports and for visualisation of data we use MS excel. Could please suggest me a certification or course, which can help me in career growth and to improve my skill set? I have a bent towards Analytics.
Hi Kartik, It is very good to know your experience in the field of Data Analytics. You just master those skills so that it is easy to sell your skill. I believe you are good at BIG DATA. If you possess...
Kartik
0 0
5
Why do we use a dollar sign in Excel?
A dollar sign $ is called a locked cell reference. Locked cell references are one of the building blocks of Excel modeling. Without them, you will waste endless amounts of time re-writing formulas.
Poonam
0 0
8
How do I rename a worksheet in MS Excel?
Double click the worksheet name, then replace the existing name with a new name and press the enter key
Dhanshri
1 0
7

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

Ask a Question

Related Lessons

Shortcut of Excel for Selection
Select the whole column: CTRL + SPACE Select the whole row: SHIFT + SPACE Select table: SHIFT + CTRL + SPACE bar Select visible cells only: ALT + ; Select entire region: CTRL + A Select range from...

Shashank Maheshwari

1 0
0
How to create drop down function in Excel?
Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...

Ayush Agarwal

1 0
0
Excel Tip: VLOOKUP formula limitations
1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns 1st found value 3. Vlookup cannot pull values which are on the left side from Lookup column 4....

Karthik Dale

0 0
0
What is the difference between Analytics and analysis?
Analysis> Separation of a whole into its component parts> Looks backwards over time, providing marketers with a historical view of what has happened Analytics > Defines the science behind the...

Itech Analytic Solutions

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

Space Base

0 0
0

Recommended Articles

Why Should you Learn Microsoft Office

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 >

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 >

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 >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Ghaziabad

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