Excel Tables

A Complete Guide for Creating, Using and Automating Lists and Tables

Author: Zack Barresse,Kevin Jones

Publisher: Tickling Keys, Inc.

ISBN: 1615473408

Category: Computers

Page: 300

View: 2343

Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates—all of which employ tables—helps introduce readers to the multiple benefits of tables. The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more advanced topics, including slicers and filtering, working with VBA macros, and using tables in the Excel web app. Novice Excel users and experts alike will find relevant, useful, and authoritative information in this one-of-a-kind resource.

Pivot Table Data Crunching

Microsoft Excel 2010

Author: Bill Jelen,Michael Alexander

Publisher: Pearson Education

ISBN: 0789746689

Category: Computers

Page: 384

View: 4433

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

Power Excel 2016 with MrExcel

Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis in Excel 2010–2013

Author: Bill Jelen

Publisher: Tickling Keys, Inc.

ISBN: 1615473556

Category: Computers

Page: 529

View: 2661

Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

Learn Excel 2011 for Mac

Author: Guy Hart-Davis

Publisher: Apress

ISBN: 1430235217

Category: Computers

Page: 488

View: 7025

Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks. What you’ll learn The secrets of the Excel for Mac interface! How to create effective workbooks and templates How to quickly format worksheets How to perform custom calculations and formulas What kind of creative and persuasive charts How to illustrate your worksheets with SmartArt, pictures, and more What business problem solving can be done with Excel How to analyze data with pivot tables How to automate tasks with Visual Basic for Applications (VBA) Who this book is for Beginning and intermediate users looking to get up to speed quickly with the Excel 2011 application and use it productively, both online and offline. Table of Contents Learning the Secrets of the Excel:Mac Interface Configuring Excel:Mac to Suit the Way You Work Creating Effective Workbooks and Templates Formatting Your Worksheets Quickly and Efficiently Performing Custom Calculations with Formulas Using Excel’s Built-In Functions Creating Clear and Persuasive Charts Using Data Bars, Color Scales, Icon Sets, and Sparklines Illustrating Your Worksheets with SmartArt, Pictures, and More Creating Databases Using Tables Solving Business Questions with What-If Analysis, Goal Seek, and Solver Analyzing Data with PivotTables Collaborating and Sharing with Macs and Windows Automating Tasks with Macros and VBA

The Definitive Guide to MySQL 5

Author: Michael Kofler

Publisher: Apress

ISBN: 9781430200710

Category: Computers

Page: 784

View: 4012

* MySQL 5, due to be released in summer 2005, is slated to be the most significant release in the product’s history. The Definitive Guide to MySQL 5, Third Edition is the first book to offer in-depth instruction on the new features. * This book shows readers how to connect to MySQL via all of the major APIs, including PHP, Perl, Java, JSP, and C#/. * Novice and intermediate database administrators are introduced to both MySQL’s key features, and crucial database management concepts by way of real-world examples such as discussion forums, online polls, and other data administration projects.

MrExcel XL

The 40 Greatest Excel Tips of All Time

Author: Bill Jelen,Szilvia Juhasz

Publisher: Tickling Keys, Inc.

ISBN: 1615473505

Category: Computers

Page: 120

View: 1813

The 40 essential tips that all Excel users need to know Crowdsourced by more than 300 contributors who collaborated on choosing the 40 best Excel tips, MrExcel XL provides users with a concise book that can be absorbed in under an hour. Each tip is explained with text, screenshots, and a custom illustration. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.

Visual Studio Tools for Office 2007

VSTO for Excel, Word, and Outlook

Author: Eric Carter,Eric Lippert

Publisher: Pearson Education

ISBN: 9780132701730

Category: Computers

Page: 1120

