The ‘Microsoft Excel’ Archives
Posted March 13, 2015 by

Analytics with the Excel Analysis Toolpack

analytics with excel

Many people talk about “Big Data” and analytics, yet few understand what it means. The term analytics basically refers to the application of math and statistics to data sets, and it is certainly not a new idea. However, certain aspects of it have changed over the past five years because of databases like Hadoop that make […]

Category Microsoft Excel

Posted February 9, 2015 by

How to Write a Custom Function in Microsoft Excel

how to create custom excel function

Microsoft products have always included Visual Basic. You can use it in Microsoft Word, Access, and Excel. One reason this is true is that Bill Gates and some of his friends wrote Visual Basic while Gates was still at Harvard.  Thus, he felt proud of his accomplishment and wanted to keep it. Gates wrote the floating […]

Category Microsoft Excel

Posted December 18, 2014 by

Excel 2013: Convert European Numbers to American

sshot-4

If you work in more than one language with Excel, then you know that there are often issues converting numbers from French, Spanish, or other Romance languages to American or British English.  The reason for this is that the number $1,000.25 USD is written as $1.000,25 in Romance languages with the decimal and comma switched. […]

Category Microsoft Excel

Posted December 16, 2014 by

Microsoft Excel: Convert Dates from European to US Format

sshot-4

If you work in more than one language with Excel, then you probably have noticed that you have problems converting dates from the European format (dd/mm/yyyy) to the American English format (mm/dd/yyyy). In fact, in most countries outside the US, the date is written as dd/mm/yyyy. (i.e., The day is first, the month is next, […]

Category Microsoft Excel

Posted December 10, 2014 by

How to Recover a Different File Version on Microsoft OneDrive

sshot-2

For many reasons, you might find you need to recover an older version of a Word document, spreadsheet, or document created online. If you find that a hacker has locked your file using a virus or if you have accidently deleted important sections of your document, knowing how to locate a previous version of a […]

Posted July 1, 2014 by

Microsoft Excel: Create a Hyperlink to Another Worksheet or Excel Sheet

Creating hyperlinks within a Microsoft Excel sheet helps you to navigate quickly to another worksheet or to another Excel sheet. By creating hyperlinks on the main page, you can keep a list of other worksheets and easily navigate through it. This definitely helps save time if you have several worksheets under an Excel sheet.

Posted May 14, 2014 by

A Beginner’s Guide to Flash Fill in Microsoft Excel 2013

flash fill in excel featured

Some of the most time consuming and irritating aspects of Excel are working with repetitive information. This included writing formulas, formatting, separating dates, and entering names and email addresses manually. Fortunately, the Flash Fill feature introduced with Microsoft Excel’s 2013 edition makes these tasks easier with brilliant automatic filling.

Category Microsoft Excel

Posted December 3, 2013 by

Office: Display Data Labels in a Pie Chart

powerpoint add labels

When you insert a pie chart in an Office program, you may notice that the data labels are missing from the chart. The missing data makes it tricky to identify which slice of the chart has the biggest proportion. Luckily, it is possible to show the data labels on the chart. This will work in […]

Posted November 29, 2013 by

Microsoft Excel: Splitting One Cell Row into Multiple Rows

_-Microsoft-Excel--Splitting-One-Cell-Row-into-Multiple-Rows

With Excel, you can split one cell into multiple rows or a comma delimited cell into multiple rows. This tutorial explains how.

Category Microsoft Excel

Posted November 13, 2013 by

Excel: Use Synchronous Scrolling and Split Multiple Column/Rows in Vertical/Horizontal View

split2window

When you have a large collection of data in an Excel spreadsheet, you may find you need a simple method for manipulating the data or for comparing the data to that of another spreadsheet. Fortunately, Excel includes some powerful features that, when used in combination, will save time and make your job easier.

Category Microsoft Excel