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.