Excel has great tools for creating beautiful charts, but what about a quick and easy trick for a simple graphical representation of your data? Here’s how the REPT function can be applied to whip up a quick and snappy looking chart.
Often when working with a spreadsheet, it becomes nessesary to extract specific bits of information from a string of data (called a substring). This video highlights the LEFT, RIGHT and MID functions that make doing this a snap.
When a part (or parts) of a data string need to be replaced with other data, the REPLACE function is you new best friend. Rather than re-enter all that data, Excel can do the work for you with this handy little gem from the function library.
The TRIM function is a great tool to help clean up your data. The function looks at your data and removes all excess spaces at the beginning, middle or end of your data.
Watch as our Excel expert takes you into the function library and reveals the usefulness of the IF function. Need specific results under two different conditions? Learn how to apply true or false statements to your formula and generate results baised on your criteria.
Fridays just feel like a day for rewards. It’s the end of the week, we’ve put in a good effort and we’re looking ahead to the weekend. Well, we’d like to give you something else on Fridays. That’s why we’re introducing, Function Fridays. Every Friday we’re going to post a new video tip on an Excel function… for free. These short tutorials get right at the heart of how to use the functions that can make your Excel life easier. Now, that sounds perfect for a Friday.
Our first tutorial is a quick tip on how to put the most recent revision date and time into a spreadsheet. Enjoy!
