Excel tips

Technology

How to Create List Reports in Excel

List-type reports such as customer addresses, lists of invoices and lists of products are vitally important in running the daily operations of a business. So it is vital that you be able to write your own when you need them. If your package has a full-strength Report Writer function, writing your own list reports may prove difficult. As an alternative approach, try writing them instead in Excel using the Sub-Total and Import External Data commands.
Technology

Embedding Data from an Excel Spreadsheet in a Power Point Presentation

Embedding data from an Excel spreadsheet into a Power Point presentation is especially useful if the basic presentation is used repeatedly and frequently. When data is embedded in a presentation or document it allows the data in the presentation to be updated automatically when the data is updated in the source spreadsheet. Presuming both the source spreadsheet and the destination presentation already exist and are open in separate windows, follow these steps to embed the data: Select the range of cells you want to copy in the Excel spreadsheet.
A&A

Avoiding Spreadsheet Slip-Ups

Spreadsheets help individuals and business organizations record financial data efficiently. Excel is probably the most common spreadsheet application used by businesses today. Users program formulas and macros to automate calculation of financial data as well. The seemingly simple financial logic inside spreadsheets can also cause embarrassing errors.
Practice Management

Security Alert: Microsoft Warns of Excel Zero-day Vulnerability

Microsoft posted a warning on Friday stating that a previously unknown flaw in Excel is being exploited by opening a malicious Excel document. The vulnerability is considered extremely critical because, according to a prepared statement from Secure Elements, it is locally and remotely exploitable by Trojan.Mdropper.J, which drops Downloader.Booli.A on the affected system.
Technology

5 Tips for Improving Spreadsheet Readability

Have you noticed that some spreadsheets are easier to read than others? Of course, there isn’t much to read in most spreadsheets just column and row labels and formulas. So why do some spreadsheet authors seem to have a magic touch? They just know and follow these five simple rules:1. Be Consistent. Many names can be expressed in more than one way. Pick one and use it in all the spreadsheets you create.2. Be Brief. Short names are easier to read than long ones.
Technology

The Best Shortcut Keys in Microsoft Excel

Provided by ExcelTip.comCtrl+ZUndoCtrl+C Enter, Ctrl+V Ctrl+XCopy, Paste, Multiple Paste, CutCtrl+F, Ctrl+HFind, Find&ReplaceCtrl+P, Ctrl+S, Ctrl+F4, Alt+F4Print, Save,
Technology

Save Customized Microsoft Excel Chart Styles

If you create charts in Excel, chances are good that you adjust the formatting of the standard chart style each time you create a new chart. You may change the size of the font, perhaps you add some background color, you might include your company logo on the chart, you may prefer the currency format for your numbers, or you may prefer a line graph to the default column style.
Technology

Excel Tip: Overriding and Removing Page Breaks

Excel automatically determines where page breaks will occur, but you can create your own page breaks in your worksheets by forcing Excel to begin printing on a new page at the location that is best for you.To create a horizontal page break, follow these steps: Place your cellpointer in Column A in the row below the row in which you wish to insert a page break.Choose Insert, Page Break from the Excel menu.
Technology

Five Quick and Easy Excel Tips

Complimenets of ExcelTip.comTip 1: Searching all Sheets in a WorkbookTo search for text, use the keyboard shortcut Ctrl+F or choose Edit, Find. To search and replace text, use the keyboard shortcut Ctrl+H or choose Edit, Replace. Searching and replacing all sheets in the Workbook From sheet tab short cut menu choose Select all sheets.
Technology

Adding a Wrap Text Shortcut in Microsoft Excel

Wrap text is a useful technique that you will use frequently when working in Excel. You add the shortcut by adding a style in the Style box.
Technology

Color Rows According to Criteria in Microsoft Excel

You can use coloring to isolate data in lists and to differentiate between various types of data.Make sure the list is set to AutoFilter. Filter the year 1996 according to the following criterion – from the drop-down list for the Year field, select 1996. Select a cell in the list of data – press Ctrl+* (select the current region). From the Formatting toolbar, select Fill Color, and then select any color. Filter the year 1997 according to the following criterion – from the drop-down list for the Year field, select 1997. Select a cell in the data l
Technology

