If you import data into Excel then you will have probably used Excel’s CSV import routines and have no doubt got frustrated that Excel’s default is to see all the number columns as numbers and format them accordingly. Sounds like a reasonable idea but if you are importing data where a zero at the front is important then it is not sure a great idea. Take for example Zip Codes. 07047 is different to 7047 and that leading zero is important. Excel CSV import routine is explained in this video and the all important step where most of us click [More]
You can bring data from an excel workbook to an access database in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into a new or existing table, or link to a worksheet from an Access database. If you want to work with data in Access but still maintain the data in Excel, you need to link the data. This process is a bit shorter and this video shows you how. The advantage is that it maintains a live link to the Excel worksheet. Any changes you made in [More]
There are times when you show something in Excel and their reaction is simply stunned silence. Last week I had one of those moments when I found a video on YouTube that showed a very powerful mapping application INSIDE EXCEL! Excel Power Map is a new tool for Excel that has been released for Excel 2013 and Excel 2010. I understand that it is going to be included as part of the main program in Excel 2016. Part of my day job involves visiting customers and leads. One of my biggest problems until today has been trying to combining visits [More]
Excel provides many ways to count cells in a range that meet various criteria. This short video shows 7 ways to count in excel. It uses the functions COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. You can see at 00:50 of this video how to use the COUNT function. This function simply count cells in a range that contain number. Also, in 4:51 of the video, the count function was used in a filtered list/range. COUNTA counts all non-empty cells while COUNTBLANK counts the number of empty cells. COUNTIF was used in this video to count cells that contain a specific [More]
If you have to type the same data into cells all the time and want to make your data entry easier, then adding a dropdown list to your spreadsheet could be the answer. This video will help you to learn how to do it. Dropdown lists are very helpful.  They are used to enter data from a pre-defined list and it limits data entry to specific set of items.  Dropdowns also improves the efficiency of your data entry as it prevents spelling mistakes and makes data input faster. Fortunately, it’s easy to implement. You need only two things: a list and [More]
Pivot tables is the most powerful feature in Excel.  But what do you do if your data has already been turned into a Pivot table when you get it?  The Answer? use Unpivot – the most hidden feature in Excel! I am really impressed that excel can convert a number of hours of work into seconds thru the use of Unpivot. Unpivot is a feature included in Power Query Excel add in.  Power Query Excel add-in lets you discover, combine and refine data.  And since this is an add-in feature, you may need to enable to use this. Or you [More]
The Excel Goal Seeking options allow you to play with your data and find out how your parameters need to change to make the result you need. There are two ways to do this in Excel, one is trial and error (this is the most popular way – and the least productive) and the other is to use the Goal Seeking options in Excel. Many users do not even know that this feature exists in excel. The file used in this video can be downloaded from here This video is one of Clayton Lock’s 47 videos – to find out [More]
Pivot tables are one of the most powerful and most underused features in Excel. The interface has been reworked in Excel 2007/2010 and this video show how to create a Pivot table in Excel 2010. What you will see in this video is that pivot tables are quick and easy to do and use no Excel equations at all. I added this video on the because it is only 5 minutes long and it shows two really cool features of pivot tables – the first is that it groups date data by day month year automatically and the second is [More]
This video clearly explains how to use two very simple Excel features to produce a very powerful technique.  Using the autofilter and status bar is a trick not to be missed and although this video demos the feature in Excel 2003 it works even better in Excel 2007 as the status bar allows you to have multiple statistics visible at the same time. You can download the file used in this video by clicking on this link This is an original Improve Your Excel video and we hope you have enjoyed it.  You can download all 47 of the original video series [More]
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.