Podcasts by Daily Office Tips by Office ToDo
Further podcasts by Office ToDo
Podcast on the topic Technologie
All episodes
140 Excel | How to add, remove or reposition chart legend? from 2011-01-17T23:02:35
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...
Listen
139 Excel | How to add, remove or reposition text used to label each axis? from 2011-01-16T23:01:32
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 determin...
Listen
138 Excel | How to add a title to the chart? from 2011-01-15T23:01:03
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 t...
Listen
137 Excel | How to compare pairs of values? from 2011-01-14T23:01:49
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 ty...
Listen
136 Excel | How to emphasize differences between several sets of data over a period of time? from 2011-01-13T23:01:47
Best used for this is area charts. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Area” choose the type of are...
Listen
135 Excel | How to compare multiple values on a chart? from 2011-01-12T23:01:21
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 sectio...
Listen
134 Excel | How to display a contribution of each value to a total on a chart? from 2011-01-11T23:01:26
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 t...
Listen
133 Excel | How to display trends over time on a chart? from 2011-01-10T23:01:19
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 typ...
Listen
132 Excel | How to change the chart type? from 2011-01-09T23:01
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 ...
Listen
131 Excel | How to compare values across categories on a chart? from 2011-01-08T23:01:28
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 “Colum...
Listen
130 Word | How to enable track changes? from 2011-01-07T23:01:35
Go to Review tab and under Tracking section click on “Track changes” to enable them. - Office ToDo
Listen
129 Word | How to delete a comment? from 2011-01-06T23:01:39
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 “Del...
Listen
128 Word | How to insert a comment? from 2011-01-05T23:01:12
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 ...
Listen
127 Word | How to toggle through Word documents opened at the same time? from 2011-01-04T23:01:08
One way, if you prefer not going to the taskbar, is to go under View tab and Window section. Click on “Switch Windows” and choose the document. - Office ToDo
Listen
126 Word | How to view different parts of my document at the same time? from 2011-01-03T23:01:11
Go to View tab under Window section and press on “Split”. You’ll get an opportunity to place the point where the split is created. Click once and a split is placed. Now you can view and edit two pa...
Listen
125 Word | How to have two Word documents open for editing in the same window? from 2011-01-02T23:01:02
First have those two documents open. From one document go under View tab and in Window section choose “Arrange All”. This way you’ll have two documents opened in one window. - Office ToDo
Listen
124 Word | How to find a word in a Word document? from 2011-01-01T23:00:58
Go under Home tab into Editing section and press on “Find”. In the new window type the word you wish to find and click on “Find next”. - Office ToDo
Listen
123 Word | How to easily replace words in a Word document? from 2010-12-31T23:01:08
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 w...
Listen
122 Word | How to add straight lines to paragraphs? from 2010-12-30T23:01:24
The paragraphs work a lot like tables. Have your cursor in your selected paragraph and work around with the selections under Paragraph section and Borders button. - Office ToDo
Listen
121 Word | How to sort data in Word? from 2010-12-29T23:01:12
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 a...
Listen
120 Powerpoint | How to duplicate slides inside a show? from 2010-12-28T23:01:28
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 H...
Listen
119 Powerpoint | How to use slides from another show? from 2010-12-27T23:01:12
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 wh...
Listen
118 Powerpoint | How to change resolution for my slide show? from 2010-12-26T23:01:05
Go to Slide Show tab under Monitors section. From Resolution choose the appropriate setting. These settings will impact only the slide show itself. - Office ToDo
Listen
117 Powerpoint | How to insert comments onto my slide? from 2010-12-25T23:01
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. Nex...
Listen
116 Powerpoint | How to get my presentation to open up as a slide show and not in edit mode? from 2010-12-24T23:01:10
Under Office button there’s Save As menu. From there instead of PowerPoint presentation choose PowerPoint Show. Give your show a name and click on Save. - Office ToDo
Listen
115 Powerpoint | How to quickly change the language? from 2010-12-23T23:01:27
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 ...
Listen
114 Powerpoint | How to continue my slideshow from current slide? from 2010-12-22T23:01:25
Notice that on the bottom right corner there’s a zoom in and out bar and just next to it there’s an icon called “Slide Show”. Just click on it and the show will continue from the current slide. - ...
Listen
113 Powerpoint | How to get slides advancing automatically? from 2010-12-21T23:01:39
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 ...
Listen
112 Powerpoint | How to calculate slide duration? from 2010-12-20T23:01:35
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 se...
Listen
111 Powerpoint | How to change the size of the slides so that they are suitable for a widescreen? from 2010-12-19T23:01:18
For changing the size of the slides, go under the Design and to the Page Setup section. Click on the “Page Setup” button and from the appearing menu under the “Slides sized for” selection choose “O...
Listen
110 Excel | How to easily apply different colors to cells depending on their value? from 2010-12-18T23:01:42
To have Excel apply the coloring depending on the values inside the cells, you should apply color scales. To do this, select the cells you wish to be analyzed and go under Home tab into Styles sect...
Listen
109 Excel | How to compare values visually? from 2010-12-17T23:01:29
Perhaps the easiest way is to enter the data bars inside the cells. To do this, select the cells you wish to be analyzed and go under Home tab into Style section. From the row click on the first bu...
Listen
108 Excel | How to clear conditional formatting rules? from 2010-12-16T23:01:47
First select the cells or just one cell depending on whether there’s a specific area you wish to clear from rules or you wish for the whole sheet to be free from formatting rules. Next go under Hom...
Listen
107 Excel | How to see below average numbers within the list? from 2010-12-15T23:01:41
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Below Average …” F...
Listen
106 Excel | How to see above average numbers within the list? from 2010-12-14T23:01:11
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Above Average …” F...
Listen
105 Excel | How to see bottom ten percent of items on the list? from 2010-12-13T23:01:37
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Bottom 10 % …” In ...
Listen
104 Excel | How to see bottom values within my list? from 2010-12-12T23:01:07
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Bottom 10 Items …...
Listen
103 Excel | How to see top ten percent of your items on the list? from 2010-12-11T23:01:20
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Top 10 % …” In the...
Listen
102 Excel | How to see top values within my list? from 2010-12-10T23:01:22
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Top 10 Items …” In...
Listen
101 Excel | How to have cells automatically formatted if they contain specific text? from 2010-12-09T23:01:34
Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” an...
Listen
100 Word | How to clear all formatting easily? from 2010-12-08T23:01:48
On the ribbon under Home tab in Font section there’s a button at the top right corner called “Clear Formatting”. Select your text and click it to clear all formatting and have a Normal plain text. ...
Listen
099 Word | How to have Word automatically update certain fields of text? from 2010-12-07T23:01:11
On the ribbon there's Quick Parts option under Insert menu. The Document Property inserts for example information pulled from properties. You can enter to your document the fields and every time yo...
Listen
098 Word | How to add a word manually to custom dictionary? from 2010-12-06T23:01:23
Go to the Office button, choose Word Options and under Proofing choose Custom Dictionaries. Select the first option - "Edit Word List" and add your word to the list. - Office ToDo
Listen
097 Word | How to insert a reference? from 2010-12-05T23:01:14
Go with your cursor to the end of the sentence or a word you wish to add a reference to. Then go to References tab and click on “Insert Footnote”. Now you can enter the reference into the footnote....
Listen
096 Word | How to have Word not replace the selected text after typing? from 2010-12-04T23:01:30
Go to the Office button and press on “Word options”. Go under Advanced menu and remove a tick from “Typing replaces selected text”. - Office ToDo
Listen
Word | How to add a transparent Text Box onto an image? [Ipod Version] from 2010-12-04T00:01:17
First make sure you haven’t selected the image. To enter a transparent Text Box that will be visible on top of the image, go to the Insert tab and press on Text Box. Choose the Simple Text Box and ...
Listen
Word | How to add a transparent Text Box onto an image? [High Quality] from 2010-12-03T23:01:25
First make sure you haven’t selected the image. To enter a transparent Text Box that will be visible on top of the image, go to the Insert tab and press on Text Box. Choose the Simple Text Box and ...
Listen
Word | How to show or hide the paragraph signs in my text? [Ipod Version] from 2010-12-03T00:01:15
Go to the ribbon onto the Home tab under Paragraph section. Click on the icon at the top right corner. - Office ToDo
Listen
Word | How to show or hide the paragraph signs in my text? [High Quality] from 2010-12-02T23:01:28
Go to the ribbon onto the Home tab under Paragraph section. Click on the icon at the top right corner. - Office ToDo
Listen
Word | How to change the lining of the entire paragraph? [Ipod Version] from 2010-12-02T00:01:08
Have your cursor in the paragraph and drag the bottom square on the ruler. This will change the left indent for the entire paragraph. - Office ToDo
Listen