UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Common MS Excel Shortcuts to make life easier!

S
Shruti S.
10/03/2017 0 0

Hi All,
I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential; mastering it really helps you get insights into your data and helps you make meaningful decisions with raw data. Here I am listing out few shortcuts which are really helpful if you have been using MS - Excel day in day out.

Keys                 Description

Alt+Enter          Useful when you want to continue writing text in the same cell

F7                    to activate a spellcheck on your worksheet

CTRL+ ;            to insert current date

CTRL+shift+;    to insert current time

shift+spacebar   select entire column

CTRL+spacebar  select entire row

CTRL+F6            to toggle between open workbooks

ALT+h+m+m     to merge cells

Hope you find this post useful.

Happy Learning!!

0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Practical use of Two way Look-up (Category: Advanced Excel)
///////////////////////////////////////////////////////////////

Dget-Extract From A Database A Single Record That Matches The Condition We Specify
Syntax: DGET(Database, Field, Criteria) The DGET function syntax has the following arguments: Database Required: The range of cells that makes up the list or database. A database is a list of related...
D

Daniel I

1 0
0

Hidden Gems Of MS Excel - Sort (add Multiple Levels to Sort Data)
Please refer following dataset: You would know:- To Sort Month from Oldest → Newest OR Newest → OldestOR- To Sort Region from A → Z OR Z → AOR- To Sort Units Sold from Smallest →...

Create a Grading in Excel using Formulas (All versions)
Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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