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
…
continue reading
Marta receives a phone call out of the blue from a lawyer inviting her to attend the reading of her father's will. But no one had even told her that her father had passed away! On her arrival, she is shocked by what she sees in her father’s office and she embarks on a journey that will change her and her family’s life. La penúltima voluntad is a podcast series for advanced learners, brought to you by the Coffee Break Spanish team, and in each of the 20 episodes, we'll hear a new chapter of t ...
…
continue reading
We reach the final chapter of our story and we find out how the breakthrough in the relationship between Carlos and Marta goes beyond their emotional bond. New words to listen out for include: descabellado, enfrascados and apurar. To take your learning further, there is also an online course version of La penúltima voluntad, which provides access t…
…
continue reading
Carlos and Marta continue their conversation and admit the mistakes that they have both made in the past, however, Carlos worries about Marta's reaction to his news. Listen out for new language which includes: volver a la infancia, algunos cabos sueltos and nunca es tarde si la dicha es buena. To take your learning further, there is also an online …
…
continue reading
Carlos and Marta meet up in the square where they spent time during her childhood. They have a very honest conversation about the path that has led them both to this point. New phrases like nimiedades, encajar el golpe and ni en pintura are included in this latest episode. To take your learning further, there is also an online course version of La …
…
continue reading
Carlos returns to the same bench in the same square he used to wait for Marta after school when she was a child. Will his game and these memories convince Marta of his plan? Find out more about Carlos in this latest chapter while listening out for new phrases like llenar de elogios, tirar la toalla and de una vez por todas. To take your learning fu…
…
continue reading
1
Capítulo 16 - Lo verdaderamente importante
13:27
13:27
Play later
Play later
Lists
Like
Liked
13:27
Marta opens the briefcase using the key from the last puzzle and finds something very special that her father has been working on. Will this finally change everything? Join Marta in this emotional chapter and listen out for the new phrases: dar en la nariz and de Pascuas a Ramos. To take your learning further, there is also an online course version…
…
continue reading
In this episode we see things from Carlos' point of view and understand this character and his motives a bit better. We will get to learn phrases like la edad del pavo and dar el brazo a torcer. To take your learning further, there is also an online course version of La penúltima voluntad, which provides access to the written chapter text, annotate…
…
continue reading
In Chapter 14 we have another dialogue between Marta and her mother Pilar. While Marta continues playing her father's game, we hear many interesting expressions like olerse la tostada and ser tal para cuál along with new verbs such as entrometerse. To take your learning further, there is also an online course version of La penúltima voluntad, which…
…
continue reading
In this episode, Marta concentrates on solving the puzzle she abandoned many years ago while Pilar observes her and seems to know more than she is letting on… what could she and Carlos be hiding? As usual, the episode is packed with new and interesting words like callejón and phrases like darse por vencido and no entrar en sí. To take your learning…
…
continue reading
In this episode we go with Marta back to her childhood; to her room, to her memories and to the last puzzle she ever received from her father. Can she find what she is looking for? Listen out for the new verbs corroer and rebuscar, and can you work out what ver algo con otros ojos means? We also discover a little about university entrance processes…
…
continue reading
In Chapter 10, Pilar called Marta following a visit from an estate agent arranged by Carlos some time ago. Before Marta had the chance to uncover any information about her father, Pilar hung up the phone on her. Listen to this week's episode as Marta heads to back to her childhood home to find out what Carlos is up to. Take note of the phrases: sac…
…
continue reading
1
Capítulo 10 - ¡Esto pasa de castaño oscuro!
11:46
11:46
Play later
Play later
Lists
Like
Liked
11:46
In Chapter 10 of La penúltima voluntad, Pilar searches for Carlos and calls Marta looking for answers before finding out that Carlos has been plotting a secret plan. Throughout the episode we hear some Galician words such as fochicar and estragar as well as some interesting Spanish expressions like: ser muy suyo/a and llevar por la calle de la amar…
…
continue reading
Following her latest clue, Marta finds herself at the Teatro Clásico and is taken aback by what is waiting for her there. While listening to this chapter, pay close attention to the interesting expressions which come up, including: tener delito, moririse de ganas de, costar trabajo and al borde de. We also learn about corrales de comedia, open-air …
…
continue reading
Welcome back to the next instalment of La Penúltima Voluntad! In this chapter, Marta takes a trip down memory lane as she makes her way to the ice-cream shop that she used to visit with her parents. While looking for her next clue, Marta uncovers some important information. Be sure to listen out for some interesting nouns in this episode, including…
…
continue reading
In Chapter 7 of La penúltima voluntad, we join Marta just as she receives a phone call from her husband, Jorge. Throughout the episode, we learn more about Marta’s personal life while hearing some interesting Argentinian expressions, including: estar hecho percha, copado, bárbaro and bancar. To take your learning further, there is also an online co…
…
continue reading
It's time for the next instalment of La penúltima voluntad! After finding a riddle on the floor in the museum, Marta begins the scavenger hunt organised by her father. But where does the first clue lead to? While listening to this episode, take note of the range of nouns, including: acertijo, pista and comisura. We also hear some interesting expres…
…
continue reading
Welcome to the newest chapter of La penúltima voluntad! In this episode Marta decides to go to the museum and remembers all the places she used visit on her way there. She reminisces on some happy memories with Carlos, but the day takes a turn when she makes a discovery in the museum. Listen out for some interesting vocabulary such as: augurio, rod…
…
continue reading
It's time for another chapter of La penúltima voluntad! In this episode, we are introduced to Pilar from whom Marta tries to find out some information about Carlos. Marta is concerned about her father’s behaviour and worries something may be wrong with Carlos after receiving her inheritance. Listen out for some interesting nouns such as rifirrafe a…
…
continue reading
In Chapter 3 of La penúltima voluntad, Marta wonders what's inside the envelope that Carlos has given her. She has some ideas about what it might contain but her main concern is who will take over her father’s company in future. Will she find the answers she's looking for? Listen to the episode to find out and take note of the following verbs: albe…
…
continue reading
In this chapter, we hear the conversation between Marta and Carlos. Throughout this dialogue, in which Carols justifies his behaviour, we learn about their relationship and get to know Carlos’ character and personality. Take note of the idiomatic expression: tanto monta, monta tanto and listen out for several triggers of the subjunctive, such as ni…
…
continue reading
Marta de los Llanos receives a phone call from the family lawyer asking her to attend the reading of her father’s will. No one had even told her that her father had passed away! Marta travels to the capital to go to her parents’ house and see her mother, Pilar. There, she discovers what her father has left her, and she is shocked to see what she fi…
…
continue reading
1
Introducing La penúltima voluntad - Coffee Break Spanish Season 5
5:48
5:48
Play later
Play later
Lists
Like
Liked
5:48
Join Mark and Anabel to find out about our new series for advanced learners, La penúltima voluntad. In this series you'll follow the story of Marta and the inheritance left to her by her father. In each episode you'll be building your comprehension of Spanish and experiencing new vocabulary at this advanced level. Each episode of the podcast repres…
…
continue reading
1
140 Excel | How to add, remove or reposition chart legend?
0:20
0:20
Play later
Play later
Lists
Like
Liked
0:20
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
…
continue reading
1
139 Excel | How to add, remove or reposition text used to label each axis?
1:06:51
1:06:51
Play later
Play later
Lists
Like
Liked
1:06:51
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 …
…
continue reading
1
138 Excel | How to add a title to the chart?
1:32
1:32
Play later
Play later
Lists
Like
Liked
1:32
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
…
continue reading
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…
…
continue reading
1
136 Excel | How to emphasize differences between several sets of data over a period of time?
0:27
0:27
Play later
Play later
Lists
Like
Liked
0:27
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 areas that suit you best. Unfortunately no live preview is applicable in this case. - Office ToDo
…
continue reading
1
135 Excel | How to compare multiple values on a chart?
16:54
16:54
Play later
Play later
Lists
Like
Liked
16:54
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…
…
continue reading
1
134 Excel | How to display a contribution of each value to a total on a chart?
0:27
0:27
Play later
Play later
Lists
Like
Liked
0:27
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…
…
continue reading
1
133 Excel | How to display trends over time on a chart?
0:25
0:25
Play later
Play later
Lists
Like
Liked
0:25
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…
…
continue reading
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…
…
continue reading
1
131 Excel | How to compare values across categories on a chart?
0:26
0:26
Play later
Play later
Lists
Like
Liked
0:26
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…
…
continue reading
Go to Review tab and under Tracking section click on “Track changes” to enable them. - Office ToDo
…
continue reading
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
…
continue reading
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
…
continue reading
1
127 Word | How to toggle through Word documents opened at the same time?
0:18
0:18
Play later
Play later
Lists
Like
Liked
0:18
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
…
continue reading
1
126 Word | How to view different parts of my document at the same time?
0:23
0:23
Play later
Play later
Lists
Like
Liked
0:23
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 parts of your document simultaneously. - Office ToDo
…
continue reading
1
125 Word | How to have two Word documents open for editing in the same window?
0:20
0:20
Play later
Play later
Lists
Like
Liked
0:20
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
…
continue reading
1
124 Word | How to find a word in a Word document?
0:17
0:17
Play later
Play later
Lists
Like
Liked
0:17
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
…
continue reading
1
123 Word | How to easily replace words in a Word document?
0:33
0:33
Play later
Play later
Lists
Like
Liked
0:33
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 …
…
continue reading
1
122 Word | How to add straight lines to paragraphs?
0:19
0:19
Play later
Play later
Lists
Like
Liked
0:19
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
…
continue reading
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
…
continue reading
1
120 Powerpoint | How to duplicate slides inside a show?
0:31
0:31
Play later
Play later
Lists
Like
Liked
0:31
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 …
…
continue reading
1
119 Powerpoint | How to use slides from another show?
0:43
0:43
Play later
Play later
Lists
Like
Liked
0:43
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 pre…
…
continue reading
1
118 Powerpoint | How to change resolution for my slide show?
0:15
0:15
Play later
Play later
Lists
Like
Liked
0:15
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
…
continue reading
1
117 Powerpoint | How to insert comments onto my slide?
0:42
0:42
Play later
Play later
Lists
Like
Liked
0:42
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…
…
continue reading
1
116 Powerpoint | How to get my presentation to open up as a slide show and not in edit mode?
0:17
0:17
Play later
Play later
Lists
Like
Liked
0:17
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
…
continue reading
1
115 Powerpoint | How to quickly change the language?
0:19
0:19
Play later
Play later
Lists
Like
Liked
0:19
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
…
continue reading
1
114 Powerpoint | How to continue my slideshow from current slide?
0:17
0:17
Play later
Play later
Lists
Like
Liked
0:17
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. - Office ToDo
…
continue reading
1
113 Powerpoint | How to get slides advancing automatically?
0:26
0:26
Play later
Play later
Lists
Like
Liked
0:26
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…
…
continue reading
1
112 Powerpoint | How to calculate slide duration?
0:34
0:34
Play later
Play later
Lists
Like
Liked
0:34
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 …
…
continue reading