October 15, 2021 - by Bill Jelen
Problem: After I create a wide report, it prints four pages wide. How do I make it print one page wide?
Strategy: Ultimately, you will set the Scale to Fit settings to print to one page wide by any number of pages tall. Before you can do that, you should follow these steps:
How to Print Page Numbers at the Bottom of Each Page »
October 14, 2021 - by Bill Jelen
I am printing a lengthy report, and I want the pages to be numbered.
Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subsequent Page »
October 13, 2021 - by Bill Jelen
I am sending out a worksheet that contains a letter followed by a lengthy report. I would like the headings to appear at the top of each page after the first page. I don’t want the headings to appear at the top of the letter on the first page.
How to Print Titles at the Top of Each Page »
October 12, 2021 - by Bill Jelen
I have a report that has 90 rows of data. I want to have the title rows print at the top of each printed page.
Excel Data Cleansing Straight To The Point
July 2019
This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.
Master Your Data with Power Query in Excel and Power BI
August 2021
Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.
Supercharge Power BI - 3rd Edition
February 2021
Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.
March 2021
Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.