Description:See how to work around Data Validations one rule limit by getting VBA code to prevent duplicates. See how to ask questions at the Mr Excel Discussion Board and get answers.
Title: Excel MT142 p2: Array Formula for Counting Dates
Video:
Description:See how to create a complex array formula that counts weekends between two dates with the SUM IF WEEKDAY ROW and INDIRECT functions in one formula See how to create an array formula that counts with date and other criteria Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions. Also see this video for another example of this date trick: Excel Magic Trick # 165: MACRO to Extract Birthdays.
Title: Excel Magic Trick #139: HYPERLINK function and Drop Down ListVideo:
Description:See how to use Data Validation List Drop-down and the hyperlink function to create a list of hyper links. See how to link to a web site or a cell on a different worksheet.
Title: How To Use Microsoft Excel : Formatting Cells in Microsoft ExcelVideo:
Description:How to format cells in Microsoft Excel; learn more about spreadsheet software in this free instructional video. Expert: Gary Zier Bio: Gary Zier, originally from Florida, is a systems administrator with 10 years of computer networking experience and an expertise in conditional access security systems. Filmmaker: Gary Zier
Description:Demo shows how to connect to Access programmatically and insert data directly to Access using ADO and SQL from Excel. Uses two textboxes and a command button.
Description:Conheça e aprenda os principais recursos do Access XP, um software que tem a finalidade de auxiliar o usuário no desenvolvimento e na manipulação de arquivos de bancos de dados. Neste curso, você irá aprender, de maneira didática, como gerar um arquivo de banco de dados, trabalhar com tabelas, criar consultas, definir e criar formulários e relatórios e vários outros recursos que o Access XP disponibiliza. São 86 lições apresentadas em mais de 2 horas e meia de vídeo. O curso apresenta uma interface intuitiva, agradável e auto - explicativa. As lições são apresentadas, passo a passo, em vídeo e organizadas em capítulos e tópicos, facilitando o acompanhamento ea navegação.
Title: Excel Magic Trick #129: More than 7 Nested IF functions
Video:
Description:See what to do if you must have more than 7 nested IF functions: 1) Use the Ampersand, Use different cells, buy Excel 2007, use VLOOKUP, or Use a Boolean formula.
Title: Excel Magic Trick #126: Macro: Advanced Filter Extract Text
Video:
Description:See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to a Form Command button.
Title: Excel Magic Trick #124: Box Plot or Box and Whisker
Video:
Description:See how to create a Box Plot or Box and Whisker Statistics chart using a Stacked Bar Chart and a Open-High-Low-Close Stock Chart. See how to use the QUARTILE function. See how to link Chart Labels to cells.
Title: 302208 - Creating a simple database using Microsoft Excel
Video:
Description:302208 - Creating a simple database using Microsoft Excel... free video to demonstrate the quality of our online Microsoft Excel training course (video tutorial)
