advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Best place to learn the next level of Excel?
Posted by: Buck
Date: July 09, 2020 11:14AM
I'm NOT sure sure of my level, but I need expand my knowledge of formulas.
Just youtube it until I find the right place?
Example:
I need to master this type:
=IFERROR(VLOOKUP($B16,'Stuff'!$A$3:$J$573,2,FALSE)/$F16,0)



Edited 1 time(s). Last edit at 07/09/2020 11:18AM by Buck.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: NewtonMP2100
Date: July 09, 2020 11:17AM
....so you want to excel.....at Excel......???



_____________________________________

I reject your reality and substitute my own!
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: freeradical
Date: July 09, 2020 11:19AM
Get some tutorial book that includes practice files.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: Buck
Date: July 09, 2020 11:19AM
No I don't need to excel at it. I just need what I needsmiling smiley
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: John B.
Date: July 09, 2020 11:38AM
I've used this site a few times for references/tutorials:
[chandoo.org]
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: Todd's keyboard
Date: July 09, 2020 12:30PM
My local library offers its patrons free access to all of the lynda.com courses. I can't speak from personal experience with specific Excel courses and have been happy with other lynda courses.

Todd's remote keyboard
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: flightdelayedagain
Date: July 09, 2020 12:45PM
I used this site in the past and got several good tips and formulas:

[www.mrexcel.com]
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: davester
Date: July 09, 2020 12:53PM
Quote
flightdelayedagain
I used this site in the past and got several good tips and formulas:

[www.mrexcel.com]

Ditto. I use that site all the time.



"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: mikebw
Date: July 09, 2020 02:31PM
Quote
davester
Quote
flightdelayedagain
I used this site in the past and got several good tips and formulas:

[www.mrexcel.com]

Ditto. I use that site all the time.

Yep, I've been there many times. Probably even asked around here too.

Not sure I would recommend you take a class or buy anything, I tend to just research how to accomplish whatever it is I need to do at the time, seems to work out.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: N-OS X-tasy!
Date: July 09, 2020 02:42PM
Excel has some pretty decent in-app help for formulas that explains the required argument(s) for each formula and what they are. That, combined with the online resources recommended by others in this thread, will take you pretty far.



It is what it is.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: cbelt3
Date: July 09, 2020 04:12PM
Feel free to ask here... for example.. the stuff in bold and red should not be there.
=IFERROR(VLOOKUP($B16,'Stuff'!$A$3:$J$573,2,FALSE)/$F16,0)
=ISERROR( Formula) = TRUE or FALSE (IFERROR is not a valid function)
=VLOOKUP( Reference , Range , column number , FALSE) produces a value or #N/A . FALSE is there to force exact matches between Reference and the first column values in Range



Edited 1 time(s). Last edit at 07/09/2020 04:12PM by cbelt3.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: Don C
Date: July 10, 2020 12:23AM
Back in my working days I used mrexcel.com quite a bit and learned some very helpful functions. VLOOKUP was probably the most important function I used regularly.

Intern with us went off to Purdue to grad school where he took an Excel course. He told us that in the first 15 minutes of the first class he learned more about Excel than he had in his entire (young) lifetime.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: Buck
Date: July 10, 2020 11:55AM
Thanks everyone. Looks like I have a busy weekend coming up.
Options:  Reply • Quote
Re: Best place to learn the next level of Excel?
Posted by: davester
Date: July 10, 2020 12:25PM
Quote
Don C
Back in my working days I used mrexcel.com quite a bit and learned some very helpful functions. VLOOKUP was probably the most important function I used regularly.

Intern with us went off to Purdue to grad school where he took an Excel course. He told us that in the first 15 minutes of the first class he learned more about Excel than he had in his entire (young) lifetime.

That's not surprising. Many of the young folks where I work have no idea how to use a spreadsheet. Many think it's just a tool for making pretty tables so their spreadsheets are not structured to work as calculation tools. I can commonly be heard moaning "why did you put mixed text and numbers in the same cells, and why is the format different in every row!"

Most of my spreadsheet knowledge was gained when my group purchased this weird program called Lotus 123 v1 in 1985. I picked up a book describing how to use it and read it cover to cover while using Lotus to process a huge amount of data from my PhD research. That basic knowledge continues to help me to this day, even though Excel has far more functionality than that early version of Lotus.



"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 173
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 2330 on October 25, 2018