Tag Archives: excel

Nesting IF and AND functions in Excel 2007

Posted on April 23, 2012 by admin

Nesting steps in Unit Application 2-2 (Stewart’s Excel 2007). Duration : 0:3:58 Technorati Tags: excel, functions, Nesting

Posted in Learn Excel Formulas | Tagged excel, functions, Nesting | 12 Comments

SUMIF and COUNTIF functions in Excel

Posted on April 23, 2012 by admin

How to use the SUMIF and COUNTIF functions in Excel – TO RECEIVE AUDIO PLEASE SEARCH FOR SUMIF AND COUNTIF FUNCTIONS IN EXCEL V2 Duration : 0:4:7 Technorati Tags: excel, Microsoft, training, Videos

Posted in Learn Excel Formulas | Tagged excel, Microsoft, training, Videos | 11 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 Formulas: User Functions and Cell Names

Posted on April 23, 2012 by admin

Shows how to write a formula in Excel using user functions and naming cells Duration : 0:5:18 Technorati Tags: excel, function

Posted in Learn Excel Formulas | Tagged excel, function | 1 Comment

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 การใช้ฟังก์ชั่น VLookup และ HLookup

Posted on April 23, 2012 by admin

เรียนรู้การประยุกต์ใช้ฟังก์ชั่น VLookup และ HLookup โดยอาจารย์รวีโรจน์ ทวีชัยนุกูลกิจ http://www.ittotop.com Duration : 0:14:39 Technorati Tags: excel, function, HLOOKUP, vlookup

Posted in Learn Excel Formulas | Tagged excel, function, HLOOKUP, vlookup | Leave a comment

Double Vlookup in Excel – Use Multiple Vlookups Together – Nested Vlookups

Posted on April 23, 2012 by admin

Go to http://www.TeachExcel.com for more. Learn how to combine two vlookups into one vlookup function in Excel. This also includes an explanation and example of when or why you would want or need to do this in Excel. Basically, this … Continue reading →

Posted in Learn Excel Formulas | Tagged advanced vlookup, database in excel, double vlookup, excel, excel help, Excel Tutorial, formulas, multiple vlookup, nest functions, tips & tricks, two vlookups, vlookup | Leave a comment

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

Learn Excel – Chart Title, Legend, Colors: Podcast #1408

Posted on March 23, 2012 by admin

The Basics of Excel Charting: Part IV This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we’d set up our Data Set, Created our Chart and made adjustments to … Continue reading →

Posted in Learn Basic Excel | Tagged accounting, Bill Jelen, business, charting, charts, excel, Excel2010, Learn Excel, MrExcel, spreadsheet, technology, tutorial, workbook | 2 Comments

Tag Archives: excel

Nesting IF and AND functions in Excel 2007

SUMIF and COUNTIF functions in Excel

Excel Formulas: User Functions and Cell Names

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

สอน Excel การใช้ฟังก์ชั่น VLookup และ HLookup

Double Vlookup in Excel – Use Multiple Vlookups Together – Nested Vlookups

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)

Learn Excel – Chart Title, Legend, Colors: Podcast #1408

Recent Posts

Blogroll

Categories