Excel's randomization functions generate values, shuffle datasets, and simulate timelines using simple formulas.

Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate business check numbers that haven't been logged into a balance ...

Is Apple’s iWork a viable alternative to Microsoft Office? To find out, we asked Rob Griffiths—our go-to expert on spreadsheets—to use Excel 2008 and Numbers ‘08 to create the same project, ...

TLDR: The pair of courses go deep into Excel training for numbers-centric professionals, including how to customize and automate Excel to do statistical gruntwork all on its own. No true professional ...

Q. My wife and I have used Apple’s Numbers program to open and edit Microsoft Excel files. But how can Excel subsequently be used to open and edit the same file after it’s been opened in Numbers? A.

Spreadsheet programs are effective tools for successful businesses. These programs can significantly reduce the time needed to create reports and financial statements used to manage a business. Most ...

I didn't realize how much time I spent on cleanups until regex let me stop.

Some of my reports list Social Security numbers. Since the reports are often viewed by others, I need a convenient but secure way to hide those numbers—such as making only the last four digits visible ...

Microsoft has updated Excel to allow developers to programmatically create their own custom data types in the popular spreadsheet program. This update isn't aimed at Excel-using business execs but ...

If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an ...