Posts

Current Date and Time for Excel Formulas and Functions 2024 in Hindi and Gujarati | Excel Formula Tutorial | Excel Formulas

Image
  Excel Formulas for Current Date and Time Excel provides easy-to-use formulas for inserting the current date, time, or both into a worksheet. Here are the formulas along with examples: 1. Current Time Only Formula Formula: =TEXT(NOW(), "HH:MM:SS AM/PM") or =TEXT(NOW(), "HH:MM:SS") for a 24-hour format. Automatic Updates: Both =TODAY() and =NOW() are dynamic and update automatically whenever the worksheet recalculates. Static Date and Time: If you want to insert the current date or time as a static value (that doesn’t change), you can press Ctrl + ; for the current date and Ctrl + Shift + ; for the current time. Description: This formula extracts and formats the current time from the NOW() function. Example: If the current time is 11:55 AM, entering =  Ctrl + Shift + ;  press  will display 11:55:00 AM. https://youtu.be/8sM9GWmZHGU 2. Current Date Formula Formula: =TODAY() Description: This formula returns the current date. The date is updated every time th...
Post a Comment
Read more

SUM, SUBTOTAL, SUMPRODUCT, SUBSTITUTE, SUMIF and SUMIFS formulas in Excel

Image
  Excel SUM Series
Post a Comment
Read more

COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS formulas in Excel

Image
  Excel Count Series Here’s a breakdown of the COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS formulas in Excel, including their usage and examples 1. COUNT Formula: The COUNT formula is used to count the number of cells that contain numbers within a specified range. COUNT: Counts the number of cells with numbers. COUNT: =COUNT(F2:F21) http://www.youtube.com/@Jemal_Knowledge32 https://youtu.be/Xi6Q8ayeuNs https://www.linkedin.com/posts/hitesh-darji-11452b271_exceltutorial-exceltips-exceltraining-activity-7224774354536996864-fpWC?utm_source=share&utm_medium=member_android https://www.instagram.com/reel/C-IUSn9yMR3/?igsh=MWg3YmZybXZ0bWNuMg== COUNTA:=COUNT(C2:D13)   3. COUNTBLANK Formula The COUNTBLANK formula is used to count the number of empty cells within a specified range. COUNTBLANK: Counts the number of empty cells. COUNTBLANK: = COUNTBLANK(B1:I21) 4. COUNTIF Formula The COUNTIF formula counts the number of cells that meet a single specifi...
Post a Comment
Read more

EXCEL 5 BASIC FORMULA

Image
  EXCEL 5 BASIC FORMULA   The syntax for the SUM function is: number1 is the first number or range to add. [number2] (optional) is additional numbers or ranges to add 1. Usage Examples Adding Individual Numbers This formula adds all the numbers in the range from cell F3 to F12 =SUM(F3:F12) The syntax for the MAX function is: number1 is the first number or range to evaluate. [number2] (optional) is additional numbers or ranges to evaluate. https://youtu.be/26AJIexDCSQ https://www.instagram.com/reel/C943ggHMcat/?utm_source=ig_web_copy_link&igsh=MzRlODBiNWFlZA== https://www.facebook.com/reel/467306936087796/?mibextid=4MzKDw5ooBP2efJs https://www.facebook.com/profile.php?id=100009298898110 https://www.linkedin.com/posts/hitesh-darji-11452b271_excel-vlookup-spreadsheet-activity-7222601907989565441-9D_D?utm_source=share&utm_medium=member_desktop 2. Usage Examples Finding the Maximum of Individual Numbers Finding the Maximum in a Range of Cells G3 to G12 =MAX(G3:G12) Th...
Post a Comment
Read more

The VLOOKUP function is a powerful tool in Excel

Image
  The VLOOKUP function is a powerful to ol in Excel VLOOKUP Syntax Excel Copy code =VLOOKUP (lookup value, table array, col index num, [range lookup]) Arguments lookup value : The value you want to search for. This can be a value, a cell reference, or a text string. table array : The range of cells that contains the data. The first column of this range is where Excel will search for the lookup value. col index num: The column number in the table array from which to retrieve the value. The first column of the table array is 1, the second column is 2, and so on. range lookup : An optional argument that determines whether you want an exact match or an approximate match: TRUE or omitted: Finds an approximate match. If an exact match is not found, the next largest value less than the lookup value is returned. The first column of the table array must be sorted in ascending order. FALSE: Finds an exact match. If an exact ...
Post a Comment
Read more
  Microsoft excel basic tools knowledge 1: Introduction to Excel Interface 1.1 Excel Interface Overview Image: Excel home screen with main sections labeled (Ribbon, Workbook, Worksheet, Formula Bar, etc.) Details: Brief description of each section. 1.2 Ribbon and Tabs Home Tab: Font Group: Image: Font group highlighted. Details: Changing font style, size, color, and adding effects (bold, italic, underline). Alignment Group: Image: Alignment group highlighted. Details: Aligning text (left, center, right), merging cells, wrapping text. Number Group: Image: Number group highlighted. Details: Formatting numbers, currency, dates, percentages. 2: Basic Functions and Formulas 2.1 Basic Formulas SUM Function: Image: Example of using the SUM function. Details: Adding a range of cells (e.g., =SUM(A1:A10) ). AVERAGE Function: Image: Example of using the AVERAGE function. Details: Calculating the average of a range of cells (e.g., =AVERAGE(B1:B10) ). COUNT Function: Image: Example...
Post a Comment
Read more