Lucidate Dataworks
Lucidate Dataworks
  • 12
  • 130 569

วีดีโอ

Excel - IF Statements and Nested Conditionals
มุมมอง 368 ปีที่แล้ว
An introduction to the IF (or Conditional) function in Excel, including "Nested Conditionals")
Office 365 Excel 2016 - Six New Functions! Woot! Part 6 of 6
มุมมอง 1318 ปีที่แล้ว
Six new Excel functions are available in the latest release of MS Excel in Office 365 - TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. Part 6: MAXIFS and MINIFS
Office 365 Excel 2016 - Six New Functions! Woot! Part 5 of 6
มุมมอง 608 ปีที่แล้ว
Six new Excel functions are available in the latest release of MS Excel in Office 365 - TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. Part 5: SWITCH and other text functions
Office 365 Excel 2016 - Six New Functions! Woot! Part 4 of 6
มุมมอง 688 ปีที่แล้ว
Six new Excel functions are available in the latest release of MS Excel in Office 365 - TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. Part 4: SWITCH
Office 365 Excel 2016 - Six New Functions! Woot! Part 3 of 6
มุมมอง 988 ปีที่แล้ว
Six new Excel functions are available in the latest release of MS Excel in Office 365 - TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. Part 3: IFS function syntax
Office 365 Excel 2016 - Six New Functions! Woot! Part 2 of 6
มุมมอง 728 ปีที่แล้ว
Six new Excel functions are available in the latest release of MS Excel in Office 365 - TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. Part 2: CONCAT and TEXTJOIN
Office 365 Excel 2016 - Six New Functions! Woot! Part 1 of 6
มุมมอง 3128 ปีที่แล้ว
Six new Excel functions are available in the latest release of MS Excel in Office 365 - TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. Part 1: Intro and CONCAT
Adaptive Insights OfficeConnect
มุมมอง 3258 ปีที่แล้ว
An overview of Adaptive OfficeConnect, Adaptive Insight's Excel Add-In for dynamic reports.
Linking picture files to an Access database
มุมมอง 106K10 ปีที่แล้ว
Linking picture files to an Access database
Excel to Quicken/QuickBooks, Step 2
มุมมอง 6K10 ปีที่แล้ว
formatting data, preparing for conversion
Excel to Quicken/QuickBooks Step 1
มุมมอง 13K10 ปีที่แล้ว
Install the add-in for Excel that converts .xls/.xlsx files to .QIF for import to Quicken or QuickBooks

