One of the common tasks we perform when working with large Excel worksheets is filtering data in alternate rows. This may be for the purpose of further analysis, or we may just want to delete such data. Whatever the reason, there’s no simple auto filter option that lets you … [Read more...] about How to Filter Alternate Rows in Excel
excel
Quick Ways to Compare Data in Excel
One of the common things we do when working with Excel data is comparing two strings of text. There are several ways to do this, and in this post, I'll share some quick ways to compare data in Excel. These are ones that I frequently use and hope you find use for them in your … [Read more...] about Quick Ways to Compare Data in Excel
How to Insert Page Numbers in Multiple Worksheets in Excel 2010
There may be instances where you have more than a couple of worksheets in Your Excel 2010 workbook and you might want to number the worksheets in a single go rather than have to do it individually for each worksheet. This is possible by using the grouping feature, which lets you … [Read more...] about How to Insert Page Numbers in Multiple Worksheets in Excel 2010
Download these Excel Calendars for 2012 from Microsoft Office
Hot on the heels of the release of 2012 calendars for Word 2010, the Microsoft Excel team has released a set of Excel Calendars for 2012 that are free for download. These set of free Excel Calendars for 2012 features business calendars, family calendars, student calendars, and a … [Read more...] about Download these Excel Calendars for 2012 from Microsoft Office
How to Insert a Bullet List in Excel Cells
Have you ever had the need to insert a bullet list in an Excel cell? You may want to do that when you want to show a bunch of items having one set of attributes. You can insert a basic bullet point or other characters to add a bit of variety to the bullets. Let's get started … [Read more...] about How to Insert a Bullet List in Excel Cells
How to Create a Drop Down List in Excel 2010
If you are preparing an Excel form that requires users to input data from certain specified options, you will need to create a drop-down list to choose from. Excel 2010 has a feature called Data Validation that lets you create a drop-down list with ease. While it is not too … [Read more...] about How to Create a Drop Down List in Excel 2010
How to Navigate to Any Worksheet Quickly in Excel 2010
When you create several worksheets in Excel, all the worksheets names are not displayed on the worksheet tab. This may make navigation to a worksheet that’s not visible a little bit annoying. You will have to use keyboard shortcuts such as the Ctrl+Page Up, Ctrl+ Page Down or the … [Read more...] about How to Navigate to Any Worksheet Quickly in Excel 2010
Microsoft Excel Web App Gets New Features and Updates
Windows Live SkyDrive is a useful platform for a number of reasons. You can store, send, and share your documents, photos, and videos with others. What works great for me is the fact that I can upload and share Microsoft Office documents with users who don't have Microsoft … [Read more...] about Microsoft Excel Web App Gets New Features and Updates