99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Want To Create A Presentation In Excel?
Mon 24th January 2011
Organising your presentation into separate sheets
To start off you might like to organize your data into separate sheets within a workbook with the aim of using the sheets as separate slides. You could use Sheet1 as a title slide and then add your tables, charts, diagrams, shapes, text boxes etc in individual sheets to create your separate slides.
Organising the Title Slide and slide navigation
You can navigate between sheets in different ways. You can add a list of sheet titles and then add a hyperlink to each item, linked to the appropriate sheet. Or if you prefer onscreen navigation you can add buttons from the forms toolbar and create macros to select particular sheets, and link the macros to the buttons. If you use either of these methods, you could create a set of hyperlinks or buttons on the title slide, and then copy and paste the set to each other sheet, so that you can navigate from any sheet to any other sheet. Or you could brush up on your keyboard shortcuts, and use, for example, CTRL+ Page Up or CTRL+Page Down go forwards or backwards through the sheets, and CTRL+Home to return to the first sheet from any other sheet.
Changing the appearance of an Excel sheet
Before you start making changes, it might be a good idea to write down the actions you take, so that you can put all settings back to normal when you finish the exercise. You can change the appearance of an Excel sheet by turning off several features such as gridlines, the formula bar, navigation bars, sheet tabs and the toolbars. If you then use the Full Screen View to show the presentation you will have a near blank sheet for your slide.
You can turn off these features in Excel 97-2003 as follows, but remember that you are turning off these features for all Excel usage, not just your presentation file, as the changes are made globally. To make the changes choose Tools, Options and select the View tab. In the View tab you can untick the options for Formula Bar, Status Bar, Row and Column Headers, Horizontal scroll bar, Vertical scroll bar, Sheet tabs and Gridlines. Then click OK to apply.
You can turn off these features differently in Excel 2007/2010, and the changes can be made for a specific file only. To make the changes for the current file in Excel 2007 choose the Office Button, Excel Options, Advanced. In Excel 2010 choose the File tab, Options, Advanced.
We then make changes under three sections. Firstly scroll down to the section "Display" and untick "Show formula bar". Then secondly in the section "Display options for this workbook" untick "Show horizontal scrollbar", "Show vertical scrollbar" and "Show sheet tabs". Then thirdly in the section "Display options for this worksheet" untick "Show row and column headers" and "Show gridlines". You need to do this last part for each sheet in the workbook. Then click OK to apply.
Don't forget you can also add multimedia such as sounds, animations or videos to your Excel presentation, but consider linking rather than embedding large media files such as videos to keep your Excel presentation file size at a reasonable level.
To sum up, you can create effective presentations in Excel if your content consists mainly of tables and charts by turning off many of its visual features such as row and column labels and gridlines, and then use navigation techniques such as hyperlinks, buttons or keyboard shortcuts to move between worksheets.
Interested in finding out more about Excel features and uses other than for presentations? You can learn a great deal about Excel by attending one of the many training course available and really boost your Excel skills and knowledge.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
PowerPoint Intermediate Advanced
This was fantastic. I feel more confident not only for PowerPoint but for other MS Office applications as well (and that's even though I've taken Excel and Word courses too!). I really liked the instructor's engaging teaching style. He used a lot of analogies which made things interesting and helpful to remember. I'm more excited to use PowerPoint, and feel more confident in my work role. Thanks!
PowerPoint Intermediate Advanced
Very insightful - great teacher
Not only was it informative but it was fun, thanks to the trainer, which I didn't expect as I didn't know too much to begin with!!!