![]() How many tellers should you have working? ![]() > Suppose it costs $20 per hour to have a teller working, and you value a customer's time at $15 per hour. > Based on the past on how long it takes to clean your house, If you start cleaning at noon, what are the chances that you will be finished in time to leave at 7:00 PM for a movie? > How to forecast one quarter ahead revenues of Apple? > How are monthly stock returns of Microsoft, GE, and Cisco Related? > Create a Pivot Table that gives average salary broken down by department? How many people need to attend to break even ? > You have a paid event with multiple fee levels and several expenses. > Write A formula to calculate the distance between two cities Use it as a checklist to see if you will find the book helpful. SOME EXAMPLES: Here are some examples of what you can accomplish with this book. Each chapter has anywhere between 10 -20 exercises, and if you diligently do them, you can be pretty confident that you have a reasonable functional mastery of the subject. The best thing about the book are the exercises. I have used excel for very long time but this book just takes your excel skills to whole another level. Winston's website and I am just an alum of his. Not trying to sell anything as this is Dr. I'm jealous because I just paid a ton of money to take his classes when I could have just watched his videos.I am only posting this here because some of the reviews said that they would like to see the videos if possible. You can find it by googling excelwithwayne (fitting name). Winston yesterday and he said that his site is up! Just checked it out and there is a lot of free content showing how to work some of the examples in his book. I am not sure of the website, but once he tells me I will update this review again. He said that currently there are around 200 videos explaining lots of the topics in his books. Winston and he mentioned that he was in the process of putting his courses up online. He is very good at explaining these concepts to somebody like me that doesn't come from a heavy quantitative background. There is a reason why he has won all of the awards that he has (google his name and Indiana University). I am biased as I have learned quite a bit from Dr. So you get to learn a ton of the really cool functions in excel, how they work together in nested formulas, and how they could directly benefit a company/organization (just from one chapter). ![]() ![]() In doing this you will learn how to use excel's solver model (constraints, changing cells, linear models, non linear.etc), vlookups, nested if statements, and several other functions in excel. This is the WHY (and was our week 1 homework problem in his class). In other words, if you wanted to build a model to help a company maximize profit by determining which limited resources to put into play (labor, materials, $$) based on the revenue of each product, this book teaches you. This book teaches you the WHY while also teaching you the HOW. They walk you through the different formulas and teach you how to do them. The big difference between this book and every other excel book (I have purchased several) is that the other ones teach you HOW to use excel. Winston's class.Īfter reading the other reviews about how this book is challenging to get through, I completely agree. Now that I am finishing up the MBA program (final semester), I have started a consulting company using the exact methods out of this book that I learned in Dr. Winston's course(s) and realized that I only took away from the previous books what was applicable to my daily excel needs for my job. After purchasing the other popular excel books and working through them, they helped a lot. Winston's at the University of Houston.Ībout two years ago (before I started the MBA program) I felt like I could work my way around a spreadsheet. Practice with over 900 problems, many based on real challenges faced by working analysts.Caveat: I am a student of Dr. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |