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

Business intelligence (BI) tools make it possible for companies to gain deep, actionable insights for faster, better decision-making - and greater competitiveness. Until recently, however, access to BI has largely been restricted to experts using complex, specialized tools. With PowerPivot for Excel 2010, Microsoft has changed that. Together with SQL Server 2008 and Microsoft's new SharePoint Analysis Services, PowerPivot makes advanced business intelligence available to any mainstream business user working with Excel 2010. Of course, having the tools isn't enough: you must learn how to use them. That's where PowerPivot for the Data Analyst comes in. In this book, legendary Excel expert and instructor Bill Jelen shows exactly how to use PowerPivot to gain deep, actionable insights for more effective business decision-making. Using concrete examples and real-life scenarios, Jelen walks through setting up PowerPivot and integrating multiple data sources; creating and sharing dynamic dashboards; slicing and dicing to perform fast, interactive, ad hoc analyses; leveraging Excel's familiar features in advanced BI applications; and much more. This book is part of the new MrExcel Library series.

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

Ebook لاتین Excel

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



Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you’ll learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel. Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required. The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, “self-service” BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint®.

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

Ebook لاتین Excel

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

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes.

Coverage includes:
  • Creating PivotTables, customizing them, and changing the way you view them
  • Performing calculations within PivotTables
  • Using PivotCharts and other visualizations
  • Analyzing multiple data sources with PivotTables
  • Sharing PivotTables with others
  • Working with and analyzing OLAP data
  • Making the most of Excel 2010's powerful new PowerPivot feature
  • Using Excel 2010's Slicer to dynamically filter PivotTables
  • Enhancing PivotTables with macros and VBA code

This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels
Includes proven PivotTable recipes for instant on-the-job results

Helps Excel users avoid common pitfalls and mistakes

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

Ebook لاتین Excel

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

Customer Service Note: We are sorry for the inconvenience, but the voucher with the online access code is missing from the first printing of this title. However, we do have the code, available upon request. Please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 to obtain your 24-character access code. This code will give you access to your online edition of this Microsoft Press book that is hosted on Safari Books Online! Once you have obtained your unique access code: Go to http://microsoftpress.oreilly.com/​safarienabled and enter your unique 24-character access code, including the hyphens. Set up your free Safari account (required), following the instructions on-screen. Enjoy unlimited access to your online edition of the Web! PLEASE NOTE: Each access code may only be redeemed once. Again, for assistance, please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 or 707-827-7019.

Master the business modeling and analysis techniques that help you transform data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical, scenario-focused guide—fully updated for Excel 2010. Use Wayne’s proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.

Wayne L. Winston is a professor of Decision..

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

Ebook لاتین Excel

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



 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  توسط اسماعیل  | 


NSWER KEY BUSINESS QUESTIONS


CONTROL COMPANY FINANCES

FORECAST SALES

PREPARE BUSINESS CASES

MAKE BETTER INVESTMENT DECISIONS

IMPROVE QUALITY

USE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITS

Using real-world examples, Carlberg helps you put Excel’s features and functions to work and get the power of quantitative analysis behind your management decisions.

Excel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010’s newest features and functions. Along the way, you’ll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios.

Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions, insider insights, complete step-by-step projects, and more. It’s all complemented by an extraordinary set of web-based resources, from sample journals and ledgers to business forecasting tools.

•  Use Excel analysis tools to solve problems throughout the business

•  Build and work with income statements and balance sheets

•  Value inventories and current assets, and summarize transactions

•  Calculate working capital and analyze cash flows

•  Move from pro formas to operating budgets that help guide your management decisions

•  Prepare business cases incorporating everything from discount rates to margin and contribution analysis

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel skills, and presents focused tasks and examples for performing them rapidly and effectively. Selected by 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

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

Ebook لاتین Excel

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

Excels what-if data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unitwhile increasing projected unit salesmight affect your profit margins.

Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data. This book is focused and to the point, and it provides tutorial treatment of what-if tools in a practical, hands-on manner.

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

Ebook لاتین Excel

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

Beginning SharePoint with Excel is for advanced Excel users who want to extend the usefulness of Excel by adding the collaborative features of SharePoint. There's no code in this book because it’s not for programmers; nor is it for Excel beginners. It's for those who regularly use Excel in enterprise business environments and who want to leverage the power and capabilities of SharePoint.

Authors Gini Courter and Annette Marquis have authored over 22 books on Microsoft Office and are partners in a business application consulting firm. In this book, they provide easy-to-implement examples of powerful business solutions. And they take care to explore the interaction between Excel and SharePoint. They also include resources and add-ons that extend SharePoint and Excel features.

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

Ebook لاتین Excel

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

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  توسط اسماعیل  |