Announcement

Welcome to B4ALLB4U Community Fourm.We have added Akaunting - Free Accounting Software. Online, open source and free accounting software for small businesses. Manage your money. Get invoices paid. Track expenses. With ease!

#1 18-01-2020 16:29:25

B4ALLB4U
Administrator
From: Vijayawada.AP-India
Registered: 17-01-2020
Posts: 39
Website

Daily Excel Tips!

Dear Friends

Here, You can find the most useful Excel Tips.

Use the UPPER(A1) and LOWER(A1) formulas to convert cells containing text to either Upper or Lower case

CdJXrceUUAEbgIM.jpg


"Yeto hasta stato Drushti, Yeto Drushti stato Manaha, Yeto mana stato Bhavaha, Yeto bhavam stato Rasaha"
                                                  "విద్య నేర్పిన ప్రతి గురువుకి పాదాభివందనం".

Offline

#2 19-01-2020 13:42:01

B4ALLB4U
Administrator
From: Vijayawada.AP-India
Registered: 17-01-2020
Posts: 39
Website

Re: Daily Excel Tips!

Hi Friends! Today's Excel TIP

Excel Shortcuts
Shift + Space ->  Selects entire row
Ctrl + Space -> Selects entire column

Cc_A8JTUsAEKnV5.jpg


"Yeto hasta stato Drushti, Yeto Drushti stato Manaha, Yeto mana stato Bhavaha, Yeto bhavam stato Rasaha"
                                                  "విద్య నేర్పిన ప్రతి గురువుకి పాదాభివందనం".

Offline

#3 20-01-2020 08:42:16

B4ALLB4U
Administrator
From: Vijayawada.AP-India
Registered: 17-01-2020
Posts: 39
Website

Re: Daily Excel Tips!

Friends today's Excel Tip

Replace old text with new text using the SUBSTITUTE function. See example below

CclIElhWIAA25sE.jpg


"Yeto hasta stato Drushti, Yeto Drushti stato Manaha, Yeto mana stato Bhavaha, Yeto bhavam stato Rasaha"
                                                  "విద్య నేర్పిన ప్రతి గురువుకి పాదాభివందనం".

Offline

#4 21-01-2020 05:19:00

B4ALLB4U
Administrator
From: Vijayawada.AP-India
Registered: 17-01-2020
Posts: 39
Website

Re: Daily Excel Tips!

Friends today's Excel Tip

Copy data, select Paste Special, check the Transpose box - this will paste your data with a different orientation.

CbhmxrEVAAARrC0.jpg

Screenshot_1.png


"Yeto hasta stato Drushti, Yeto Drushti stato Manaha, Yeto mana stato Bhavaha, Yeto bhavam stato Rasaha"
                                                  "విద్య నేర్పిన ప్రతి గురువుకి పాదాభివందనం".

Offline

#5 01-02-2020 09:04:30

B4ALLB4U
Administrator
From: Vijayawada.AP-India
Registered: 17-01-2020
Posts: 39
Website

Re: Daily Excel Tips!

Use these formulas for simple calculations

In addition to doing pretty complex calculations, Excel can help you do simple arithmetic like adding, subtracting, multiplying, or dividing any of your data.
                         .To add, use the + sign.

                         .To subtract, use the - sign.

                         .To multiply, use the * sign.

                         .To divide, use the / sign.

You can also use parenthesis to ensure certain calculations are done first. In the example below (10+10*10), the second and third 10 were multiplied together before adding the additional 10. However, if we made it (10+10)*10, the first and second 10 would be added together first.
Simple_Math_GIF.gif


"Yeto hasta stato Drushti, Yeto Drushti stato Manaha, Yeto mana stato Bhavaha, Yeto bhavam stato Rasaha"
                                                  "విద్య నేర్పిన ప్రతి గురువుకి పాదాభివందనం".

Offline

#6 25-02-2020 08:32:58

B4ALLB4U
Administrator
From: Vijayawada.AP-India
Registered: 17-01-2020
Posts: 39
Website

Re: Daily Excel Tips!

Thanks a lot to Sele Training for this wonderful video.

The Top 25 tips and tricks for Excel 2016 and above version. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly.  Best trick is #21.  Become more productive using Excel at work, school, and home.

https://www.youtube.com/watch?v=EdnAeqxqdzM


Contents:
1. Quick Analysis Tool 0:47
2. Filter 1:44
3. Drop-Down List 2:25
4. AutoFit Column Width 3:12
5. Transpose 3:47
6. Remove Duplicates 4:13
7. Goal Seek 5:23
8. VLOOKUP 6:55
9. Flash & Auto Fill 9:06
10. Paste Special Values 10:47
11. Images in Charts 11:50
12. IF Function 12:28
13. Insert Screenshot 13:40
14. Absolute Cell Reference 14:15
15. Show Formulas 15:54
16. Text to Columns 16:57
17. Conditional Formatting 18:11
18. PowerPivot 19:36
19. Freeze Panes 20:46
20. Ctrl-Arrow Keys 21:40
21. 3D References 21:58
22. Forecast Sheet 23:43
23. SUMIFS Function 24:16
24. IFERROR Function 25:38
25. Filled Maps 26:30


"Yeto hasta stato Drushti, Yeto Drushti stato Manaha, Yeto mana stato Bhavaha, Yeto bhavam stato Rasaha"
                                                  "విద్య నేర్పిన ప్రతి గురువుకి పాదాభివందనం".

Offline

Board footer