Tag Archives: excel tutorials

Customizing the Ribbon bar in Excel 2010 Essential Training from lynda.com

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=61219&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

lynda.com Tutorial | Excel 2010: Advanced Formulas and Functions—COUNTIF, SUMIF, and AVERAGEIF

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=75923&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best … Continue reading

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

Adding numbers using Sum and AutoSum in Excel 2010 Essential Training from lynda.com

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=61219&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , | 2 Comments

Microsoft Excel Formula Builder

Build complex formulas with Excel 2008 for Mac using the Formula Builder. Duration : 0:4:41 Technorati Tags: excel tips, excel tutorials, Microsoft Excel, Microsoft Excel 2008 Tips

Posted in Learn Excel Formulas | Tagged , , , | Leave a comment

lynda.com Tutorial | Excel 2010: Advanced Formulas and Functions—Ranking data without sorting

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=75923&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best … Continue reading

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

Excel Lookup/Search Tip 6 – Vlookup with a Drop Down Menu and Data Validation

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use the VLOOKUP function in Excel in conjunction with a data validation drop down menu in order to create more logical and easy to use Excel spreadsheets. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , | 3 Comments

Excel 2010: Complex Formulas

http://www.GCFLearnFree.org Excel is a spreadsheet application that can help you calculate and analyze numerical information for household budgets, company finances, inventory, and more. To do this, you need to understand complex formulas. In this lesson, you will learn how to … Continue reading

Posted in Learn Basic Excel | Tagged , , , , , , , , , , , , | Leave a comment

lynda.com Tutorial | Excel 2010: Macros in Depth—Welcome

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=74463&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , | Leave a comment

lynda.com Tutorial | Excel 2010: Macros in Depth—Understanding what a macro does

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=74463&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , | Leave a comment

Excel Lookup/Search Tip 5 – Vlookup – Assign Values Instead of Errors to a Vlookup with IFERROR

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() function in order to never have to see another error displayed in Excel. The IFERROR() function allows … Continue reading

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