Essential Excel 2019: A Step-By-Step Guide
Autor David Slager, Annette Slageren Limba Engleză Paperback – 22 oct 2020
Create, edit, sort, analyze, summarize, and format data as well as graph it in Excel 2019. Chock full of visuals, user-friendly instructions, and reader exercises, this in-depth guide makes it easy for you to get on the bandwagon taking advantage of this powerful software and what it can do. Essential Excel 2019 doesn’t mess around. It provides the most clear and concise, but complete, information you need to successfully use the expansive features of Excel in your work environment.
The second edition of this soup-to-nuts book delivers essential how-to and reference information for users who are new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to speed on the latest changes and features in Excel 2019. It is heavy on the practical examples and light on the theory, providing a step-by-step process of what you need to do when you are working with Excel. You will begin with the basics, advancing as each chapterbuilds on knowledge from previous chapters. You will appreciate real-life examples and exercises that reinforce what you have learned, and upon finishing the book, you will have the confidence to use much more than the typical 10% that most people use in Excel.
What You Will Learn
The second edition of this soup-to-nuts book delivers essential how-to and reference information for users who are new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to speed on the latest changes and features in Excel 2019. It is heavy on the practical examples and light on the theory, providing a step-by-step process of what you need to do when you are working with Excel. You will begin with the basics, advancing as each chapterbuilds on knowledge from previous chapters. You will appreciate real-life examples and exercises that reinforce what you have learned, and upon finishing the book, you will have the confidence to use much more than the typical 10% that most people use in Excel.
What You Will Learn
- Create amazing visualizations of your data
- Get up to speed on easy and accurate methods for entering data
- Extract the information you want from imported data; manipulate and format it to meet your needs
- Export your results to other programs or share with others in the cloud
- Organize, summarize, filter, and consolidate your data in multiple ways
- Audit, validate, and protect your data
Who This Book Is For
Anyone new to Excel or looking to take better advantage of the advanced features of the platform
Preț: 288.20 lei
Preț vechi: 360.26 lei
-20% Nou
Puncte Express: 432
Preț estimativ în valută:
55.16€ • 57.84$ • 45.58£
55.16€ • 57.84$ • 45.58£
Carte disponibilă
Livrare economică 09-23 ianuarie 25
Livrare express 25-31 decembrie pentru 73.82 lei
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9781484262085
ISBN-10: 1484262085
Pagini: 585
Ilustrații: XXIV, 914 p. 1244 illus., 61 illus. in color.
Dimensiuni: 178 x 254 x 49 mm
Greutate: 1.6 kg
Ediția:2nd ed.
Editura: Apress
Colecția Apress
Locul publicării:Berkeley, CA, United States
ISBN-10: 1484262085
Pagini: 585
Ilustrații: XXIV, 914 p. 1244 illus., 61 illus. in color.
Dimensiuni: 178 x 254 x 49 mm
Greutate: 1.6 kg
Ediția:2nd ed.
Editura: Apress
Colecția Apress
Locul publicării:Berkeley, CA, United States
Cuprins
Chapter 1: Becoming Acquainted with Excel.- Chapter 2: Navigating and Working with Worksheets.- Chapter 3: Best Ways to Enter and Edit Data.- Chapter 4: Formatting and Aligning Data.- Chapter 5: Different Ways of Viewing and Printing your Workbook.- Chapter 6:Understanding Backstage.- Chapter 7: Creating and Using Formulas.- Chapter 8: Excel’s Pre-existing Functions.- Chapter 9: Auditing, Validating and Protecting your Data.- Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar.- Chapter 11: Transferring and Duplicating Data to Other Locations.- Chapter 12: Working with Tables.- Chapter 13: Working with Charts.- Chapter 14: Importing Data.- Chapter 15: Using PivotTables and PivotCharts.- Chapter 16: Geography and Stock Data Types.- Chapter 17: Enhancing Workbooks with Multimedia.- Chapter 18: Icons, 3D Images and Object Grouping.- Chapter 19: Automating Tasks with Macros.
Notă biografică
David Slager has been a computer programmer for four decades, with a focus on Excel. He also was head of the computer department of a college for many years. He is currently a software manager. David has worked with spreadsheets since their introduction. As a consultant, he developed major e-learning training projects for agriculture and steel businesses and designed a simulation program that trained feed market managers to use analytics to improve their market position. He enjoys working with analytics and solving problems and has taught learners of all ages and levels. David holds an MS in Education, specializing in Instructional Media Development, a BA in Organizational Management, and an associate’s degree in Accounting, as well as many certifications.
Annette Slager has been involved in data management and employee training in the non-profit and higher education sectors. She has been responsible for coordinating donor stewardship events and processes, and in overseeing information entered into the donor/alumni data system. She has transitioned systems from manual accounting and processing to shared databases, and created learning manuals and training for employees. Annette has a bachelor’s degree in English Literature and a post-baccalaureate certificate in Technical Writing.
Annette Slager has been involved in data management and employee training in the non-profit and higher education sectors. She has been responsible for coordinating donor stewardship events and processes, and in overseeing information entered into the donor/alumni data system. She has transitioned systems from manual accounting and processing to shared databases, and created learning manuals and training for employees. Annette has a bachelor’s degree in English Literature and a post-baccalaureate certificate in Technical Writing.
Textul de pe ultima copertă
Get up to speed quickly with Microsoft Excel 2019. See how easy it is to create, edit, sort, analyze, summarize, and format data. A broad range of other topics are covered, such as data import and export, sharing, visualization, validation, security, customization, and more.
Loaded with screen shots, step-by-step instructions, and hands-on exercises, Essential Excel 2019 makes it easy for you to get started or ramp up your skills with this powerful software.
In this book, you learn easy and accurate methods for entering data plus how to:
David Slager has been a computer programmer for four decades, with a focus on Excel. For many years he served as head of the computer department at a college. He is currently a software manager. He has worked with spreadsheets since their introduction. As a consultant, he developed major e-learning training projects for agriculture and steel businesses and designed a simulation program that trained feed market managers to use analytics to improve their market position. He enjoys working with analytics and solving problems and has taught learners of all ages and levels. He has an MS in education, specializing in instructional media development, a BA in organizational management, and an associate’s degree in accounting, as well as many certifications.
Annette Slager has been involved in data management and employee training in the non-profit and higher education sectors. She has been responsible for coordinating donor stewardship events and processes, and overseeing information entered into the donor/alumni data system. She has transitioned systems from manual accounting and processing to shared databases, and created learning manuals and training for employees. She has a bachelor’s degree in English literature and a post-baccalaureate certificate in technical writing.
Loaded with screen shots, step-by-step instructions, and hands-on exercises, Essential Excel 2019 makes it easy for you to get started or ramp up your skills with this powerful software.
In this book, you learn easy and accurate methods for entering data plus how to:
- Organize, format, filter, and consolidate your data in almost any way imaginable
- Use built-in functions and customize your own functions
- Create amazing visualizations of your data
- Extract just the information you want from imported data, and manipulate and format the data in the way you want
- Export your results to other programs orshare with others in the cloud
- Audit, validate, and protect your data
David Slager has been a computer programmer for four decades, with a focus on Excel. For many years he served as head of the computer department at a college. He is currently a software manager. He has worked with spreadsheets since their introduction. As a consultant, he developed major e-learning training projects for agriculture and steel businesses and designed a simulation program that trained feed market managers to use analytics to improve their market position. He enjoys working with analytics and solving problems and has taught learners of all ages and levels. He has an MS in education, specializing in instructional media development, a BA in organizational management, and an associate’s degree in accounting, as well as many certifications.
Annette Slager has been involved in data management and employee training in the non-profit and higher education sectors. She has been responsible for coordinating donor stewardship events and processes, and overseeing information entered into the donor/alumni data system. She has transitioned systems from manual accounting and processing to shared databases, and created learning manuals and training for employees. She has a bachelor’s degree in English literature and a post-baccalaureate certificate in technical writing.
Caracteristici
Provides hands-on learning through extensive workbooks and exercises for every chapter Written by an Excel expert with years of experience teaching people of all ages how to get the most out of Excel Gets you up to speed quickly and thoroughly on the new features in Excel 2019 and helps you better use the powerful tools available