Gtech Publishing (316 results)

paperback. Condition: Good.

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Condition: acceptable. Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may be missing bundled media.

Paperback. Condition: Good. Learn Excel Fast in Simple and Easy StepsMastering Excel 2019 is your all-in-one, step by step, tutorial to the latest and most powerful version of Excel from Microsoft 365. This book contains everything you need to know to master the basics of Excel and a selection of advanced topics relevant to real-world productivity tasks you'll encounter in your job, business or home.This guide has been designed to be a resource for you whether you're an Excel beginner, intermediate user, or a power user. You will learn not only how to use specific features, but in what context those features need to be used.Excel Made Easy without the JargonThis book is concise and to the point, using clear and practical examples that you can adapt to your own needs. The aim is to show you how to perform tasks in Excel as quickly as possible without getting bogged down with the unnecessary filler text you may find in some other Excel books.Three books in one Mastering Excel 2019 is made up of Excel 2019 Basics, Excel 2019 Advanced Topics, and Excel 2019 Functions. Now brought together and organized as an all-in-one powerful guide. This book brings you all the powerful material in those books and more.Mastering Excel 2019 also comes with downloadable sample files to enable you to follow the examples in the book hands-on.By reading this book, you will: Master all the fundamentals to quickly get up to speed with creating solutions for common Excel tasks.Create basic and advanced formulas for different types of calculations.Use Excel tables to easily manage and manipulate your data.Filter, sort, and apply styles to data lists and Excel tables.Analyze your data visually with charts and sparklines.Use data from external sources like Access databases, CSV text files, and websites.Deploy macros to automate repetitive tasks and increase your efficiency.Create dynamic summaries of your data with pivot tables and pivot charts.Analyze different data scenarios and projections with What-If Analysis tools.Password-protect workbooks, worksheets, ranges, or even specific cells.Create formulas with over 70 of the most useful and powerful Excel functions, including new dynamic array functions like XLOOKUP, XMATCH and FILTER.Master many more Excel features.Get your copy today and start your journey to mastering Excel.…

paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority.

Paperback. Condition: Good. Learn Excel Fast in Simple and Easy StepsMastering Excel 2019 is your all-in-one, step by step, tutorial to the latest and most powerful version of Excel from Microsoft 365. This book contains everything you need to know to master the basics of Excel and a selection of advanced topics relevant to real-world productivity tasks you'll encounter in your job, business or home.This guide has been designed to be a resource for you whether you're an Excel beginner, intermediate user, or a power user. You will learn not only how to use specific features, but in what context those features need to be used.Excel Made Easy without the JargonThis book is concise and to the point, using clear and practical examples that you can adapt to your own needs. The aim is to show you how to perform tasks in Excel as quickly as possible without getting bogged down with the unnecessary filler text you may find in some other Excel books.Three books in one Mastering Excel 2019 is made up of Excel 2019 Basics, Excel 2019 Advanced Topics, and Excel 2019 Functions. Now brought together and organized as an all-in-one powerful guide. This book brings you all the powerful material in those books and more.Mastering Excel 2019 also comes with downloadable sample files to enable you to follow the examples in the book hands-on.By reading this book, you will: Master all the fundamentals to quickly get up to speed with creating solutions for common Excel tasks.Create basic and advanced formulas for different types of calculations.Use Excel tables to easily manage and manipulate your data.Filter, sort, and apply styles to data lists and Excel tables.Analyze your data visually with charts and sparklines.Use data from external sources like Access databases, CSV text files, and websites.Deploy macros to automate repetitive tasks and increase your efficiency.Create dynamic summaries of your data with pivot tables and pivot charts.Analyze different data scenarios and projections with What-If Analysis tools.Password-protect workbooks, worksheets, ranges, or even specific cells.Create formulas with over 70 of the most useful and powerful Excel functions, including new dynamic array functions like XLOOKUP, XMATCH and FILTER.Master many more Excel features.Get your copy today and start your journey to mastering Excel.…

Condition: acceptable. Book is considered to be in acceptable condition. The actual cover image may not match the stock photo. Book may have one or more of the following defects: noticeable wear on the cover dust jacket or spine; curved, dog eared or creased page s ; writing or highlighting inside or on the edges; sticker s or other adhesive on cover; CD DVD may not be included; and book may be a former library copy.…

Condition: good. This book is in good condition. The cover has minor creases or bends. The binding is tight and pages are intact. Some pages may have writing or highlighting.

Condition: very_good. This book is in Very Good condition. The cover and pages have minor shelf wear. Binding is tight and pages are intact.

Condition: good. All pages and cover are intact. Dust jacket included if applicable, though it may be missing on hardcover editions. Spine and cover may show minor signs of wear including scuff marks, curls or bends to corners as well as cosmetic blemishes including stickers. Pages may contain limited notes or highlighting. "From the library of" labels may be present. Shrink wrap, dust covers, or boxed set packaging may be missing. Bundled media e.g., CDs, DVDs, access codes may not be included.…

Condition: acceptable. Book shows noticeable wear from use. May include writing, highlighting, or other markings, but not excessive. Cover or edges may have visible wear. The book remains complete and fully readable.

