In this webinar, you will learn some of the most widely used formulas and functions that businesses are using, such as: Sum, Average, Text functions, Date and Time functions, round up, etc.
Training Class Goal
Students exiting this class will be more confident in using Excel formulas and functions and will have specific knowledge about some specific examples.
Prerequisites
Basic Excel skills, this class is intended for an intermediate level user.
Excel Common Formulas and Functions Webinar Topics covered.
Calculating pay raise amounts based on criteria such as years of employment
How to sum items in a list only if they meet a certain criteria you define
A formula that applies ledger shading to an entire table
How to calculate date and time correctly in formulas, etc.