Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
You can use macros to automate complex and repetitive tasks. A macro is a series of instructions that execute automatically with a single command. You can use the macros already available in Excel or create your own.
Absolute Reference is when you anchor a particular cell(s) in your formula. When you copy an absolute reference to another location, Excel does not change the absolute cell reference. However, the reference will change when it is a Relative Cell Reference.
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.