The Project Management Blog

dp tutorial_FULL COLOR-01.png

DPTutorials

Learning Made Easy...
  • Home

  • Tutorials

  • Resources

    • YouTube Tools
  • Templates

  • Services

  • About Me

  • Blog

  • More

    Use tab to navigate through the menu items.
    • All Posts
    • MS Excel
    • Primavera
    • Project Management
    • MS Project
    • Excel-Advanced
    • Excel-VBA
    • Formulas
    • Beginner
    • Excel Tricks
    • Excel Charts
    • Excel Intermediate
    Search
    Count Unique Numeric Values In A Range
    Dp
    • Jan 30
    • 1 min

    Count Unique Numeric Values In A Range

    In this tutorial, let us learn how to Count unique numeric values in a range using the combination of Frequency and Sum functions Let us...
    0 comments
    3 Ways To Highlight Blank Cells In Excel || Use Of Conditional Formatting
    Dp
    • Jul 17, 2020
    • 2 min

    3 Ways To Highlight Blank Cells In Excel || Use Of Conditional Formatting

    In this tutorials, let us know how to highlight blank cells in Excel using 3 ways. 1. Use of Conditional Formatting is the easiest way to...
    0 comments
    How To Quickly Unhide Multiple Sheets In Excel At Once
    Dp
    • May 2, 2019
    • 2 min

    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...
    0 comments
    How To Quickly Generate Serial Numbers In Excel
    Dp
    • Apr 26, 2019
    • 2 min

    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....
    0 comments
    How To Copy and Apply Formatting For Any Chart With Paste Special Option
    Dp
    • Apr 23, 2019
    • 1 min

    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...
    0 comments
    Adjust Copy Pasted Excel Data into Correct Columns
    Dp
    • Apr 17, 2019
    • 2 min

    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...
    0 comments
    How To Inverse the Data Range in MS Excel || Turn Data Upside Down in Excel
    Dp
    • Apr 17, 2019
    • 2 min

    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,...
    0 comments
    How to Highlight MAX and MIN Values in MS Excel Chart || MS Excel ||
    Dp
    • Mar 29, 2019
    • 2 min

    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...
    0 comments
    How To Unprotect An Excel Sheet Without Password
    Dp
    • May 5, 2018
    • 1 min

    How To Unprotect An Excel Sheet Without Password

    If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you...
    0 comments
    Create Instant Chart In Excel
    Dp
    • May 1, 2018
    • 1 min

    Create Instant Chart In Excel

    You can create a Instant Chart in Excel, without using the Chart Button in the Insert tab on the Toolbar by pressing the function key F11...
    0 comments
    Autosum In Excel
    Dp
    • Apr 22, 2018
    • 1 min

    Autosum In Excel

    Instead of using the Autosum function or the button from the toolbar You can press Alt and  = to achieve the same result Just you have to...
    0 comments
    Show only some portion of Excel sheet
    Dp
    • Apr 21, 2018
    • 1 min

    Show only some portion of Excel sheet

    Excel Sheet has 2^20 Rows and 2^14 Columns. Instead of Using the blank cells appearing. It is better to hide all the unwanted blank...
    0 comments
    • primavera (3) 3 posts
    • .xer (2) 2 posts
    • activity id (1) 1 post
    • advance excel (1) 1 post
    • budgeted units (1) 1 post
    • count unique (1) 1 post
    • excel (1) 1 post
    • excel tips (1) 1 post
    • excel tricks (1) 1 post
    • l (1) 1 post
    • labor units (1) 1 post
    • p6 (1) 1 post
    • project management (1) 1 post
    • resources (1) 1 post
    • rimavera (1) 1 post
    • schdulereader (1) 1 post
    • schedule (1) 1 post
    • scheduling (1) 1 post
    • sources (1) 1 post
    • top down estimation (1) 1 post
    • unique (1) 1 post

    IF YOU THINK THIS IS HELPFUL ...

    Let’s celebrate by 

    buying dptutorials a cup of coffee :-)

    • YouTube Social  Icon
    • Facebook Social Icon
    • Twitter Social Icon
    • Google+ Social Icon
    • Blogger Social Icon

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