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 Power Query is free and can be installed for Excel 2013 or Excel 2010. It is the golden nugget of hidden Excel features, so hidden in fact that many people have never even seen it. This video is created by Mynda Treacy, Microsoft Excel MVP, who in my opinion is the Queen of Excel Dashboards. In it she shows just two of the uses of this very powerful tool and shows you the complete power of reusing power query functions. Power Queries are like VBA but easy to create and just a powerful when working with datasets. Mynda is [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]
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]
It is vital that you get to grips with Excel Named Ranges if you are to Improve Your Excel Skills. This video is an original Improve Your Excel video and shows 3 great ways to use Excel Named Ranges. It starts by looking at naming cells and using them in equations. Then it looks at naming a group of cells and finally it looks at one of the secrets of Excel named ranges and how to use them with with Data Validation drop down list. This video was recorded a few years ago – but everything shown works with Excel [More]
Excel Pivot tables are in our opinion the best and most powerful way to analyse data in Excel and so watching this video is a must for everyone who has lists of data to look at and try to summarise. In this Video you will learn:- Pivot Tables Basics Group By Date Format Fields Format Pivot Table Pivot the table Page Filter Report Filter We hope you enjoy the enthusiasm of the presenter we have selected here. If you have learnt something from this video then please share it or like it using the buttons above or leave us a [More]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.