View: 6944

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Microsoft Visual Studio 2008 and the .NET Framework to program against Microsoft Office 2007. This book delivers in one place all the information you need to succeed using VSTO to program against Word 2007, Excel 2007, and Outlook 2007, and provides the necessary background to customize Visio 2007, Publisher 2007, and PowerPoint 2007. It introduces the Office 2007 object models, covers the most commonly used objects in those object models, and will help you avoid the pitfalls caused by the COM origins of the Office object models. Developers who wish to program against Office 2003 should consult Carter and Lippert’s previous book, Visual Studio Tools for Office. In VSTO 2008, you can build add-ins for all the major Office 2007 applications, build application-level custom task panes, customize the new Office Ribbon, modify Outlook’s user interface using Form Regions, and easily deploy everything you build using ClickOnce. Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO, based on the deep knowledge that comes from the authors’ unique perspective of living and breathing VSTO for the past six years. This book Explains the architecture of Microsoft Office programming and introduces the object models Covers the main ways Office applications are customized and extended Explores the ways of customizing Excel, Word, and Outlook, and plumbs the depths of programming with their events and object models Introduces the VSTO programming model Teaches how to use Windows Forms and WPF in VSTO and how to work with the Document Actions Pane and application-level task panes Delves into VSTO data programming and server data scenarios Teaches ClickOnce VSTO deployment This is the one book you need to succeed in programming against Office 2007. C# and Visual Basic .NET Code samples for download can be found here: http://www.informit.com/store/product.aspx?isbn=0321533216

Guerilla Data Analysis Using Microsoft Excel

Author: Oz du Soleil,Bill Jelen

Publisher: Tickling Keys, Inc.

ISBN: 1615473432

Category: Computers

Page: 180

View: 8771

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.

Exchanging Data Between SAS and Microsoft Excel

Tips and Techniques to Transfer and Manage Data More Efficiently

Author: William E. Benjamin

Publisher: SAS Institute

ISBN: 1629596892

Category: Computers

Page: 290

View: 9956

Master simple-to-complex techniques for transporting and managing data between SAS and Excel William Benjamin's Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently describes many of the options and methods that enable a SAS programmer to transport data between SAS and Excel. The book includes examples that all levels of SAS and Excel users can apply to their everyday programming tasks. Because the book makes no assumptions about the skill levels of either SAS or Excel users, it has a wide-ranging application, providing detailed instructions about how to apply the techniques shown. It contains sections that gather instructional and syntactical information together that are otherwise widely dispersed, and it provides detailed examples about how to apply the software to everyday applications. These examples enable novice users and power developers alike the chance to expand their capabilities and enhance their skillsets. By moving from simple-to-complex applications and examples, the layout of the book allows it to be used as both a training and a reference tool. Excel users and SAS programmers are presented with tools that will assist in the integration of SAS and Excel processes in order to automate reporting and programming interfaces. This enables programming staff to request their own reports or processes and, in turn, support a much larger community.

Excel Outside the Box

Author: Bob Umlas

Publisher: Holy Macro Books

ISBN: 9781615470105

Category: Computers

Page: 176

View: 3991

Discusses over fifty advanced techniques for the Excel expert, including tips on building formulas within formulas, formatting, creating dynamic charts, and using VBA macro code to clean up cell calculations.

Guerilla Data Analysis Using Microsoft Excel

Author: Oz du Soleil,Bill Jelen

Publisher: Tickling Keys, Inc.

ISBN: 1615473432

Category: Computers

Page: 180

View: 2353

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.

Microsoft Excel 2013

Building Data Models with PowerPivot

Author: Alberto Ferrari,Marco Russo

Publisher: Pearson Education

ISBN: 0735676348

Category: Computers

Page: 487

View: 6845

Shows readers how to perform complex data analysis, create reports with the data analysis expressions language, and add hierarchies to data models to enable faster browsing.

VBA and Macros

Microsoft Excel 2010

Author: Bill Jelen,Tracy Syrstad

Publisher: Pearson Education

ISBN: 0789743140

Category: Computers

Page: 630

View: 5108

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features Learning advanced Excel scripting has never been easier You'll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. 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

Excel Programming Weekend Crash Course

Author: Peter G. Aitken

Publisher: John Wiley & Sons

ISBN: 0764555758

Category: Computers

Page: 456

View: 3840

Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X" Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes Applicable to Excel 2000, Excel 2002, and the latest release, Excel 2003 Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects A how-to guide to using Excel's programmability to create custom data-processing and analysis solutions Covers security, debugging, and error handling Companion Web site includes sample files, projects, and test enginewith self-assessment exam

My Excel 2016 (includes Content Update Program)

Author: Tracy Syrstad

Publisher: Que Publishing

ISBN: 0134217209

