krainaksiazek excel 2013 pivot tables including the data model smart data analysis 20169703
- znaleziono 6 produktów w 2 sklepach
Książki / Literatura obcojęzyczna
CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours...understand exactly what's going on in your business...take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function. Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You'll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems. * Create, customize, and change your pivot tables and pivot charts * Transform gigantic data sets into crystal-clear summary reports * Summarize and analyze data even faster with new Excel 2013 recommended pivot tables * Instantly highlight your most (and least) profitable customers, products, or regions * Quickly filter pivot tables using slicers * Use dynamic dashboards using Power View to see exactly where your business stands right now * Revamp analyses on the fly by simply dragging and dropping fields * Build dynamic self-service reporting systems your entire team can use * Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets * Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills 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 CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013
Excel 2013: The Missing Manual O´REILLY
Książki / Literatura obcojęzyczna
The world's most popular spreadsheet program is now more powerful than ever, but it's also more complex. That's where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You'll be using new features like PowerPivot and Flash Fill in no time. The important stuff you need to know: Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results. Illustrate trends. Discover the clearest way to present your data using Excel's new Quick Analysis feature. Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives. Import data. Pull data from a variety of sources, including website data feeds and corporate databases. Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App. Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn. Master the new data model. Use PowerPivot to work with millions of rows of data. Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.
Learn Excel 2016 Expert Skills with the Smart Method The Smart Method Ltd
Książki / Literatura obcojęzyczna
This Excel 2016 book is for users who want to upgrade their basic Excel 2016 skills to true expert level. It will teach you to master all of the Excel 2016 advanced features. If you are an absolute beginner you need our Excel 2016 Essential Skills book.The book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to master advanced Excel 2016 features. Here's just four of the many ways in which the book is unique:This book won't waste your time by teaching basic Excel 2016 skills that you already know. All of that material is covered already in our beginner's Excel 2016 Essential Skills book. By assuming that you are already able to use the Excel 2016 basic features, far more ground can be covered. Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).Each lesson has a sample file that models a real-world business problem. You'll immediately appreciate the value and relevance of each skill you learn. Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way. No matter what your background is, this book will enable you to master Excel 2016's most advanced features.Amongst other things you'll learn how to:Use Excel 2016's new 3D maps feature to create interactive video toursUse Excel 2016's new Get & Transform tool to clean and combine dataPerform What-If analysis to model and compare business scenariosUse advanced functions to solve real-world business problemsCreate intuitive user interfaces using form controls and recorded macrosMaster dynamic tables and structured table referencesUse Excel 2016's new Append and Merge queries to de-normalize dataMaster Excel's data modeling features to define table relationshipsCompletely understand Excel's ability to create OLAP cubesUse OLAP pivot tables and 3D Maps to present OLAP cube dataUse OLAP features to gain total control over PivotTable formatting Break the million row limit with Excels 2016's new Big Data features Companies who have taken Smart Method courses include:AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, The British Museum, The National Gallery, Pokerstars, Marks & Spencer, Virgin, O2, BMW... and many, many others.
Excel 2013 In Depth PEARSON
Książki / Literatura obcojęzyczna
Get more out of Microsoft Excel(R) 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen ("Mr Excel") brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won't find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013's full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick "tour" of Excel 2013's most valuable new features. Then, learn how to * Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets * Get more productive with Excel 2013's new Start Screen and Timelines * Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens * Quickly apply attractive, consistent formats * Master every function you'll ever need,- including powerful new web services functions * Solve real-world business intelligence analysis problems * Create amazing PowerPivot data mashups that integrate information from anywhere * Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations * Share workbooks on the Web and social networks * Leverage the improved Excel Web App to create highly interactive web pages and online surveys * Automate repetitive functions using Excel macros * Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can't fix on your own. Whatever you intend to do with Excel 2013, this is the only book you'll need!
Książki / Literatura obcojęzyczna
7+ Hours of Video Instruction You've got Microsoft Excel 2010...now get the most out of it, faster and more easily than ever before! In 90 quick video lessons, Power Excel 2010 with MrExcel shows how to maximize your productivity with Microsoft Excel 2010's best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Cell Styles, Color Scales, Icon Sets, Data Bars, Web Queries, Backstage View, and more! Get more done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts...control and analyze data more effectively...communicate more visually with new charting tools and SmartArt...and plenty more! Just watch: You'll master high-powered Microsoft Excel 2010 skills at your own pace-and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2010 fast-from novices to experienced power users. Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts more than 12 million page views annually. Jelen is author of the five-star reviewed Guerilla Data Analysis Using Microsoft Excel, co-author of VBA and Macros for Microsoft Excel, co-author of Pivot Table Data Crunching, and author of Learn Excel From Mr. Excel. Part 1 Excel Interface 1 - Ribbon, QAT, Mini Toolbar, Live Preview 2 - Finding Icons 3 - Customizing the Ribbon 4 - Backstage View 5 - Recent Documents 6 - Keyboard Shortcuts 7 - Zoom Slider and Page Layout 8 - Unlocking the Big Grid 9 - Data Entry Tricks 10 - Customize All Future Workbooks 11 - Copy Worksheets 12 - Change All Worksheets 13 - Arranging Windows 14 - Saving Workbook to PDF 15 - Saving Workbook to Excel Web App Part 2 Text Formulas 16 - Drag the Fill Handle 17 - Create Your Own Series 18 - Joining Text 19 - Rapid Formula Copy 20 - Convert to Proper Case 21 - Joining Dates 22 - Formulas to Values 23 - Breaking Apart Text 24 - Parsing Fixed Width Part 3 Formulas 25 - AutoSum Tricks 26 - Formula Auditing 27 - Three Ways of Entering Formulas 28 - Relative Versus Absolute Formulas 29 - Tables and Table Formulas 30 - Discovering Functions 31 - Goal Seek 32 - IF Formulas 33 - VLOOKUP 34 - Date and Time Part 4 Sorting & Filtering 35 - Data Preparation 36 - One-Click Sorting 37 - Sorting by Color 38 - Sorting by Weekday 39 - Rearranging Columns 40 - Filter by Selection 41 - Other ways to Filter 42 - Remove Duplicates Part 5 Subtotals 43 - Subtotals 44 - Collapsing Subtotals 45 - Copy Subtotals 46 - Formatting Subtotals 47 - Sorting Subtotals 48 - Changing Sum to Count in 1 column 49 - Data Consolidate 50 - Easy-XL Part 6 Pivot Tables 51 - Creating a Pivot Table 52 - Changing a Pivot Table 53 - Pivot Gotchas 54 - Pivot Formatting 55 - Drill Down 56 - Pivot Calculations 57 - Summarizing Dates 58 - Pivot Sorting 59 - Filtering Row Fields 60 - Top 10 Report 61 - Filtering a Pivot Table with Slicers 62 - Slicers on Two Pivot Tables 63 - 50 Reports in 5 Seconds 64 - Using GetPivotData Part 7 PowerPivot 65 - Getting Data into PowerPivot 66 - Adding Calculations in PowerPivot 67 - Linking Tables in PowerPivot 68 - Creating Pivot Table in PowerPivot 69 - Sorting in PowerPivot Part 8 Charting and SmartArt 70 - Creating and Formatting a Chart 71 - Adding or Removing Chart Data 72 - Saving Favorite Chart Settings 73 - Charting Differing Orders of Magnitude 74 - Pie Chart Tricks 75 - Sparklines 76 - Labeling Sparklines 77 - Creating SmartArt 78 - Smart Art Formulas Part 9 Visual Impact 79 - Cell Styles and Document Themes 80 - Color Scales, Icon Sets, Data Bars 81 - Icons for Only a Subset 82 - Paired Bar Charts with Negative Data Bars 83 - Picture Tools and WordArt 84 - Picture Background Removal 85 - Insert Screen Clipping 86 - Equation Editor Part 10 Tips & Tricks 87 - Web Queries 88 - Turn Data 89 - Choose from a List 90 - ToolTips for a Cell 91 - Word Processing in Excel 92 - Have a Talk with Excel LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more. View All LiveLessons http://www.quepublishing.com/imprint/series_detail.aspx?st=87397
Oxygen Forensic Detective (zawiera 12 m-cy aktualizacji) GSM-Support, Kraków
Oprogramowanie użytkowe > Oxygen > Programy dla śledczych
Oxygen Forensic Detective (zawiera 12 m-cy aktualizacji) - to oprogramowanie dla komputerów klasy PC służące do wydobycia maksymalnej ilości informacji z telefonów komórkowych i smartfonów, w celach dochodzeniowo-śledczych. Program ten odegrał znaczącą rolę w śledztwach w postępowaniach kryminalnych i innych w ponad 20 krajach na całym świecie. Jednym z głównych zastosowań tego oprogramowania jest odzyskiwanie informacji, które mogą służyć jako dowód w postępowaniu sądowym. Firma GSM-SUPPORT posiada bezpośrednią autoryzację od producenta na sprzedaż oprogramowania firmy Oxygen Software. Supports live data acquisition from 11,000+ mobile devices running on iOS, Android, Windows 8, Windows Mobile 5/6, RIM(Blackberry), Symbian, Bada, Chinese MTK chipset, and feature phones. Offers advanced Oxygen Forensic
Sklepy zlokalizowane w miastach: Warszawa, Kraków, Łódź, Wrocław, Poznań, Gdańsk, Szczecin, Bydgoszcz, Lublin, Katowice
Szukaj w sklepach lub całym serwisie
1. Sklepy z krainaksiazek pl excel 2013 pivot tables including the data model smart data analysis 20169703
t1=0.045, t2=0, t3=0, t4=0.028, t=0.046