Tag Archives: formulas
Double Vlookup in Excel – Use Multiple Vlookups Together – Nested Vlookups
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
Excel AND function – beginner
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Duration : 0:5:27 Technorati … Continue reading
Posted in Learn Excel Formulas
Tagged AND, Begin, beginner, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logical, Microsoft Excel, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial
2 Comments
Excel: Using Percentage in Formulas (calculations)
If you need to do a calculation and you want to use a percentage then it is easier than you might think. In this short tutorial by Gary Schwartz from http://www.jargonfreehelp.com you will see how to work out the percentage … Continue reading
Excel OR function – beginner
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Duration : 0:6:31 Technorati … Continue reading
Posted in Learn Excel Formulas
Tagged AND, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logic, Logical, Microsoft Excel, nested, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial
Leave a comment
Use named cell references in your Excel formulas
Do you find it difficult to interpret a formula that you wrote in last year’s spreadsheet? Can you easily explain your formulas to a colleague, client or to your boss? This is a common proble. Learn how to use named … Continue reading
Posted in Learn Excel Formulas
Tagged cells, excel, finance, formulas, References, spreadsheets
Leave a comment
Excel Formulas
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
Excel Formulas – Cold Spotz
An introduction to using formulas in excel. Duration : 0:7:13 Technorati Tags: Cold Spotz, excel, formulas
Microsoft Excel 2003 course: Excel Basics (05- Creating Simple Formulas)
By the end of this lesson, learners should be able to: Understand the parts of an Excel formula Create a simple addition formula Create a simple subtraction formula using the Point-and-Click Method Create simple multiplication formulas Create simple division formulas … Continue reading
Excel Lookup/Search Tip 7 – Vlookup on Data that has a Prefix before it
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use the VLOOKUP function in Excel to search a database or table array which contains lookup values that have prefixes. This allows you to only have to … Continue reading
Posted in Learn Excel Formulas
Tagged Advanced, complex vlookup, data with prefix, excel guides, excel help, excel teacher, excel tips, excel tricks, excel tutorials, formulas, functions, microsoft excel 2007, Prefix, search databases in excel, spreadsheets, vlookup, workbooks, worksheets
Leave a comment
