(Part 2) Best spreadheet books according to redditors

This one is a great read.

The only book you'll really need.

Hey,

Maybe you'll find this interesting:
https://www.amazon.com/Practical-Astronomy-your-Calculator-Spreadsheet/dp/0521146542


I haven't read the book, but by description,
"...this new edition shows you how to use spreadsheets to predict, with greater accuracy, solar and lunar eclipses, the positions of the planets, and the times of sunrise and sunset. Suitable for worldwide use, this handbook covers orbits, transformations and general celestial phenomena, and is essential for anyone wanting to make astronomical calculations for themselves...",
it may be what are you looking for.

The only book for excel I've ever bought(so far) is

http://www.amazon.co.uk/Excel-2007-Bible-John-Walkenbach/dp/0470044039

but this was to learn a lot of the fundemental stuff that you metion already having down.

My biggest suggestion would be to practice, practice and practice some more. That's mostly why I'm on here tbh. If there's something you'd like to understand a bit more about I'd suggest just starting a new thread on here and asking. More than likely you'll have someone come along and explain it to you.

Try to find a good general course on data analysis for Excel.
Nothing beats having good Excel skills when you are an analyst.

https://www.amazon.co.uk/Excel-Data-Analysis-Dummies-3rd/dp/1119077206/ref=dp_ob_title_bk

Edit: the most important thing though is actually writing and presenting reports. This consist of finding the insights and not overflowing your reader with data, overcome the urge to report everything but dig to find the gold and only report that. And then be able to "sell" it during a presentation. Create a story.

The help function works wonders. Because when you use that, you also learn why you might need a specific function. I have also noticed that you can google whatever you want to learn, especially something computer related like this.

Like someone else pointed out, forums are great.

Also, if you're looking for suggestions for Excel books, I recommend Mike Smart's Learn Excel 2007

As others have said, if you have 2013 it is not worth buying 2016.

However the book: Excel 2016 VBA and Macros has some very useful material and is quite different than the dummy books.

I mean, there's a lot of textbooks out there. Some are even dedicated to Charts and Graphs. But I genuinely feel there's enough Excel tutorials out on the web that buying a textbook may be a bit useless.

I had to take a class about computers in business, and we spent a long time on Excel. This is the book we used. It's very readable and covers everything from the absolute basics to creating lookups and I think pivot tables. It's written for Word 2007, but there aren't really any major differences between it and the 2010 edition. Hope that helps!

https://www.amazon.com/dp/1119514924/ref=cm_sw_r_cp_awdb_t1_TUriDb8ZQMH18

I just bought this book for the same reason, and I have found it tremendously helpful. I am reading it cover to cover. It’s like 750 pages.

My recommendation is not a YouTube channel, but a book: Pivot Table Data-Cruching

Check the book "excel advanced report development" http://www.amazon.com/Advanced-Report-Development-Timothy-Zapawa/dp/0764588117

[Teach yourself in 24 hours] (https://www.amazon.com/Teach-Yourself-Microsoft-Excel-Hours/dp/0672314452)

In my job, knowing vba has really helped me out and allowed me to pursue a lot of opportunities.

It's a really good start point. It's easy to pick and widely used. It is by no means the be all and end all.

I learnt a real lot from the following books,

http://www.amazon.com/Microsoft-Excel-Programming-Absolute-Beginner/dp/1598633945

http://www.amazon.com/Engineering-Excel-Edition-Ronald-Larsen/dp/0132788659

Also, check out CS50 from Havard. It's a great free, introductory course that will help you get your head around the basics.

The ____ for Dummies guides are always a good place, but if you want to get serious into understanding Excel you might just want to get the appropriate text book. That way if you want you can use it to get Microsoft Certification for it.

Here's some: It depends on which version of Microsoft Office you have:

• Textbook 1
  
  
• Textbook 2
  
  
• Textbook 3
  
  
• Dummy's Book 1
  
  
• Dummy's Book 2
  
  
• Dummy's Book 3
  
  Microsoft even offers some basic training courses by itself

Basically, a pivot table is a way of summarizing and visualizing a bunch of data analysis operations and results. It's kind of hard to describe, but Wikipedia has a pretty decent explanation of pivot tables.

To play around with one, go the the Excel "Data" tab and create one. Make sure you have some data available to use in the pivot table. It doesn't need to be a lot...perhaps five or six columns, and a dozen or so rows. Again, Wikipedia has a couple of screen shots that provide good examples.

If you can part with a few bucks, this is a pretty decent book for learning about them

Pivot tables are awesome. If you are going to be using Excel, I seriously encourage you to take some time and learn how they work.

The For Dummies series is fabulous, you can't go wrong with it.

I bought this one back in the day

https://www.amazon.com/gp/product/0470044020/ref=oh_aui_search_detailpage?ie=UTF8&psc=1

John Walkenbach is the author, I think he has an updated version for at least 2010.