create account

20 Tricks That Can Make Anyone An Excel Expert? by deathcross

View this thread on steemit.com
· @deathcross ·
$101.30
20 Tricks That Can Make Anyone An Excel Expert?
![lifehack 20 Tricks That Can Make Anyone excel-1771393_1280.jpg](https://cdn.steemitimages.com/DQmdDLHLDq6KhZk2YCxHb5F9dpm99vAqk81AWzX5tiZ3sPg/lifehack%2020%20Tricks%20That%20Can%20Make%20Anyone%20excel-1771393_1280.jpg)

_(Second part.)_ MS Excel and similar office, business software packages are very complicated and in reality you can’t find 20, nor 30 tricks and say then automatically “I’m an expert”. I think the solution is learning how to solve problems and how learn every new tricks and features you meet, or you can need. 
# Social needs, individual researches
For example, for some people it is very important how tables, reports, queries look in Excel or Word, they need to master the formatting in the software. Fort others, this is not important, for example for speculators or entrepreneurs making analysis for their own, to support their own investment decisions. 

And others can use the built-in functions, templates, styles, format painter to give a readability-friendly look to the sheet or chart, but they need only the standard tools. Some need only basic functions and some use the advanced financial or the database functions. Some are making charts all the time, others are calculating accounting tables or statistical indicators. 
# Dozens of guru builders
The last time I gave you 9 advice, now I owe you 11 more. But the best advice is, I think, to teach you to find the solutions in every situation. There are at least 20-30 posts with a similar title ([20 Tricks That Can Make…](https://duckduckgo.com/?q=20+Tricks+That+Can+Make+Anyone+An+Excel+Expert&ia=web)). Different hotkeys, shortcuts, mouse clicks, searching methods etc. 
# From two to three dimensions
All seem to be good ideas, but I’m not sure I need them. Maybe I need something different. Some time ago, for example I needed three-dimensional lookup. I often use functions “vlookup” and “hlookup” to extract a value from a table. For example, here:

![lifehack 20 tricks that can make0.jpg](https://cdn.steemitimages.com/DQmefGmhWtctgYPRpg9iyRgpm8oCU1o6YVr5otsPmc51ra5/lifehack%2020%20tricks%20that%20can%20make0.jpg)

There are two dimensions, companies, and countries. Rows and columns. But if you complete it with a third dimension, or field, the year, you have an advanced, 3 dimensional table:

![lifehack 20 tricks that can make.jpg](https://cdn.steemitimages.com/DQmdyomUjaDHAoqsRS9cqTcZw8e6JFviP121y4tiDefBbJT/lifehack%2020%20tricks%20that%20can%20make.jpg)

If you search for “3 dimensional lookup” or “three-way lookup”, you find for example, [this 7 minutes video](https://www.youtube.com/watch?v=zjfpA2kJhm8) and a simple trick. You can easily concatenate (join) the two criteria, with the “&” sign and search for this new string in the array. (Or, you can use a pivot table first.)
# Not only hotkeys or mouse clicks
If you look at the video again you see it is the “Excel Magic Trick 781” – incredible how many Excel teachers and lessons are there on Youtube. Thousands of tutorials, you only have to find the right one. If you have problems with financial functions, you could [begin here](https://www.youtube.com/results?search_query=excel+financial+functions), if you need to learn pivot tables, you can [do it here](https://www.youtube.com/results?search_query=excel+pivot+tables). 

I recommend you also this [article of Business Insider](https://www.businessinsider.com/excel-tips-and-tricks-2017-11), teaching some important advanced functions, and not only hotkeys or mouse strokes like many other posts. 

_([First part here.](https://steemit.com/lifehack/@deathcross/20-tricks-that-can-make-anyone-an-excel-expert))_

_(Picture: Pixabay.com)_
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 1558 others
properties (23)
post_id76,159,132
authordeathcross
permlinkbdcxt-20-tricks-that-can-make-anyone-an-excel-expert
categorylifehack
json_metadata{"tags":["lifehack","excel","productivity","tricks","work"],"image":["https:\/\/cdn.steemitimages.com\/DQmdDLHLDq6KhZk2YCxHb5F9dpm99vAqk81AWzX5tiZ3sPg\/lifehack%2020%20Tricks%20That%20Can%20Make%20Anyone%20excel-1771393_1280.jpg","https:\/\/cdn.steemitimages.com\/DQmefGmhWtctgYPRpg9iyRgpm8oCU1o6YVr5otsPmc51ra5\/lifehack%2020%20tricks%20that%20can%20make0.jpg","https:\/\/cdn.steemitimages.com\/DQmdyomUjaDHAoqsRS9cqTcZw8e6JFviP121y4tiDefBbJT\/lifehack%2020%20tricks%20that%20can%20make.jpg"],"links":["https:\/\/duckduckgo.com\/?q=20+Tricks+That+Can+Make+Anyone+An+Excel+Expert&ia=web","https:\/\/www.youtube.com\/watch?v=zjfpA2kJhm8","https:\/\/www.youtube.com\/results?search_query=excel+financial+functions","https:\/\/www.youtube.com\/results?search_query=excel+pivot+tables","https:\/\/www.businessinsider.com\/excel-tips-and-tricks-2017-11","https:\/\/steemit.com\/lifehack\/@deathcross\/20-tricks-that-can-make-anyone-an-excel-expert"],"app":"steemit\/0.1","format":"markdown"}
created2019-06-10 14:47:54
last_update2019-06-10 14:47:54
depth0
children2
net_rshares169,490,066,579,495
last_payout2019-06-17 14:47:54
cashout_time1969-12-31 23:59:59
total_payout_value77.094 SBD
curator_payout_value24.208 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length3,662
author_reputation611,880,575,751,820
root_title"20 Tricks That Can Make Anyone An Excel Expert?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1622)
@linita70 ·
buen post , muy util yo utilizo mucho el excel en mi profesion de contador publico, gracias
👍  
properties (23)
post_id76,168,311
authorlinita70
permlinkpsw9ph
categorylifehack
json_metadata{"tags":["lifehack"],"app":"steemit\/0.1"}
created2019-06-10 17:54:36
last_update2019-06-10 17:54:36
depth1
children0
net_rshares17,746,271,820
last_payout2019-06-17 17:54:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length91
author_reputation85,989,306,113
root_title"20 Tricks That Can Make Anyone An Excel Expert?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@arcange ·
Congratulations @deathcross!
Your post was mentioned in the [Steem Hit Parade](/hit-parade/@arcange/daily-hit-parade-20190610) in the following categories:

* Upvotes - Ranked 6 with 1598 upvotes
* Pending payout - Ranked 9 with $ 93,32
properties (22)
post_id76,215,273
authorarcange
permlinkre-bdcxt-20-tricks-that-can-make-anyone-an-excel-expert-20190610t175923000z
categorylifehack
json_metadata{}
created2019-06-11 15:59:30
last_update2019-06-11 15:59:30
depth1
children0
net_rshares0
last_payout2019-06-18 15:59:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length237
author_reputation163,430,584,272,314
root_title"20 Tricks That Can Make Anyone An Excel Expert?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000