MS Excel for Project Managers

This lecture is about how you can generate data faster by using the power of Cell Handles.

This lecture is about how you can leverage suggested "smart" text as well as cell handles. 

In the resources area of this lecture, please download Project 1 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

In this lecture, we take a look at using different fonts, leveraging borders to make your text stand out, and aligning your data properly in Excel.

This lecture is regarding Merging Cells and how to represent multiple rows of data with one heading that spans the length of that data set.

Here, we will discuss formatting numbers into various formats and understand how easy it is.

This lecture will demonstrate how to leverage the Format Painter so that you can quickly format multiple cells without having to edit each one.

Creating Themes and changing Tab Colors of your spreadsheets will be the focus of this lecture.

In the resources area of this lecture, please download Project 2 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

In this lecture, we'll focus on putting the power of Excel's mathematical functions to work for you.

Here, we deep-dive into the Sum, SumIf, and Average functions.

Net Present Value and Internal Rate of Return are necessary statistics to generate to figure out if a project is worthy of undertaking.  Here, we will review the NPV and IRR functions to help you get these results.

In this lecture, we'll understand how to "nest" Excel functions leveraging the following functions:  If, And, Or.

Here, we'll leverage the IfError function so that you can provide your users with more informational data rather than the generic Excel-generated error messages.

In this lecture, we'll use the Count and CountIf functions and discuss how they can be leveraged to return the count of data that meet certain conditions.

In the resources area of this lecture, please download Project 3 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

In this lecture, we'll discuss cell referencing within the same Excel sheet.

Here, we'll discuss one of the more powerful functions of MS Excel where we'll reference data across multiple worksheet to consolidate information to one summary worksheet.

In the resources area of this lecture, please download Project 4 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

We'll go over the various methods of Data Validation that MS Excel offers.  This will ensure that your users only enter the correct information into your worksheets.

This lecture discusses Error Reporting and how you can produce informational error messages to your users instead of the generic and vague Excel system-generated messages.

This is the first part regarding formatting portions of your spreadsheet based on certain conditions.

This is the second part regarding formatting portions of your spreadsheet based on certain conditions.

This is the third part regarding formatting portions of your spreadsheet based on certain conditions.

In the resources area of this lecture, please download Project 5 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

In this lecture, we'll leverage the VLOOKUP function to find data within a data set.

Here, we'll look into the MATCH and XMATCH functions and how they are powerful tools to find data.

The INDEX MATCH function is probably the most powerful tool Excel provides to find specific data within a vast data set.

In the resources area of this lecture, please download Project 6 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

In this lecture, we'll go over how to create Pivot Tables and leverage an example of performing a project financial analysis.

Here, we'll discuss how to leverage the power of charts to graphically represent your pivot data or data from a regular cell range.

In the resources area of this lecture, please download Project 7 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

In this lecture, we'll discuss how to leverage Excel data to automatically generate information on PowerPoint slides.  This is especially useful if you're leveraging PowerPoint to make presentations regarding project status.

In the resources area of this lecture, please download Project 8 and feel free to practice on your own.  Again, if you have any questions, please feel free to reach out to me.

This is the first part in our video series on creating your own Project Task tracker and Gantt chart.

This is the second part in our video series on creating your own Project Task tracker and Gantt chart.

This is the third part of our video series on creating your own Project Task tracker and Gantt chart.

This is the fourth part in our video series on creating your own Project Task tracker and Gantt chart.

This is the fifth part of our video series on creating your own Project Task tracker and Gantt chart.

This is the sixth part of our video series on creating your own Project Task tracker and Gantt chart.

This is the final part in our video series on creating your own Project Task tracker and Gantt chart.