The IF statement is a useful function of Microsoft Excel that can save a great deal of time spent on analysing and annotating data manually.
It’s a versatile, advanced, formula that can be combined with other formulae where needed. This is exactly the sort of thing we’ll teach you in our Advanced Excel course.
If this is the kind of advanced Excel tip you find useful, you might also want to have a look at our tutorials on the VLOOKUP and HLOOKUP functions of Excel and Conditional Formatting in Excel.
How to Use the IF Formula in Excel
The IF formula is built on a premise of auto-populating a field with the result of a true/false test.
For example, an employer may have a bonus structure where employees get a staggered bonus payment based on how much they sell in a month. If they make more than 60 sales, they get 5 times their sales in pounds in their pay packet! If they make less than 60 sales, they get 2 times their sales.
The formula looks like this: IF (logical_test, [value_if_true], [value_if_false]).
So, using the example above, we’d say =IF(b3<60, 5, 2)
Read the rest of “Using IF Statements in Excel”
It doesn’t take long for what was a simple spreadsheet to grow and become a monstrous maze of data. These become increasingly difficult to navigate and work with, making the simplest tasks take an unnecessary amount of time.
While it’s no substitute to proper Excel Training, Microsoft included several handy shortcuts and little-used functions that once used become essential for future spreadsheet set up, manipulation and navigation.
If you find that you are spending most of your time performing the same monotonous spreadsheet tasks, such as copying data from one place to another, you need to look into is setting up your own macros.
Name your Macro and set its shortcut once you have pressed the 'Record Macro' button.
Built using VBA (Visual Basic for Applications), a Microsoft built event-driven programming language; macros allow the user to create a set of instructions which it can complete within the parameters you set. This means that you can set them up to automatically perform tasks such as cell formatting, cell selection, adding or removing rows or columns or even adding a date into your spreadsheet. Read the rest of “Time saving tips for Excel”
Microsoft have announced updates for their Office Web Apps based on feedback from users. Microsoft Excel Web App is one of the web based Office Apps available free to Hotmail users allowing you to create, access, edit and share documents anywhere with an internet connection and a browser. For full details on how to use Excel Web Apps and why they are useful read our previous post Excel Web App in Office 365. Office Web Apps are the free alternatives to Office 365 which has a monthly fee.
Microsoft Office Web Apps have faced criticism for lacking the features of Google Docs. This update addresses some of the issues associated with Excel Web App that regular Excel users have been asking for. Microsoft have had a year to listen to feedback since the launch of Office Web Apps and so this update should reflect what users have missed.
Excel Web App – New Features
Merge and Autofit Cells in Excel Web App
There have been two useful additions to cell formatting in the update – Merge and Autofit. To Merge Cells simply highlight the cells you want to merge and click the button: Read the rest of “Microsoft Announces New Features for Excel Web App”