Skip to content
ExcelSirJi
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Excel Functions
  • Excel Shortcuts Keys
  • Productivity Tools
Courses
ExcelSirJi

learn excel macros

Home / learn excel macros
Create Pareto Chart In Excel
Excel Data Tips | Excel Dashboarding Tips

Create Pareto Chart In Excel

Byexcelsirji

What is Pareto Chart? Pareto principle was introduced by Italian EconomistĀ Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of…

Read More Create Pareto Chart In ExcelContinue

VBA Code to Add Border to Excel Range
Excel VBA Codes/Macros

VBA Code to Add Border to Excel Range

Byexcelsirji

Through formatting the cells, you can make your Excel data more beautiful and easier to understand. If you record a macro to add borders to Excel range, you will notice that it generates 30 plus lines of code for just a small work. Here we are sharing one line of code which does the same thing.

Read More VBA Code to Add Border to Excel RangeContinue

Excel VBA Tool to Get File Properties
Excel VBA Codes/Macros

Excel VBA Tool to Get File Properties

Byexcelsirji

Excel VBA Tool To Get File Properties Here is one more interesting VBA tool from the ExcelSirJi team. File Properties Tool is an Excel VBA tool that gets the following properties of the file. File…

Read More Excel VBA Tool to Get File PropertiesContinue

How to Count Color Cells in Excel- Step by Step Tutorial
Excel Formula Tips | Excel VBA Codes/Macros

How to Count Color Cells in Excel- Step by Step Tutorial

ByKailash Sharma

Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…

Read More How to Count Color Cells in Excel- Step by Step TutorialContinue

DMCA.com Protection Status
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2023 ExcelSirJi

  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Excel Functions
  • Excel Shortcuts Keys
  • Productivity Tools
Search