Excel 2019 instructions

 Posts: 160
 Joined: Tue Feb 20, 2007 9:43 pm
Excel 2019 instructions
Folks,
Do any of you know if the book Excel 2019/2020 for Dummies has sections providing sample problems that you can practice on? If not are there any other books on excel that contain problems for practice?
Thanks in advance.
Do any of you know if the book Excel 2019/2020 for Dummies has sections providing sample problems that you can practice on? If not are there any other books on excel that contain problems for practice?
Thanks in advance.
Re: Excel 2020 instructions
I would use the Excel Is Fun channel on YouTube, it is excellent
Re: Excel 2020 instructions
What are you trying to do? When I was trying to learn Excel I found very slow progress slugging thru a book from A to Z. Only when I started working on a problem I was actually interested in did I start to make progress.
Re: Excel 2019 instructions
Duplicate posts have been merged.
Re: Excel 2019 instructions
You can do so much in Excel it is hard to recommend a book.
I think you are better off either searching for a tutorial online (https://www.exceleasy.com/ is one but I don't know how good it is) or search for what you want to do (e.g., financial, statistical, formatting, specific function like vlookup, etc.).
I do a lot of stuff in Excel, especially with some really large spreadsheets (3,000 rows, 100 columns) but there is a ton of stuff people could ask me about and I'd be clueless because I simply don't do those things.
I think you are better off either searching for a tutorial online (https://www.exceleasy.com/ is one but I don't know how good it is) or search for what you want to do (e.g., financial, statistical, formatting, specific function like vlookup, etc.).
I do a lot of stuff in Excel, especially with some really large spreadsheets (3,000 rows, 100 columns) but there is a ton of stuff people could ask me about and I'd be clueless because I simply don't do those things.

 Posts: 1655
 Joined: Mon Feb 25, 2013 1:34 am
 Location: Southern AZ
Re: Excel 2019 instructions
Over the past 25 years, I have purchased a number of Excel books. A lot of them have some good information. However, they generally sit there to be used less than once a year.
Google and YouTube are probably the best source for problem solving in ANY version of Excel. There are a lot of professionals out there putting together excellent videos that are easy to follow.
Good luck.
Google and YouTube are probably the best source for problem solving in ANY version of Excel. There are a lot of professionals out there putting together excellent videos that are easy to follow.
Good luck.
Re: Excel 2019 instructions
Browse mrexcel.com
Rocket science is not “rocket science” to a rocket scientist, just as personal finance is not “rocket science” to a Boglehead.

 Posts: 2256
 Joined: Mon Mar 27, 2017 10:47 pm
 Location: CA
Re: Excel 2019 instructions
You don't learn computer languages/applications/software unless you have problems to solve which are dear to you. Proficiency with them is not a knowledge, but just a skill. Use it or lose it.
Re: Excel 2019 instructions
When I can't get Quicken to do what I want, I sometimes download Quicken data to Excel as a worksheet. That worksheet, in turn, can be linked to other Excel worksheets to provide others ways of viewing personal financial information.
Just as an example: it's possible to run your grosstonet process far into the future as a simulation of how one's longterm portfolio looks. I find the Microsoft help good for functions that are new to me. Sometimes I spend time building a workaround that I later learn already exists in Excel. Just looking through the list of available functions in the help can be interesting, and may give you an idea of something useful to you.
Microsoft also provides preformatted worksheets that may be something you want or need to do.
I echo the tip from others in this thread: you really learn about Excel when you have a problem to solve. The best problems arise when you're doing something important for yourself or for someone else.
Just as an example: it's possible to run your grosstonet process far into the future as a simulation of how one's longterm portfolio looks. I find the Microsoft help good for functions that are new to me. Sometimes I spend time building a workaround that I later learn already exists in Excel. Just looking through the list of available functions in the help can be interesting, and may give you an idea of something useful to you.
Microsoft also provides preformatted worksheets that may be something you want or need to do.
I echo the tip from others in this thread: you really learn about Excel when you have a problem to solve. The best problems arise when you're doing something important for yourself or for someone else.

 Posts: 160
 Joined: Tue Feb 20, 2007 9:43 pm
Re: Excel 2019 instructions
Folks,''
Thanks you one and all for your excellent input. In general I agree with your observation that you will only learn how to do the excel app(like all other apps) through applying what your learn, As the post from MathMy Way reads" You don't learn computer languages/applications/software unless you have problems to solve which are dear to you. Proficiency with them is not a knowledge, but just a skill. Use it or lose it." Also as jlawrence01 states "Google and YouTube are probably the best source for problem solving in ANY version of Excel. There are a lot of professionals out there putting together excellent videos that are easy to follow."
Also I appreciate the tips from others in this thread relative to using (https://www.exceleasy.com?, Excel is Fun, mrexecel.com.)
FiveK, per your question, I will give you twosignifivcantve examples:
1. My friend whom I am working with would like to be able to evaluate his numerous customers through the use of Statistical signifcance tests on characteristics such as repeat versus non repeat buyers.
2. I would like to be able to review my financial skills through be able to evaluate the results of certain actins I have taken such as rebalancing my portfolio.
Every one have a great weekend.
Thanks you one and all for your excellent input. In general I agree with your observation that you will only learn how to do the excel app(like all other apps) through applying what your learn, As the post from MathMy Way reads" You don't learn computer languages/applications/software unless you have problems to solve which are dear to you. Proficiency with them is not a knowledge, but just a skill. Use it or lose it." Also as jlawrence01 states "Google and YouTube are probably the best source for problem solving in ANY version of Excel. There are a lot of professionals out there putting together excellent videos that are easy to follow."
Also I appreciate the tips from others in this thread relative to using (https://www.exceleasy.com?, Excel is Fun, mrexecel.com.)
FiveK, per your question, I will give you twosignifivcantve examples:
1. My friend whom I am working with would like to be able to evaluate his numerous customers through the use of Statistical signifcance tests on characteristics such as repeat versus non repeat buyers.
2. I would like to be able to review my financial skills through be able to evaluate the results of certain actins I have taken such as rebalancing my portfolio.
Every one have a great weekend.
Re: Excel 2019 instructions
In that case, see Rebalancing Spreadsheets for some examples.mucho dinero wrote: ↑Sat Sep 26, 2020 9:32 am 2. I would like to be able to review my financial skills through be able to evaluate the results of certain actins I have taken such as rebalancing my portfolio.
See also Tools and calculators  Bogleheads and search for "spreadsheet" to find many good examples.

 Posts: 160
 Joined: Tue Feb 20, 2007 9:43 pm
Re: Excel 2019 instructions
Folks,
I need some more advice here. The course excel is fun can only be done with a PC. I have a Mac so the utube course is not compatible with my computer. So does any body know of a similar course oriented to folks using Microsoft Office for Mac software on a apple computer? I am using the Microsoft course on this for now, but I thought there might be some other sources,
Thanks in advance.
I need some more advice here. The course excel is fun can only be done with a PC. I have a Mac so the utube course is not compatible with my computer. So does any body know of a similar course oriented to folks using Microsoft Office for Mac software on a apple computer? I am using the Microsoft course on this for now, but I thought there might be some other sources,
Thanks in advance.