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 videos

Home / excel videos
EXCEL FUNCTION – DATEVALUE
Excel Formula Tips

EXCEL FUNCTION – DATEVALUE

ByPradeep Kumar
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the...

Read More EXCEL FUNCTION – DATEVALUEContinue

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

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 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

How to Insert Symbol in Excel Numbers?
Excel Data Tips

How to Insert Symbol in Excel Numbers?

Byexcelsirji

Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special…

Read More How to Insert Symbol in Excel Numbers?Continue

Usage of Delta Symbol in Excel – Complete Guide
Excel Data Tips

Usage of Delta Symbol in Excel – Complete Guide

Byexcelsirji
USAGE OF DELTA SYMBOL IN EXCEL – COMPLETE GUIDE The Greek Capital Alphabet letter Delta (▲) and  is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert...

Read More Usage of Delta Symbol in Excel – Complete GuideContinue

How to Insert Symbol in Excel
Excel Data Tips

How to Insert Symbol in Excel

Byexcelsirji

I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may insert any kind of special characters…

Read More How to Insert Symbol in ExcelContinue

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

VBA Code to Find Duplicate Files
Excel VBA Codes/Macros | Excel Utilities/Templates

VBA Code to Find Duplicate Files

Byexcelsirji
Watch Excel Tutorial Video - VBA Code to Find Duplicate Files Yesterday I was working on my computer and cleaning the drives to make some more space.  I was surprised to see so many files...

Read More VBA Code to Find Duplicate FilesContinue

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

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

VBA Code to Browse a File
Excel VBA Codes/Macros

VBA Code to Browse a File

ByKailash Sharma

There are few VBA codes which are commonly used by every developer. One of them is giving an option to user to browse a file. Below is a sample code where I have given a browse button…

Read More VBA Code to Browse a FileContinue

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

  • 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