An Excel Helper's Cheat Sheet

taurean

Well-known Member
Joined
Jun 17, 2011
Messages
2,179
Office Version
365, 2016
Platform
Windows
this is insanely close to what i was referring to thank you. just wish it was organized in categories, but beggars cant be choosers.
Also there is famous Hiker's list on MrExcel which I remembered later.

@mikerickson As I understood this post is for helper for quick search and not for end users per se. I might be wrong!
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
756
Office Version
2016
Platform
Windows
@mikerickson As I understood this post is for helper for quick search and not for end users per se. I might be wrong!
correct!
I understand end users will be end users. I just want a quick and easy way to navigate useful info to share, templates, and formula basics.
What you've supplied is SO GOOD. i love it thank you.
 

CephasOz

Board Regular
Joined
Feb 18, 2020
Messages
55
Office Version
365, 2016
Platform
Windows
In the same vein, but for personal use, I have a lot of reusable code stored in a "The Guide" file. The Guide uses outlining, so I can keep my code in a structured fashion. (For example, I have a node called "Sort", with a variety of different sort functions as its child nodes.) Whenever I want a piece of code to do something, I open The Guide, and using the structure can usually go straight to the code, copy, paste, and done! Sometimes, when a piece of code can be stored in several different places in The Guide, and I am looking in the wrong place, I just use Ctrl-Shift-F to find what I'm looking for. And because there is a portable version - see The Guide Portable (two-pane outliner) | PortableApps.com - I can load it onto a USB stick and use it on any computer. The only complaint I have with The Guide is that it doesn't understand VBA, so everything is mono-coloured text. (The Guide will also store entire files and graphics, not just text, if you need that.)

A side-effect of doing things this way is I only paste the code that I actually use into a given project. Before I used to wholesale import modules, because 60% of the code in a given module might be used. Now I just compile, and when it complains that a sub/function isn't present, I copy and paste, then repeat the compile to pick up the next one, until there are none missing. Only the necessary code is then present.
 

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
756
Office Version
2016
Platform
Windows
In the same vein, but for personal use, I have a lot of reusable code stored in a "The Guide" file. The Guide uses outlining, so I can keep my code in a structured fashion. (For example, I have a node called "Sort", with a variety of different sort functions as its child nodes.)
Thats a super interesting way to keep organized. Its pretty much the same concept only mine wouldn't be for personal use. I am still working on my helper workbook, but once i'm finished with it i will share.
My version of this emphasizes ease of access to code and automatically copies templates to your clipboard after making a selection, I've even been considering writing entire responses to the most generic questions like "multiple criteria vlookup" and match/index type of things as they are one in the same, just pointing to different columns. I also happen to be a fan of teaching someone how to do things as opposed to just giving them a solution (even though most of the time i just give them the solution)
 

Forum statistics

Threads
1,089,638
Messages
5,409,474
Members
403,265
Latest member
HMR120

This Week's Hot Topics

Top