The course will cover:
- Formulas/ functions between worksheets
- Creating and using Range Names
- Concatenation (joining text cells together)
- Text functions: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER,
- Date functions: TODAY, NOW
Courses in this Series:
- Microsoft Excel – Formulas and Functions (A)- Tutor led training
- Microsoft Excel – More Formulas and Functions (B)- Tutor led training
- Microsoft Excel – Logical and Look-up Functions (C)- Tutor led training
- Microsoft Excel – Data Sets and Tables- Tutor led training
- Microsoft Excel – Charts- Tutor led training
- Microsoft Excel – Pivot Tables- Tutor led training