Tuesday, March 26, 2013

Now Excel is available everywhere

It is important to every business owner that their customers are able to get their Excel spreadsheets from anywhere on every device. Microsoft introduced a new feature 'Excel Interactive View' in Excel 2013 to solve this issue. Now we can say that Excel is available all over the web.

Here is the quick overview of this feature: 

When you find this Excel Button on the web, just click it and you’ll see the simple HTML table with filters, conditional formatting, sorting, and charts options. You can also download it to your desktop to open it in Excel.  You can also add this Excel Button on your website page by adding one line of HTML & a JavaScript tag to the bottom of the page to generate Excel table and chart views on your web page.

Benefits of this feature:

  • Now we can use Excel online just like we used it offiline.
  • Even MS Excel is not installed on your system; users can use analytical power of Excel on any HTML table on any web page, in most the browsers. 
  • You can filter data like if you have a huge list of top companies & you want to sort it according to your needs then it can be easily done by using Excel Interactive View. 

How it works?

When we add this button on the web site, it requires a small piece of HTML & a JavaScript tag to the bottom of the page. There are no additional resources required from the website owner to add this button to the table on their web site. The plain piece of HTML is defined that the table is sent to Excel servers in the cloud where it is parsed. After that it put into an automatically generated spreadsheet complete with a table that includes sorting and conditional formatting, the most relevant charts, and a set of filters based on the most relevant columns in the table.

How to add this button on the website: 

  • To add Excel Button on the website, you need to open this website In left pane, you will find “Add the button option”. On ExcelMashup, you can also check the demo of the Excel button. 
  • When you click on 'Add the Button' option, you will see this picture: 

  • Now choose all fields according to your need: Button Style, Title, Add Company Name.
  • Now Click on Generate Code option. This option will generate the Excel button code for your website. 
  • Now Copy and paste this code above the HTML table that you want to add the Excel Button to:

         <a href="#" name="MicrosoftExcelButton" data-xl-buttonStyle="Standard"></a>

  • Copy and paste this code (as a single line) right above the closing body tab (</body>):

        <script type="text/javascript" src=""></script>

When you click on Excel Interactive View button then the view displays on top of the web. Now you can see the options of filter the view, configure options for the view, and open the view in page, as shown in Figure:

You can also download it to your desktop to open it in Excel. You can also use this Excel button on O365 and SharePoint.
READ MORE - Now Excel is available everywhere

Tuesday, March 19, 2013

How to Open & Edit PDF file in Word 2013

One of the most advance features of Word 2013 is PDF Reflow in that you can use to convert a PDF File into a Word file & can also open & edit the PDF file content. This feature works with all PDF File versions, but the results are best for textual documents. Please take a look of this feature: 

Here is the example of PDF Reflow conversion: 

When you convert PDF file in to Word using PDF Reflow then it creates a copy of your content during the conversion process. If the results are not up to your need then your original file are still in safe hand. 

How PDF Reflow works: 

PDF is a fixed file format which includes the text, fonts, graphics, and other information needed. When you open a PDF file in Word 2013, PDF Reflow constructs a new Word document from it; you can easily your PDF file content in it. PDF Reflow used a system of complex rules to figure out what Word objects (like headings, lists, tables, etc.) would best represent the original PDF.  

To convert a PDF, open it like you would any other document.

  • Click File > Open.
  • Choose the PDF location and click Browse.
  • Find the PDF and click Open.

You can also open it by right clicking on PDF file & open with MS word 2013.

When you open PDF file in to word then it opens the content in a new file. The converted document is not just like original PDF file. For example, the pages might break in different places. 

You can make all changes according to your need, and then again save your word file as PDF file again. 

To save word file in PDF file format, use following steps: 

  • Click the File tab.
  • Click Save As.
  • In the Save As dialog box, click the arrow next to the Save as type list, and then click the file type as a PDF. 
  • In the File name box, type a name for the document.
  • Click Save.

Some of the PDF file elements are not handled as well by PDF Reflow such as: 

  • PDF bookmarks, tags & comments
  • Tables with cell spacing
  • Page colors & borders
  • Tracked changes
  • Frames
  • Footnotes that span more than one page
  • Endnotes
  • Audio, video, and PDF active elements
  • Font effects, like Glow or Shadow  

PDF Reflows is a best utility to convert PDF files into Word documents.
READ MORE - How to Open & Edit PDF file in Word 2013
Related Posts Plugin for WordPress, Blogger...