How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
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.
More cool Excel tutorials:
Excel VBA Loop
The Excel VBA Loop (or For Next loop) is a very useful programming statement which is often used in Excel VBA. First we will look at an easy example of how to loop through a one-dimensional range. You can also loop through a two-dimensional range using a Double Loop. In a similar way you can use three loops (a triple loop) to loop trough two-dimensional ranges on different Excel Worksheets. Besides For Next loops, there are other loops in Excel VBA, such as Do While Loops and For Each Next Loops.
Save To SpreadsheetML And Extracting Data
Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information.
Name a Worksheet in Excel 2007
Providing a name for your worksheets in your Excel 2007 workbooks will allow you to organize and keep track of where your data lies within the workbook.
Count or Sum Cells That Meet Conditional Formatting Criteria
Once you can see the results of conditional formatting, you might want to create formulas that reference only the data that was conditionally formatted.
Quickly Finding the Workbook
This technique covers ways to quickly and easily find the workbook file you want.