Adding a Wrap Text Shortcut in Microsoft Excel

Wrap text is a useful technique that you will use frequently when working in Excel. You add the shortcut by adding a style in the Style box. Adding the Style box to the Formatting toolbarRight-click one of the toolbars, and select Customize. Select the Commands tab, and then select Format. Drag the Style icon from the Customize dialog box to the Formatting toolbar, and drop it next to the Font Size box (or anywhere else you choose).
Technology

Excel Tip: Save Customized Excel Chart Styles

If you create charts in Excel, chances are good that you adjust the formatting of the standard chart style each time you create a new chart. You may change the size of the font, perhaps you add some background color, you might include your company logo on the chart, you may prefer the currency format for your numbers, or you may prefer a line graph to the default column style.

Inserting Fields to Calculate Percentage in Excel with Pivot Tables

With a PivotTable, you can insert additional data fields that you have already used and change the calculation function by which you create new calculated columns.Insert an additional data field, Quantity field as an example.Stage 1 – Add field to Data area. Select any cell in Pivot Table area. Right-click, and from the shortcut menu, select Wizard, Layout (in Excel 97, there is no need to select Layout). Drag the Quantity field to the data area.

The Best Shortcut Keys in Microsoft Excel

Ctrl+ZUndoCtrl+C Enter, Ctrl+V Ctrl+XCopy, Paste, Multiple Paste, CutCtrl+F, Ctrl+HFind, Find&ReplaceCtrl+P, Ctrl+S, Ctrl+F4, Alt+F4Print, Save, Close, Close Excel
Technology

Three Timesaving Microsoft Excel Tips

Here are three tips for MS Excel Users. Tip One: Use the Color Code Feature For Your Excel Sheet Tabs - Version 2002 and above.If you have multiple offices or departments, this is a nifty tip. You can color-code sheet tabs for easier identification or grouping of related sheets. Here's how:Select the sheets you want to color by holding down the CTRL key and clicking the tabs. On the Format menu, point to Sheet, and then click Tab Color.

Excel Tip: Overriding and Removing Page Breaks

Excel automatically determines where page breaks will occur, but you can create your own page breaks in your worksheets by forcing Excel to begin printing on a new page at the location that is best for you.To create a horizontal page break, follow these steps: Place your cellpointer in Column A in the row below the row in which you wish to insert a page break.Choose Insert, Page Break from the Excel menu.
Technology

Excel Tip: 10 Quick Range Name Tricks

If you've ever used a range name in your Excel worksheet, you already know what a time saver this device is. Here are some suggested uses for range names that may speed up the time you spend on your worksheet even more. Don’t worry if you don't know how to name a range - that's covered in the first tip! Name a range in a hurry by first selecting (highlighting) the range, then clicking in the Name Box in the upper left corner of your Excel screen, and typing the name for the selected range.
Technology

Excel Tip: Share Spreadsheets on The Web

If you use Excel 2000 or later, it's relatively easy to save a workbook in HTML as a web document. In fact, Excel supports two types: static documents and interactive documents.Creating a Static Web DocumentAfter creating your workbook, use the File, Save as Web Page command. Specify what you want to save (a single worksheet or the entire workbook) and click the Save button. The result will be an HTML document and, possibly, a directory containing ancillary files; the number of such files varies with the complexity of your workbook.
Technology

Copy Page Setup Settings to Other Sheets In Your Excel Workbook

Each Excel sheet has its own print setup options (orientation, margins, headers and footers, and so on). These options are specified in the Page Setup dialog box, which you access using the File, Page Setup command. When you add a new sheet to a workbook, it contains the default page setup setting. Here's an easy way to transfer the settings from one worksheet to additional worksheets: Activate the sheet that contains the desired setup info. This is the "source" sheet. Select the "target" sheets.

Pages