If this is your first visit, then welcome! Be sure to
check out the FAQ by clicking the
link above.Register here
so that you can post in the forums or comment on the articles.
Today Christoper Fennell of Excel and Access asked about web stats, so just took a quick look at mine. Due to a change in tracking back in October I had to estimate, but based on traffic from Jan 1 - now, annualized assuming no growth, ExcelGuru.ca sees:
337,000 visitors per year279,000 of those visitors are unique552,000 page views per year
Wow! I didn't realize that it had grown up that high!
It will be interesting to look back at the end of the
I have just posted a new KB Entry on using conditional formatting to highlight subtotals. You can find it here: http://www.excelguru.ca/content.php?...r-Easy-Reading
A few years ago I worked with Steve French of Infomatix on time managment techniques. One of the things we talked about was getting into a daily goal setting habit, with a key point of that being reviewing the previous days goals. It was an important point that you need to recognize that you have had success to pump you up to challenge the next goal. Helps you recharge your batteries in a way.
Since that time I've slipped in and out of the system, (just being honest,) but every time
I've been doing a lot of work with PowerPivot where I connect to databases. My normal development cycle is as follows:
Connect to a view or table, pulling in ALL columnsWork through my data scenario until I've worked out my logic and solve the issue I'm trying to solveCut the table/view query down to just the required columnsAdd WHERE clauses to cut the data down to just the bare minimum I needDeploy to my users
By doing all this, I really focus on trying
After discussions with a friend the other day, I thought it might be worth pulling together an entry to show how to get the selected item from a PivotTable Slicer into a formula. This approach allows you to drive dynamic chart titles, or based other logic off a slicer as well.
You can find the full aticle at: http://www.excelguru.ca/content.php?...otTable-Slicer