Create a Master Spreadsheet You'll often want to have Excel consolidate data from multiple spreadsheets with similar data.

How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

Use Word to create a chart from existing Excel data You don't need Microsoft Excel to chart data in an existing Excel file; you can simply import that data and chart it entirely in Microsoft Word.

Learn how to create and and forms to Excel spreadsheets to help make data entry easier. This guide makes it easy to create Excel forms for ...

Convert your daily General Journal data into a more extensive, yet focused, General Ledger using Excel in this tip from Mary Ann Richardson.