Category: Tips And Tricks

Dynamic Pareto Chart in Excel – The 80/20 Phenomenon

Pareto principle (also known as the 80/20 rule) is a well-known concept in project management. According to it, ~80% of the problems can be attributed to about ~20% of the issues (or ~80% of your results could be a direct outcome of ~20% of your efforts, and so on..). The 80/20 percentage value may vary, … Continue reading Dynamic Pareto Chart in Excel – The 80/20 Phenomenon

Extract Usernames from Email Ids in Excel [2 Methods]

A colleague asked me if she could quickly extract usernames from Email Ids. She had more than 1000 records and less than 2 minutes to do it. In this tutorial, I will show you 2 methods to do this. And none of it would take more than a minute. Method 1 – Using Text to … Continue reading Extract Usernames from Email Ids in Excel [2 Methods]

How to Create a Thermometer Chart in Excel

Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value. A good example could be while analyzing sales performance of regions or sales rep. Here is a quick way to create Thermometer Chart in Excel Have the data in adjacent cells (Actual Value and Target … Continue reading How to Create a Thermometer Chart in Excel

How to Quickly Add Grunge To Text in Adobe Illustrator

How to Quickly Add Grunge To Text in Adobe Illustrator For a while, it seemed liked every client wanted grungy graphics. This might sound familiar, “I like it, but can we grunge it up more”. Don’t get me wrong, having some grunge can create a great deal of depth to a design or illustration, but … Continue reading How to Quickly Add Grunge To Text in Adobe Illustrator

How to Create a Halftone Pattern in Adobe Illustrator

How to Create a Halftone Pattern in Adobe Illustrator It used to be a time consuming process to create a halftone pattern. First, I would open a picture in Photoshop, convert it to grayscale, apply a halftone pattern effect, open it up in illustrator, trace it, and if didn’t get messed up somewhere in the … Continue reading How to Create a Halftone Pattern in Adobe Illustrator

How to Create A Wood Grain Texture in Adobe Illustrator

How to Create A Wood Grain Texture in Adobe Illustrator Last up for Vectip’s Texture Week is wood grain. The steps for this technique are very similar to the previous Brushed Metal Texture tutorial. It uses the same Graphic Pen effect but stretched a little more. It also uses the Warp Tool and Twirl Tool … Continue reading How to Create A Wood Grain Texture in Adobe Illustrator

Create a Trendy Flat Desk Mockup Vector!

Create a Trendy Flat Desk Mockup Vector! Look around your desk for inspiration and let’s create a trendy, flat desk mockup vector design comprised mostly of rectangles with manipulated Live Corners in under 20 minutes! Tutorial Details: Trendy Flat Desk Mockup Vector Program : Adobe Illustrator CS6 – CC 2015 Difficulty : Beginner Topics Covered : Live … Continue reading Create a Trendy Flat Desk Mockup Vector!

How to Make a Fun and Cute Halloween Pattern Vector!

How to Make a Fun and Cute Halloween Pattern Vector! It’s almost Halloween, and to celebrate we’re gonna cook up a fantastically spooky and quite cute Halloween pattern vector made from basic shapes. Tutorial Details: Cute Halloween Pattern Vector Program : Adobe Illustrator CS6 – CC 2015 Difficulty : Beginner Topics Covered : Shape Tools, Pattern … Continue reading How to Make a Fun and Cute Halloween Pattern Vector!

10 Useful Design Freebies From DealFuel

10 Useful Design Freebies From DealFuel Most all designers use one or more design resources to help with their design projects. But finding the right design resources that perfectly suit your current projects’ requirements is a difficult and time-consuming task. You need to make sure that the design resource that you use is compatible with … Continue reading 10 Useful Design Freebies From DealFuel

Create a Bootiful Haunted House Halloween Vector Background!

Create a Bootiful Haunted House Halloween Vector Background! In today’s tutorial we will create a Haunted House Halloween Vector poster in flat design style. This style is characterized by minimalism, the lack of gradient fills, textures, and use of elementary forms for the construction of all objects. So let’s get started! Tutorial Details: Haunted House Halloween Vector … Continue reading Create a Bootiful Haunted House Halloween Vector Background!