AM 4217 Database functions Dsum Dmax Dmin Dcount Daverage Microsoft Excel 2003 ECDL Advanced ITQ 3
Loading...
Loading...
6,928
Loading...
Uploader Comments (ronzohaylau)
see all
All Comments (4)
-
@cathal2011 Hi. I have the advanced database videos at my youtube channel (youtube.com/user/ronzohaylau)
, but if you want a bit more help, you can get my full course for as little as £1 - have a look at my main site ( haylau-ict-training.co.uk) -
Hello, what happens if their is no criteria range? Can you just leave it as criteria?
Great videos
Loading...
4:02
Using Excel as a Databaseby HugoPhongPresents4,905 views- 4:39
How to use dsum and array formulas to perform specific calculations in Microsoft Excelby familycomputerclub545 views
- 2:09
DSUM Excel 2010 Functionby tommy82pl1,354 views
- 4:31
The =SUMIF() Function in Excelby DannyRocksExcels12,723 views
- 7:48
How to Use SUMPRODUCT To Total an Excel List Using Multiple Criteriaby DannyRocksExcels2,871 views
- 2:01
Data Base Functions in Excelby DaveGalligan32,745 views
- 1:58
Dung cong thuc DSUMby trinhquangminh22,415 views
- 4:20
Microsoft Access DSUM Functionby ted602111,636 views
- 1:55
How to use the Daverage function in Excel 2010by LearnMeSomething33498 views
- 8:28
Excel 2007 - The COUNTIF function and absolute referencesby ictteachercom21,863 views
- 4:41
Excel Tutorial - SUMIF functionby supernicko7914,781 views
- 4:19
Microsoft Excel #04: Excel as a Databaseby freetutorials450,335 views
- 5:46
SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3by raycolondotcom63,289 views
- 6:05
Excel 2007 Tutorial 13: Advanced Functions Part 1by 10minutetrain33,428 views
- 6:01
Excel Tutorial, Pivot Tables (1 of 3)by FinneyLearning356,989 views
- 4:13
Excel Lookup Series #8: MATCH Functionby ExcelIsFun70,456 views
- 6:11
Excel 2003 Tutorial Using Database Functions Microsoft Training Lesson 28.5by teachucompinc24,937 views
- 6:32
Microsoft Access DLOOKUP Functionby 599CD59,962 views
- 7:55
Excel Magic Trick #130: 3 Dimensional Database in Excelby ExcelIsFun23,408 views
- 0:54
Remove Duplicate Records in Excel 2003by contextures57,933 views
Hi. You can put criteria into the function but that reduces the usefulness of the Database functions. The whole idea of database functions is that anyone can enter a criteria into the criteria range and the answer is automatically updated. If you put criteria into the function, then this facility is not available unless users know hoe to edit functions
ronzohaylau 1 year ago