Topic: Excel 2007
New with Topic: Excel 2007
LudwigPaeps posted a blog entry
Excel 2007 Tip: Werken met tabellen
Excel 2007 heeft een veel betere tabelfunctie dan vroeger. Deze kan o.a. gebruikt worden voor het opmaken van een werkblad. ...
Excel 2007 heeft een veel betere tabelfunctie dan vroeger. Deze kan o.a. gebruikt worden voor het opmaken van een werkblad. ...
Max.Gunther posted a blog entry
Creating a Scrolling Chart in Excel 2007
Earlier in this chapter, you learned how to create a chart that expands automatically as you add new data points (see...
Earlier in this chapter, you learned how to create a chart that expands automatically as you add new data points (see...
Max.Gunther posted a blog entry
Charting Small Values with a Bar of Pie Chart in Excel 2007
In earlier Figure, I exploded one of the pie chart slices and then added a shape with some explanatory data about the...
In earlier Figure, I exploded one of the pie chart slices and then added a shape with some explanatory data about the...
LudwigPaeps posted a blog entry
Excel Tip 2007: hou bepaalde cellen altijd in het oog
Wist je dat er een simpele methode bestaat om bepaalde cellen altijd in het oog te houden, zodat je de waarde kan bekijken...
Wist je dat er een simpele methode bestaat om bepaalde cellen altijd in het oog te houden, zodat je de waarde kan bekijken...
fersal posted a blog entry
Change Your Default Chart Type in Excel 2007
Excel 2007 allows you to change your default chart type... here's how to change it.
Excel 2007 allows you to change your default chart type... here's how to change it.
fersal posted a blog entry
Debugging complex formulas in Excel 2007
Debugging complex formulas in Excel 2007 can get very tricky, especially when a slight difference in the use of parentheses,...
Debugging complex formulas in Excel 2007 can get very tricky, especially when a slight difference in the use of parentheses,...
Max.Gunther posted a blog entry
Optimizing Profit and Margin in Excel 2007
Breaking even is always nice, but profits are even better, so you might want to use Excel to optimize profits. In this case,...
Breaking even is always nice, but profits are even better, so you might want to use Excel to optimize profits. In this case,...
fersal posted a blog entry
Debugging complex formulas in Excel 2007
Debugging complex formulas in Excel 2007 can get very tricky, especially when a slight difference in the use of parentheses,...
Debugging complex formulas in Excel 2007 can get very tricky, especially when a slight difference in the use of parentheses,...
fersal posted a blog entry
Create Data Icons in Excel 2007 Using Conditional Formatting Rules Manager
Excel 2007's Conditional Formatting Rules Manager makes it easier to view large number tables.
Excel 2007's Conditional Formatting Rules Manager makes it easier to view large number tables.
Max.Gunther posted a blog entry
Using a Watch Window to Watch a Cell Value in Excel 2007
Using a range snapshot is a useful and nifty trick, but it’s only practical if you want to watch one or two values....
Using a range snapshot is a useful and nifty trick, but it’s only practical if you want to watch one or two values....
Max.Gunther posted a blog entry
Using a Range Snapshot to Watch a Cell Value in Excel 2007
What-if analysis is perhaps the most basic method for understanding worksheet data. With what-if analysis, you first calculate...
What-if analysis is perhaps the most basic method for understanding worksheet data. With what-if analysis, you first calculate...
Max.Gunther posted a blog entry
Using Dialog Box Controls to Input Data in Excel 2007
If you are constructing worksheets that other people will use for data entry, ensuring that data is entered as accurately as...
If you are constructing worksheets that other people will use for data entry, ensuring that data is entered as accurately as...
Max.Gunther posted a blog entry
Saving All Open Workbooks in Excel 2007
If you often work with multiple workbooks at once, you may find yourself moving from one workbook to another, making changes to...
If you often work with multiple workbooks at once, you may find yourself moving from one workbook to another, making changes to...
