Michael Alexander – författare
473 kr
Skickas inom 5-8 vardagar
154 kr
Skickas inom 5-8 vardagar
319 kr
Skickas inom 5-8 vardagar
84 kr
Läs direkt efter köp
143 kr
Skickas inom 5-8 vardagar
190 kr
Lyssna direkt efter köp
16 kr
Läs direkt efter köp
86 kr
Läs direkt efter köp
143 kr
Skickas inom 5-8 vardagar
353 kr
Skickas
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
353 kr
Skickas
Excel® 2016 PIVOT TABLE DATA CRUNCHING
CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES!
Use Excel 2016 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. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else!
• Create, customize, and change pivot tables
• Transform huge data sets into clear summary reports
• Analyze data faster with Excel 2016’s new recommended pivot tables
• Instantly highlight your most profitable customers, products, or regions
• Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map
• Use Power View dynamic dashboards to see where your business stands
• Revamp analyses on the fly by dragging and dropping fields
• Build dynamic self-service reporting systems
• Combine multiple data sources into one pivot table
• Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot
• Automate pivot tables with macros and VBA
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
Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth. Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.
CATEGORY: Spreadsheets
COVERS: Microsoft Excel 2016174 kr
Skickas
118 kr
Läs direkt efter köp
567 kr
Skickas inom 10-15 vardagar
209 kr
Skickas inom 5-8 vardagar
375 kr
Skickas inom 10-15 vardagar
630 kr
Skickas inom 10-15 vardagar
922 kr
Skickas inom 10-15 vardagar
342 kr
Läs direkt efter köp
The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help.
The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.
The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).
310 kr
Skickas inom 5-8 vardagar
366 kr
Läs direkt efter köp
The ultimate handbook for Excel analysts who need reporting solutions using Access
Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions.
Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how.
Coverage includes:
Data Analysis in Access & the Basics of Access Beyond Select Queries Transforming Your Data with Access Working with Calculations and Dates Performing Conditional Analysis Adding Dimension with Subqueries and Domain Aggregate Functions Running Descriptive Statistics in Access Scheduling and Running Batch Analysis Leveraging VBA to Enhance Data Analysis Reports, Dashboards, and Visualization in Access Presenting Data with Access Reports Using Pivot Tables and Pivot Charts in Access Enhancing Queries and Reports with Visualizations Advanced Excel and Access Integration Techniques Getting Access Data into Excel Using VBA to Move Data between Excel and Access Exploring Excel and Access Automation Integrating Excel and Access with XML Integrating Excel and Other Office Applications Access VBA Fundamentals Understanding and Using SQL and more!The Excel Analyst''s Guide to Access helps you get more from both applications.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
558 kr
Skickas inom 5-8 vardagar
387 kr
Läs direkt efter köp
1 246 kr
Skickas inom 5-8 vardagar
428 kr
Skickas inom 5-8 vardagar
450 kr
Läs direkt efter köp
304 kr
Skickas
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 Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
225 kr
Skickas
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 Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
2 193 kr
Skickas inom 10-15 vardagar
89 kr
Skickas