Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can i make a slide show in microsoft excel?

user-image
Question added by Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital
Date Posted: 2013/10/09
Mostafa Hassaan
by Mostafa Hassaan , Human Resources Director (HR Director) , G4S

there is many option , try the smart art in excel tools bar (Insert), or make it in Excel and then convert it to PDF or copy paste to power point presentation

Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Microsoft Powerpoint would be the best tool for slideshows and presentations. You can incorporate data from Excel into Powerpoint and vice versa as needed.

SUBHASHISH BHATTACHARYA
by SUBHASHISH BHATTACHARYA , Asst. Manager-AutoCAD Drawing & Technical Documentation , Jindal Steel & Power Ltd.

I have tried to say the method of presentation in microsoft Excel in ,brief as follows:

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 Excel97-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 unstick 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 Excel2007/2010, and the changes can be made for a specific file only. To make the changes for the current file in Excel2007 choose the Office Button, Excel Options, Advanced. In Excel2010 choose the File tab, Options, Advanced.

We then make changes under three sections. Firstly scroll down to the section "Display" and unstick "Show formula bar". Then secondly in the section "Display options for this workbook" unstick "Show horizontal scrollbar", "Show vertical scrollbar" and "Show sheet tabs". Then thirdly in the section "Display options for this worksheet" unstick "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.

With Excel2007’s extended data handling capacities, it is possible to analyze any data set from household surveys in Microsoft Excel for EFA Monitoring. In many cases, however, it is easier to use other popular data analysis software, such as SPSS Statistics, for initial data analysis then exporting the outputs to Excel in which formatting and presentation can be further improved.

haitham hamouda
by haitham hamouda , صيانه كمبيوتر وستلايت , ديسك توب صيانه وتركيب كمبيوتر وساتلايت

try the smart art in excel tools bar (Insert), or make it in Excel and then convert it to PDF or copy paste to power point presentation

Bassam Ahmed Hamed
by Bassam Ahmed Hamed , محاسب عام , ابو فكري

فى رأيى الموضوع محتاج عمل الملف المطلوب فى microsoft excel ثم حفظه ثم فتح برنامج microsoft power point و عمل Insert للملف فى slide show

mohanad al samarah
by mohanad al samarah , مشرف وطبيب مخبر , محافظة دمشق

a best program to make slide show is powerpoint and make it open from excel program

I only know that poerpoint is the gate for slid shows. Its very simple just click F5 and let the show begin.

Mohsin Ali
by Mohsin Ali , Product Manager-Branch-less Banking , Bank Alfalah

Well the power point is actually made for presentations but if you are still eager to use excel for slide show then the best way to do is what SUBHASHISH BHATTACHARYA    has said by placing slides in seperate sheets and make a hyperlink to proceed to next sheet but don't forget to add hyperlink to previous sheet aswell because anytime anyone can ask you to go back to the previous slide(basically there will be two buttons at the end or top of the sheets with hyperlink stating previous and next)

hi for you Microsoft office2010 would be the best to make slideshow it is easy and you can learn by finger tips every option is given in tables.thanks

Rechie Caringal
by Rechie Caringal , Draftsman , Public Works Authotiy

For Presentation purposes, I would recommend Powerpoint instead

Haithm Abdulrahman Garallah
by Haithm Abdulrahman Garallah , Head Of Development Dapt. , Sahafah Yemen Agency - sahafahyemen.net

Can't you just copy the charts over to powerpoint? Or more simply, have Excel running on the computer that is hooked up to the overhead and simply click on each page you want when you want it?

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.