Tuesday 22 July 2008

2.26 Password Login Form / screen using VBA in Access

Title:
2.26 Password Login Form / screen using VBA in Access


Video:


Description:Creating a Login Form and password protecting your database Here's the code I used: Username.SetFocus If Username = "user1" And Password = "user1" Then MsgBox "Access Granted", vbInformation, "CD Shop" MsgBox "Welcome", vbInformation, "CD Shop" DoCmd.Close DoCmd.OpenForm "F_Switchboard" Else MsgBox "Please re-enter your Username and Password." End If

Published:
23/Jul/2008

TUTORIAL EXCEL 2007 - ORDENAR DATOS

Title:
TUTORIAL EXCEL 2007 - ORDENAR DATOS


Video:


Description:Aprende con este video tutorial de Excel 2007 cómo ordenar datos de una tabla de manera alfabética, ascendente, descendete,... Este video ha sido realizado por Seeway Formación www.seeway.net

Published:
23/Jul/2008

Tuesday 8 July 2008

WST: 19.11 Advanced Excel - Excel 2003 Create Macro Part 1

Title:
WST: 19.11 Advanced Excel - Excel 2003 Create Macro Part 1


Video:


Description:Wall St. Training Self-Study Instructor, Hamilton Lin, CFA covers the creation of macros (via record macro), how to create a macro button and toolbar as well as assigning the macro to the button, customizing the image of the macro icon and always having it at your disposal. Unfortunately, Excel 2007 significantly reduces the functionality of macros and toolbars and the new Excel for Mac completely removes VBA support for Excel. Go figure, great job Microsoft. For more information of the video courses previewed here, go to: www.wstselfstudy.com Over 80 hours of online, interactive Self-Study Videos! ***YOUTUBE VISITORS ONLY*** 10% off any online course, use Discount code: youtube www.wstselfstudy.com Wall St. Training Self-Study provides online, video-based, self-study financial modeling training solutions to Wall Street. Our interactive course modules are Excel-based and specialize in advanced and complex financial modeling, valuation modeling, investment banking, mergers and acquisitions and leveraged buyout training topics. Enhance your skills and master the content required by Wall Street investment banks, MandA, research, asset management, credit, and private equity firms.

Published:
09/Jul/2008

Wednesday 2 July 2008

Excel to PDF Techniques

Title:
Excel to PDF Techniques


Video:


Description:Free trial at: docudesk.com Quicklinks Excel to PDF: 00:24 Error in Excel: 00:54 How to resolve the error: 02:07 NEW version of this video is available in HD here: www.youtube.com Short tutorial demonstrating techniques for converting Excel to PDF, including selecting multiple worksheets in a spreadsheet to produce a single PDF. To learn how to scan to PDF, print to PDF, fill out forms, create fillable forms, and electronically publish your PDF's please view this video about our DocQ OnRamp application: www.youtube.com Fully compatible with Citrix and Terminal Services, deskPDF is deployed in over 30% of Fortune 1000 organizations. For more information please visit: www.docudesk.com

Published:
03/Jul/2008

Tuesday 1 July 2008

Excel 2007 - Using Goal Seek to calculate a value

Title:
Excel 2007 - Using Goal Seek to calculate a value


Video:


Description:Excel 2007 - Using Goal Seek to calculate a value Please note that I no longer own the domain ictteacher.com or maintain the website. I am no longer in teaching (thankfully!) but I can still be contacted if you have any questions. Just visit... www.themightierpen.co.uk ...where you can drop me a line, as well as finding some of the old resources which used to be on the old site.

Published:
01/Jul/2008