Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
You can change the format of all the text in an active cell or only a selected portion of it. You can also select multiple cells and apply formatting to all of the cells at once. The selected cells can be continguous or non continguous.
You can link multiple worksheets within a workbook and you can link multiple workbooks. You can do this by writing a formula in one workbook that refers to a cell, range, or name in another worksheet tab or workbook file. The benefit of this is if the data changes in one location, all linked cells will automatically update accordingly.
Use the IF logical function to test your data and calculate a value or display a word or phrase based on whether the logical test is true or false. You can use the IF function along with the AND and OR functions.
Ask us how we can service your company's training requirements.