OasisLMS

Easily automate calculations and tasks to increase efficiency, accuracy, and productivity

Are your worksheets giving you the wrong answers? Learn the need-to-know formulas and function formulas that will help you see deeper into your worksheet data. It’s time to ditch the old calculator approach to worksheet calculations and super-charge your formulas and function-formulas skillset to get the right answers from your worksheet data. We teach you how to solve simple to complex problems in creative ways by learning what formulas to use and why. Learn all the tips and tricks to best summarize and analyze your worksheet data.

What you will learn in this workshop:

• Create formulas with combinations of addition, subtraction, multiplication, and division. 
• Create function-formulas to perform mathematical, logical, and statistical calculations, that dig deep into your data. 
• Nest of combine multiple formulas and function-formulas for dynamic calculative results. 
• Learn the roles that absolute and relative referencing and parenthesis play in the formula creation process. 
• Tools to edit and troubleshoot formula errors and oversights. 
• Formula auditing tools to evaluate formulas, error checking and trace formula precedents and dependents. 
• Perform worksheet calculations without the use of formulas. 
• Link cell values within and between multiple worksheets and consolidate worksheets.

• The session will be delivered on the Zoom platform so all participants will work from their own workspace and use their own computer. Zoom has video capability but, if the participant’s computer is not equipped with a camera, audio will also work. 
• Participants should enter the Zoom training room at least 15 minutes (8:45 AM) before the start time.