My Excel 2013

Que Publishing
16
Free sample

Full-color, step-by-step tasks walk you through everything you want to do with Excel 2013.

Step-by-step instructions with callouts to Excel 2013 screenshots that show you exactly what to do.
Help when you run into Excel 2013 problems or limitations.
Tips and Notes to help you get the most from Excel 2013.

• Quickly find and use the Excel 2013 features you’re looking for
• Create, save, and organize your spreadsheets
• Build custom formulas using Excel’s powerful built-in functions
• Master time-saving techniques to find, replace, move, filter, and sort data
• Find, fix, and avoid errors that break spreadsheets or cause inaccuracies
• Create a unique look and feel for your spreadsheets with formatting
• Generate powerful charts and visualizations with Excel’s new tools
• Insert images, shapes, SmartArt, and even org charts
• Precisely control what you print and how it looks
• Secure your spreadsheets and control who can view or edit them
• Use improved PivotTables to analyze huge amounts of data
• Store and share workbooks on the Web with SkyDrive

Read more
Collapse

About the author

Michael Alexander has been named a Microsoft MVP for his ongoing contributions to the Excel community. A Microsoft Certified Application Developer (MCAD), he has authored several books on advanced business analysis with Excel and Access, including Easy Microsoft Excel 2010. He has 15+ years’ experience developing Office solutions, and runs the free Excel and Access tutorial and tips site datapigtechnologies.com.

Read more
Collapse
3.3
16 total
Loading...

Additional Information

Publisher
Que Publishing
Read more
Collapse
Published on
Apr 30, 2013
Read more
Collapse
Pages
99998
Read more
Collapse
ISBN
9780133380934
Read more
Collapse
Read more
Collapse
Read more
Collapse
Language
English
Read more
Collapse
Genres
Computers / Desktop Applications / Spreadsheets
Read more
Collapse
Content Protection
This content is DRM protected.
Read more
Collapse
Eligible for Family Library

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
What is this book about?

VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment.

Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support.

Based on the successful content and format of Excel 2000 VBA Programmer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community.

What does this book cover?

The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real-world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models.

Here are just a few of the things you'll learn in this edition:

The entire Excel Object Model and the Common Office Object Model Working with PivotTables Accessing and manipulating data sources from Excel with ADO Programming the Visual Basic Editor (VBE) New features in Excel 2002, SmartTags, XML, and the Web Expanded references for Excel versions 97, 2000, and 2002

Who is this book for?

This book not only caters for beginner- and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.

A guide to PowerPivot and Power Query no data cruncher should be without!

Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities.

Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting.

Demonstrates how Power Query is used to discover, connect to, and import your data Shows you how to use PowerPivot to model data once it's been imported Offers guidance on using these tools to make analyzing data easier Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand

If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.

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. Work efficiently with ranges, cells, and R1C1-style formulas Build super-fast applications with arrays Customize the Excel 2010 Ribbon to run your macros Write Excel 2010 VBA code that works on older versions of Excel Create custom dialog boxes to collect information from your users Use error handling to make your VBA scripts more resilient Use Web queries to import data from virtually any online source Master advanced techniques such as classes and collections Use Excel VBA to control other Office programs…even control Windows itself, via the Windows API Create add-ins to share or sell your programs

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
©2019 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.