Excel software Tip Laying out text in a cell CLIP FOCUS Laying out text can be tricky but once we've shown you a few tools you will never have a problem again.
Excel software Tip Good Spreadsheet Design CLIP FOCUS Setting up your spreadsheets well can increase, accuracy, legibility and usability. Our tips are all you need to get started.
Excel software Tip Basic Calculations CLIP FOCUS Learn how to add, subtract, multiply and divide using any of the figures in your spreadsheet.
Excel software Tip Combining IF and AND/OR Functions CLIP FOCUS Think you need an IF but have multiple rules. Well let us show you how to include And and OR functions to make Excel do exactly what you need.
Excel software Tip Using an HLookup to Categorise Data CLIP FOCUS Need to lookup one value with another such as numbers with their corresponding months, we'll show you how right from scratch including which lookup to choose and setting up your lookup table.
Excel software Tip Combing logic and text functions CLIP FOCUS How can you pull out just the initial letters from a postcode when it is sometimes one letter and sometimes two? Well it takes a combination of functions - let us show you how.
Excel software Tip The Left, Right and MID Functions CLIP FOCUS CLIP FOCUS Extract just part of the value in a cell such as the first two characters or the last using these handy functions.
Excel software Tip The Networkdays Function CLIP FOCUS CLIP FOCUS This clip will show you how to find out the number of working dates between any two dates. It's really easy and can even take into account your bank holidays.
Excel software Tip The Sumproduct function CLIP FOCUS This video will show you how to use the Sumproduct function.
Excel software Tip Using IF ISBLANK to get rid of 0s and Errors in Master and Feed sheets CLIP FOCUS When using master and feed sheets or referring to data elsewhere you may sometimes see 0s and errors where there is no source data. This neat [...]