DPTutorials

In this tutorial let us learn about an interesting tool in Excel. With this tool, one can join pieces of text together into a single line an

In this tutorial, I will show you an interesting trick in Excel on How To Add Direct Legends To the Chart Itself.

Let us learn How To Create Waterfall Chart in Excel. This kind of chart looks like a waterfall and that's the reason why it has been calle

In this video tutorial we will see how we can prevent users from deleting rows and columns in Excel Sheet.

In this Tutorial, Let us see How To Quickly Unhide Multiple Sheets In Excel At Once, with a single click. Generally, to unhide any sheet...

In this tutorial, let us learn about sparklines in Excel. Sparklines are types of graphs that show trends and variation of data....

In this video tutorial, let us learn how to easily generate serial numbers in excel data range. This is very quick and easy to perform....

In this video tutorial, let us learn how to copy formatting from any chart and apply the same to other unformatted charts in Excel. This...

In this video tutorial, let us learn how to apply borders to a table in MS Excel. I Prefer this method which makes our data speak out...

In this tutorial, you will learn how to clean the excel data into the right matrix. Sometimes when you copy paste the data from other...

In some situations, you will be required to Inverse the data like the transpose function which does the switching of columns and rows,...

In this tutorial, Let us see how to create an awesome Organizational Chart in just 3 easy steps. Generally we prepare Organizational...

Hi, In this tutorial, let us learn how to highlight special data points in the Chart that we create in MS Excel. Let's see how to do it...

One should update project schedule so as to maintain, record progress and keep on track. Updating schedules can be either done by...

As the project progresses, many changes occur in project data. Then the original baseline project that you have created may not...

You can use the assign baselines feature to designate the current project or an existing baseline as the project, primary, secondary, or...

A baseline is a copy of a project plan that you can compare to the current schedule to evaluate progress. You can create and maintain any...

Cost accounts help you to track activity costs, project expenses and earned value throughout the project life cycle. Cost accounts can be...

Activities are the fundamental elements of the project. These are the lowest level of WBS structure. Let us understand about activities in

In This tutorial, let us see how to create WBS and then add activities to the Project that we have created in the last tutorial. Once you...