A dueling Excel podcast where Mike and Bill take a look at how to sort using a formula. While most people would use RANK and COUNTIF, Episode 1025 shows you how to use LARGE and ROW or ROWS.
http://www.tvlesson.com/video/74267_how-to-sort-excel-sheet-using-a-formula.html
Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games. In Episode 1041, I take a look at...
http://www.tvlesson.com/video/74536_how-to-build-excel-nested-if-formula.html
Pablo sends in a cool tip for using Spearing Formulas. Episode 1099 shows you how.
http://www.tvlesson.com/video/93899_excel-tips--how-to-use-spearing-formula.html
Join me on this lesson and forget of using a calculator anymore, we are going to show you how to do all your calculations in Excel in a few clicks. Creating an Excel formula in Microsoft Office is...
http://www.tvlesson.com/video/20664_how-to-create-an-excel-formula.html
In this Windows tutorial you will learn how to use the formula bar in excel.
http://www.tvlesson.com/video/79835_how-to-use-the-formula-bar-in-excel.html
Paul sends in a few tricks to help deal with the Function Tooltip that appears when you edit a cell.
http://www.tvlesson.com/video/73818_mrexcels-learn-excel--formula-tooltip.html
William asks how to base his conditional formats on a start date in column A and a duration in column B. This calls for the Formula version of conditional formatting. Episode 1007 shows you how.
http://www.tvlesson.com/video/73938_excel-formula-conditional-formatting-tips.html
Learn the importance of the formula bar in Microsoft Excel.
http://www.tvlesson.com/video/67009_overview-of-ms-excel-2007-formula-bar.html
Systematic description of what Excel can do from beginning to end. In this video you will see: about Excel\'s operators, order of operations, and how it evaluates your formula! Learn about Math,...
http://www.tvlesson.com/video/3079_excel-basics-2-functions-formula-evaluator--math.html
This video teaches you the TEXT formula for dynamic labels.
http://www.tvlesson.com/video/6579_excel-magic-trick-40-text-formula-dynamic-label.html
