The ‘Microsoft Excel’ Archives
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


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


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

Posted October 4, 2013 by

Office 2013: Place Favorite Commands on a Custom Tab on the Ribbon


When using an Office program, a user may need to switch between many tabs to access their favorite commands. To be more productive and stop wasting time looking for the location of the commands, you can create your own custom tabs, and place all your desired commands there for quicker access.

Posted May 31, 2013 by

Microsoft Excel: Count the Number of Occurrences of a Text or Number

Excel count the number of occurrence excel sheet last name

If you wish to determine how many times a text or number has been repeated within a range or an entire workbook of Excel, this tech-recipe will guide you through the steps with examples.

Category Microsoft Excel

Posted February 3, 2013 by

Excel 2013: Create Sparklines to Visualize Trends


Inserting sparklines next to your data set provides a simple way of viewing a trend for a set of data points. Sparklines are tiny, free-flowing graphs with no axis or labels.

Category Microsoft Excel

Posted January 24, 2013 by

Office 2013: See Amount of Time Spent Editing a Document, Spreadsheet, or Presentation


Two methods exist for determining how much time has been spent editing your file in Excel, Word, or PointPoint.

Posted January 16, 2013 by

PowerPoint, Excel, and Word 2013: Add Effects to Images

step (3)

The reason many documents and presentations are not interesting is because of the use of boring images. Even if your images are extremely mundane, you can still attract attention to them by carefully adding effects.

Posted January 12, 2013 by

Office 2013: Force Excel, Word, or Powerpoint to Save in Older Formats

Step (3)

Sometimes, when you send a document, presentation, or spreadsheet, users with prior Office versions can often have problems opening and viewing it. These issues can be resolved by saving the file in an older format.

Posted January 4, 2013 by

Excel 2013: Convert Columns to Rows


Did you create a spreadsheet and realize that you got the layout mixed up? Did you receive a table or a chart through your email, but you need to reformat it? Excel’s Transpose option will allow you to fix your charts easily.

Category Microsoft Excel

Posted December 31, 2012 by

Excel 2013: Find Duplicate Data Using Conditional Formatting


Finding duplicate data within an Excel worksheet is a difficult task to attempt to do manually. Conditional formatting techniques can highlight this duplicated data to facilitate easier removal.

Category Microsoft Excel

Posted December 26, 2012 by

Excel 2013: Create Progress Bars


Using Excel 2013’s conditional formatting features, you can create progress bars on your spreadsheets. Progress bars are used to graphically represent the advancement of the data. Essentially, you get a chart-like effect within the rows and cells themselves.

Category Microsoft Excel