Inicio > > Informática: cuestiones generales > Excel XLOOKUP and Other Lookup Functions
Excel XLOOKUP and Other Lookup Functions

Excel XLOOKUP and Other Lookup Functions

Excel XLOOKUP and Other Lookup Functions

Nathan George

12,13 €
IVA incluido
Disponible
Editorial:
GTech Publishing
Año de edición:
2020
Materia
Informática: cuestiones generales
ISBN:
9781916211360
12,13 €
IVA incluido
Disponible

Selecciona una librería:

  • Librería Samer Atenea
  • Librería Aciertas (Toledo)
  • Kálamo Books
  • Librería Perelló (Valencia)
  • Librería Elías (Asturias)
  • Donde los libros
  • Librería Kolima (Madrid)
  • Librería Proteo (Málaga)
Sobre IBD

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. XLOOKUP is a new and exciting function that replaces VLOOKUP and addresses most of the limitations of its predecessor. XLOOKUP is so versatile that it also replaces HLOOKUP 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 XLOOKUP, XMATCH, FILTER, SORT, CHOOSE, INDEX etc. VLOOKUP 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 VLOOKUP in some depth. If you’re looking to skill up on VLOOKUP, 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.

Artículos relacionados

  • Interview with Jeffery Khoury, Bringing Telemedicine to the People
    Richard G Lowe Jr
    Did you know you can consult with a medical specialist over your smartphone from the comfort of your own home? Imagine speaking to a highly-trained and accredited doctor about whatever is ailing you from virtually anywhere in the world.Thanks to a young entrepreneur named Jeffery Khoury, you can get the advice you need from a pool of medical specialists without waiting in a doc...
  • IT Consulting Secrets
    Carl A Katz
    This book is for IT consultants of all experience levels and the content is relevant to any IT support business model from managed services (MSP) to break/fix. The author has methodically compiled these strategies and this information from over sixteen years of experience working in the IT support field at the small and medium sized business and enterprise levels. ...
    Disponible

    29,41 €

  • Modeling, Analysis, and Applications in Metaheuristic Computing
    Peng-Yeng Yin
    The engineering and business problems the world faces today have become more impenetrable and unstructured, making the design of a satisfactory problem-specific algorithm nontrivial. Modeling, Analysis, and Applications in Metaheuristic Computing: Advancements and Trends is a collection of the latest developments, models, and applications within the transdisciplinary fields rel...
  • Knowledge Management and Drivers of Innovation in Services Industries
    Knowledge Management is concerned with all aspects of eliciting, acquiring, modelling, and managing knowledge. Application of knowledge resources successfully helps the organization to deliver creative products and services. Especially in service business, service job experience and information about the customer, as well as the installed site equipment, are key factors to deli...
  • Current Trends and Future Practices for Digital Literacy and Competence
    Antonio Cartelli
    Being a digital citizen has transformed from a process of familiarizing ones’ self with terminology and techniques to a full-time responsibility in the hands of any who want to stay abreast of the latest technological change in their respective field. Current Trends and Future Practices for Digital Literacy and Competence offers a look at the latest research within digital lite...
  • Human Rights and Risks in the Digital Era
    Globalization, along with its digital and information communication technology counterparts, including the Internet and cyberspace, may signify a whole new era for human rights, characterized by new tensions, challenges, and risks for human rights, as well as new opportunities. Human Rights and Risks in the Digital Era: Globalization and the Effects of Information Technologies ...

Otros libros del autor

  • Mastering Excel VBA Programming
    Nathan George
    Leverage the full power of Excel with VBAThis guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel’s functionality with VBA to create solutions not possible with the standard features.Mastering Excel VBA Programming takes you step-by-step from beginner to expert with Excel VBA. This book start...
  • Mastering Excel VBA Programming
    Nathan George
    Leverage the full power of Excel with VBAThis guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel’s functionality with VBA to create solutions not possible with the standard features.Mastering Excel VBA Programming takes you from beginner to expert in Excel VBA. This book starts with the basi...
    Disponible

    40,23 €

  • Mastering Excel 365
    Nathan George
    Learn Excel Fast in Simple and Easy StepsMastering Excel 365 is your all-in-one, step-by-step tutorial to the latest and most powerful version of Excel from Microsoft 365 in 2023. 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...
  • Mastering Excel 365
    Nathan George
    Learn Excel Fast in Simple and Easy StepsMastering Excel 365 is your all-in-one, step-by-step tutorial to the latest and most powerful version of Excel from Microsoft 365 in 2023. 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...
    Disponible

    52,10 €

  • Excel 365 Advanced Topics
    Nathan George
    Gain expert Excel skills and easily perform complex tasksWhether you have basic Excel skills or you’re a power user, Excel 365 Advanced Topics is full of tips, techniques, and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheet solutions, using the right tool in Excel can increase the accuracy and efficiency o...
    Disponible

    26,47 €

  • Excel Formulas and Functions
    Nathan George
    Leverage the full power of Excel functionsExcel Formulas and Functions provides clear, step-by-step explanations on creating formulas with over 80 of the most useful Excel functions.This book provides a detailed description of each function, its arguments, and practical examples relevant to real-world productivity tasks. Create powerful formulas with simpler syntax using modern...