Also op, when you get to a real issue, YouTube it.

Someone somewhere has solved it already.

Txl

My old boss showed me 3 workbooks his last day of work. I now have his job and spend a good amount of time in those workbooks. Google was my friend.

super TAG

With a little care in the table/data structure, an Access DB can migrate easily to SQL if the need grows, as well.  Access is pretty damn powerful, for what it is.

Learn how to use the question mark button.

Don't use the question mark button.  It has sucked ass for the last several years.  Just Google your problem instead.  You'll get much better results.

No hate, stupid people allow me to charge ridiculous amounts of money to fix companies.

ZOMG!! Pivot tables! So hard.......

Our quality engineer at work came down and was wanting us to put tolerance data in a spreadsheet and asked me why we don't have excell on our floor computers. I told him we're not smart enough to use it . He then looked at me like.

How do I upgrade from Lotus 1-2-3?

You can't. You can only downgrade to Excel, and Excel clones. Sorry, but anyone who has a Heavy Metal image as an avatar should know that.

well, considering the only ones we ever dealt with were created by this one guy and none of us had a good experience,
I'm willing to bet it had a lot to do with what he created.
No big deal, I'm not going to lose any sleep over it.. you can have my share

and exact
 

That's how I did it. I made my own accounting software from scratch with Access and Excel.


 

Oh yeah, that's a totally reasonable alternative.

Anytime I take over someone's job (and I do that a lot more frequently than I'd like) I generally set as my first task the purging of their tools and crutches, Excel workbooks are priority ONE.

If you're using Excel as a standalone application, you're doing it wrong. Oh, you can do it, but it'll never be "correct" and it will always be vastly more fragile and more difficult work.

Excel is the "answer" that virtually everyone with a passing familiarity with computers migrates to. It's almost *always* the wrong answer.

There are COTS packages that do what you want Excel to do and do it properly, with scalability. You can hire a dev to write you an application to do *precisely* what you want to do, probably a LOT cheaper than you think.

Please, stop bending a spreadsheet program into a hybrid/bastard database, calendar, inventory, accounting, reporting, invoicing, tax and HR tool.

That's not what Excel is for. Oh, it *can* do all that shit but, it *shouldn't* be doing any of it.

I say this as a guy who has, long ago, mastered the program.

For the OP, the best way to learn how to use an application as wide and deep as Excel is to start having problems and work toward solving them with the application. You're never going to get far trying to do it by rote memorization of the, literally, millions of ways of doing "stuff."

Or Project.



My latest use for Excel was to create a spreadsheet to analyze the cost per round to purchase XM193 from various vendors. The output was cost per round for each increment of ordering (20 or 90 rounds per box) and included shipping cost per round. I could see the increments where I could buy more boxes without an increase in shipping cost so free shipping on those boxes was essentially free. More boxes with free shipping. Nice!

Using a jackhammer to crack walnuts, sure. But it was fun, gave me practice.