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

Excel Online Courses

Home / Excel Online Courses
Free Excel Based Random Data Sampling Tool
Excel Utilities/Templates

Free Excel Based Random Data Sampling Tool

Byexcelsirji

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

Read More Free Excel Based Random Data Sampling ToolContinue

VBA Code to Sum Cells by Color
Excel VBA Codes/Macros

VBA Code to Sum Cells by Color

Byexcelsirji

VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.

Read More VBA Code to Sum Cells by ColorContinue

VBA Tool to Merge Excel Files from a Folder
Excel Utilities/Templates

VBA Tool to Merge Excel Files from a Folder

Byexcelsirji
From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free VBA tool from...

Read More VBA Tool to Merge Excel Files from a FolderContinue

How to Add Outlook Reference in Excel VBA
Excel VBA Codes/Macros

How to Add Outlook Reference in Excel VBA

ByKailash Sharma

To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps to add Outlook reference in Excel VBA: 1….

Read More How to Add Outlook Reference in Excel VBAContinue

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

VBA Code to Send Outlook Emails
Excel VBA Codes/Macros

VBA Code to Send Outlook Emails

ByKailash Sharma

Sending bulk emails is very common activity, there are many office activities which needs a person to send bulk emails to a single or multiple recipients. You also may require to add attachments in the…

Read More VBA Code to Send Outlook EmailsContinue

  • 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