Learn These New Excel Tricks

Unlock the full potential of Microsoft Excel with our comprehensive blog on Excel Tricks. Dive into a world of efficiency as we unravel time-saving shortcuts, advanced formulas, and ingenious tips to streamline your spreadsheet tasks. Whether you’re a beginner seeking fundamental insights or an experienced user aiming to master advanced functionalities, our blog caters to all skill levels.Learn These New Excel Tricks

Discover the art of data visualization with stunning charts and graphs, and learn how to present your findings with clarity and impact. Explore powerful functions like VLOOKUP, INDEX-MATCH, and pivot tables to manipulate data effortlessly. We share insider knowledge on lesser-known features that can revolutionize the way you work in Excel, enhancing your productivity and transforming raw data into actionable insights.

Stay ahead in your professional journey by mastering conditional formatting, data validation, and automation techniques. From keyboard shortcuts that save seconds to advanced analysis that saves hours, our Excel Tricks blog is your go-to resource for becoming an Excel maestro. Elevate your spreadsheet game and unlock the secrets that will make you a data-driven decision-making powerhouse. Join us on this transformative journey through the world of Excel mastery.

Learn These New Excel Tricks

Let’s start with different Excel Tricks:

Mastering Excel: Top 35 New Excel Tricks to Boost Your Productivity


Excel is a powerhouse for data analysis and organization, and mastering its array of formulas can significantly enhance your efficiency. In this blog post, we’ll explore the top New Excel Tricks with examples to help you become a proficient user.

Basic Formulas: New Excel Tricks

  1. SUM:
  • Example: =SUM(A1:A5)
  • Adds up values in cells A1 through A5.
  1. AVERAGE:
  • Example: =AVERAGE(B1:B10)
  • Calculates the average of values in cells B1 through B10.
  1. VLOOKUP:
  • Example: =VLOOKUP(D2, A1:B10, 2, FALSE)
  • Searches for D2 in A1:B10 and returns the corresponding value from the second column.
  1. HLOOKUP:
  • Example: =HLOOKUP(D2, A1:B10, 2, FALSE)
  • Similar to VLOOKUP, but searches in the first row.
  1. INDEX/MATCH:
  • Example: =INDEX(B1:B10, MATCH(D2, A1:A10, 0))
  • Returns the value in the same row as the matched value in column A.

Logical and Conditional Formulas:

  1. IF:
  • Example: =IF(C2>10, "Yes", "No")
  • Returns “Yes” if C2 is greater than 10, otherwise “No”.
  1. COUNT:
  • Example: =COUNT(C1:C10)
  • Counts non-empty cells in C1:C10.
  1. COUNTIF:
  • Example: =COUNTIF(D1:D10, ">50")
  • Counts cells in D1:D10 greater than 50.
  1. SUMIF:
  • Example: =SUMIF(A1:A10, "Apples", B1:B10)
  • Adds up values in column B where the corresponding cell in column A is “Apples”.
  1. CONCATENATE:
    • Example: =CONCATENATE(A2, " ", B2)
    • Combines values in A2 and B2 with a space in between.

Text and String Manipulation: New Excel Tricks

  1. LEFT:
    • Example: =LEFT(A1, 3)
    • Returns the leftmost 3 characters of the value in A1.
  2. RIGHT:
    • Example: =RIGHT(B1, 2)
    • Returns the rightmost 2 characters of the value in B1.
  3. LEN:
    • Example: =LEN(C1)
    • Returns the number of characters in cell C1.
  4. TRIM:
    • Example: =TRIM(A1)
    • Removes leading and trailing spaces from the value in A1.
  5. IFERROR:
    • Example: =IFERROR(D2/B2, "Error in calculation")
    • Returns D2/B2 or “Error in calculation” if an error occurs.

Date and Time Formulas:

  1. DATE:
    • Example: =DATE(2022, 12, 31)
    • Returns the date December 31, 2022.
  2. NOW:
    • Example: =NOW()
    • Returns the current date and time.
  3. INDIRECT:
    • Example: =INDIRECT("Sheet1!A1")
    • Returns the value in cell A1 of Sheet1.
  4. RANK:
    • Example: =RANK(E1, E1:E10, 1)
    • Calculates the rank of the value in E1 within E1:E10, in descending order.
  5. CHOOSE:
    • Example: =CHOOSE(A1, "Option 1", "Option 2", "Option 3")
    • Returns the value corresponding to A1, like “Option 1”, “Option 2”, or “Option 3”.

New Excel Tricks for Complex Analysis:

  1. MATCH:
    • Example: =MATCH(F2, G1:G10, 0)
    • Returns the relative position of the value in F2 within G1:G10.
  2. IFNA:
    • Example: =IFNA(VLOOKUP(H2, I1:J10, 2, FALSE), "Not Found")
    • Returns VLOOKUP result or “Not Found” if #N/A error occurs.
  3. IFERROR with VLOOKUP:
    • Example: =IFERROR(VLOOKUP(K2, L1:M10, 2, FALSE), "No Match")
    • Returns VLOOKUP result or “No Match” if an error occurs.
  4. DATEDIF:
    • Example: =DATEDIF(N1, N2, "d")
    • Calculates the difference in days between dates in cells N1 and N2.
  5. MIN:
    • Example: =MIN(O1:O10)
    • Returns the smallest value in the range O1:O10.
  6. MAX:
    • Example: =MAX(P1:P10)
    • Returns the largest value in the range P1:P10.
  7. ROUND:
    • Example: =ROUND(Q1, 2)
    • Rounds the value in Q1 to two decimal places.
  8. UPPER:
    • Example: =UPPER(R1)
    • Converts the text in cell R1 to uppercase.
  9. LOWER:
    • Example: =LOWER(S1)
    • Converts the text in cell S1 to lowercase.
  10. PROPER:
    • Example: =PROPER(T1)
    • Converts the text in cell T1 to proper case.

Formulas for Text and Date Formatting:

  1. TEXT:
    • Example: =TEXT(U1, "dd-mmm-yyyy")
    • Converts the date in cell U1 to the specified text format.
  2. SUMPRODUCT:
    • Example: =SUMPRODUCT(V1:V5, W1:W5)
    • Calculates the sum of the products of corresponding values in V1:V5 and W1:W5.
  3. IF AND OR:
    • Example: =IF(AND(X1>5, OR(Y1="A", Y1="B")), "Yes", "No")
    • Returns “Yes” if X1 is greater than 5 and Y1 is either “A” or “B”, otherwise “No”.
  4. IF with ISBLANK:
    • Example: =IF(ISBLANK(Z1), "Empty", "Not Empty")
    • Returns “Empty” if Z1 is blank, otherwise “Not Empty”.
  5. SUBTOTAL:
    • Example: =SUBTOTAL(109, AA1:AA10)
    • Calculates the sum of values in AA1:AA10, ignoring

Hope these tips formulas helps you. Comment for any suggestions

Leave a Reply

Your email address will not be published. Required fields are marked *