Tag Archives: 2010

Excel (Macros / Botões / Guias) – www.jeffersoncosta.com.br

Posted on April 23, 2012 by admin

www.jeffersoncosta.com.br Essa é uma vídeo aula de Microsoft Excel Avançado 2010. O objetivo aqui é ensinar macros / botões / guias de forma simples. twitter: ProfJcosta Duration : 0:4:21 Technorati Tags: 2010, apagar, aula, automático, avançado, botões, costa, desenvolvedor, excel, … Continue reading →

Posted in Learn Excel Macros | Tagged 2010, apagar, aula, automático, avançado, botões, costa, desenvolvedor, excel, gravar, guias, jefferson, macros, Microsoft, office, professor, video | 3 Comments

Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions

Posted on April 23, 2012 by admin

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a lookup for Pictures in Excel 2007 using: Data Validation Dropdown List INDEX and MATCH Functions Defined Names Excel 2007 Hint (from Joe): Insert Bitmap Image (Insert Ribbon Tab, Text group, Object) instead … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, Bitmap, College, Community, data, Defined, Dragons, Dropdown, excel, excelisfun, functions, Girvin, group, Highline, Image, INDEX, Insert, List, Lookup, match, Mike, Names, object, Picture, Ribbon, Slaying, tab, text, validation, with | 19 Comments

Excel Magic Trick 906: Ctrl + Backspace: Keyboard To Jump To Active Cell In Worksheet or Formula

Posted on April 23, 2012 by admin

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Keyboard to jump to Active Cell is Ctrl + Backspace: 1. In A Formula 2. In The Worksheet Shmuel Oluwa at Facebook!!! Duration : 0:2:2 Technorati Tags: 2003, 2007, 2010, active, At, Backspace, cell, College, Community, Ctrl, … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, active, At, Backspace, cell, College, Community, Ctrl, Dragons, excel, excelisfun, FaceBook, formula, Girvin, Highline, in, Jump, keyboard, Mike, Oluwa, OR, Shmuel, Slaying, to, worksheet | 12 Comments

Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record

Posted on April 23, 2012 by admin

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Excel 2003 0r 2007: See 4 methods to allow a person to enter “ID Number” OR “Name” (Lookup value is one OR another thing from two differenet columns in the database) and lookup the correct Record: 1. … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, allow, AND, CHOOSE, College, Community, correct, display, Dragons, Enter, excel, excelisfun, functions, Girvin, Highline, id, IF, IFERROR, INDEX, Lookup, match, methods, Mike, name, Number, OR, person, Record, records, ROWS, See, Slaying, the, to, vertically, vlookup | 10 Comments

VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

Posted on April 23, 2012 by admin

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, Add, As, CHOOSE, College, column, COLUMNS, Community, different, Dragons, Element, excel, excelsifun, first, formula, function, functions, Girvin, Highline, HLOOKUP, Horizontal, in, Join, left, Lookup, match, MID, Mike, named, on, Partial, range, right(), ROWS, Search, Shark, sheet, Slaying, space, table, Tax, text, TRIM, Two, values, vlookup, Way, WEEK, workbook | 25 Comments

Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula

Posted on March 23, 2012 by admin

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. : VLOOKUP A Date and Pattern To Simplify Formula Duration : 0:2:31 Technorati Tags: 2003, 2007, 2010, AND, College, Community, Date, Dragon, excel, excelisfun, formula, Girvin, Highline, Mike, Pattern, simplify, Slaying, to, vlookup

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, AND, College, Community, Date, Dragon, excel, excelisfun, formula, Girvin, Highline, Mike, Pattern, simplify, Slaying, to, vlookup | 4 Comments

Excel Magic Trick 873: VLOOKUP – Lookup that rounds to the nearest number (Increment Equal)

Posted on March 23, 2012 by admin

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. See how to avoid the default VLOOKUP behavior and instead find a value in the first column of the lookup table that is closest to the lookup Value. 2. Because the increment between … Continue reading →

Posted in Learn Excel Formulas | Tagged 0.25, 2003, 2007, 2010, behavior, between, can, College, column, Community, default, Dragon, equal, excel, excelisfun, first, formula, formulas, function, functions, Girvin, Highline, in, increment, instead, Lookup, Mike, MROUND, Nearest, Number, of, Round, Rounded, rounds, same, Slaying, table, that, the, to, value, values, vlookup | 8 Comments

Excel Dates – Calculations and Functions

Posted on March 3, 2012 by admin

Dates are just numbers in Excel. This tutorial demonstrates the use of some date calculations and functions to create a perpetual calendar. Duration : 0:11:50 Technorati Tags: 2003, 2007, 2010, Calendar, Date, excel, function, Microsoft, perpetual

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, Calendar, Date, excel, function, Microsoft, perpetual | 6 Comments

Working with Pivot Tables in Excel 2010 – Part 1

Posted on February 26, 2012 by admin

Learn to create pivot tables from lists of information in Microsoft Excel 2010 Duration : 0:4:56 Technorati Tags: 2010, excel, Microsoft, Pivot, tables

Posted in Learn Basic Excel | Tagged 2010, excel, Microsoft, Pivot, tables | 25 Comments

Excel Formulas

Posted on February 5, 2012 by admin

Hi Guys, First video of the new year. In this video I will be showing you how to use simple formulas in Excel. —– PLEASE DON’T FORGET TO: – LIKE, COMMENT & SUBSCRIBE!!! THANKS —– This video is for Educational … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, AVERAGE, excel, formulas, Max, Microsoft Office, Min, SUM, vista, Windows 7, WolfTM2008, xp | Leave a comment

Tag Archives: 2010

Excel (Macros / Botões / Guias) – www.jeffersoncosta.com.br

Excel Magic Trick 906: Ctrl + Backspace: Keyboard To Jump To Active Cell In Worksheet or Formula

Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record

VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula

Excel Magic Trick 873: VLOOKUP – Lookup that rounds to the nearest number (Increment Equal)

Excel Dates – Calculations and Functions

Working with Pivot Tables in Excel 2010 – Part 1

Excel Formulas

Recent Posts

Blogroll

Categories