Register  |   Contact Us  |  Log in

Classroom Tips

Classroom Tips

PowerPoint Tip: Avoid These Presentation Pitfalls

By Anthony Bell

Research works hard to diagnose business partner decisions, develop the insight, and deliver actionable recommendations. But we sometimes fall short in presenting research findings that are clear, convincing and visually captivating?  Don’t dilute the message of your presentation; avoid these common PowerPoint errors. MREB Members, interested in learning more about our presentation workshops? Reach out to our Advisory Team, abronder@executiveboard.com

Classroom Tips

Excel Tip: A Better Way to Analyze Survey Data

While we’ve often compared results in traditional stacked bar charts, see how in-cell panel charts can help you better visualize survey data. The panel chart shows data for multiple variables in an appealing format.

Classroom Tips

Excel Tip: Embed YouTube videos in excel workbooks

Trying to become a bit flashier with your dashboards? Maybe you’re just looking to include additional material. Take a look at this quick tool to embed YouTube videos in excel workbooks.

Classroom Tips

Excel Tip: Try an Array Formula

While it sounds simple enough to identify a range of cells and count the number of items in that range, it actually requires an excel mystery- the array formula. Our friends at CFO.com walk you through the process.

Classroom Tips

Excel Tip: A built-in solution to illustrate contrasts

Are you looking for a swift way to conditional format your chart range? Look no further! Here’s a built-in solution to change chart colors by positive, negative or other dividing lines in excel.

Classroom Tips

Excel Tip: Stop Flip-Flopping Between Worksheets

Are you looking for an easier way to move between worksheets? Using excel’s watch window helps you navigate to any cell, displaying the name, value, and formula in a floating window. Learn tricks and make your excel life a bit easier.

Classroom Tips

Excel Tip: A Well-Formed Dataset builds a stronger Pivot Table

Wouldn’t you love to learn a way to have a pivot table always default to sum the amounts rather than count them?  Interestingly enough, when your pivot table counts instead of sums, it’s caused by on of three reasons.

Classroom Tips

Excel Tip: PDF to Excel…As Simple As???

Don’t you hate when a data dump of information comes in a PDF or Adobe format? Here’s a simple best practice to convert that cumbersome information into an easy to analyze format.

Classroom Tips

Excel Tip: How to Rearrange Column Entries

Ever wonder how to convert a list of names from last name, first name to show first name, last name? A cool article helps you rearrange column entries so an employee’s last name comes first and the first name follows.