MS Excel

  • Using AutoCorrect to Speed up Data Entry in Excel 2013

    Microsoft Office's AutoCorrect feature enables you to add custom entries manually. You can capitalize on the option for customization by reducing complicated, frequently entered text to just a few letters, which could dramatically speed up data entry...
    By C. Taylor December 22, 2015 

  • Sorting by Custom Lists in Excel 2013

    Excel 2013 supports multi-tiered sorting rules to arrange data as you prefer, but the default sorting rules only provide alphabetical or reverse-alphabetical ordering. A convenient workaround is to specify sort order using custom lists that give you exact...
    By C. Taylor December 3, 2015 

  • Adding Data Bars to Cells in Excel 2013

    Excel 2013’s Conditional Formatting tool offers, among other things, graphical elements that are directly linked to data within cells. One such visual tool is Data Bars that effectively creates a bar chart within a group of selected cells.
    By C. Taylor December 3, 2015 

  • Sorting an Excel 2013 Table on Fill or Text Color

    Colors are often overlooked as sorting criteria. Learn how to make sorting in Excel even easier using text or fill colors as criteria.
    By C. Taylor November 13, 2015 

  • Customizing Lists in Excel 2013

    Custom lists can save loads of time when entering a handful of items repeatedly into cells in an Excel worksheet. Learn how to create your own custom lists quickly and easily.
    By C. Taylor October 19, 2015 

  • How to Perform a Mail Merge Using Data from Excel 2013

    Word 2013 mail merges can be a lifesaver when you need to send out form letters or create mailing labels. This article will show you how easy it is to get your mail merge data from Excel.
    By Ryan Tetzlaff September 16, 2014 

  • How to Combine Excel Files

    Although Excel 2013 comes with the excellent and powerful Spreadsheet Compare tool, it’s not very helpful when it comes to actually combining or merging Excel files. This article will look at the best way to combine multiple Excel 2013 files.
    By Ryan Tetzlaff August 25, 2014 

  • How to Calculate Weighted Averages in Excel 2013

    Excel makes it easy to find the average for a set of numbers, but what if some values are more important or carry more weight than other values? That’s where weighted averages come in. Let’s cover how to find the weighted average for a...
    By Ryan Tetzlaff August 22, 2014 

  • How to Make a Line Graph in Excel

    Making a line graph in Excel is very easy – especially in Excel 2013. This guide will walk you through creating and customizing line charts for impressive results.
    By Ryan Tetzlaff August 21, 2014 

  • How to Make a Bar Graph in Excel 2013

    Excel 2013 makes it even easier than ever to create a great looking bar graph. This article will walk you through the steps of creating a bar graph from start to finish.
    By Ryan Tetzlaff August 18, 2014 
showing 11-20 of 274    < Previous  |  page: 1 2 3 4 5 ...  |  Next >