A great way to distribute Excel reports is as a PDF file. Then you distribute the file. Here's how to save any number of Excel reports to one PDF file.

How to Save Multiple Excel Reports to One PDF File

Reporting Charley Kyd - 0
A great way to distribute your Excel reports is to save them in a PDF file and then distribute the file. People who receive your...
With the help of three functions most Excel users seldom use -- INT, MOD, and CEILING -- you can round Excel time values to any increment you want.

How to Round Time in Excel to Any Increment

Date-Time Functions Charley Kyd - 0
Several years ago, a reader asked whether it's possible to use the ROUND function to round times quarter- or half-hour increments. I gave him a...

How to Reproduce Your Excel Work Across Many Categories, Part 3 of 3

Data Management Charley Kyd - 0
Part 1 of this series about analytical spawning with Excel described how Excel users often need to spawn one model or report across many related...
Here's how to apply an Excel report, forecast, or analysis for one product, division, or other categoy to any number of categories. Part 2 of 3.

How to Reproduce Your Excel Work Across Many Categories, Part 2 of 3

Data Management Charley Kyd - 0
As I explained in Part 1 of this series, Excel users often need to apply many instances of data to one model or forecast, list...
Here's how we Excel users can replicate one report or analysis across many similar categories of data, like regions, products, departments, and so on.

How to Reproduce Your Excel Work Across Many Categories, Part 1 of 3

Business & Economics Charley Kyd - 0
A member of an Excel forum recently asked how to solve a problem that many Excel users face in various forms. In his particular case,...
Do you need to update your Excel reports with daily, weekly, or monthly data? Here's a low-maintenance way to do it, using one type of Excel database.

How to Report Periodic Data from Excel Databases

Data Management Charley Kyd - 0
Sometimes, the best way to solve your Excel problem is to redesign your workbook. Ron G. brought this thought to mind with a recent question....
Here's how a few Excel formulas can move data between Excel's most widely used table designs to transfer data from source files into a more usable form.

How to Read and Update Excel Tables Using SUMIFS and INDEX-MATCH

Excel Tables Charley Kyd - 0
A growing number of Excel users in business are linking their reports and analyses to Excel tables. By doing so, they can update them...
Excel includes many outstanding features that you probably don't know even exist. Here's how to find those features and to use the ones you need.

How to Find and Use Excel’s Best Hidden Features

Worksheet Interaction Charley Kyd - 0
Excel has many outstanding hidden features. Here are a few that I use frequently… In Excel 2013 and above, when you close Excel's last...
Do you spend hours each period turning raw data into useful information? You can fight such Spreadsheet Hell with help from three key Excel functions.

How to Fight Spreadsheet Hell with Three Excel Lookup Functions

Formulas & Functions Charley Kyd - 0
(I wrote this long ago, and there's much to be added. It's high on my Update list. Charley) Many Excel users build their reports like...
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Here's the first of two methods.

How to Delete Blank or Unneeded Rows, Method 1

Worksheet Interaction Charley Kyd - 0
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Often, you’ll want...
1...111213...22Page 12 of 22