Skip to content

Contact:    TDL Development - 9028914917 (Sohel)     |     Excel Support - 9536250020 (Nazim)       

TechGuruPlus.com
  • HOME
  • BLOG
  • DOWNLOAD
    • 70+ Invoice Format
    • 50+ Salary Format
    • 50+ Quotation Format
    • 60+ Proforma Invoice
    • PowerPoint Templates
    • All Shortcut Keys
    • 30+ YouTube Templates
    • 70+ YouTube Background
  • TALLY TDL
    • Tally Prime TDL
    • Tally ERP 9 TDL
  • RESUME
  • BIO-DATA
  • VIDEOS
  • CONTACT
    • CONTACT US
    • ABOUT US
    • IMAGE GALLERY
    • PRIVACY POLICY
  • Part-Time Business
    • 10 Business Ideas for Accountant
    • 7 Instagram Business Ideas
    • 8 Passive Income Ideas
    • 50 Home Based Business Ideas
    • 12 Profitable Business Ideas
    • Make Money with Telegram
    • Make Money with Instagram
    • 48 Low Investment Ideas
    • College Student Business Ideas
    • 14 Business Ideas for Women
    • 8 YouTube Money Making
    • more…
  • Stock Management Software
  • Experience Certificate
  • Cheque Printing Software
  • Proforma Templates
  • Shortcuts Keys
  • YouTube Design
  • Balance Sheet Format
  • Free Excel Course
  • Invoice Format
  • Salary Slip Format

Excel Formulas

Tally to Excel data problem

Tally to Excel Data Export Problem and Solution

Whenever we export Data from Tally to excel, like sales register, purchase register, or daybook, …

Read moreTally to Excel Data Export Problem and Solution

Merge Multiple Excel Files in to One File in Excel (by One Click) VBA Code

Merge Multiple Excel File in to One File (by One click) VBA Code

How To Merge Multiple Excel Files Into One (Running VBA) Excel VBA To Combine Multiple …

Read moreMerge Multiple Excel File in to One File (by One click) VBA Code

How to Apply Vlookup on Large Big Data in Excel

How to Apply Vlookup on Large / Big Data in Excel

Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project …

Read moreHow to Apply Vlookup on Large / Big Data in Excel

How to make Courier Charges Calculator in Excel Shipping Charges Calculator

How to make Courier Charges Calculator in Excel | Shipping Charges Calculator

Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project …

Read moreHow to make Courier Charges Calculator in Excel | Shipping Charges Calculator

Top10 HIDDEN & SURPRISING Copy Paste Secrets for EXCEL PROs

Top10 – Excel HIDDEN Copy Paste Secrets for EXCEL PROs

Video Tutorial Download Practice File (Download.xlsx) Download Excel File Download more Excel Project Files

Calculate Min value greater than zero in Excel

How to Calculate Minimum Value Greater than Zero “0” with Formula in Excel

