top of page
Search

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...
Daniel Rivera, PMP
Sep 3, 20211 min read
40 views


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...
Daniel Rivera, PMP
Aug 11, 20211 min read
17 views


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...
Daniel Rivera, PMP
Jul 29, 20211 min read
35 views


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...
Daniel Rivera, PMP
Jul 8, 20213 min read
392 views


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...
Daniel Rivera, PMP
Jun 30, 20211 min read
48 views


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...
Daniel Rivera, PMP
Jun 17, 20211 min read
19 views
bottom of page