If you have a number of Excel workbooks saved on your computer and need to open up a specific workbook, say a workbook containing sales data for the last three years, would you be able to select exactly the right document the first time around? To make it easier for you to select … [Read more...] about How to Save Thumbnail Preview of Excel Workbooks
excel how to
How to Create a Watermark in Word, Excel, PowerPoint and Outlook
Want to add some watermark to your documents to personalize it? Here is a step-by-step guide that shows you how to create a watermark in Word, Excel, PowerPoint and Outlook. The activity was performed on Office 2013 but should work on 2010 and 2016 versions as well. How to … [Read more...] about How to Create a Watermark in Word, Excel, PowerPoint and Outlook
How to Create a Table of Contents in Excel and Word 2010
Often, when you work with Excel, you tend to use a number of worksheets so that data related to a particular project stays in one workbook. Soon, you find yourself having ten to fifteen worksheets and struggling to find data from among those several sheets. One quick way to solve … [Read more...] about How to Create a Table of Contents in Excel and Word 2010
How to Extract a Unique List of Entries in Excel 2010
When working with Excel, your data may have columns with repeated values or entries. There may be times when you want to view or extract only the unique values in the column. Although you can use the Filter command to check the unique entries, you may want to want to generate a … [Read more...] about How to Extract a Unique List of Entries in Excel 2010
How to Add Page Numbers to an Excel Worksheet
There may be times when you want to print out an Excel worksheet containing a large volume of data. When you take a print, the worksheet will print out as several pages. To ensure that you don’t lose track of the sequential order of the pages, it is better to have page numbers … [Read more...] about How to Add Page Numbers to an Excel Worksheet
How to Collate Amazon RSS Feeds to Excel 2010
If you are an Amazon affiliate, you may be using a widget or program to collate your Amazon RSS feeds and incorporate them into your advertising campaigns such as blog posts or tweets. In this post, I’ll show you how to collate Amazon RSS feeds into Excel, so that you can stay on … [Read more...] about How to Collate Amazon RSS Feeds to Excel 2010
How to Extract Comments in an Excel Sheet
Comment boxes are great when you want to share additional information about Excel data. You can view all comments on a worksheet or just specific comments you want to see. However, there may be times when you need to consolidate the comments in an Excel worksheet. … [Read more...] about How to Extract Comments in an Excel Sheet