Post Sitemap

Function & Date

  1. Week number in Excel: Avoid Mistakes
  2. Write Months in Any Language in Excel
  3. Converting a Date from YYYYMMDD to...
  4. Excel Calendar with Automatic Monthly...
  5. Unlocking the Secrets of Excel’s...
  6. Displaying Days in Letters in Excel
  7. Minutes to Hours converter with Excel
  8. Date Picker in Excel
  9. The TIME function in Excel
  10. Displaying Date and Time in the Same...
  11. How to display Months in Letters in...
  12. Calculate the Number of Days between 2...
  13. The WEEKDAY function – Secrets...
  14. Formula to Calculate Quarter with Excel
  15. Separate Date and Time with Power Query
  16. Display negative time in Excel
  17. Calculate Monday Previous Week with...
  18. Calculate the Previous Monday with...
  19. Calculate Monday in 2 weeks with Excel
  20. Calculate the Next Monday with Excel
  21. Formula First Monday of the month with...
  22. Calculate Monday 2 weeks ago with Excel
  23. Convert a Text Date to a Number Date
  24. Highlight the Date outside the...
  25. Add Days Excluding the Weekend in Excel
  26. How to Calculate the Week Number in...
  27. How to display hours over 24 in Excel?
  28. How to build your dynamic dates in...
  29. Calculate any Day of the Week Using...
  30. Time Format in Excel to avoid mistakes
  31. Change the Color of Weekends in Excel...
  32. Calculate a date from the week number...
  33. Create a weekly calendar with just one...
  34. First day – Last day in Excel
  35. DATEDIFF for POWER QUERY
  36. Calculate Seniority in Excel
  37. The DATEDIF function in Excel
  38. Calculate Public holidays with Excel...
  39. Change the default Date format in Excel
  40. How to Highlight a Birthday Reminder...
  41. Find Weekend or Weekday in Excel
  42. TODAY and NOW function in Excel
  43. Title with Text and Date in the same...
  44. Date Format in Excel
  45. Excel Split Date and Time
  46. How to Display Tenths, Hundredths with...
  47. Function DATE – YEAR –...
  48. How to make automatic calendar in Excel

Expert

  1. Become an Office Insider 😃👍
  2. Excel Calendar with Automatic Monthly...
  3. Connect slicer with Data Type
  4. Return Arrays with Excel’s...
  5. Splitting a text based on a pattern in...
  6. Convert Binary Number to Decimal in...
  7. Test Excel for Expert users
  8. Excel Dropdown list – Exclude...
  9. Formula to Calculate Quarter with Excel
  10. Microsoft has blocked macros from...
  11. Find duplicate values in Excel by...
  12. How to create a chart Man & Woman...
  13. How to do a Cube Root in Excel?
  14. Dynamic SUM in Excel
  15. Generate a QR Code with Excel
  16. Keep your Last Updated Data
  17. Calculate any Day of the Week Using...
  18. Calculate a date from the week number...
  19. How to create a Gantt Chart with Excel?
  20. Convert Numbers to Words in Excel
  21. How to use the INDIRECT function of...
  22. Excel as a sports coach
  23. Explanation of the VBA code for the...
  24. Update a Dropdown List automatically
  25. Wildcard with COUNTIFS or SUMIFS
  26. How to make automatic calendar in Excel

Free Excel Tutorial for beginners

  1. Remove Gridlines in Excel Easily
  2. Mixed References in Excel: Explanation
  3. Tips and Tricks to Paste Data in Values
  4. Extract text with AI in Excel with...
  5. Why there is dollar in the Excel...
  6. How to create a formula in Excel
  7. Move cells with the mouse in Excel...
  8. Copy the formula without the...
  9. In Excel, How to highlight missing...
  10. Meaning of the sign & in Excel?
  11. Clear All Filters in Excel in one...
  12. Beginner Excel Test
  13. How to remove gridlines from Excel
  14. Tutorial – How to make...
  15. Tutorial – Adjust the Size of...
  16. Tutorial – Excel keywords
  17. Excel for free
  18. How to find the column number in Excel?
  19. TOP 10 Most Useful Statistical...
  20. How to Fill Series Automatically with...
  21. Use Filter for your data in Excel
  22. Basic calculations with Excel
  23. The SUM function – All Tricks
  24. Capitalize the first letter in Excel...
  25. How to Copy and Paste in Excel?
  26. Draw your borders with the mouse
  27. How to Reuse Cell Values in Excel: A...
  28. Function DATE – YEAR –...
  29. Examples of Paste Special (All Options)

Function & Statistical functions

  1. GROUPBY function: The future of...
  2. Select the Top 5 Values with TAKE...
  3. Easily Create a Running Total in Excel...
  4. Return a Value Between Two Values in a...
  5. Calculate Percentage Change in Excel
  6. Quickly Calculate Percentages in Excel...
  7. How to Round a Number to the Nearest...
  8. Function MOD (Modulo) of Excel
  9. Round nearest 10, 25, or 50 cents with...
  10. How to Create a Running Total in Excel?
  11. How to do a Cube Root in Excel?
  12. Dynamic SUM in Excel
  13. How to round in k$ with Excel?
  14. TOP 10 Most Useful Statistical...
  15. Study Case with Excel Statistics...
  16. What is the Most Common Value in your...
  17. Calculate Moving Average in Excel
  18. Understand the Standard Deviation
  19. Basic calculations with Excel
  20. The SUM function – All Tricks
  21. 3D Formula in Excel
  22. Displaying Negative Numbers in...
  23. Round to the next decimal range