I have 2 quick announcements & 1 Excel tip for you.
Announcements
- Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
- 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.
Excel Tip
When you print a long report, notice how Excel chops it in to pages? Sometimes, you don’t like how the pages are broken and want to insert page breaks where you want.
Here is how you can insert page breaks:
- If you want to insert a break after Row 7
- Select the row 8
- Go to Page Layout > Breaks
- Select Insert Break
PS: If you use Page Break Preview mode (from view ribbon), you can manually drag and resize pages until everything looks the way you want.
PPS: If you want to learn Excel (and dashboards), consider joining Excel School. If you hurry up, you can even get 20% discount. Click here.
3 Responses to “CP049: Don’t do data dumps!!!”
Your title got me nervous because I'm all about data dumps, but not for attaching graphics to data dumps. My reason for using data dumps is when someone is trying to do analysis and their starting point is a report that's formatted in a way for a human to read. I instruct them to stop with the report and go get a data dump: just rows and columns and rows and columns.
Agreed, nearly all of my reports start with 100+ lines of simple table data.
That way you can build your functionality around pulling information from that tabled information.
Yes yes!