Category: Computers

Page: 480

View: 4884

Book + Content Update Program My Excel 2016 is your must-have companion for getting most out of Excel 2016. This friendly, quick, full-color, 100% practical tutorial walks you through every task you'll want to do with Excel 2016. Get productive fast with Excel 2016’s updated interface Save time and make your data easier to work with Efficiently enter, insert, move, and manage data Use templates to reuse work and get a jumpstart on new projects Format worksheets and charts to make them clearer and more useful Use intuitive sparkline charts that fit in a single cell Build custom formulas using powerful built-in functions Sort, filter, and consolidate data and eliminate duplication Instantly group data and generate subtotals Quickly summarize huge data sets with PivotTables Find, fix, and avoid errors that break spreadsheets or cause inaccuracies Communicate more powerfully using visual tools such as SmartArt and WordArt Precisely control what you print and how it looks Securely share and distribute your workbooks Use Excel on the Web wherever you have Internet access Every task is presented step-by-step, using carefully annotated, colorful screenshots, all numbered so there's no chance of getting lost or confused. Everything's clearly organized in modular, self-contained chapters designed to help you get started quickly. Throughout, the book is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter. In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP. How to access the web edition: Follow the instructions in the book to learn how to register your book to access the FREE Web Edition.

Excel 2013 Power Programming with VBA

Author: John Walkenbach

Publisher: John Wiley & Sons

ISBN: 1118490398

Category: Computers

Page: 1074

View: 2784

Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize Excel with UserForms, PivotTables, and user-oriented applications.

Automate the Boring Stuff with Python

Practical Programming for Total Beginners

Author: Al Sweigart

Publisher: No Starch Press

ISBN: 1593276850

Category: Computers

Page: 504

View: 9166

If you’ve ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how tedious tasks like these can be. But what if you could have your computer do them for you? In Automate the Boring Stuff with Python, you’ll learn how to use Python to write programs that do in minutes what would take you hours to do by hand—no prior programming experience required. Once you’ve mastered the basics of programming, you’ll create Python programs that effortlessly perform useful and impressive feats of automation to: –Search for text in a file or across multiple files –Create, update, move, and rename files and folders –Search the Web and download online content –Update and format data in Excel spreadsheets of any size –Split, merge, watermark, and encrypt PDFs –Send reminder emails and text notifications –Fill out online forms Step-by-step instructions walk you through each program, and practice projects at the end of each chapter challenge you to improve those programs and use your newfound skills to automate similar tasks. Don’t spend your time doing work a well-trained monkey could do. Even if you’ve never written a line of code, you can make your computer do the grunt work. Learn how in Automate the Boring Stuff with Python. Note: The programs in this book are written to run on Python 3.

Microsoft Office Excel 2007 Data Analysis

Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables

Author: Denise Etheridge

Publisher: John Wiley & Sons

ISBN: 0470132299

Category: Computers

Page: 289

View: 4592

Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.

Excel 2016 VBA and Macros (includes Content Update Program)

Author: Bill Jelen,Tracy Syrstad

Publisher: Que Publishing

ISBN: 0134386035

Category: Computers

Page: 640

View: 1646

MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it… capture data from anywhere, and use it anywhere… automate Excel 2016’s best new features. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel! Get started fast with Excel macro development Work efficiently with ranges, cells, and formulas Build super-fast applications with arrays Automate Excel’s new pivot table enhancements Collect user data with custom dialogs Make your macros more reliable and resilient Pull data from the Internet with web queries Use advanced classes, collections, and custom functions Build sophisticated business analysis solutions Read and write to Access or SQL Server databases Control other Office programs, and Windows itself Write code that also works on older Excel versions Start writing Office Store-style Excel Apps 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 This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.

MrExcel XL

The 40 Greatest Excel Tips of All Time

Author: Bill Jelen,Szilvia Juhasz

Publisher: Tickling Keys, Inc.

ISBN: 1615473505

Category: Computers

Page: 120

View: 708

The 40 essential tips that all Excel users need to know Crowdsourced by more than 300 contributors who collaborated on choosing the 40 best Excel tips, MrExcel XL provides users with a concise book that can be absorbed in under an hour. Each tip is explained with text, screenshots, and a custom illustration. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.