April 7, 2017

### Excel VLOOKUP Function: Why and How?

Before we learn how to use Excel VLOOKUP function, we must learn WHEN do we use Excel VLOOKUP function? Task: Imagine if you have to find when does train no. 6948 departs in the schedule chart above? Your approach: You will scan the first column top to bottom. When you find the same train no.,...

### Time Travel with PowerPoint tricks – Smart Art for Powerpoint

Powerpoint Tricks Time travel has been a core theme for many Hollywood science fiction flicks. Well, let me make it a reality for you. You can zoom past an hour in less than five minutes with these special power point tricks. 1) Convert boring bullet points in attractive SmartArt in 5 seconds – I borrowed...

### PowerPoint Picture Tools to Create Magnifier Glass Effects

Learn a new PowerPoint trick using picture tools: Magnifier Case Study: Let’s say my company has launched a new water dispenser. I would like to highlight the new features of the product. To do so, I will like to use a magnifier like an effect to attract the viewers attention (Picture tools). This is a...

### How to remove password from Excel or Unprotect an Excel

How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software.  So what it includes? This includes changing file extension and manipulating its constituents to get an unprotected excel file. Almost ALL Excel users wish at some point or the other felt the need of some magic to “Unprotect Excel Sheet”...

### How to Customize PowerPoint Slides Only in 15 Minutes?

Is your boss constantly nagging on your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tips that you wished you would know much before so that you would complete creating your presentation within...

### Learn how to use Countif function in Excel

Countif function will help you to know how many records of a certain type you have in your Excel spreadsheet. The Excel Countif function returns the number of cells within a supplied range, that satisfy a given criteria. When to use Countif Function? COUNTIF function can be used when you want to count the number of...

### Excel Versions: Evolution of Spreadsheets [Infographic]

Excel versions aka Spreadsheets have a come a long way over the years and plenty of companies today are attempting to build the best one. Spreadsheets have been used by accountants for hundreds of years. Computerised or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspapers and magazines...

### 9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? [This post on Excel tips and tricks is just a 5 min read] Here’s a list of top 9 mistakes that one makes while...

### Export data from SQL to Excel spreadsheet using VBA

In this blog, we will Import data from SQL to Excel spreadsheet using VBA. Assuming that you have a little bit of knowledge on SQL server. Now if you are preparing reports in Excel and the data is on your SQL server then you don’t need to copy the data first from SQL server to...

### Learn how to create a horizontal bar chart in Excel

Horizontal bar chart may look appealing, but to make it may be troublesome. This article shows a step by step process to make a percentage horizontal bar chart in Excel. Consider there are two tables i.e. Income and Expense Select the data with headers and Press Ctrl + T. Do it for both Income and...

### Excel basics guide for beginners: Learn Excel Online

In this blog, we will learn Excel basics guide for beginners, Learning Excel basics are just a start to what’s in store to solve a lot of our daily problem and save time. Microsoft Excel is very useful for a wide range of applications. It features calculation, graphing tools, pivot tables, and a macro programming...

### Password protect excel using VBA for a shared Excel file

Password protect Excel Sheet based on the User as part of excel vba tutorial. For Example, you have a master excel sheet in your centralized location. Now everyone can access the same file and if someone changes something on that it is very difficult or hard to track who has modified the same. Password protect excel sheet...

### Learn how to use SUMIF function in Excel

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to...

### Create Advanced Excel Filters using Excel VBA

In this blog, I will try to cover how to use a custom VBA autofilter in excel. This Advanced Excel filter technique is meant for Advanced Excel users.  We all know how to use a custom filter or advanced filter in Excel. Here we will discuss creating custom Excel VBA autofilter: For example, you have a huge...

### Learn how to remove blank row or empty cell in Excel

How to remove blank row or cell in Excel? confused ? Data doesn’t always import or paste into Excel as nicely as you want. Sometimes, all the information is there, but extra blanks and spaces are carried along with the data cells. Think that if you work with a large data set in an Excel...

### 7 formula error in Excel that make you look dumb

In this blog, I will try to help you to debug your excel formula. As soon as you will use excel formula, you will likely need to know how to correct the error in excel formula. First of all, we need to know how many types of error, we can get we are applying excel formula...

### Learn how to create sparklines in Excel

Imagine you have result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case, you are thinking if only there were some small mini-charts in a single cell. Well here is the solution. Ever had a worksheet of data in Excel and...

### Learn how to create Scatter Plots in Excel

Choosing the right type of chart or graph can be key to convey the most important insights of your data—on sight. When you want to dig a little deeper into some data, but not quite sure how – or if – different pieces of information relate? Scatter plots are an effective way to give you...

### How to delete rows in excel based on a condition?

In this blog, I will discuss how to delete rows in excel based on condition. Sometimes we get the data set from another person and the need to do a lot of work to clean this data set. You need to delete a certain section of data which is not relevant or there are innumerable...

### Merge Excel Files into a Spreadsheet using Excel Macro

How to merge excel files into a single sheet from a different workbook using excel macro is the topic of this blog. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. We are trying to cover technique to combine...
1 2