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

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

Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world’s most widely-used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts/graphs, and get work done efficiently.

Microsoft rolled out several new features with Excel 2010—perhaps the most notable was the ability to use Excel 2010 online and collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these features and more.

What you’ll learn

  • What distinguishes 2010 from its immediate predecessor
  • What distinguishes 2010 from Excel 2003
  • Get started with data entry and formatting
  • How to get started with formula writing skills
  • Get started with database capabilities, including pivot tables
  • How to get started with charting

Who this book is for

This book is for those new to Excel and for those who have used Excel in the past but are new to Excel 2010.


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

Ebook لاتین Excel

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






John Walkenbach, "Excel 2010 Bible"
Wiley | 2010 | ISBN: 0470474874 | PDF

A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010
John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.
An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won’t find anywhere else.
Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel
Delivers essential coverage of all the newest features of Excel 2010
Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience

برای خرید کلیه کتاب های وبلاگ به صفحه محصولات مراجعه کنید.

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