Paperback. Condition: Good. Leverage New Powerful Lookup Functions in Excel 2019 Dynamic array formulas represent one of the biggest changes to Excel formulas in years. Maybe the biggest change ever. They enable you to work with multiple return values at the same time in a formula. XLOKUP is a new and exciting function that replaces VLOKUP and addresses most of the limitations of its predecessor. XLOKUP is so versatile that it also replaces HLOKUP and the INDEX/MATCH/MATCH combination used for simultaneous vertical and horizontal lookups. A Detailed Walkthrough of New and Exciting Lookup Functions Recently Released This book provides comprehensive coverage of several of the newly released dynamic array lookup formulas in more depth, and with more examples, than would have been practical in a general-purpose Excel book. Learn how to use functions like XLOKUP, XMATCH, FILTER, SORT, CHOSE, INDEX etc. VLOKUP will still be in use for a while as the new dynamic array functions are not available to one-time purchase version of Office users yet. For that reason, this book also covers the good old VLOKUP in some depth. If you're looking to skill up on VLOKUP, then this book is also for you. Functions can save you a lot of time as they're tried and tested predefined formulas.From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.Included are downloadable Excel practice files to enable you to follow the examples in the book hands-on.…

Condition: acceptable. Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may be missing bundled media.

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Hardcover. Condition: Good. Hardcover. NO DUST JACKET. Pages are clean and unmarked. Covers show light edge wear with rubbing/light scuffing. Binding is tight, hinges strong.; 100% Satisfaction Guaranteed! Ships same or next business day.

Condition: Good. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.

Paperback. Condition: Good. Leverage New Powerful Lookup Functions in Excel 2019 Dynamic array formulas represent one of the biggest changes to Excel formulas in years. Maybe the biggest change ever. They enable you to work with multiple return values at the same time in a formula. XLOKUP is a new and exciting function that replaces VLOKUP and addresses most of the limitations of its predecessor. XLOKUP is so versatile that it also replaces HLOKUP and the INDEX/MATCH/MATCH combination used for simultaneous vertical and horizontal lookups. A Detailed Walkthrough of New and Exciting Lookup Functions Recently Released This book provides comprehensive coverage of several of the newly released dynamic array lookup formulas in more depth, and with more examples, than would have been practical in a general-purpose Excel book. Learn how to use functions like XLOKUP, XMATCH, FILTER, SORT, CHOSE, INDEX etc. VLOKUP will still be in use for a while as the new dynamic array functions are not available to one-time purchase version of Office users yet. For that reason, this book also covers the good old VLOKUP in some depth. If you're looking to skill up on VLOKUP, then this book is also for you. Functions can save you a lot of time as they're tried and tested predefined formulas.From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.Included are downloadable Excel practice files to enable you to follow the examples in the book hands-on.…

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Condition: New.

Paperback. Condition: Good. Database creation and management made easyWhether you're new to Access or looking to refresh your skills on this popular desktop database application, you'll find everything you need to create efficient and robust database solutions for your data in this book.Even if you have no formal database training, don't worry. This book starts from the basics and shows you how to structure your data for a relational database management system.Clear, concise, and straightforwardThis book offers clear and straightforward explanations on creating tables and relationships, building user-friendly forms, importing data from external sources, writing queries to answer questions, and presenting information with reports.Practical examples for hands-on learningMastering Access 365 is a practical guide, using examples from a case study to demonstrate each aspect of Access. Screenshots illustrate the concepts, features, and tasks being discussed.The best way to learn is through practice, so downloadable sample files have been provided to enable you to follow the examples in the book hands-on.This book covers Access 2021 and the latest version of Access for Microsoft 365 (2022 update).Learn how to: Plan your database, including how to capture and refine your data requirements.Structure your data design for efficient data storage. Create Access tables and define table relationships.Quickly generate feature-rich, user-friendly forms to simplify data entry.Write queries to answer questions and perform data updates.Build quick and powerful reports to present and analyze your data.Perform different data transformation tasks to clean up or organize your data.Import and export data to/from external sources like Excel, text files, and SQL Server.Split your database into front-end and back-end files in a multi-user environment.…

Paperback or Softback. Condition: New. Excel XLOOKUP and Other Lookup Functions. Book.

Condition: As New. Unread book in perfect condition.

Condition: very_good. Book is in very good condition and may include minimal underlining highlighting. The book can also include "From the library of" labels. May not contain miscellaneous items toys, dvds, etc. . We offer 100% money back guarantee and 24 7 customer service.

Condition: new.

Paperback. Condition: Good. Database creation and management made easyWhether you're new to Access or looking to refresh your skills on this popular desktop database application, you'll find everything you need to create efficient and robust database solutions for your data in this book.Even if you have no formal database training, don't worry. This book starts from the basics and shows you how to structure your data for a relational database management system.Clear, concise, and straightforwardThis book offers clear and straightforward explanations on creating tables and relationships, building user-friendly forms, importing data from external sources, writing queries to answer questions, and presenting information with reports.Practical examples for hands-on learningMastering Access 365 is a practical guide, using examples from a case study to demonstrate each aspect of Access. Screenshots illustrate the concepts, features, and tasks being discussed.The best way to learn is through practice, so downloadable sample files have been provided to enable you to follow the examples in the book hands-on.This book covers Access 2021 and the latest version of Access for Microsoft 365 (2022 update).Learn how to: Plan your database, including how to capture and refine your data requirements.Structure your data design for efficient data storage. Create Access tables and define table relationships.Quickly generate feature-rich, user-friendly forms to simplify data entry.Write queries to answer questions and perform data updates.Build quick and powerful reports to present and analyze your data.Perform different data transformation tasks to clean up or organize your data.Import and export data to/from external sources like Excel, text files, and SQL Server.Split your database into front-end and back-end files in a multi-user environment.…

Paperback. Condition: Fine.

Paperback. Condition: New.

Condition: New.

Paperback or Softback. Condition: New. Excel 2019 Macros and VBA: An Introduction to Excel Programming. Book.

Condition: As New. Unread book in perfect condition.