Spreadsheet Presentation

When you first use Microsoft Excel, your primary concern is to keep a lot of numbers into a single file. You may also use spreadsheets to analyze data. If asked to identify an advanced user, most people would define an Excel expert as someone who can use the package to perform complex calculations.

To a certain extent, that is true. The logic involved in writing Excel formulas is similar to that required for computer programming. However, if you start to think in those terms, you can forget the great advantage of Excel. Fundamentally, it is designed to present data. That’s why the package has a chart wizard. Yes, it can be used as a calculator, but it can also be used as management reporting software. Therefore we should consider not just the substance, but also the visual appearance of our spreadsheets.

If asked to draw a spreadsheet, most people would draw a simple criss-cross of horizontal and vertical lines on a white background. On Windows 95, that may have looked cutting edge but, on Windows 7, everything’s become rounded and shaded. As an Excel consultant, I would nearly always get rid of gridlines. You can do this by unchecking the Gridlines box from Tools->Options->View->Windows Options on early versions of Excel, or from View->Show/Hide on Excel 2007/2010.

The only reason for having gridlines is to identify cells in the same row or column. This is extremely important e.g. within a table. I would certainly recommend adding internal borders to the tables in your spreadsheet. The difference between borders and gridlines is that you can manage the formatting of borders to ensure they are aesthetically pleasing.

Another trick of the consulting trade is to remove row and column headings. One reason Excel feels somewhat dated is that it says A, B, C, D… at the top of the sheet, and has a list of numbers at the side. You can remove these by unchecking the Headings box next to the Gridlines box. When developing formulas, it is extremely useful to see the headings because they will quickly tell you which column is which. Therefore, I would only recommend making this change once you have built your file.

The two changes I’ve recommended above will make your on-screen sheet look just like the printed version. Our next concern is to ensure your experience of Excel matches your experience of other programs and the worldwide web.

This means you should use an up-to-date font and color scheme. Since Office 2007, Microsoft has moved away from Arial and Times New Roman fonts, instead preferring users to use Calibri. If you have an old spreadsheet, it may still be written in an older font. I would recommend selecting all the cells in your spreadsheet and setting the font to Calibri. Much as Microsoft has invested a lot of time in graphical menus, the main reason Excel 2007 looks modern is because it uses modern fonts.

Color is also of interest. On the internet, it is very unusual to see a completely white website, Google being a notable exception. Most websites draw attention to content by lightly shading any peripheral space. You can see this on a site like Wikipedia and, it is so subtle, you may not have noticed it. Microsoft Word certainly uses a blue surround to highlight the main content. So why not color your entire spreadsheet light blue/grey, and make any tables white?

These simple tips are far more important to spreadsheet development than being able to write macros and formulas. You can create the best spreadsheet in the world but its presentation is the first thing your manager will notice.

PowerPoint Presentation Tips: Deliver Presentations Designed by Someone Else

Narrating PowerPoint Presentations designed by someone else can be very challenging. In fact, one of the fastest ways to increase public speaking fear and make your PowerPoint presentations sound canned and… well boring, is to try to deliver a PowerPoint slideshow that someone else designed for you. This doesn’t mean that you can’t deliver PowerPoint slide decks that someone else created. It just means that when you do, you’ll probably be more nervous and have less of a natural flow than what you’d normally have when you stand up and deliver a speech. Remember that a presentation or a speech is just a conversation with your audience, so if you create the speech, you’ll be speaking in your own words. When someone else creates a speech for you, you will feel more uncomfortable and the public speaking nervousness will increase.

If you remember the movie Roxanne or the play about Cyrano de Bergerac, the two male characters, Christian and Cyrano are both in love with Roxanne, but Christian sees himself as being inarticulate and Cyrano sees himself as being ugly. Christian gets Cyrano to write love letters for him, which works pretty well until Roxanne finds out who actually wrote them. In the movies, Christian is portrayed as a dunce, but according to the original play, Christian is a brave and intelligent warrior who is just nervous. Christian is the kind of person that Roxanne would have fallen in love with if he had just used his own words to woo her. But because he was using Cyrano’s verbiage (his slideshow,) it just made Christian even more nervous – not less. Roxanne never got to know the real Christian. Your audiences are the same way. You will feel much more confident if you can communicate your own words to your audience versus trying to manufacture the “right thing to say” about a PowerPoint slide or bullet points that someone else created.

With that in mind, we know that situations will occur where we have no control over the PowerPoint slideshow or any of the visuals really. For instance, if you are a sales associate, and your company requires that you use a standardized PowerPoint presentation when you speak to customers or if someone calls in sick and you have to fill in for them at the last minute, the tips below will help you out tremendously.

