Instant Creating Data Models with PowerPivot How-to

By Leo Taehyung Lee

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This is a practical, recipe-based book, taking the reader through the hands-on steps required to set up and use PowerPivot with as little fuss as possible. This is an introductory book on PowerPivot for basic Excel users who handle lots of data and are willing to go beyond the limitations of Excel without the need to learn a new language from scratch.

• Language: English
• Publisher: Packt Publishing
• Release date: Apr 25, 2013
• ISBN: 9781849689571

Book preview

Table of Contents

Instant Creating Data Models with PowerPivot How-to

Credits

About the Author

About the Reviewer

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the sample files

Errata

Piracy

Questions

1. Instant Creating Data Models with PowerPivot How-to

Installation (Simple)

Getting ready

How to do it...

How it works...

There's more...

Importing data from the database (Advanced)

Getting ready

How to do it...

How it works...

There's more...

Excel 2013

Importing data from other files (Simple)

How to do it...

How it works...

There's more...

Filtering the data to be imported (Intermediate)

Getting ready

How to do it...

How it works...

There's more...

Creating a pivot table (Simple)

Getting ready

How to do it...

How it works...

There's more...

Creating a pivot chart (Simple)

Getting ready

How to do it...

How it works...

There's more...

Managing data relationships (Simple)

How to do it...

How it works...

There's more...

Creating custom tables instead of connecting relationships

Adding new custom columns (Intermediate)

Getting ready

How to do it...

How it works...

There's more...

Making the data look presentable (Simple)

Getting ready

How to do it...

How it works...

There's more...

Publishing as Excel (Simple)

Getting ready

How to do it...

How it works...

There's more...

Version compatibility issue

Instant Creating Data Models with PowerPivot How-to

---

Instant Creating Data Models with PowerPivot How-to

Copyright © 2013 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: April 2013

Production Reference: 1180413

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-84968-956-4

www.packtpub.com

Credits

Author

Leo Taehyung Lee

Reviewer

Mohammed Raza Saghar

Acquisition Editor

Andrew Duckworth

Commissioning Editor

Neha Nagwekar

Technical Editor

Hardik B. Soni

Project Coordinator

Joel Goveya

Proofreader

Jonathan Todd

Production Coordinators

Melwyn D'sa

Nilesh R. Mohite

Cover Work

Melwyn D'sa

About the Author

Leo Taehyung Lee is an outgoing individual with a diverse background and experiences. His studies in engineering along with the pursuit of a career in finance helped him work in various positions across diverse fields from R&D to patents as well as financial risk management. He has over 3 years of extensive experience in Excel, VBA, and is a Microsoft Certified Excel Expert in Excel 2010.

This book would not have been possible without the constant support from YN. Special thanks to YW for the encouragement and help in developing relevant skills.

About the Reviewer

Mohammed Raza Saghar is a Microsoft Certified Office 2007 and 2010 Master and a Microsoft Certified Excel Expert in 2003, 2007, and 2010 versions. He has Excel and VBA experience of more than 13 years and overall training experience of more than 3 years that also includes complete training of 48 batches at AFCKS Technologies (Pune,

Reviews for Instant Creating Data Models with PowerPivot How-to

[sushil_kumarp · Rating: 1 out of 5 stars]

This is a very basic book and has to be improved