PDF格式论坛已经有了,就不再上传了。
介绍
So here’s a funny deal: 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 I bet that you sometimes wish that you could do more with Excel. You sometimes wish, I wager, that you could use Excel to really gain insights into the information, the data, that you work with in your job.
Using Excel for data analysis is what this book is all about. This book assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information that you’re already working with in Excel — or the information stored electronically in some other format, such as in your accounting system or from your web server’s analytics
关于本书
This book isn’t meant to be read cover to cover like a Dan Brown page-turner. Rather, it’s organized into tiny, no-sweat descriptions of how to do the things that must be done. Hop around and read the chapters that interest you.
If you’re the sort of person who, perhaps because of a compulsive bent, need
ExcelDataAnalysisWorkBookExamples.zip
大小:(393.62 KB)
只需: 1 个论坛币
马上下载
本附件包括:
- a blank grocery list.xlsx
- A simple array formula.xlsx
- A Simple Budget.xlsx
- A worksheet for illustrating the ranking functions.xlsx
- Another Simple Budget.xlsx
- Apple production collapses.xlsx
- Bad data arrangement fixed with text functions.xlsx
- Book SRPs vs. Annual Units #1.xlsx
- Book SRPs vs. Annual Units #2.xlsx
- Book SRPs vs. Annual Units #3.xlsx
- capbudget example.xlsx
- Datalist of coffees #2.xlsx
- Datalist of coffees with pivottable custom calculations.xlsx
- Datalist of coffees.xlsx
- Datalist of herbal tea sales.xlsx
- David vs Goliath.xlsx
- Exploring effect of ads on sales #2.xlsx
- Exploring effect of ads on sales.xlsx
- figure for chi square discussion.xlsx
- Figure for DAVERAGE #2.xlsx
- Figure for DAVERAGE #3.xlsx
- Figure for DAVERAGE.xlsx
- Figure for DCOUNT and DCOUNTA.xlsx
- Figure for DGET.xlsx
- Figure for DMAX and DMIN.xlsx
- Figure for DSTDEV and DSTDEVP.xlsx
- Figure for DSUM.xlsx
- Figure for DVAR and DVARP.xlsx
- Golf scores in FREQUENCY bins.xlsx
- Good data but bad arrangement.xlsx
- grocery list #1.xlsx
- grocery list #2.xlsx
- grocery list #3.xlsx
- grocery list #4.xlsx
- grocery list setup for advanced filters.xlsx
- Illustrating the PROB function.xlsx
- Sales and profits continue to increase.xlsx
- Simple budget worksheet.xlsx
- Solver workbook example.xlsx
- temps for moving averages.xlsx
- text I've just imported.xlsx
- t-test workbook.xlsx
- Uniform distribution six sides of a die.xlsx
- z-test workbook.xlsx