Mastering Excel Formulas and Functions 2019

Topics

• Copying formulas and the difference between absolute and relative references
• Creating formulas to perform mathematical calculations
• Using functions to combine text strings from multiple cells
• Assigning names to cells and using them in formulas
• Using functions to perform calculations on dates and times
• Using functions to change text from lowercase to uppercase and vice versa
• The VLOOKUP function
• Using the IF function to automate data entry
• Creating complex functions the easy way

Who should Attend

Excel users.