Embed Excel into Word

Embed Excel into Word

we need to know how to Embed Excel sheet into Word documents in case you have to create reports for presentations and want to include an Excel sheet for reference. It’s no trouble at all simply to embed the excel file directly in your Microsoft Word documents and how you do it.

Excel chart show in Word File

1. Select the tables or cells in the Excel sheet which you want to embed in your Word document file and copy it to the clipboard by pressing Ctrl+C.

2. Now go to your Word document and click the cursor where you want the chart to be placed, go to the Paste button in your toolbar and click Paste Special.

3. When you select paste special then open dialogue box select the Microsoft Excel Worksheet Object as the method of pasting.

4. then Ensure that the  radio button is selected and click OK to insert the linked chart into your  excel document embed excel sheet (Paste Link means that when the original changes, the destination cell automatically changes as well, so it’s easier to update worksheets.)

Use Ctrl Easily Navigatecells

 Use Ctrl  Easily Navigate cells

         When you're debugging a worksheet, you can easily navigate through all the cells referenced in a formula.

• Highlight the cell and press Ctrl-[ (that's Ctrl-open-square-bracket). 
• Excel highlights all the cells referenced by the formula, and moves the current selection to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell
• Continue to press Enter to move though the rest of the referenc
  ed cells.

Recovery for Excel

Recovery for Excel

Data recovery software Download free

   Excel For Recovery 

 Download

Recovery for Excel software Description

Excel Recovery is designed for effective data recovery from corrupted Microsoft Excel spreadsheets. Using Recovery for Excel allows to avoid the loss of important information. Nowadays Microsoft Excel textual processor is the most widespread tool for creation any types of spreadsheets, including corporate spreadsheets.

Office Recovery Fix and Recover Excel Files

At first a very main point is to define whether your xls, xlsx or xla file is corrupted. A excel file is corrupted when it has changeability that make it not possible to open it with Microsoft Excel. If while trying to open your xls, xlsx or xla file you got an error message or the application not working or the file could open as a mix of random characters, all these are typical symptom of your excel file corruption.

Recovery for Excel repairs corrupted Excel spreadsheets (.xls, .xla, .xlsx).

Supported Excel versions: 
2010, 2007, 2003, 2002, 2000, 97, 95 and 5.0

Attention: make backup copies of corrupted file(s) before recovery

Click Recover to start

Excel for Recovery  repairs corrupted Excel spreadsheets (.xls, .xla, .xlsx).

Supported Excel versions: 
2010, 2007, 2003, 2002, 2000, 97, 95 and 5.0

The recovered data is saved into a new Excel spreadsheet.

Features

New in Recovery for Excel 6.0:

·                                 New user interface featuring multiple files recovery, folders recovery, recently opened files recovery

·                                 Chartsheets recovered for Excel 2007 and 2010

Standard features:

·                                 Supports all modern file versions, including Excel 2010, 2007, 2003, 2002, Excel 2000, Excel 97, Excel 95 and Excel 5.0

·                                 Fixes text, numbers and formulas

·                                 Fixes filter settings

·                                 Fixes conditional formatting

·                                 Fixes merged cells

·                                 Fixes comments

·                                 Fixes frozen rows and columns

·                                 Fixes embedded images

·                                 Fixes conditional formatting

·                                 Fixes filter settings

·                                 Fixes structure of multi-sheet files

·                                 Fixes sheet names

·                                 Fixes password-protected files if the password is known

·                                 Fixes charts, both embedded into data sheet and placed as separate page

·                                 Fixes images

·                                 Fixes hyperlinks

·                                 Fixes filters

·                                 Fixes formulas with external links to other pages, workbooks and files

·                                 Supports Microsoft Excel 2007 formulas, including shared formulas

·                                 Supports Microsoft Excel 2007 password protected files

·                                 Full support for .xlsx as the output file format

·                                 Supports Far East codepages

·                                 Easy to use, no special user skills required

·                                 Full install/uninstall support

Limitations

·                                 Recovery for Excel fixes every feature of the original spreadsheet that can be useful; Microsoft Excel will possibly filter out the unnecessary items.

·                                 Does not recover Visual Basic modules, drawings

·                                 Does not recover cells' names

System Requirements

·                                 Operating system: Windows 2000, XP, Vista, 7, 2003 Server or 2008 Server. Windows 95, 98, ME are not supported.

·                                 RAM: 256-1024 MB (depends on spreadsheet size and corruption range)

·                                 Hard Disk: minimum 10 MB of free space required for installation

·                                 Display: 640 x 480 or higher resolution, 256 colors

Recovery for Excel scans, analyzes the corrupted file and exports all available data from the file. If the spreadsheet is strongly damaged, some data loss is inevitable. All restored data is saved into a new xls or xlsx spreadsheet. After the recovery the spreadsheet becomes available for processing.Recovery for Excel repairs text, numbers and formulas, merged cells, comments, frozen rows and columns, embedded images, filter settings, sheet names, images, hyperlinks and so on.

The important fact is that the program only analyzes the damaged file and does not change the original data.Recovery Excel Tools works with text files of various formats: Microsoft Excel spreadsheets of different versions (.xls, .xlsx and .xla files).

What if no data to recover detected in your damaged excel file? You can order a file review by our technical team. In some cases it is possible to retrieve data only manually.

Using Recovery for Excel

1         1.Backup the corrupted spreadsheet(s) before proceeding with any recovery activities. Use reliable non-local media such as CD or network drive to store backups.

2.                              Start Recovery for Excel

3.                              Select the Recover item in the File menu A file selection dialog will open.

4.                              Select the spreadsheet corrupted and press "Recover" button.

5.                              Wait until the file processing is completed.

6.                              When prompted, save the recovered spreadsheet, assigning it a new name. By default, Recovery for Excel adds "Recovered" to the file name, i.e. Corrupted spreadsheet.XLS will be saved as "Recovered Corrupted spreadsheet.XLS"

Columns, rows, and cells

Columns, rows, and cells

Worksheets are divided into “columns” “rows” and “cells”.

That’s the grid you see when you open up a workbook.

Columns, rows, and cells

1. “Columns” go from top to bottom on the worksheet, vertically. Each “column” has an alphabetical heading at the top.
2. “Rows” go across the worksheet, horizontally. Each row also has a heading. “Row “headings are numbers, from 1 through 1,048,576.

The alphabetical headings on the columns and the numerical headings on the rows tell you where you are in a “worksheet” when you click a “cell”.

The headings combine to form the cell address. For example, the cell at the intersection of column A and row 3 is called “cell” A3. This is also called the cell reference.

Workbooks and worksheets

Workbooks and worksheets

When you start Excel, you open a file that’s called a "workbook".

Each new workbook comes with three "worksheets" into which you enter data.

Shown here is a blank worksheet in a new workbook

1. The first "workbook" you’ll open is called Book1. This title appears in the bar at the top of the window until you save the workbook with your own title.

2. Sheet tabs appear at the bottom of the window. It’s a good plan to rename the "sheet" tabs to make the information on each sheet easier to identify. 

Calculate Age MSExcel

 Calculate Age with Excel

calculate age on MSExcel for a many applications by combining an undocumented function and the date format for cells. Microsoft Excel inside stores dates as serial numbers, which is the number of days a date is from Jan. 1, 1900. Please remember  as you set up your age calculation formula in MsExcel.

1-Open New Workbook Excel save with the name of calculate Age.

2- calculation by creating labels in the row of cells from A1 over to C1.

·                   

          Cell A1 should include a label pertaining to the opening date or start date. This may be the date an invoice was created or the birthday of a person.

     Cell B1 should include the label, "Today."

            Cell C1 should be labeled "Age."

3- Enter the variables for your age calculation in cells A2 and B2.

The invoice or birth date should be mention in cell A2.

          In cell B2, create the "Now" function by typing "=Now()" without the quotation marks. Press the "Enter" key to complete the entry.

·                                 If you like  more than one  person for which you want to know calculating age in days or years, you may b  mention  those variables in the rows down.

4-use the  "DATEDIF" function in cell .

Enter the Formula in the cell.

Type "=DATEDIF(" in the Formula Bar, without the quotation marks, and then click cell A2. =DATEDIF(birthday date cell,today date cell,"y")  example for year =DATEDIF(A2,B2,"y") and for month  =DATEDIF(A2,B2,"M") and for days =DATEDIF(A2,B2,"D")

      Click the cell B2 and press the comma key again.

          Enter the definition of your date interval, this time with quotation marks, and then press the "close parenthesis" key, ")".

5-Copy the formula in cell C2 and paste it into the cells in the C column for any other entries you have made.

         The formula will retain "relative references" to the cells in the A and B columns and will preserve the date interval definition from the original formula.

Goals

Goals

•Create a new workbook.

•Enter text and numbers.

•Edit text and numbers.

•Insert and delete columns and rows.