An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.
Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.
Excel's chart features can turn your spreadsheets into compelling visual ideas. This guide covers the basics and the best tips.
We'll dive deep into Excel workbooks in this guide, starting with the basics and diving straight into powerful three-dimensional workbooks.
Excel spreadsheets do so much. This guide starts with the basics and will add more Excel tips over time, so you'll always be in the know.
When Microsoft Excel complains it "cannot complete this task with available resources," or it's "Out of memory," here's what to do.
Better graphics, better features, more options
Photoshop lets you make any font fancier with swashes, swirls and other flourishes. Here's how.
Adobe Photoshop's Text Type and Text Editing tools let you manipulate standard fonts for greater visual impact.
Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.
Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.
Use commands and formulas to make these tasks a breeze
The bigger and uglier your Excel spreadsheet gets, the more you need these tips to handle the data with as little hassle as possible.
Updating your résumé means more than refreshing the information. We'll show you how to use style sheets, shapes, and text boxes to create a modern, professional layout.
Excel can streamline your global activities if you set up functions to convert metric to American Standard, and dollars to euros.