How to Make a Graph or Chart in Excel-Complete Video Guide

This is a complete video tutorial on How to Make or Plot a Graph or Chart in Excel. To make complex chart like Gantt Chart, you have know the basic principles of making a...

How to Make a Gantt Chart in Excel 2013 [Video Tutorial]

You cannot create a Gantt chart in Excel in direct way. But don’t worry, you can make advanced level Gantt chart in Excel modifying the Stacked Bar chart. This quick tutorial will guide you...

How to Make a Pie Chart in Excel [Video Tutorial]

Then you want to make a Pie Chart in Excel. But do you know: Pie Chart is the worst chart in the world! These are not my words. Read this article by Walter Hickey,...

Change the color of text and background of cells – An Excel Font and Fill Color Complete Guide

Overview on Excel Font and Fill Color Change Hello, here I am present to give you a complete guide on how you can work with Excel font color and background color of cells. I...

I carry your heart with me

Sometimes you’ll feel that you’re in a dark room, you’ve blank eyes, you’ve no motion, and you’re all alone. You’ll feel that you did a grave mistake but there is no way to escape...

Excel Pivot Table Tutorials for Dummies Step by Step | Download PDF

Excel Pivot Table! The most important feature added to the toolbox of Microsoft Excel, ever! A serious data analyst cannot think of passing a single day without this sophisticated data analysis tool. Why? Because...

Microsoft Excel Templates: Create and Use a Default Excel Template and a Custom Invoice Excel Template

What are Excel Templates According to Oxford dictionary the word “template” means “something that serves as a model for others to copy”. In the same way, an Excel template is a special type of...

How to Create a Combo Excel Chart

I want to teach you how to make a combo chart in Excel in this tutorial. To do this, I have used the following data table. The chart I am going to make is...

Elements of an Excel Chart

I want to teach you different parts of an Excel chart in this article. To do this, I have used the following data table. The chart I am going to make is like the...

How Excel Handle Charts, Embedded Charts and Chart Sheets

In this article, I shall discuss on how Excel handle charts, what is embedded chart and chart sheets. No Data, No Chart Before we start creating an Excel chart, we need data. No data,...

What is an Excel Chart?

Do you know why Excel is the most powerful spreadsheet software? What is the most commonly used feature of Excel? Answer: Charting! It’s charting with Excel! Excel is probably the most commonly used software...

How to Use Non-object Events

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide and Learn Excel VBA Events Completely with 5 Tutorials. In article Workbook-level Events and Their Uses, I...

Worksheet-related Events and Their Uses

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide and Learn Excel VBA Events Completely with 5 Tutorials. Worksheet related events are some of the most...

Workbook-level Events and Their Uses

In this article, I am going to introduce you with the Excel Workbook-level events. This introduction will help you to use them in future efficiently. Workbook-level events work for a particular workbook. The following...

How to Enter Event Handler VBA Code

In my last article, I have introduced you with Excel events and their types. In this article, I am going to narrate you how to enter Event Handler VBA code in the relevant code...