國立高雄大學圖資館 |

Language: English

Back

Essential Excel 2019a step-by-step g...

Slager, Annette.

Essential Excel 2019a step-by-step guide /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Essential Excel 2019by David Slager, Annette Slager.
Reminder of title:	a step-by-step guide /
Author:	Slager, David.
other author:	Slager, Annette.
Published:	Berkeley, CA :Apress :2020.
Description:	xxiv, 914 p. :ill., digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	Electronic spreadsheetsComputer programs.
Online resource:	https://doi.org/10.1007/978-1-4842-6209-2
ISBN:	9781484262092$q(electronic bk.)

Essential Excel 2019a step-by-step guide /
Slager, David.

Essential Excel 2019a step-by-step guide /[electronic resource] :by David Slager, Annette Slager. - Second edition. - Berkeley, CA :Apress :2020. - xxiv, 914 p. :ill., digital ;24 cm.

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.

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: 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 or share with others in the cloud Audit, validate, and protect your data This book delivers essential how-to and reference information to users new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to date on the latest changes and features in Excel 2016. 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.

ISBN: 9781484262092$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-6209-2doiSubjects--Uniform Titles:

Microsoft Excel (Computer file)
Subjects--Topical Terms:

220170
Electronic spreadsheets
--Computer programs.

LC Class. No.: HF5548.4.M523 / S53 2020

Dewey Class. No.: 004

Essential Excel 2019a step-by-step guide /
LDR:04434nmm a2200337 a 4500 001 589079
003 DE-He213
005 20210205094947.0
006 m d
007 cr nn 008maaau
008 210525s2020 cau s 0 eng d
020 $a 9781484262092$q(electronic bk.)
020 $a 9781484262085$q(paper)
024 7 $a 10.1007/978-1-4842-6209-2 $2 doi
035 $a 978-1-4842-6209-2
040 $a GP $c GP
041 0 $a eng
050 4 $a HF5548.4.M523 $b S53 2020
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 004 $2 23
090 $a HF5548.4.M523 $b S631 2020
100 1 $a Slager, David. $3 763324
245 1 0 $a Essential Excel 2019 $h [electronic resource] : $b a step-by-step guide / $c by David Slager, Annette Slager.
250 $a Second edition.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a xxiv, 914 p. : $b ill., digital ; $c 24 cm.
505 0 $a 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.
520 $a 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: 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 or share with others in the cloud Audit, validate, and protect your data This book delivers essential how-to and reference information to users new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to date on the latest changes and features in Excel 2016. 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.
630 0 0 $a Microsoft Excel (Computer file) $3 190780
650 0 $a Electronic spreadsheets $x Computer programs. $3 220170
650 0 $a Computer science. $3 199325
650 0 $a Application software. $3 200645
650 1 4 $a Microsoft and .NET. $3 760507
650 2 4 $a Professional Computing. $3 763344
650 2 4 $a Statistics, general. $3 275684
650 2 4 $a Computer Applications. $3 273760
700 1 $a Slager, Annette. $3 880790
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-6209-2
950 $a Professional and Applied Computing (SpringerNature-12059)