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 formulas for finding a particular string or text in a list or array.  In this video, you will learn how to use the MATCH function. Excel defines MATCH function as “Returns the relative position of an item in an array that matches a specified value in a specified order”. In simple plain language Match function searches for a value in a defined range and then returns its position. You will definitely love this video as it not only shows how to compare 2 lists but also demonstrate 2 ways how to handle errors when the comparison finds [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]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.