Excel software Tip 121 - Setting the Print Area CLIP FOCUS Want to know how to print specific areas on a spreadsheet then watch this video.
Excel Tip Conditionally formatting a whole row (RAG) CLIP FOCUS Create hyperlinks from different elements in a picture to create an interactive flow to your presentation.
Excel Tip Flash Fill CLIP FOCUS If you ever work with long lists and need to combine extract or tidy you are not going to believe how easy it can be in 2013.
<h1>Excel Tip</h1> [vimeo id="159489375" width="640" height="480" autoplay="yes"] [separator top="10" style="single"] <h2>103 - Joining Text Together</h2> [fontawesome icon="screenshot" circle="yes" size="small" iconcolor="#0f0f0f" circlecolor="#efefef" circlebordercolor="#333333" animation_type="0" animation_direction="down" animation_speed="0.1"] <strong>CLIP FOCUS</strong> Join text together in one cell, for example create a salutation from a separate title, first name and last name. [separator top="10" style="single"] <form><input [...]
Excel Tip Where You Copy And Paste In To (feed) CLIP FOCUS If you regularly get data that you need to tidy up in the same way here is a solution you might like to see.
Excel Tip Fixing Dodgy Dates In Imported Data CLIP FOCUS Here are a few tools you can try if you can't get excel to recognise dates from other systems.
Excel Tip datedif CLIP FOCUS Need to find the difference between two dates? Let us show you a function that can do this and put it straight intp the format you want.
Excel Tip Adding Up A List Of Numbers Using AutoSum CLIP FOCUS This video will take a look at how to add up a list of numbers using a built-in feature within Excel.
Excel Tip Understanding The Different Mouse Shapes In Excel CLIP FOCUS Depending on what you need to do within Excel you will encounter different mouse shapes. This video will take you through the common ones that you will see.
Excel Tip Inserting And Deleting Rows And Columns CLIP FOCUS This video will take you through the steps required in order to insert and delete rows and columns.