Skip to content
Excel Champs
  • About
  • Free E-Book
  • Videos
  • Blog
    • Basics
    • Shortcuts
    • Functions
    • Tips
  • Power Query
  • VBA

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain

How to Get End of the Month Date in Excel

Sometimes we need to get an end of the month date to use as a completion date, due date, as a target date or sometimes we need it to calculate

12 Comments

How to Create a Step Chart in Excel

A step chart is a perfect chart if you want to show the changes happened at irregular intervals. And that’s why it’s a part our advanced charts list. It can

14 Comments

How to Get Month from a Date in Excel

Dates are an important part of data. There are few times when we need to use only a part from a date. Take an example of the month. Sometimes you

6 Comments

How to use OR Logic in COUNTIF/COUNIFS in Excel

How to use OR Logic in COUNTIF/COUNIFS in Excel A few days back I wrote about how we can use SUMIF OR. And today, I want to show that by

19 Comments

How to Remove Extra Spaces in Excel

A clean data is our birthright, but sometimes we are not able to access it. Sometimes, we are not able to use our data as the way we want. And one of

8 Comments

How to use SUMIF / SUMIFS with an OR Logic in Excel

Sometimes we need to make small amendments in formulas to make them effective. Just like that, SUMIF OR. It’s an advanced formula which helps you to increase the flexibility of SUMIF.Yes, you

30 Comments
Post navigation
Older posts
Newer posts
← Previous Page1 … Page12 Page13 Page14 … Page22 Next →
  • Contact
  • Terms
  • Policy
© ExcelChamps 2021
DMCA.com Protection Status