Kategorien Über uns
home.book.professional_ebook

Ms Excel Logical and Lookup Functions

82
Sprache :  English
Logical and Lookup functions are very powerful Microsoft Excel functions, and are frequently used for business analysis purposes. These sought-after functions are covered in great detail in this book.
Professional Plus Mitgliedschaft 30 Tage gratis, danach $6.99/Monat
Beschreibung
Inhalt
book.tabs.learning objectives

The ability to analysis information, show data trends and cross reference information are invaluable skills in the modern workplace. There are function areas in Microsoft Excel, namely Logical and Lookup Functions, which are designed to effectively perform these types of tasks. This book covers in a step-by-step manner the use of Logical and Lookup functions as well as explaining how and why these functions are used. There are many useful Logical and Lookup Functions covered in this book including, Vlookup, Hlookup, Xlookup, Match and Index, IF, And, Or, Not and Nested Logical Functions.

About the Author

My name is Richard Giles Walters, and I am a qualified teacher (Cert/Ed) with vast experience of training Microsoft (MS) Office applications. I deliver both classroom and online training in MS Office applications, including MS Excel and MS Project. I am an experienced MS Office book author and I look forward to writing books as a BookBoon author, to further develop my writing skills and experience. I am a qualified Microsoft Office Specialist (MOS) Expert and I constantly look at ways to develop my own skills in the use of MS Office, to enhance my own training methods.

  • About the Author
  • Introduction
  1. What is a Lookup Function
    1. Different types of Lookup Functions
    2. Lookup Functions and Cell Referencing
    3. Lookup Functions and Named Ranges
    4. The Vlookup Function
    5. The Hlookup Function
    6. Vlookup and Hlookup “Table Array” Design Requirements
    7. The Xlookup Function
    8. The Match Function
    9. The Index Function (Array)
    10. Combining the Match and Index (Array) Functions
  2. What is a Logical Function
    1. Different types of Logical Functions
    2. The IF Function
    3. The AND Function
    4. The OR Function
    5. The NOT Function
    6. Nested IF Functions
    7. Nested Functions IF/AND/OR/NOT
  • Table of Figures

Explain how to use Lookup functions to find and match data in MS Excel sheets and workbooks. Apply Logical functions to test conditions and present true or false results or custom messages. Demonstrate how to use complex logic combinations with IF, AND, OR, and NOT functions to solve real-life data problems. Design spreadsheet tables effectively to meet requirements for Vlookup and Hlookup, understanding why their structure matters. Use named ranges and absolute cell referencing to make formulas stable and accurate when copying across multiple cells.

Über den Autor/die Autorin

Richard Giles Walters