Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi

Learn Excel Formulas

Home / Learn Excel Formulas
Create Pareto Chart In Excel
Excel Data Tips | Excel Dashboarding Tips

Create Pareto Chart In Excel

Byexcelsirji
Watch Excel Tutorial Video - Create Pareto Chart In Excel 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...

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

Find Duplicates in Excel
Excel Data Tips

Find Duplicates in Excel

Byexcelsirji
Watch Excel Tutorial Video -Find Duplicates in Excel Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to...

Read More Find Duplicates in ExcelContinue

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

Excel VBA Tool to Get File Properties

Byexcelsirji
Here is one more interesting VBA tool from ExcelSirJi team. File Properties Tool is an Excel VBA tool which gets the following properties of the file. File Name Date Created Date Last Accessed Date Last...

Read More Excel VBA Tool to Get File PropertiesContinue

VBA Code to Export Access Recordset to Excel
Excel VBA Codes/Macros

VBA Code to Export Access Recordset to Excel

ByKailash Sharma

Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user interface and ability to handle multiple users. Still people prefer to pull and see the…

Read More VBA Code to Export Access Recordset to ExcelContinue

  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search