Excel 2010

Sorted by:  

Adding the Excel Camera Tool to the Quick Access Toolbar

The Excel Camera tool enables you to take a live picture of a range of cells that updates dynamically while the data in that range updates. Although Microsoft doesn't include the Excel Camera tool in the [more…]

File Menu Commands: Common Excel 2010 Hot Keys

To activate the Excel 2010 hot keys, you press the Alt key before typing the mnemonic letters for a particular task. The mnemonic letter is F (for File) for the commands on the File menu in the new Backstage [more…]

Hot Keys for Excel 2010 Editing Commands

To activate Excel 2010 hot keys, you press the Alt key before you type the mnemonic letters for a particular task. The mnemonic letter is H (Home) for the editing commands because these commands are located [more…]

Excel 2010 View Commands Hot Keys

You can activate the Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letters for a particular task. The mnemonic letter for all view-related commands in Excel 2010 is [more…]

Hot Keys for Common Excel 2010 Formula Commands

You activate Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letter for a particular task. Hot key sequences for the most common formula-related commands in Excel 2010 begin with [more…]

Excel 2010 All-in-One For Dummies Cheat Sheet

As an integral part of the Ribbon interface used by the major applications included in Microsoft Office 2010, Excel gives you access to hot keys that can help you select program commands more quickly. [more…]

Moving the Cell Cursor in Excel 2010 Spreadsheets

Excel 2010 offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if [more…]

Excel 2010 Data-Entry Etiquette

To begin to work on a new Excel 2010 spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window. Here are a few simple guidelines [more…]

Deciphering Error Values in Excel 2010 Formulas

You can tell right away that an Excel 2010 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness, in the parlance of Excel 2010 [more…]

Top Ten Features in Excel 2010

If you’re looking for a quick rundown on what’s cool in Excel 2010, look no further! Just a cursory glance down the list tells you that the thrust of the features is graphics, graphics, graphics! [more…]

Excel 2010 For Dummies Cheat Sheet

At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2010 user interface. However, this Cheat Sheet will help you navigate your way by showing you [more…]

Office 2010 Shortcuts for PowerPoint and Excel

Office 2010 has myriad shortcuts for Excel, and PowerPoint. Using the Office 2010 shortcuts shown in this table can help you run your applications more efficiently. [more…]

Excel Order of Operations to Keep in Mind

Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that protocol. The following is the order in which mathematical operators and syntax are applied both in Excel and in [more…]

Excel Cell References Worth Remembering

In Excel formulas, you can refer to other cells either relatively or absolutely. When you copy and paste a formula in Excel, how you create the references within the formula tells Excel what to change [more…]

Excel Functions You're Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference [more…]

Excel Text Functions You'll Find Helpful

Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description [more…]

How to Save an Excel 2010 Workbook as a PDF or XPS File

Microsoft Excel 2010 lets you save your workbook files directly in the PDF (Portable Document Format) or XPS (XML Paper Specification) file format. These formats enable people to open and print your Excel [more…]

What's New in Excel 2010?

For a quick rundown on what’s new in Excel 2010, look no further! The new features and enhancements in Excel 2010 build upon the significant changes in Excel 2007. To learn more from Excel 2010 itself, [more…]

How to Start and Exit Excel 2010

Microsoft Office Excel 2010 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…]

Exploring the Excel 2010 Program Window

When you start Microsoft Office Excel 2010, you see the first of three worksheets (named Sheet1) in a workbook file (named Book1) inside a program window. The Excel 2010 program window is made up of the [more…]

How to Navigate the Excel 2010 Ribbon

The Ribbon interface in Microsoft Office Excel 2010 may seem tricky to navigate until you get used to how commands are organized. The File tab on the left side of the Ribbon provides access to commands [more…]

Using Excel 2010’s File Tab to Access Backstage View

Near the top-left corner of the Excel 2010 window, you find the green File tab, which provides access to Backstage view. The File tab replaces the Office button [more…]

Scrolling through an Excel 2010 Worksheet

You can use the horizontal scroll bar in Excel 2010 to scroll left and right in a worksheet and the vertical scroll bar to scroll up and down. The horizontal scroll bar appears at the bottom of the worksheet [more…]

How to Navigate Excel 2010's Worksheet Tabs

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

How to Select Cells in Excel 2010

Before you can enter your worksheet data in Microsoft Office Excel 2010, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com