Posts under Excel tag.

pull stock quotes in to excel easily

How to get Stock Quotes in Excel

Most of us use Microsoft Excel in our daily life in many ways. We use it to keep track of tasks to be completed using color coding and people dealing with business, use it to keep track of products brought and […]

Enable the developer tab

How to create Custom Excel Functions

Microsoft Excel Pack comes with the many pre defined functions which does the maximum job for us. We never need any more functions other than those built-in functions in most of the cases. But, what if you are in need […]

Excel Name Box

Make the best use of Name Box in Excel

Many of us make use of Microsoft Excel to calculate budget or to do some additions and subtractions. We also know that it supports Macros which helps us to automate our tasks. An Excel sheet is no stranger to us […]

Perform calculations with Range Calculations App for Excel 2013

Microsoft Office runs an online store dedicated to providing extensions for Office apps like SharePoint, Word, Powerpoint and more. These apps help you either personalize your documents or speed up the work in progress. For instance, with an app you […]

3 Methods to Hide Gridlines in Excel

In this port we will see how to hide the Gridlines in Microsoft Excel. The horizontal and vertical faint lines that represent the boundaries and are used to distinguish cells on the worksheet are called ‘Gridlines’. By default, gridlines are […]

Hide Formula in Microsoft Excel sheets

Using the formula in Excel can make your day-to-day tasks easier. Excel has formulas for almost all the operations. Having said that don’t you it is desirable to hide formulae if you are sharing your Excel spreadsheet with your colleagues […]

Add Windows Calculator to Excel Quick Access Toolbar

At times, while working on an Excel sheet we run into a situation where we require the use of Windows calculator to perform quick calculations. The calculations do not necessarily require a special formula, but simple arithmetic operation. The need […]

Learn Excel 2013 faster with Excel Video Tutorials App

Let’s say you are organizing your data in the new Excel 2013 and get stuck with a tricky function or feature. Normally you would waste your time searching on Google for an apt answer which could satisfy your Excel query, […]

Microsoft Data Explorer for Office Excel

Microsoft, some days ago released an add-in for Microsoft Excel called Data Explorer. The free add-in has been designed with the sole purpose for reducing your efforts in searching, shaping and preparing data. You might agree, getting your important personal/official […]

Oscars Ballot Predictor app for Excel 2013

David Rothschild of Microsoft Research has created Oscars Ballot Predictor for Excel 2013. We already saw how he created and used a versatile, data-driven model to predict the winners of the Oscar Awards this year. Based on the prediction modeling from […]

How to use the, now available, Excel Survey feature on SkyDrive

Earlier we had seen how SkyDrive had introduced the Recycle Bin feature and how Microsoft had then said that the Excel Survey Feature would soon be made available too. And today, Microsoft announced the availability of Excel Surveys on SkyDrive. The Excel survey […]

Microsoft Advertising Intelligence Keyword Research Tool updated to v8

Microsoft has released an updated version of the Microsoft Advertising Intelligence Excel add-on. This add-on is a useful tool for keyword research and optimization. The tool, earlier called adCenter Add-in for Excel, has taken a jump straight from version  5.6 to version […]

Excel Mixer Nano: Adjust Values of Excel Cells with Sliders

Any person who maintains and audits business accounts has to deal with Excel files now and then. These files help in maintaining data sheet, making corresponding pie charts, bar graphs and much more. Although a software with great functionality, Microsoft […]