Excel University Volume 3 - Featuring Excel 2016 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals - Tapa blanda

Lenning CPA CITP, Jeff

 
9781543187243: Excel University Volume 3 - Featuring Excel 2016 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals
Tapa blanda
ISBN 10: 1543187242 ISBN 13: 9781543187243
Editorial: CreateSpace Independent Publishing Platform, 2017

Sinopsis

The third installment in the Excel University series picks up right where Volume 2 leaves off. In the final exercise of Volume 2, we created a formula-based report that required several features and functions. In Volume 3, we build that same report without writing a single formula. We create it with the PivotTable feature. The first section of this volume covers PivotTable basics and concludes with a comparison between formula-based and PivotTable reports. The second section explores various report layout and design options that enable us to replace our formula-based reports with PivotTables when appropriate. In the final section, we consider the reporting process, including efficient ways to get data into our workbooks, how to prepare the data for use, and how to summarize it graphically with PivotCharts and other Excel features. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.

"Sinopsis" puede pertenecer a otra edición de este libro.

Reseña del editor

The third installment in the Excel University series picks up right where Volume 2 leaves off. In the final exercise of Volume 2, we created a formula-based report that required several features and functions. In Volume 3, we build that same report without writing a single formula. We create it with the PivotTable feature. The first section of this volume covers PivotTable basics and concludes with a comparison between formula-based and PivotTable reports. The second section explores various report layout and design options that enable us to replace our formula-based reports with PivotTables when appropriate. In the final section, we consider the reporting process, including efficient ways to get data into our workbooks, how to prepare the data for use, and how to summarize it graphically with PivotCharts and other Excel features. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
CreateSpace Independent Publishing Platform
Año de publicación
2017
Idioma
Inglés
ISBN 10 
1543187242
ISBN 13 
9781543187243
Encuadernación
Tapa blanda
Número de páginas
300
Contacto del fabricante
no disponible
Persona responsable
no disponible