Excel Library

DeaninGA

Board Regular
Joined
May 20, 2013
Messages
146
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
So after several years of doing the impossible with Excel. I started a new job recently where my primary function will revolve around pulling in data (of all types) and turning it into something usable.

So I've collected a small library of resource material. My question is what ( Books, Resources, etc.) do you keep within arms reach at your desk? Peanut M&M's and 5 hour Energy already stocked for any ":rofl:Emergency:rofl:" that should occur .

Thank you in advance,
Dean
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
No books.....I have learnt what keywords and phrases are the most relevent and plug 'em in to Google.
The world keeps changing and stuff I have in my favourite book of VBA has been superceded by different methods,
Have a look, for example, at any post by someone like Rick Rothstein and see how we code now compared to a few years ago.
I know the code was always there, but we seem to interpret and write differently.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

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