Professional Services Agreements in Construction Live Webinar

Utilizing Formulas in Microsoft® Excel® (OnDemand Webinar)

$149.00

SKU: 410995EAU

Description

Simplify priority tasks by using Excel formulas to streamline work to save time.Are you new to Excel and struggling to understand formulas? Are you tired of manually calculating data in Excel spreadsheets? Do you want to learn how to use Excel formulas to streamline your work and save time? If so, this online training session is the perfect solution for you. Think of any scenario that involves addition, subtraction, division, or multiplication and that’s where you’d use a formula. In addition to building formulas, the session will introduce you to Functions which are builtin formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a longwinded manuallyentered formula.

Date: 2024-02-22 Start Time: End Time:

Learning Objectives

Tweet
Share
Share
Pin

Creating Basic Formulas: Addition, Subtraction, Division, Multiplication

Using Parentheses in Formulas – the What and Why

Copying a Formula – the Gotchas You Need to Know About

Make Formulas Logical and Understandable by Assigning Names to Your Important Cells

Speed up Your Work by Using the Sum, Average, and Count Functions

Tweet
Share
Share
Pin

ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Tweet
Share
Share
Pin

Mike Thomas-theexceltrainer.co.uk

Tweet
Share
Share
Pin
Professional Services Agreements in Construction Live Webinar

Utilizing Formulas in Microsoft® Excel® (OnDemand Webinar)

$149.00

SKU: 409938EAU

Description

Learn how to unlock powerful Excel formulas and features.This course provides a keen understanding of creating formulas and using the builtin functions for analysis and effective spreadsheet results. Expand your analytical capabilities and add a whole new level of depth and analysis to your worksheets.Learn how to perform calculations, return information, or manipulate the contents of other cells. Even if you already know how to apply basic formulas, you’ll discover how to structure your formulas, including mathematical, textual, and logical, to get more out of Microsoft Excel.

Date: 2022-05-26 Start Time: End Time:

Learning Objectives

Function vs. Formulas
• Most Common Formulas
• Creating a Formula
• Parts of a Formula

Using References
• Absolute References
• Relative References
• Mixed References

Understanding Workflows
• Arguments
• Order of Operations
• Nested Formulas and Functions

Shortcuts
• Autocomplete
• Formula Bar
• Built-in Functions

Troubleshooting
• View All Formulas
• Show a Formula
• Printing Formulas

AIPB ,ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Lauritta Sowa-WiseOwlOps, Inc.