Day-5 Lookup in Excel
Lookup in Excel Lookup in Excel. 📘 What is Lookup in Excel? Lookup refers to the process of searching for specific data in a dataset or table and returning corresponding results. It is especially useful when working with large tables where you need to find information quickly based on a known value. 📊 Example: You […]
Day-4 Excel Functions & Data Validation.
Excel Functions & Data Validation. 1. IF, AND, and OR Functions. ✅ IF Function – Conditional Decision Making. The IF function is used when you want Excel to make decisions based on logic. It checks whether a condition is true or false, and then returns a value accordingly. Syntax: =IF(logical_test, value_if_true, value_if_false) Detailed Example: =IF(A2>=35, […]
Day-1 Introduction to PowerBI
Day-3 Excel Functions: Text, Date & Time, Statistical, and Mathematical Functions
Excel Functions: Text, Date & Time, Statistical, and Mathematical Functions 1. Text Functions in Excel. Overview Text functions in Excel help manipulate, format, and process text data efficiently. These functions are useful for cleaning data, extracting information, and formatting text. Common Text Functions. Function Description Example & Output LEFT Extracts a specific number of characters […]
Day-2 Basic Formatting , Formula , Function and Sorting and Filtering in Excel.
Day-2 Basic Formatting , Formula , Function and Sorting and Filtering in Excel. Basic Functions of Excel Microsoft Excel provides a wide range of functions to simplify data management, calculations, and analysis. Some of the most commonly used functions include: SUM Function: Adds up all the numbers in a given range. Formula: =SUM(A1:A10) AVERAGE Function: […]
Introduction to Excel.
Getting Started with Excel Introduction to Microsoft Excel Microsoft Excel is one of the most widely used spreadsheet applications, developed by Microsoft, and is a part of the Microsoft Office suite. It helps users manage, analyze, and visualize data efficiently. Excel provides features such as formulas, functions, charts, pivot tables, and data validation, making it […]
UNIT-5: Python Collections and Library
UNIT-5: Python Collections and Library UNIT-5: Python Collections and Library 5.1.1 Tuples in Python. A tuple in Python is an ordered, immutable collection used to store multiple items in a single variable. Unlike lists, tuples cannot be modified (i.e., no adding, removing, or changing elements after creation). Tuples are useful when we want to ensure […]
UNIT-4: Python conditional and iterative statements
UNIT-4: Python conditional and iterative statements UNIT-4: Python conditional and iterative statements 4.1 Conditional Statements in Python Conditional statements in Python allow decision-making in programs. The if, if-elif, if-elif-else, and nested if statements help execute specific blocks of code based on conditions. 4.1.1 If Statement The if statement checks a condition. If the condition is […]
UNIT-3: Python Strings and Operators
UNIT-3: Python Strings and Operators UNIT-3: Python Strings and Operators 3.1 Python Strings. A string in Python is a sequence of characters enclosed within single (‘), double (“), or triple (”’ “””) quotes. Strings are immutable, meaning they cannot be changed once created. 3.1.1 Multiline String, String as Character Array, Triple Quotes Multiline Strings Python […]
UNIT-2: Python Fundamentals
UNIT-2: Python Fundamentals UNIT-2: Python Fundamentals 2.1 Concepts of Interpreter-Based Programming Language. What is an Interpreter-Based Programming Language? An interpreter-based language executes the code line by line instead of compiling the entire program before running it. Python is an interpreted language, unlike C or Java, which are compiled. How an Interpreter Works The Python Interpreter […]