Dptutorials

How To Join Texts Together To Form A Single Line In MS Excel and Vice Versa || Justify Tool in Excel

Feb 22, 20202 min read

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

How To Add Legends To the Chart Itself In Excel; Smart way to show legends in chart

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.

How To Create Waterfall Chart in MS Excel

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

How To Prevent Users From Deleting Rows and Columns in Excel

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.

How To Quickly Unhide Multiple Sheets In Excel At Once

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...

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....

How To Quickly Generate Serial Numbers In Excel

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....

How To Copy and Apply Formatting For Any Chart With Paste Special Option

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...

How To Correctly Apply Borders To Tables In MS Excel

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...

Adjust Copy Pasted Excel Data into Correct Columns

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...

How To Inverse the Data Range in MS Excel || Turn Data Upside Down in Excel

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,...

How To Create Organizational Chart in Just 3 Steps

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...

How to Highlight MAX and MIN Values in MS Excel Chart || MS Excel ||

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...

4.4 : Primavera Learning - Updating and Scheduling Projects

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...

4.3 : Primavera Learning - Updating Baselines

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...

4.2 : Primavera Learning - Assigning Baselines

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...

4.1 : Primavera Learning - Maintaining Baselines

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...

3.3 : Primavera Learning - Cost Accounts and Expenses

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...

3.2 : Primavera Learning - Working with Activities

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

3.1 : Primavera Learning - Create WBS, Add Activities

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...

The Project Management Blog

DPTutorials

Learning Made Easy...

Subscribe to my YouTube channel | Copyright 2022 dptutorials.com | All Rights Reserved