ความคิดเห็น

  • @user-ln6mv2qw7p
    @user-ln6mv2qw7p 4 หลายเดือนก่อน

    Hi, I have created links to images in my database but I can not get them to display when I generate a Form, Query or Report.

  • @froggert119
    @froggert119 11 หลายเดือนก่อน

    lot of effort for a single photo

  • @svergurd3873
    @svergurd3873 2 ปีที่แล้ว

    I need to do just this, but you didn't tell what I need to know. I need to make a relative path to the photos in the folder, so that the access file + image folder can be moved to other computers. Unfortunately you only showed it with the absolute path. How do you make a relative path?

    • @catepilarr
      @catepilarr ปีที่แล้ว

      I would love to do that too! Have you found out how to do it?

  • @RedFlyer350
    @RedFlyer350 3 ปีที่แล้ว

    Good Lord! Thank you so much for this! I was going crazy looking at all these other tutorials that WERE NOT WORKING!!! 🤪

  • @andybawn1
    @andybawn1 3 ปีที่แล้ว

    doing this for 10,000 employees would take a life time

  • @nikolaskierska2740
    @nikolaskierska2740 4 ปีที่แล้ว

    it did not work :(

  • @pjutub
    @pjutub 4 ปีที่แล้ว

    Thank you, it was very helpful, solved my problem!

  • @oscarfilms9375
    @oscarfilms9375 4 ปีที่แล้ว

    How can I add multiple pictures to one line item? like receipts particular to one merchant?

  • @ajdgreat0707
    @ajdgreat0707 4 ปีที่แล้ว

    thank u so much it helped me 👍👍👍

  • @astrophile5
    @astrophile5 5 ปีที่แล้ว

    Thank you so much Sir! very helpful!

  • @Munky332
    @Munky332 5 ปีที่แล้ว

    Is it possible to lock the size, without having to edit the photos? for example, I have a database with employees, but a few admin using their phones to take pictures of new employees, and everyone uses different phones these days (android vs apple and such) which ends up causing different sizes and resolutions, but say I decide to use the image to print out paper ID cards using the database info and a form with certain certifications, but I need the pictures to be uniform in size (height/width). How would you lock it?

  • @haiderabdullah7244
    @haiderabdullah7244 5 ปีที่แล้ว

    what about adding button to control the inserting or deleting of the file or image from the image control box? Would you mind to show us how to do that.

  • @pawznclawzpetaccommodation3015
    @pawznclawzpetaccommodation3015 5 ปีที่แล้ว

    were you even talking?!? can't hear a thing

  • @propersoft
    @propersoft 5 ปีที่แล้ว

    try CSV2QIF at www.propersoft.net/products/csv2qif - it works with excel and csv files.

  • @tore28
    @tore28 5 ปีที่แล้ว

    Compact and good narrative and efficient introduction to how to get started with pivot tables in Excel. I am a developer and must make an overview of E-R tables in a system and want to start with a pivot table before using software modelling tools. Your video helped me out. Thanks!

  • @btappan1
    @btappan1 5 ปีที่แล้ว

    How can this be adapted for items that have a varying number of 1 to 5 pics?

  • @vicentegonzalez8403
    @vicentegonzalez8403 6 ปีที่แล้ว

    I am trying to install the plugin in the excel 2016 but this gives me an error (Tools). Can you help me? Thank you

  • @sergioivanpg
    @sergioivanpg 6 ปีที่แล้ว

    Very helpful thanks, some problems with the audio volume.

  • @janicesilverstein5294
    @janicesilverstein5294 6 ปีที่แล้ว

    Difficult to hear you.

  • @joseg.teaches7916
    @joseg.teaches7916 6 ปีที่แล้ว

    Horrible audio!!!

  • @alexkurdin6509
    @alexkurdin6509 6 ปีที่แล้ว

    I tried CSV2QIF at www.propersoft.net/csv2qif/ it worked great for me.

  • @MattComptonLA
    @MattComptonLA 6 ปีที่แล้ว

    I will be using my database on two different computers, and the path where I will store my image files will not be the same. Do you know if instead of typing the entire path of the image file, I can indicate the path is a specific folder inside the "current path", meaning wherever the database lives on the particular computer I'm using?

    • @catepilarr
      @catepilarr ปีที่แล้ว

      I would love to do that too! Have you found out how to do it?

    • @MattComptonLA
      @MattComptonLA ปีที่แล้ว

      @@catepilarr I never did. I just ended up using the database on one computer only.

  • @christophernoble5757
    @christophernoble5757 7 ปีที่แล้ว

    Helpful video!!! You should mention to make sure the file extension is added at the end of the file path...an easy thing to forget!!!

    • @lucidatedataworks3699
      @lucidatedataworks3699 7 ปีที่แล้ว

      Many thanks - will incorporate into the "reboot"

    • @andrewmayne6772
      @andrewmayne6772 6 ปีที่แล้ว

      Thanks for this comment - it was only after reading this and adding the file extension that I got it to work! It is indeed clearly shown by Lucidate Dataworks in the video - which is much appreciated as I could not find any other help anywhere on this simple but rather important capability - but as you say CN it would help first-timers like me to specifically remind to include the file extension.

  • @michaelmekhail502
    @michaelmekhail502 7 ปีที่แล้ว

    Hi, Do you know how to address a 'compile error in hidden module: tools' error?

  • @MrWyng
    @MrWyng 7 ปีที่แล้ว

    thanks, it was very helpful for me.... keep on sharing your knowledge... thanks again.

  • @AlexanderKachowski
    @AlexanderKachowski 7 ปีที่แล้ว

    Access 2007 Table with students with images (folder address&file names) of the classes.All what I need is: filter the table in any form (form, query, report or as table) to transform it into html file with images later. I've learned how to show the images in the form. I've learned how to filter the table. How to put it all together in one table of any form, query, report or table of some sort? Could you make such tutorial please or readdress me to somebody's already made video please?

  • @partytill10
    @partytill10 7 ปีที่แล้ว

    does this work for recent versions of quicken? eg 2015

  • @TonyEarlsTrinityLawns
    @TonyEarlsTrinityLawns 7 ปีที่แล้ว

    Cheers Barry, I've just found your videos and it makes it all clear, and I feel empowered .. I'll give up working on this tonight and return to it tomorrow. I'm trying to get the data from the Bank - CSV then import to Excel, massage it then turn it into a QIF file Then Import it into Sage accounting system which is the most popular system here in the UK. I'll let you know if I am successful. Then I'll make a donation. I imagine you are in Canada by the restaurants you eat in ;-)

  • @dannicarobles1558
    @dannicarobles1558 7 ปีที่แล้ว

    It worked! thank you so much! It really helped me a lot! God bless.:)

  • @ShamsQaend
    @ShamsQaend 7 ปีที่แล้ว

    Now, what if you have 100 record, and you want the photo field link address to have a default value from the name field ? Like : ="\C:\Face Photo\FIRST NAME.jpg" Is there a way to make "first name" a default value taken from the first name field ?

  • @markmeyer1268
    @markmeyer1268 8 ปีที่แล้ว

    Thanks for posting but it didnt work in my database - I am using a front / back end scenario and the coding doesnot appear to work

  • @danelavery7436
    @danelavery7436 8 ปีที่แล้ว

    Torzo Tehnology - The volume on this video is very low (at least on my lap top)...It would help immensely if you could re-post this useful presentation with a better sound track.

  • @buddesatva
    @buddesatva 8 ปีที่แล้ว

    The information is in the video if you can tolerate the annoying presentation. Very amateurish. An outline and a a modicum of forethought would have made a big difference.

    • @tbazzer
      @tbazzer 8 ปีที่แล้ว

      +buddesatva - You are right - it was an improv. It was one of my first and just for trying out the software mostly - posted anyway in case people found it useful. Thanks for the feedback; I'll try and improve.

  • @sirrahphotography5930
    @sirrahphotography5930 8 ปีที่แล้ว

    I'm having trouble having the picture show up. All I get is the file name. I'm following exactly what you are doing, but still "blank". Is there something I'm missing?

    • @ShamsQaend
      @ShamsQaend 7 ปีที่แล้ว

      Maybe you forgot to add .jpg It happens with me a lot.

    • @christophernoble5757
      @christophernoble5757 7 ปีที่แล้ว

      I was also having the same problem...until I added the extension for the file type. Thanks!!! Your video (and reply to this issue) was VERY helpful.

  • @andrewfranks8328
    @andrewfranks8328 8 ปีที่แล้ว

    Thanks. That was very helpful!

  • @metras3
    @metras3 8 ปีที่แล้ว

    Easy1 Thanks

  • @shinjiccs
    @shinjiccs 8 ปีที่แล้ว

    Do you know how to make splits? i.e. Transfer 95 Fee 5 Bank 100

    • @lucidatedataworks3699
      @lucidatedataworks3699 7 ปีที่แล้ว

      Sorry I just noticed your question. Use the "invert amount" option for credit balances

  • @wbesack
    @wbesack 9 ปีที่แล้ว

    Awesome! Just what I was looking for and very simple to follow. Great!

    • @tbazzer
      @tbazzer 9 ปีที่แล้ว

      Thanks!

  • @alexandergitanes6953
    @alexandergitanes6953 9 ปีที่แล้ว

    Thank Men :D

  • @ozziegarcia1
    @ozziegarcia1 9 ปีที่แล้ว

    Very nice tutorial.