Excel 2010

View:  
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…]

Setting Up Your Baseline in Excel Sales Forecasting

You need to provide a solid baseline (history) in order for your Excel forecast functions to work accurately in Excel sales forecasting. This chart shows you some ways to arrange data for your baseline [more…]

The Analysis ToolPak in Excel Sales Forecasting

The Analysis ToolPak in Excel sales forecasting figures out what's going on with your data without your having to enter formulas. Excel's Analysis ToolPak has three useful tools for directly forecasting [more…]

Excel Sales Forecasting Functions

Give these sales forecasting functions in Excel a good baseline and you can get a handle on future sales business. Some Excel forecast functions and their actions appear in the following chart — keep it [more…]

The LINEST Function in Excel Sales Forecasting

The LINEST (or linear estimate) function in Excel sales forecasting uses formulas to calculate a regression equation and related statistics. This chart shows the information the Excel LINEST function will [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…]

Excel Error Messages to Get to Know

If you create a formula in Excel that contains an error or circular reference, Excel lets you know about it with an error message. A handful of errors can appear in a cell when a formula or function in [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…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com