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]
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]
Click here to Download the spreadsheet used in this presentation Create an Excel Chart Budget vs Actuals chart using the clear instructions in this video the Queen of Excel Charts Mynda Tracey. The video is divided into two parts – the first showing how to create a Excel Chart Budget vs Actuals chart in Excel 2007/2010 and the second part (starting at around 8 mins) shows how to create the same graph in Excel 2013. The video shows some cool tricks along the way to creating the Excel Chart Budget vs Actuals chart – Including how to cut and paste [More]
This video shows you how you can have more than one type of chart type on a single chart (often called a combination chart).  In the video an example is used to show how to have one data set shown as a bar chart and one set of data as a line chart.  Pretty cool! The trick is to use the second scale option on the graph using the format data series options. The video gives a clear and easy to follow example – which we can probably related to. This video is taken from the missing manual books. If [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]
In this video we look at creating a DO LOOP in Excel VBA.  The DO LOOP arrangement allows the section of code between the DO command and the LOOP command to be repeated until a specified condition is true.  As the majority of VBA code you write will repeat a process for several lines of data getting to grips with this command will help you write clearer code. The example in this video is easy to follow and easy to replicate for yourself – so once you have watched the video have a go at getting it to work for [More]
This video contains everything you need to know to have confidence with Excel Dates.  if  you sometimes find dates turn into long numbers or you have never tried to find the the difference between two sets of dates then this video is for you. The video initially talks about how Excel handles Dates internally and why it stores them as numbers.  It then goes on to tell you how to write equations to find the difference between two dates. On the way it also introduces you the ### problem in Excel and the shortcut key for entering today’s date into [More]
This video introduces you to how to write code to work with sheets in VBA and shows you a few tricks with renaming, selecting and hiding sheets. Make sure you stay on the video until about 3.30 mins in as the video introduces you to the veryhidden property of a sheet.  I use this property a lot as it stops people unhiding them in the Excel interface. The video finishes by showing you how to select sheets with VBA. I hope you enjoy this video on Working with sheets in VBA – if you have found it useful or have any questions [More]
This video introduces you to the OFFSET command in Excel.  99% of people have not heard of the OFFSET command and the other 1% are often left wondering what you can do with such an odd function. Smart tables and graphs are the OFFSET command best uses and this video shows an excellent use of the command linked to a scroll bar on the spreadsheet.  We have tagged this video as advanced as there are some concepts in here that may confuse beginners but I would recommend you go ahead and watch just to get an idea of what Excel [More]
This video shows you how to use the COUNTIF function in Excel. This functions is very useful when trying to work out how many values fall into a particular category. The example uses a list or people’s names and then adds an equation to find out how many people have paid their bill and how many people are still to pay. COUNTIF is very useful if you are looking to make a spreadsheet that works for every user that uses it, however if you are look for simple counting functions then you need to check our pivot tables as these [More]
This video is a brief tutorial on how to use the vlookup() function in Microsoft Excel. It uses Excel 2007 in this video but everything he talks about will work with Excel 2003 and Excel 2007 and 2010. The tutorial is designed for beginners and works at a nice slow pace.
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.