MS Excel

  • How to Convert Between PDF and Excel Formats

    Excel makes it easy to convert your spreadsheets to PDF but what about converting back from PDF to Excel? With Office 2013 you can now do this without too much hassle. Read on to find out how!
    By Ryan Tetzlaff July 22, 2014 

  • How to Use the Spreadsheet Compare Tool

    Microsoft Office Professional Plus 2013 includes a new utility that makes it easy to compare two separate Excel worksheets. This article will walk you through the simple process of using the Spreadsheet Compare tool.
    By Ryan Tetzlaff March 27, 2014 

  • Creating and Using QR Codes in Word and Excel

    This article will show you how easy it is to create and add QR codes in Word and Excel 2013 using a variety of applications.
    By Ryan Tetzlaff March 10, 2014 


  • Excel Power Query and Power Map Preview

    Excel Power Query and Power Map are new tools that are part of the Power BI suite available in Excel 2013 Professional Plus and Office 365 ProPlus. This article will cover the basics of each tool and give you a brief sample to show you what they can do...
    By Ryan Tetzlaff November 5, 2013 

  • Excel 2013: An Overview of Power Pivot

    Power Pivot is a free add-in for Excel that allows you to import and manipulate huge sets of data from multiple sources. The Pivot charts you create can be dynamically altered to provide users the ability to view data sets that they care about.
    By Ryan Tetzlaff October 31, 2013 

  • Excel 2013: Overview of Power View

    Excel Power View allows you to create interactive charts that give users the ability to create ad-hoc reporting based on the set of data they wish to visualize. The ad-hoc reports can be easily manipulated by anyone with access to Excel.
    By Ryan Tetzlaff October 29, 2013 


  • Using Sparklines in Excel 2013

    Sparklines were introduced in Excel 2010 and are back in Excel 2013. This simple chart lets you visualize a series of values right next to the values themselves to give viewers of your spreadsheet a quick glance of your data.
    By Ryan Tetzlaff October 25, 2013 

  • Using the Developer Tab in Excel 2013

    The Developer Tab in Excel allows power users to utilize automation functions such as macros and allows you to develop applications using forms and controls within Excel. This guide will show you how to enable the Developer tab in Excel and will go over...
    By Ryan Tetzlaff October 22, 2013 

  • Building a Boxplot in Excel 2013

    Boxplots are handy charts for visualizing sets of data along with statistical facts related to that data such as median and percentile ranges. Although there is no boxplot chart available in Excel 2013, this article will show you the relatively easy way...
    By Ryan Tetzlaff October 17, 2013 

  • So You Think You Can Use Microsoft Excel? A General Knowledge Quiz

    Are you a newbie to Microsoft Excel? Can you whip a simple spreadsheet together without using help files? Sharpen your thinking cap and test your knowledge with this quick quiz.
    By Sheila Robinson October 14, 2011 
showing 21-30 of 274    < Previous  |  page: 1 2 3 4 5 ...  |  Next >