MyBlogLog

The Home for Engaged Publishers & Readers

Subscribe

Topic: Excel 2007

New with Topic: Excel 2007


LudwigPaeps
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. ...
9 days ago EHBO voor je PC | Topics: excel 2007, tabellen
 
Max.Gunther
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...
 
Max.Gunther
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...
 
LudwigPaeps
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...
 
fersal
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.
44 days ago CyberSkillsGuide | Topics: Excel, chart, charting, default
 
fersal
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,...
 
Max.Gunther
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,...
 
fersal
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,...
 
fersal
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.
 
Max.Gunther
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....
 
Max.Gunther
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...
 
Max.Gunther
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...
 
Max.Gunther
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...
 
more...