Daily Office Tips by Office ToDo - podcast cover

Daily Office Tips by Office ToDo

Office ToDowww.podomatic.com
Giving daily Office tips for Word, Excel and Powerpoint so you can be more effective and have better results. For older Daily Tips please visit our website www.officetodo.com
Last refreshed:
Follow this podcast in the Metacast mobile app to refresh it and see new episodes.
Download Metacast podcast app
Podcasts are better in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episodes

140 Excel | How to add, remove or reposition chart legend?

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Legend” and from the appearing menu choose whether you wish for the legend to show in the first place, or the placement of it if you decide to show it on the graph. - Office ToDo

Jan 17, 201120 sec

139 Excel | How to add, remove or reposition text used to label each axis?

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Axis Titles” and from the appearing menu choose which axis you wish to edit. From the next selection determine whether you wish for the title to show up or not. Also choose the placement for the title if you decide to show it on the chart. Unfortunately no live preview is shown however you get a pretty good image of the display from the little picture before every selection. - Office ToDo

Jan 16, 201136 sec

138 Excel | How to add a title to the chart?

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Chart Title” and from the appearing menu choose the placement of the title. Notice that you can also remove the title under this menu. - Office ToDo

Jan 15, 201121 sec

137 Excel | How to compare pairs of values?

Best used for this is the scatter chart. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Scatter” choose the type of scatter that suits you best. Unfortunately no live preview is available on this case. - Office ToDo

Jan 14, 201124 sec

135 Excel | How to compare multiple values on a chart?

Best used for displaying multiple values comparison is a chart with bars. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Bar” choose the type of bars that suit you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Jan 12, 201125 sec

134 Excel | How to display a contribution of each value to a total on a chart?

Best used for contribution display is a pie chart. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Pie” choose the type of the pie chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Jan 11, 201127 sec

133 Excel | How to display trends over time on a chart?

Best used for trends is a chart with lines. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Line” choose the type of the line chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Jan 10, 201125 sec

132 Excel | How to change the chart type?

If you have for some reason chosen an inappropriate type of chart, you can easily change it. First select the chart and go under Chart Tools and Design tab. From there the very first button on the ribbon is called “Change Chart Type”. Click on it once and you’ll be able to try again with hopefully a more suitable chart type for you. - Office ToDo

Jan 09, 201126 sec

131 Excel | How to compare values across categories on a chart?

Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Column” choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Jan 08, 201126 sec

129 Word | How to delete a comment?

Right click on the bubble and choose “Delete Comment” from the menu. In case you wish to delete all comments in your document, go under Review tab and under Comments section. From there choose “Delete” and “Delete all comments in document”. - Office ToDo

Jan 06, 201121 sec

128 Word | How to insert a comment?

Select your text or part of the text you wish to comment and go to Review tab. Under Comments choose “New Comment”. To the right side of the document a bubble appears. Into this you can leave your comments. - Office ToDo

Jan 05, 201118 sec

123 Word | How to easily replace words in a Word document?

If you need to replace a specific word in your document, press the button “Replace” under Home tab in Editing section. Under “Find what” type the word that needs to be replaced and under “Replace with” obviously the word to be used instead. You can either click on “Replace all” to have all the words replaced at once or click on “Find next” to move to the next word and “Replace” to replace single words. - Office ToDo

Dec 31, 201033 sec

121 Word | How to sort data in Word?

In Word you can sort text, numbers and dates. Select your data and click on the button “Sort”, which is located under Home tab in Paragraph section. It also works for the data in tables. From the appearing window determine by what characteristics you would like your data to be sorted. - Office ToDo

Dec 29, 201027 sec

120 Powerpoint | How to duplicate slides inside a show?

First select the slide or slides from the Slides menu on the left. Multiple slides can be selected whilst holding down CTRL on your keyboard and pressing once on appropriate slides. Next go under Home tab into Slides section. Click on “New Slide” and choose Duplicate Selected Slides from the down appearing menu. Your slides are now appearing twice in the show. - Office ToDo

Dec 28, 201031 sec

119 Powerpoint | How to use slides from another show?

Go under Home tab into Slides section. Click on “New Slide” and choose Reuse Slides from the down appearing menu. On the right side of the screen appears a new menu. Click on “Browse” and select whether you want to browse slide library or files. Since we want to use slides from another show, we’ll browse the files. Click on the correct file and press on “Open”. Into the same right side menu a selection of slides used in the show appears. Click on the appropriate slide and notice how the slide ap...

Dec 27, 201043 sec

117 Powerpoint | How to insert comments onto my slide?

You can add comments for the slide as whole and to certain parts of text. Simply have either the slide selected from Slides menu on the left or select the text on the slide you wish to comment. Next continue to Review tab and Comments section. Click on “New Comment” to leave a comment. Note that all the comments are numbered. To hide those comments from the view, click on “Show Markup”. To view the comments, click on the same button again. To edit a comment click on “Edit Comment” that is just n...

Dec 25, 201042 sec

115 Powerpoint | How to quickly change the language?

First select the text for which you wish to change the language. Notice that on the bottom left corner of the screen you have three sections. The one on the right is the Language section. Click on the field and choose an appropriate language from the menu. - Office ToDo

Dec 23, 201019 sec

113 Powerpoint | How to get slides advancing automatically?

Select the slide and go under Animations tab and into Transition to this Slide section. Click on Advance Slide and uncheck “On Mouse Click” and check “Automatically After”. Now you need to set the time for advancing to the next slide. You can choose it by simply entering the time in the format of minutes and seconds. - Office ToDo

Dec 21, 201026 sec

112 Powerpoint | How to calculate slide duration?

Go under Slide Show tab and to Set Up section. Choose the box “Use Rehearsed Timings” and click on “Rehearse Timings”. Now you can tailor your presentation timings to your needs. You can see the seconds pass and after the determined time you need has elapsed, press on either “Next”, which is the first button in the menu and takes you to next slide or “Pause” if you want to pause the timing rehearsal or “Repeat”, which would restart the rehearsal. - Office ToDo

Dec 20, 201034 sec
For the best experience, listen in Metacast app for iOS or Android