Top PowerPoint Presentation Narration Tips

1. Add Your Own Personal Experiences: The main thing that sets one presenter apart from another is the personal examples or stories that they tell when they deliver a presentation. You can easily make your PowerPoint presentation your own by inserting stories and examples from your own experience into the speech. For example, let’s assume your bullet point is “Sales decreased by 10% last quarter,” you’ll want to first clarify the point and explain in more detail what it means. For instance you might show the total number of “call-in” leads that the sales team received in the quarter versus previous quarter. Then once you have explained the point, add a personal experience to further explain it. “A couple of years ago, when I was a sales rep, I remember days that as soon as I would set the receiver down, another new incoming call was already being routed to me. The guys who are on duty now, however, are averaging ten to fifteen minutes between each call. At first, we thought that the time between calls was wasted time, so we looked at downsizing the sales team. However, because each salesperson is able to follow up better with each incoming lead, their closing rations have increased over 250%. So that 10% decrease in sales is coming from less than half the number of incoming leads that we were receiving in the boom.” Without the personal story, the bullet looks like the sales team is failing, but in reality, they are doing a tremendous job with the resources that they have had.

2. Avoid Memorizing Someone Else’s Notes: If you try to write down everything that someone else tells you to say and memorize it, you will increase your nervousness exponentially. Instead, go to each bullet point and ask yourself, “What is the most important thing that the audience would need to know about that point?” Whatever pops into your head when you ask that question will likely be exactly what the audience needs to know. If you use this technique, then if you forget what you have prepared while you are speaking, you can just, internally, ask yourself the question again, and your answer is likely to return pretty easily.

3. You May not Need to Speak to Every Point: When other people write a PowerPoint presentation for you, they often will insert way too much data into each slide. As a result, it can be very challenging to speak to every point. Realize that, as the presenter, you are in control of what you say. I had a client once whose executives decided that they wanted to create one all-encompassing slideshow that any sales rep could use in any situation. The finished PowerPoint deck had over 120 slides. There is no way that any presenter could deliver that much data in so short a period of time. So what my client did was print out the whole deck and had an office supply store put a cover on it. She gave this out to the clients as a reference and hand-picked the slides that were most appropriate to each client at the time she presented. As a result, she didn’t bore any of them. So sometimes, you might have to get a little creative in your delivery.

Remember that narrating a PowerPoint slideshow that someone else creates for you is definitely more challenging than delivering a presentation that you create on your own, however it can be done. Just be sure to make the PowerPoint your own by inserting your own personal stories and experiences into the slides, spend time determining exactly what is most important to the audience, and feel free to cut out some of the bullets if your presentation is too data heavy. If you follow these simple tips, you will be more charismatic and articulate when you narrate someone else’s PowerPoint presentation.

The Guide to Giving Bras As Presents

Shopping for a bra can be really difficult when you’re faced with a multitude of shapes and styles and then you need to consider what size! Here’s out guide to picking out the right one.

Entering the store, you’ll notice that there are many different names for types of bras. Does she want a bra with an underwire? Strapless? A push up bra? Front-clasp? Sports bra? If you know what style she normally wears, you can select this type, or you can help her to go out for a change. Push up bras are almost always a safe bet for a gift — many women love to wear push up bras normally, as they provide the support and lift that many women desire. A push up bra can also be a sexy alternative to her normal everyday wear, that she’s likely to enjoy for special occasions or formal events. Best of all, a push up bra can be a great option for women of all sizes.

Next, you’ll need to consider the bra’s sizing. This can be more difficult if you don’t already know her size, so the best option is to try to go into the store with her size in mind. If you don’t already know it, try to look at the label in another bra she wears often. Bra sizes can vary widely and do not necessarily correspond to her other measurements. You’ll need to know two sizes in order to get her the properly sized bra — both the band size and the cup size. The band is measured in numbers, such as 34, 36, or 38, and corresponds to the measurement underneath her bust. The cup size is measured in a letter, such as B, C, or D, and corresponds to the measurement of the fullest point of her bust. As you can see, this number is highly specific and may be difficult to guess on your own if you don’t already know her size.

Choosing a new bra for a woman can oftentimes make a wonderful present when you are careful to pay close attention to the bra’s style and sizing. As bras come in many different varieties, there is no one bra that will suit every woman’s needs. By thinking about her lifestyle and general fashion preferences, as well as her size and shape, you can choose a bra that she is sure to love.