Understanding Excel

View:

Sorted by:

Using Built-in Add-In Programs in Excel 2007

Add-in programs are small modules that extend the power of Excel 2007 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three [more…]

How to Change Column Width and Row Height in Excel 2007

In Excel 2007, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen [more…]

Navigating Excel 2007's Worksheet Tabs

Each new workbook you open in Excel 2007 contains three blank worksheets, although you can add many more. You can easily move between the worksheets in an Excel workbook by using the sheet tabs, the Sheet [more…]

Get Help in Excel 2007

If you get stuck and have questions about Microsoft Office Excel 2007 features, you can use the Excel Help window to quickly find the answers. The Excel Help button — the button with a question mark, located [more…]

Dealing with the New Excel 2007 File Formats

Office Excel 2007 supports the use of a new XML-based file format that Microsoft officially calls the Microsoft Office Open XML format. This new file format carries the filename extension [more…]

Starting and Exiting Excel 2007

Microsoft Office Excel 2007 provides several methods for starting and exiting the program. You can open Excel by using the Start menu or a desktop shortcut. When you want to exit Excel, you can do so by [more…]

Dictating to Excel: What to Say for Common Punctuation

The Speech Recognition feature in Excel 2003 dictates a word or phrase you speak into your PC's microphone for common punctuation and symbols. Here are the words to say and what Speech Recognition executes [more…]

Shortcut Keys for Manipulating Worksheets in Excel 2003

Learning keyboard shortcuts will make operating your worksheets easier in Excel 2003. Here are some shortcut keys to basic commands in your Excel worksheets: [more…]

Shortcut Keys for Editing and Formatting Cell Entries in Excel 2003

Each one of those little squares on a worksheet in Excel 2003 is called a cell and it holds important information. Here are some keyboard shortcut keys that help you organize and correct your cell entries [more…]

Excel 2003 for Dummies Cheat Sheet

Running Excel 2003 is easier when you know the shortcut keys to manage your worksheets and cell entries. The Speech Recognition feature in Excel 2003 lets you enter data, like symbols and punctuation, [more…]

Keyboard Shortcuts for Entering Data in Excel 2003

Filling in all those empty Excel 2003 cells may seem daunting, but keyboard shortcuts ease the pain. Use these Excel 2003 keyboard shortcuts to enter data quickly. You'll find Excel a much more enjoyable [more…]

Keyboard Shortcuts for Editing Cells in Excel 2003

Editing information within a cell in Excel 2003 can get confusing without some guidance. Excel 2003 has plenty of keyboard shortcuts to make editing cells a breeze: [more…]

Keyboard Shortcuts for Excel 2003 Worksheets

Excel 2003 — any version of Excel, actually — is about creating spreadsheets (worksheets) contained in workbooks. To navigate around worksheets and workbooks in Excel 2003, use these keyboard shortcuts [more…]

Keyboard Shortcuts for Moving within an Excel 2003 Worksheet

You’re moving cell-by-cell through an Excel 2003 worksheet, thinking "I wish there was a shortcut." Your wish is granted! Excel 2003 keyboard shortcuts make quick work of your spreadsheet. [more…]

Excel 2003 All-in-One For Dummies Cheat Sheet

Excel 2003 offers a multitude of options — along with keyboard shortcuts — to create glorious spreadsheets (or worksheets, in Excel-ese). Whatever you use Excel 2003 for, you can move around and through [more…]

Helpful Web Sites for Excel 2007 Reports

The dashboards and reports of Excel 2007 offer a wide range of Excel tools, and it’s always nice to see the approach others take to design their reporting mechanisms. The following Web sites [more…]

Shortcuts for Common View Commands in Excel 2007

If you want to change the way you're looking at an Excel 2007 spreadsheet, or the way the page is laid out, use these view command shortcuts (Alt + hot key). [more…]

Shortcuts for Common File Commands in Excel 2007

Instead of using the ribbon for your basic file functions in Excel 2007, check out this chart for keystroke shortcuts ( Alt + hot key) to get your spreadsheet basic commands quickly accomplished. [more…]

Common Editing Command Shortcuts in Excel 2007

As an alternative to using the ribbon in Excel 2007, these shortcut keystrokes (Alt + hot key) get you moving quickly through basic spreadsheet editing functions. [more…]

Excel 2007 For Dummies Cheat Sheet

In Microsoft Office Excel 2007, using the keystroke shortcuts (Alt + hot keys) instead of the ribbon will get you quickly through common view, file, and editing commands. [more…]

Related Topics

Cheat Sheets