top of page
Search

Daniel Rivera, PMP
Sep 3, 20211 min read
How to Embed a MS Excel worksheet into MS Power Point.
In this video, we'll discuss how to insert an MS Excel worksheet into your MS PowerPoint presentation. We'll also see how you can do...
40 views


Daniel Rivera, PMP
Aug 11, 20211 min read
How to Leverage Multiple Worksheets in MS Excel
In the below video, we discuss how to reference multiple worksheets in MS Excel. Our example is to develop a summarized worksheet that...
17 views


Daniel Rivera, PMP
Jul 29, 20211 min read
How to Use the AVERAGEIF Function in MS Excel
In the below lecture, we discuss the usefulness of the AVERAGEIF function in MS Excel. We'll discuss from the context of a program's...
35 views


Daniel Rivera, PMP
Jul 8, 20213 min read
How to Calculate Net Present Value (NPV)
NPV provides an indication to the benefit that is going to be created by the project in question. This formula is leveraged when an...
392 views


Daniel Rivera, PMP
Jun 30, 20211 min read
How to use the MS Excel SLN Function to determine Depreciation
MS Excel provides a nifty SLN function to determine depreciation leveraging the straight-line method. In the below example, this...
48 views


Daniel Rivera, PMP
Jun 17, 20211 min read
How to Work with Delimited Files in MS Excel
As Project Managers, we sometimes work with plain delimited files from external systems such as SAP for employee time tracking. The...
17 views
bottom of page