Calculate Minimum Value but Greater than Zero with Formula in Excel   Formula: {=MIN(IF(C2:I2>0,C2:I2))} (then …

Read moreHow to Calculate Minimum Value Greater than Zero “0” with Formula in Excel

How to Select Automatic a Name from Column with Formula in Excel

How to Select Automatic a Name from Column with Formula in Excel

The table in Name and Sales amount to enter the salesman name automatically in a …

Read moreHow to Select Automatic a Name from Column with Formula in Excel

PETROL CONVEYANCE CALCULATION CHART WITH FORMULA

How to Calculate Petrol Conveyance with Formula in Excel Easily

Pricing Chart & Calculation of Petrol Conveyance with Formula in Excel Formula for Pricing: =IF(C3>1000,1.4,IF(C3>350,1.5,IF(C3>240,1.75,IF(C3>120,1.95,IF(C3>0,2.75,))))) …

Read moreHow to Calculate Petrol Conveyance with Formula in Excel Easily

April May June July Sales Report in Excel

How to Enter All Sheets Monthly Total Summery in a New Sheet

Raw Data of Daily Sales in different-different monthly Sheets  Formula:  =VLOOKUP(“TOTAL”,INDIRECT(B3&”!A:D”),2,0) Output After Applied formula …

Read moreHow to Enter All Sheets Monthly Total Summery in a New Sheet

Output data after applied formula to enter kgs and liters in excel cell

Enter Kgs and Liters Automatically in Excel Cells – by One Click

Raw Data to Enter Kgs and Liters in Excel Cells Output Data After Applied Formula …

Read moreEnter Kgs and Liters Automatically in Excel Cells – by One Click

Monthly Stock Summery with Opening & Closing Balance

Make Monthly Stock Sheet in Excel – (Opening Stock + Purchase – Sale = Closing Stock)

Monthly Raw Data of Quantity – Purchase & Sales with date-wise  Formula: =SUMIFS(C:C,B:B,”>=”&G5,B:B,”<=”&EOMONTH(G5,0)) After Formula …

Read moreMake Monthly Stock Sheet in Excel – (Opening Stock + Purchase – Sale = Closing Stock)

How to Split Each Excel Sheet Into a Separate File by One Click (1)

How to Split Each Excel Sheet Into a Separate File by One Click

1 Introduction Here in this article, I have explained How can we split each Excel …

Read moreHow to Split Each Excel Sheet Into a Separate File by One Click

Post navigation
Older posts
Newer posts
← Previous 1 2 3 … 14 Next →

More Excel Commands

  • Sales Analysis
  • Forecast Formula
  • Stock Management
  • MIS Report (Part-1)
  • MIS Report (Part-2)
  • MIS Report (Part-3)
  • MIS Report (Part-4)
  • Sales Commission Report
  • Filter without Mouse
  • Filter Example
  • Max Min Formula
  • MACRO (PART-1)
  • MACRO (PART-2)
  • MACRO (PART-3)
  • MACRO (PART-4)
  • MACRO (PART-5)
  • MACRO (PART-6)
  • Number to Text
  • Vlookup Example 1
  • Vlookup Example 2
  • Fill Blank Cells
  • Excel Magic Formula
  • Indirect Vlookup Formula
  • Excel Automatic Pricing
  • Wildcard Vlookup
  • TOP 2 Ranking Items
  • Vlookup 2 Conditions
  • Vlookup and Hlookup
  • RandBetween Formula
  • RandBetween Part-2
  • Hidden Tricks
  • Auto Serial No. Formula
  • Pass-Fail Formula
  • Image in Excel Comment
  • Ceiling Floor Formula
  • Excel Hidden Trick
  • TOP-3 Hidden Shortcut
  • Fill Justify Command
  • Visible Filter
  • Hidden Command
  • GST Invoice Format
  • Top 6: Excel Shortcut
  • Top 19: Excel Shortcut
  • GST Auto in Excel
  • Data Formatting Excel
  • Top 10: Excel Tips
  • Top 20: Excel Tips
  • 100+ Google Sheets
  • Cheque Printing Format
  • EMI Calculator in Excel
  • Age Calculator in Excel
  • Income Tax Calculator
  • Excel Password
  • Pivot Table Part-1
  • Pivot Table Part-2
  • Pivot Table Part-3
  • Pivot Table Part-4
  • Pivot Table Part-5
  • Pivot Table Part-6
  • Pivot Table Part-7

Categories

  • Balance Sheet, P&L Templates (22)
  • Excel Formulas (157)
  • Excel Templates (315)
  • Excel VBA Code (2)
  • Experience Certificate (31)
  • Featured Post (76)
  • Graph Paper Templates (25)
  • Invoice Templates (71)
  • Letterhead Templates (96)
  • Master Files (22)
  • Medical Certificate Templates (11)
  • Miscellaneous (32)
  • Online Tools (4)
  • Payment Voucher Format (51)
  • PowerPoint Templates (21)
  • Proforma Invoice Format (61)
  • Quotation Formats (61)
  • Resume-CV-Biodata Format (235)
  • Reviews (5)
  • Salary Slip Templates (51)
  • Shortcut Keys (70)
  • Special Post (104)
  • Tally ERP9 TDL (219)
  • Tally Prime Course (9)
  • Tally Prime TDL (72)
  • Warranty Certificates (21)
  • YouTube Channel Art (51)

READ NEXT

Useful Links

Free Download

Resume/CV Format

Salary Slip format

Marriage Biodata

Experience Certificates

Tally TDL

Tally Prime TDL List

Tally ERP 9 TDL List

Tally Shortcut List

Tally Course

Templates

Invoice Templates

Quotation Templates

Proforma Templates

Payment Vouchers

More Downloads

Shortcut Keys Download

YouTube Channel Templates

Balance Sheet & PL

Medical Certificate

NAZIM KHAN (AUTHOR)

Nazim Khan is a Microsoft Excel Expert & Excel Trainer, dedicated to helping you create outstanding tools and reports in Excel. Nazim’s background is Master of Business Administration (MBA-Finance), For over 10 years he has worked in the Accounts-Finance and MIS department implementing reporting systems based on Excel & Tally ERP.

CONTACT US

  • TECH GURU PLUS
  • New Delhi, India
  • Email : nazim.khan09@gmail.com
  • Phone : +91 9536250020
Youtube Facebook Telegram Instagram Linkedin Pinterest

Copyright © TechGuruPlus.com (Since 2016)
Scroll back to top
  • My Telegram Group
  • Excel Tutorials
  • Tally TDL
  • Invoice Formats
  • PPT Templates
  • Shortcut Keys
  • Contact Us
  • About Us
  • Copyright Policy
  • Privacy Policy
  • Sitemap (xml)