Excel Data Entry Tips and Tricks : Awesome!

Here are some cool options for entering data quickly into an Excel worksheet…

When you spend a lot of time entering data in Excel it helps to understand the tools available to you to speed up data entry. Here, I’ll show you a range of Excel features which make entering repetitive data much easier.

Read More

How to Connect “External Data” source to “Import” data into Excel

The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.

Read More

How to Use the Formula Auditing Tools in Excel

Learn Excel Formula Auditing with examples to take you to the next level! It allows you to graphically display the relationship between formulas and cells. Features: Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera). The example helps you master Formula Auditing quickly and easily.

Read More

How to Download/Extract Product Details from eBay Shopping Website in Excel

Excel VBA Solution to Download/Extract Product Details from eBay Shopping Website.
Many businesses use Ebay to sell surplus inventory and many individuals and small businesses use Ebay as a marketplace to make a profit. Unfortunately, the data cannot be download into an excel readable format or pasted into excel for obtaining statistics and do some analysis. This application accesses Ebay data and populates on Excel worksheet with it. It has a simple interface to allow the user to input the ebay url for the product or results that he or she wants to download.

Read More

7 Simple Tricks to Make Smart and Neat Excel Graphs

To make sure you’re making your data as convincing as possible, you should always customize your graphs in Excel. And by customization, we’re not talking about big sweeping changes. Below are some quick tweaks you can make to your graphs convincing, easy-to-read, and beautiful.

Read More

14 Advanced Excel Tips and Tricks for Basic to Intermediate Users

Whether you’re an Excel power user or just reasonably experienced with spreadsheets, there are generally still things you can learn about Microsoft’s program, and points which can be refreshed in your memory. So, we’ve put together this compilation of 14 tips for those of you using Excel 2010, going over some important features – and making sure you’re making the most of them. Also, some of these tips cover essential Intermediate to Advanced-level skills that you should know no matter what version of Excel you use.

Read More