Subscribe
Tutorial search

Managing Projects with MS Project and Microsoft Excel - Excel tutorial


Are you a project manager? If so, learning how to use Microsoft`s Excel and MS Project can be pivotal to your success.
Category: Excel > Basics - Difficulty:


More cool Excel tutorials:



Saving Time with Excel Add-ins
Saving Time with Excel Add-ins
Excel add-in programs provide a quick-and-easy way to extend the basic features of Excel. Most of the add-in programs created for Excel offer you some kind of specialized function or group of functions that extend Excel's computational abilities.
Difficulty:
Show Full Toolbars All The Time
Show Full Toolbars All The Time
While learning Excel, use the Tools Customize feature to show the complete version of Standard and Formatting toolbars.Microsoft only show the most common menu choices from Excel’s two most important toolbars: Standard and Formatting.
Difficulty:
Lookup in a Column to the Left in Excel
Lookup in a Column to the Left in Excel
Lookup data in a column to the left in Excel. The Vlookup function cannot look to the left in Excel. Index and Match can be used to lookup data from any column.
Difficulty:
CountA Function
CountA Function
The CountA function in Excel will return the number of entries (actually counts each cell that contains number data OR text data) in the selected range of cells.
Difficulty:
Distribute Macros
Distribute Macros
Although you can distribute a macro along with a workbook, if you want to distribute only the macro's functionality, an Excel add-in is the way to go.
Difficulty: