Recently Posted Videos
There is a worksheet where every row in column A is associated with three rows in column B. How did someone set this up? Episode 313 shows you the trick.
Episode 312 features a preview of one of the cool new features in Excel 2007 - data visualizations. Check out how you can use the greatly improved Condtional Formatting rules to visualize the outliers in columns of data.
Ethan calls in with today's question - how to rank a column of data, but exclude certain data points. This question made my head spin and I eventually gave up. Luckily, the FANTASTIC resource of the MrExcel Message Board provided the answer. Episode 311 shows you how to post your nearly impossible questions to the MrExcel Message board!
In this screencast you will learn about the method lookup and basic concept required for an upcoming episode "Higher Order Procedures in Ruby".
Cliff Rhyne describes in 15 minutes what it takes to get up and running with RSpec.
In this week’s episode we take a break from the CS3 "exclusive" content and get back into a creative mindset using clipping masks. This is a very popular technique that is used in all sorts of magazine ads, posters, invitations, and book covers. You’ll learn how to quickly "clip" your photographs into your text layer to create a very eye-catching effect, without ...
Summary Dr. V opens the door to new worlds in .NET as he shows us some of the hidden Ruby-like features .NET developers can use today. Bio Venkat is an agile developer who teaches and mentors. He has significant experience in architecture, design and development of distributed object systems. He has worked in positions, from Programmer Analyst to Systems Architect, at organizations like Hallibu...
Summary Windows Presentation Foundation is a fundamental shift from how interactive applications have previously worked in Windows. In this interview, Ian Griffiths talks about the key features of WPF such as XAML, composition, layout, animation, and data binding. Included is advice on when to use WPF and its sister technology Windows Forms. Bio Ian is a C# MVP, freelance software developer and...
The profit waterfall chart is a great way to show how the top-line revenue translates down to bottom line profit. In Episode 310, learn how to make the bars on the chart apparently float in mid-air.
Can you predict the future with Excel? MrExcel thinks you can. See how he uses the Trendline feature on a chart to make sure that his books get done on time. Episode 309 shows you how.