Posts

Showing posts with the label excel 2013

Top Excel 2013 Free & Featured Apps

Image
An App is the combination of an XML manifest file and a webpage as you can clearly check in below picture:  App for Office= App Manifest + Webpage   Excel Apps is one of the best & most exciting feature of version 2013. These Apps allow you to  add more additional functionality to your documents that provides more unified web-based extensibility platform for Excel.  Microsoft added many different free & featured apps for Excel 2013 which you can easily download from Microsoft Store. You can use these apps in all Office 2013 and Office 365 versions like Home Premium and Small Business Premium. There are two types of apps available for Excel: Content apps and Task pane apps.  Content Apps:   Content apps allow you to extend apps with custom content. These apps are embedded inside your worksheet and saved with it.  Task Pane Apps: We can use Task Pane Apps side-by-side with an Office document. While you are working in these a...

Excel 2013 Quick Analysis Feature

Image
Microsoft introduced a new feature in Excel 2013 to organize and analyze data easily named as Quick Analysis. This feature includes five options such as formatting, total, Sparklines, tables, and charts. With the help of these options, you can apply formatting to data and convert that data into the form of charts or PivotTables etc. As the name itself indicates, it performs all these tasks quickly and with a minimal number of steps.  All Quick Analysis features are dynamic, it means when you select the range of data, all these options will appear on the type of data, you’ve selected. Here is small look of Quick Analysis Feature: How to use Quick Analysis Feature: First select the data as much you want & you will see Quick Analysis option at lower-right corner of your data set or You can also use shortcut the Ctrl + Q to open Quick Analysis Feature: When you click on this option then you will see the following options for converting your data as below: ...

Now Excel is available everywhere

Image
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...

MS Office 2013 Overview

Image
Hi!! Welcome to MS Office 2013    Let's Start with  Word 2013 Starting Screen: This is the starting screen of MS Word 2013: Have you notice some changes in the starting page? Yes!! Left-hand pane shows recent documents. Now let's take a look of right area of starting screen. First of all a blank document and a Ribbon user interface has a new Design tab, from where you can change all your design changes in one place. More options include fonts, paragraph spacing, themes, and adding watermarks to documents etc... Here is the list of changes : In new Read Mode, you will see that text reflows automatically in columns for easier on-screen reading. There are Fewer menus available which means more focus on your content You can also open a PDF in Word, and also can edit content. You can also add Online Videos Show your style by using Word templates in more than 40 categories Now it's time for Excel  Excel 2013 Starting Scre...