UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

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

Some Excel Functions

I
ICreative Solution
08/12/2016 0 0
You need to know about these following functions which are based on Microsoft Excel 2010.

1. Speedily Move and Copy Data in Cells:-
If you want to move one column of data in a spreadsheet, the fast way is to choose it and move the pointer to the border, after it turns to a crossed arrow icon, drag to move the column freely. & if you want to copy the data then You can press the Ctrl button before you drag to move; the new column will copy all the selected data.

2. Compose Text with &:-
Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below.
Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.


3. One Click to Get More Status:-
Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value.
But for more status you can move the pointer to the bottom tab and right click to get more status, as shown in the image.


4. Hide Data Thoroughly:-
Almost all users know how to hide data by right clicking to select the Hide function, but this can be easily noticed if there is only a little bit of data. The best and easiest way to hide data thoroughly is to use the Format Cells function. Choose the area and go to Home->Font->Open Format Cells->Number Tab->Custom->Type ;;; -> Click OK, then all the values in the area will be invisible, and can only be found in the preview area next to the Function button.
0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

TODAY WE LEARN MAX FORMULA, HOW TO USE IT.
1 A B 2 NAME SERIES 3 Vinita 50 4 Vimlesh 34 5 Karina 73 6 Kartrina 18 7 Salman 65 8 Gold 48 =MAX(C3:C8) ANSWER- 73 =MAX(NUMBER 1, NUMBER 2)

What is a Dashboard?
Introduction There are many different ideas of what a dashboard is. This article will clearly define it along with other presentation tools. In article, What is BI? - A Business Intelligence Primer, it...


Lookup Reference Formulas
MS Excel Formulas - Lookup Reference Formulas

HERE TODAY WE WILL USE THE SUMIFS FUNCTION.
A B C D 1 NAME PRODUCT NAME TOTAL AMOUNT 2 SAURABH WASHING MACHINE 4165 3 MANIPAL MI PHONE 4803 4 ANJALI SAMSUNG MOBILE 4610 5 UMA NOKIA PHONE 4441 6 SHANKER T.V 3765 7 NARESH ...
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