How to learn Excel & fast!

I'm a novice user of Excel; however, my job has taken a turn where I need to become an Excel master.. and fast. Any advice? Watched a few YouTube videos, but damn they're boring. I need to especially improve at making formulas and of course creating spreadsheets. I typically am the user of someone else's spreadsheets, but this is apparently going to need to change quick.

 

I don't know much beyond the basics but here is an excerpt about formulas linked to the rest of the article

"4. Learn how to master Excel formulas
One of the main ways to master Excel is to be accomplished at writing formulas. These are the muscles of Excel.

From performing basic calculations in cells to using more advanced formulas - you will stand head and shoulders above the rest if you have this skill.

If you are new to formulas, start with creating basic calculations that add, subtract, multiply and divide values.

Then begin to learn some of the more commonly used functions. These include SUM, IF, VLOOKUP, COUNTIF, and CONCATENATE.

When you are comfortable writing formulas, you can do almost anything. You can even use formulas within Conditional Formatting rules, charts and other Excel features to make them more powerful.

Check out some of our favorite Excel formulas and functions."

 

Thank you so much Moon Goddess, I'm going to check it out. I appreciate you replying with a great article!

 

The biggest mistake with Excel, as with all computer programmes, is people assuming that they have magic powers. Nothing can ever be any better than the data you are working from, which all too often is not in full months or years.
When estimates are included (such as in estimated meter readings) putting them on a spreadsheet is a total waste of time.

 

I understand your point, but in today's working environment, what can be measured is treasured, and the services my specific job performs is full of things that can be measured.

 

Error - I posted in the wrong thread

 

I have done that more than once. It was quite embarrassing.
I just blamed my age and being HF's nutty professor.

 

I am sure that you are not guilty, but I see it quite a lot.
When I was at college, I was asked to describe the internet. My answer, "The world's largest dustbin", certainly got a few laughs. LOL