+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Lookup Functions And Logical Functions: Excel For Beginners (/Thread-Lookup-Functions-And-Logical-Functions-Excel-For-Beginners)
Lookup Functions And Logical Functions: Excel For Beginners - AD-TEAM - 03-23-2025
![[Image: 354ad56141bb73cdc53b1dd1e6c66c69.jpg]](https://i124.fastpic.org/big/2025/0323/69/354ad56141bb73cdc53b1dd1e6c66c69.jpg)
Lookup Functions And Logical Functions: Excel For Beginners
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.00 GB | Duration: 1h 19m
A beginner's guide to Excel spreadsheets, formulas, and fundamental data analysis.
What you'll learn
Efficiently use VLOOKUP to retrieve information from Excel datasets.
Execute VLOOKUP with an approximate match for flexible data retrieval.
Effectively use error-handling functions to manage and troubleshoot data issues.
Apply IF, AND, and OR functions for logical analysis and decision-making.
Requirements
Basic Excel knowledge - Familiarity with basic Excel functions like entering data and simple formulas.
Willingness to practice - Practicing the formulas and functions will help reinforce your skills.
Microsoft Excel installed - You need Excel to follow along with the course.
No prior advanced formula experience required - This course is suitable for beginners with a basic understanding of Excel.
Description
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to the Microsoft Excel Beginner course. This short course introduces intermediate formulas for new users of Excel. You will learn how to use the VLOOKUP function to look up and retrieve data from large tables. The course also covers handling errors using the IFERROR and IFNA functions, ensuring your formulas work smoothly even when data is missing or incorrect.Each lesson includes video tutorials and downloadable exercises, ensuring hands-on practice for comprehensive learning.Whether you are taking your first steps into spreadsheet management or seeking to solidify your beginner-level skills, this course will equip you with the skills to create high-quality spreadsheets that meet the needs of your audience. Join us and ELEVATE your Excel proficiency today.In this course, you will learn how to:Efficiently use VLOOKUP to retrieve information from Excel datasets.Execute VLOOKUP with an approximate match for flexible data retrieval.Effectively use error-handling functions to manage and troubleshoot data issues.Apply IF, AND, and OR functions for logical analysis and decision-making.This course includes:78 minutes of video tutorials10 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
Overview
Section 1: Intermediate Formulas
Lecture 1 Course Introduction
Lecture 2 WATCH ME: Essential Information for a Successful Training Experience
Lecture 3 DOWNLOAD ME: Course Files
Lecture 4 DOWNLOAD ME: Exercise Files
Lecture 5 Looking up Information with VLOOKUP
Lecture 6 VLOOKUP Approximate Match
Lecture 7 Error Handling Functions
Lecture 8 Basic Logical Functions (IF, AND, OR)
Lecture 9 Making Decisions with IF Statements
Lecture 10 Cleaning Data Using Text Functions
Lecture 11 Working with Time and Date Functions
Lecture 12 Exercise
Lecture 13 Course Close
Beginners who are new to Microsoft Excel and want to learn intermediate formulas to improve their spreadsheet skills.,Students who want to build their Excel knowledge and need help with formulas and data analysis.,Professionals who work with data and want to learn how to use Excel.,Anyone who has basic knowledge of Excel and is ready to take their skills to the next level.
![[Image: MPo5v5lR_o.jpg]](https://images2.imgbox.com/ba/cb/MPo5v5lR_o.jpg)
TurboBit
RapidGator
FileFactory