Excel/Sheets Formulas.

Work faster with Excel and Google Sheets

Excel and Google Sheets share about 90% of their functionality, so learning/using one is a personal preference. I'll be using Google Sheets, which is free, and all you need is a Gmail account to start. Most of the formulas will work on Microsoft Excel and are suitable if you have exposure to Excel or Sheets to some extend.

If you are an absolute beginner in Microsoft Excel or Google Sheet, I would recommend checking my personal favorite Mike Girvin channel on YouTube name ExcelIsFun. He absolutely saved my ass when I started my career as a data analyst.

Looking for custom formulas for your daily work — copy and paste your desired formulas, and you are good to go.

100 Custom Excel and Google Sheets Formula and Example

  1. Daily used Excel and Google Sheets formulas to supercharge your productivity

  2. Widely used Excel and Google Sheets functions explained

  3. Sum functions based on criteria — Excel & Google Sheets example

  4. Change number sign — Excel & Google Sheets example

  5. Date and time functions — Excel & Google Sheets example

  6. Currency conversion functions — Google Sheets example

  7. Combine cells and columns data — Excel & Google Sheets example

  8. Convert functions — Excel & Google Sheets example

  9. Count functions — Excel & Google Sheets example

  10. Extract functions — Excel & Google Sheets example

  11. Change the text position — Excel & Google Sheets example

  12. Transpose functions — Excel & Google Sheets example

  13. Unit conversion functions — Excel & Google Sheets example

  14. Advance Google Sheets function example