How To Join Texts Together To Form A Single Line In MS Excel and Vice Versa || Justify Tool in Excel
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
top of page
The Project Management Blog
DPTutorials
Learning Made Easy...
Search
Dp
May 8, 20191 min read
How To Add Legends To the Chart Itself In Excel; Smart way to show legends in chart
In this tutorial, I will show you an interesting trick in Excel on How To Add Direct Legends To the Chart Itself.
Dp
May 7, 20192 min read
How To Create Waterfall Chart in MS Excel
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
Dp
May 7, 20192 min read
How To Prevent Users From Deleting Rows and Columns in Excel
In this video tutorial we will see how we can prevent users from deleting rows and columns in Excel Sheet.
Dp
May 2, 20192 min read
How To Quickly Unhide Multiple Sheets In Excel At Once
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...
Dp
Apr 30, 20192 min read
How To Create Sparklines in MS Excel
In this tutorial, let us learn about sparklines in Excel. Sparklines are types of graphs that show trends and variation of data....
Dp
Apr 26, 20192 min read
How To Quickly Generate Serial Numbers In Excel
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....
Dp
Apr 23, 20191 min read
How To Copy and Apply Formatting For Any Chart With Paste Special Option
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...
Dp
Apr 23, 20192 min read
How To Correctly Apply Borders To Tables In MS Excel
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...
Dp
Apr 17, 20192 min read
Adjust Copy Pasted Excel Data into Correct Columns
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...
Dp
Apr 17, 20192 min read
How To Inverse the Data Range in MS Excel || Turn Data Upside Down in Excel
In some situations, you will be required to Inverse the data like the transpose function which does the switching of columns and rows,...
Dp
Apr 8, 20192 min read
How To Create Organizational Chart in Just 3 Steps
In this tutorial, Let us see how to create an awesome Organizational Chart in just 3 easy steps. Generally we prepare Organizational...
Dp
Mar 29, 20192 min read
How to Highlight MAX and MIN Values in MS Excel Chart || MS Excel ||
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...
Dp
Mar 5, 20193 min read
4.4 : Primavera Learning - Updating and Scheduling Projects
One should update project schedule so as to maintain, record progress and keep on track. Updating schedules can be either done by...
Dp
Mar 1, 20192 min read
4.3 : Primavera Learning - Updating Baselines
As the project progresses, many changes occur in project data. Then the original baseline project that you have created may not...
Dp
Mar 1, 20192 min read
4.2 : Primavera Learning - Assigning Baselines
You can use the assign baselines feature to designate the current project or an existing baseline as the project, primary, secondary, or...
Dp
Feb 25, 20193 min read
4.1 : Primavera Learning - Maintaining Baselines
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...
Dp
Feb 6, 20193 min read
3.3 : Primavera Learning - Cost Accounts and Expenses
Cost accounts help you to track activity costs, project expenses and earned value throughout the project life cycle. Cost accounts can be...
Dp
Dec 27, 20185 min read
3.2 : Primavera Learning - Working with Activities
Activities are the fundamental elements of the project.
These are the lowest level of WBS structure. Let us understand about activities in
Dp
Nov 23, 20181 min read
3.1 : Primavera Learning - Create WBS, Add Activities
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...
bottom of page