BLOG
Pareto Chart Sample
DATA ANALYSIS TRICKS
1

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 causes. So if we closely monitor and solve 20% of the causes. It will significantly improves the affected area and you will see good results.  …

Read More
VBA Code to Sum Cells by Color
VBA TRICKS

VBA Code to Sum Cells by Color

Recently some of our subscribers have requested us to share a VBA code that can sum the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to sum the cells with specific color and returns the total sum of the matching color cells

Read More
Logo Inserting Symbols in Excel
EXCEL TRICKS

How to Insert Symbol in Excel Numbers?

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 Character Symbols in Excel Number Formatting.  You may easily do this by following below steps: …

Read More
Delta Symbol
EXCEL TRICKS
1

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 the symbol in excel etc. Though inserting Delta (▲) is very easy in any of the MS Office Applications i.e. Excel, Word, Power Point …

Read More
Logo Inserting Symbols in Excel
EXCEL TRICKS

How to Insert Symbol in Excel

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 in Excel via using this method. So lets start Excel Symbol Dialog Box Here I …

Read More
Excel VLOOKUP
DATA ANALYSIS TRICKS
1

What is VLOOKUP in Excel?

An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.

Read More
FREE VBA UTILITIES
33

VBA Tool to Track Start and End Time (Time & Motion Tracker)

Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time

Read More
VBA Code to Delete File
VBA TRICKS

VBA Code to Delete File

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

Read More
VBA Code to Add Border to Excel Range
VBA TRICKS

VBA Code to Add Border to Excel Range

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
Conditional Formatting
VIDEOS

Video – How to Use Conditional Formatting?

This video will help you to understand how you may use conditional formatting to highlight row based on conditions. Subscribe us for more updates

Read More
Protect Excel Sheet for Manual Input
VBA TRICKS

Protect Excel Sheet for Manual Input but Allow Programming Inputs

Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you.

Read More

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn