excel real life examples

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I always wanted to know how other users in different industries (Banks, Engineering firms, Government, Hospitals, Accounting firms etc etc) are using Excel. I mean what is important for those users, which topics or features they use the most. Let me give you an example, I know very well how to use Filter but someone showed me a real life example that they used filter to filter data and how the empty cells might cause an issue and how they filter that etc. It is like totally different from what you have learnt about filter. Another example, someone showed me how the spot empty cells and how they give values to these cell that = to the cell above. Another example, how to convert date and time after importing from databbase. These skills you do not learn them from books/courses/online tutorials and videos.. So if you do not practice real life example, is like you are not going anywhere. . Is there any website(s) that shows real life scenarios and how it is solved in excel?
Thank you.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
so can i ask how you use excel such that you are not solving some real life problem or pursuing some purposeful outcome? every time i do more fiddle for 10 minutes and not save a sheet, i am doing something related to work or interests.
 
Upvote 0
This and other Excel-related forums are full of real-life examples you could study...
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top