Excel Basics #21: Data Analysis Filter &Dynamic Ranges

Title:
Excel Basics #21: Data Analysis Filter andDynamic Ranges


Video:


Description:The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #21 Video topics: 1)Filter Text 2)Filter Number 3)Filter Date 4)Filter by color 5)Sort by color 6)Excel Table or List Sort Filter Dynamic Ranges 7)Function with Dynamic Range (Range updates when records added) 8)Excel Table Ctrl + T 9)Excel List Ctrl + L

Published:
17/Dec/2008

Using the Solver in Excel

Title:
Using the Solver in Excel


Video:


Description:This video demonstrates the use of the Solver in Excel for minimizing a function. It also shows a simple constrained optimization problem. A full resolution version of the video can be found at blanchard.ep.wisc.edu These videos were recorded for a course I teach as part of a distance masters degree. See mepp.engr.wisc.edu

Published:
16/Dec/2008

Tabela de Futebol em Excel (parte 2)

Title:
Tabela de Futebol em Excel (parte 2)


Video:


Description:Você insere os resultados eo Excel calcula a pontuação, o saldo de gols (diferença de golos), gols feitos (gols pró), gols sofridos (gols contra) e ordena a classificação automáticamente

Published:
13/Dec/2008

Tabela de Futebol em Excel (Parte 1)

Title:
Tabela de Futebol em Excel (Parte 1)


Video:


Description:Classificação automática de tabelas de futebol. Você insere os resultados eo Excel calcula a pontuação, saldo de gols (diferença de golos), gols feitos (gols pró), gols sofridos (gols contra) e ordena automaticamente a classificação

Published:
13/Dec/2008

i-teach-u Excel Macro to Remove Toolbars

Title:
i-teach-u Excel Macro to Remove Toolbars


Video:


Description:"i-teach-u Excel Macro to Remove Toolbars" What I tried to do here was to create a macro button that would 'tidy up' the Excel screen. This button when pressed was made to remove all toolbars, scroll-bars, and anything that will make the screen look 'crowded. A second button was added which 'replaced' all these items. So the user is put in control of the look of the screen. Dedicated to the late John Hooton, Great Tutor at the University of Westminster, who gave me a love of Excel.

Published:
05/Dec/2008

Mayorización de Libro Diario

Title:
Mayorización de Libro Diario


Video:


Description:Mayor informacion en www.excelnegocios.com Macro desarrollada en excel para mayorizar libro diario a nivel de dos digitos... PUEDES CONTACTARME A: excelparacontadores@hotmail.com Celular: 970982933 Rpm: #265789 Atte: Gustavo A. Sebastiani Cépeda

Published:
04/Dec/2008

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Title:
Excel Magic Trick 167p1 IF function formula: 12 Examples!


Video:


Description:Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions: AND, OR, SUM, AVEARAGE, STDEVP, and VLOOKUP. See how to use the IF function to put: 1 of 2 numbers in a cell or formula. 1 of 2 words in a cell or formula. 1 of 2 text strings in a cell or formula. 1 of 2 formulas in a cell or formula. 1 of 2 functions in a cell or formula. 1 of 2 cell ranges in a cell or formula. How to have more than one IF (Nested IF Ifs). When to switch to the VLOOKUP function. How to build multiple criteria formulas with the IF function. How to use the AND function with the IF function. How to use the OR function with the IF function. Excel If statement Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days Other amazing videos at YouTube: Excel Trick, Making a Gantt Chart with Excel, Recording Macros - Excel 2003, VLOOKUP in Excel 2007.

Published:
03/Dec/2008