لطفا به وب سایت www.office-learning.ir مراجعه کنید
این کتاب توسط جناب آقای صمدیان تالیف شده است

برای دانلود به وبلاگ زیر مراجعه کنید.

http://amar80.blogfa.com

در صورتی که لینک دانلود پاک شده بود یا مشکل داشت در قسمت نظرات این وبلاگ بیان کنید تا لینک دانلود قرار داده شود


از اینجا دانلود کنید.

+ نوشته شده در  90/05/01ساعت 10:54  توسط اسماعیل  | 



 Statistical Analysis: Microsoft Excel 2010

“Excel has become the standard platform for quantitative analysis. Carlberg has become a world-class guide for Excel users wanting to do quantitative analysis. The combination makes Statistical Analysis: Microsoft Excel 2010 a must-have addition to the library of those who want to get the job done and done right.”

—Gene V Glass, Regents’ Professor Emeritus, Arizona State University

 

Use Excel 2010’s statistical tools to transform your data into knowledge

 

Use Excel 2010’s powerful statistical tools to gain a deeper understanding of your data,
make more accurate and reliable inferences, and solve problems in fields ranging from business to health sciences.

 

Top Excel guru Conrad Carlberg shows how to use Excel 2010 to perform the core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including its new consistency functions. Along the way, you discover the most effective ways to use correlation and regression and analysis of variance and covariance. You see how to use Excel to test statistical hypotheses using the normal, binomial, t and F distributions.

 

Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by an extensive set of web-based resources.

  •  Master Excel’s most useful descriptive and inferential statistical tools

  •  Tell the truth with statistics, and recognize when others don’t

  •  Accurately summarize sets of values

  •  View how values cluster and disperse

  •  Infer a population’s characteristics from a sample’s frequency distribution

  •  Explore correlation and regression to learn how variables move in tandem

  •  Understand Excel’s new consistency functions

  •  Test differences between two means using z tests, t tests, and Excel’s
Data Analysis Add-in

  •  Use ANOVA and ANCOVA to test differences between more than two means

  •  Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

+ نوشته شده در  90/04/31ساعت 21:6  توسط اسماعیل  | 

Excel As Your Database guides those of you who need to manage facts and figures, yet have little experience, budget, or need for a full-scale relational database management system. Youll learn how to use Excel to enter, store, and analyze your data.

This book is written and organized in a way that assumes you have some familiarity with Excel, but not with databases. The book features quick-start solutions, practice exercises, troubleshooting tips, and best practices.

What you’ll learn

  • This book covers Excel 2007 and 2003.
  • The author clarifies not just how to use a technique, but under what realistic scenarios.
  • The text features step-by-step, how-to procedures.
  • Try-it-out exercises are based on realistic sample data.

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

+ نوشته شده در  90/04/31ساعت 20:43  توسط اسماعیل  | 

Learn the business thinking behind financial modeling and execute what you know effectively using Microsoft Excel. Many believe that sales and profitability projections shown in financial models are the keys to success in attracting investors. The truth is that investors will come up with their own projections. The investor wants to understand the assumptions, structure, and relationships within the modeling of a startup. If the investor is satiated, the entrepreneur has successfully demonstrated a complete understanding of the business side of the enterprise. Pro Excel Financial Modeling provides the keys necessary to learn this thinking and to build the models that will illustrate it.

  • Step–by–step approach to developing financial models in Excel
  • Extensive case studies and Excel templates provided

What you’ll learn

  • Learn the business thinking behind successful financial modeling aimed at investors.
  • Communicate effectively with investors.
  • Explore advanced modeling with Microsoft Excel, including cost of information technology, Customer return on investment, cost of sales and marketing, cost of goods sold, team and staffing, profit and loss.
  • Discover best practices for modeling using Microsoft Excel.

Who this book is for

Anyone who wants to think critically about their business models, communicate these models to investors, and successfully build them in Microsoft Excel will find the information they need within this material. Additional readers who will benefit include entrepreneurs, technologists, and developers who wish to start a business utilizing their technology ideas, and business and technology consultants.

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

+ نوشته شده در  90/04/31ساعت 20:38  توسط اسماعیل  | 


PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.


PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world.

  • Covers the leading technology for bringing data analytics to the desktop
  • Presents real-world solutions to real-world scenarios
  • Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence

What you’ll learn

  • Install and verify the PowerPivot software
  • Integrated existing, available data to deliver business intelligence
  • Leverage Time Intelligence to report change over time
  • Write Data Analysis Expressions (DAX) to create custom measures
  • Identify and implement solutions for role-playing dimensions
  • Recognize and work-around PowerPivot’s missing features

Who this book is for

PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

+ نوشته شده در  90/04/31ساعت 20:33  توسط اسماعیل  | 

Take your Excel formulas to the next level with this updated reference John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010. You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else.* Demonstrates how to use all the new features of Excel 2010 to maximize your formulas* Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more* Serves as an indispensable reference no matter your skill level* Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

+ نوشته شده در  90/04/31ساعت 20:5  توسط اسماعیل  | 

Formulas and Functions: Microsoft Excel 2010

MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS!

 

Excel expert Paul McFedries shows how to use Excel 2010’s core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you’ll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions… insider insights… even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.

 

• Create more powerful formulas

• Use conditional formatting to instantly reveal anomalies, problems, or opportunities

• Analyze your data with standard tables and PivotTables

• Use complex criteria to filter data in lists

• Understand correlations between data

 

• Perform sophisticated what-if analyses

• Use regression to track trends and make forecasts

• Build loan, investment, and discount formulas

• Troubleshoot problems with formulas, ranges, and functions

 

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excelskills, and presents focused tasks and examples for performing them rapidly and effectively. Selectedby Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will:

 

• Dramatically increase your productivity–saving you 50 hours a year, or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make

 

Paul McFedries, president of Logophilia Limited, is a Microsoft Office expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 70 books to his credit, which combined have sold more than three million copies worldwide. His recent titles include Using the Microsoft Office Web Apps, and Microsoft Windows 7 Unleashed. He is also proprietor of Word Spy (www.wordspy.com), a website that tracks new words and phrases as they enter the English language.

 

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

+ نوشته شده در  90/04/31ساعت 19:5  توسط اسماعیل  | 

ناشر : سهادانش نويسنده : کیوان غلامی مترجم : ندارد

١٣٨٩, ويرايش اول, چاپ اول شابك : ٩٧٨٦٠٠١٨١٠٠٩١ وزن و نوع جلد : ١٥٠ گرم، نرم

http://www.fardab.com/index.php?option=com_bookcity&Itemid=58&task=detailproduct&id=17709

+ نوشته شده در  90/04/31ساعت 12:30  توسط اسماعیل  |