So here’s a funny You know how to use Excel. You know how to create simple workbooks. And how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But sometimes you wish that you could do more with Excel, such as how to use Excel to really gain insights into information, the data, that you work with in your job. Using Excel for this kind of stuff is what Excel Data Analysis For Dummies is all about. This is a book that assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information you’re already working with in Excel. Ready to take Excel to the next level? This plain-English guide covers all of these concepts, and more, to ensure that you’re using Excel to its fullest If all this talk of statistics and advanced tools makes you light-headed, don’t worry. Excel Data Analysis For Dummies distills the most important fundamentals into everyday language. You’ll find just enough information to help you get your work done – without leaving you gasping for air in a sea of technobabble. It’d be a real shame if you didn’t at least know what bells and whistles Excel has to offer and the basic steps that you need to use them.
Librarian Note: There is more than one author on goodreads by this name.
Stephen L. Nelson (b. 1959) is the author of more than 160 books about using personal computers, including Quicken for Dummies, QuickBooks for Dummies, MBA's Guide to Microsoft Excel, and Excel Data Analysis for Dummies. The Wall Street Journal once called him the Louis L'Amour of computer books because at the time (December 2000), he had written more computer books than any other author.
Very good! I read up to and including Pivot Tables. It feels good to finally know what the heck are pivot tables! There are plenty of pictures to guide you and the instructions are well written, except for one thing, and this is why I gave it 4 stars instead of 5. In the beginning of the book, it is explained that in order to guide you, a ribbon name will be given, followed by the ribbon's category name, followed by the button you should click. Well, the ribbon name was often ignored, so I was hunting down the button I was supposed to click.
Whether you're a beginner, student trying to grasp the basics of Excel or a corporate executive trying to grab some insights from your data using an efficient spreadsheet like Excel, or a budding data analyst trying to work your way through heaps of data in a simple way, this book has something for everyone. Not in depth, but this can take you far enough to give you confidence about your ability to work through your data.