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…]
Common VBA Statements for Excel VBA Programming
The following table provides a list of commonly used VBA statements that you might use when creating macros for Excel. For more information on a particular statement, consult Excel's Help system. [more…]
VBA Functions for Excel VBA Programming
The VBA language contains a number of functions that you can use to build code in Excel. The following table provides descriptions of the most useful functions. When writing code, type the word [more…]
Excel Statistical Analysis Functions
Excel shines at statistical analysis. It has a range of functions you can use to determine tendency and variability, comparatives, and correlations among other things. The following tables show which function [more…]
Excel Array Functions
Excel offers statistical analysis functions which you can use to find and insert an array of values into a selected array of cells in an Excel worksheet. The following table tells you which function calculates [more…]
Excel Data Analysis Toolpak Functions
You can load in the tools in Excel's Analysis ToolPak and add a whole range of statistical analysis tools. You can do F-tests, find covariance coefficients, as well as a lot of other tools. The following [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…]
