Creating Calculations in Lists with Excel Functions

SharePoint Spotlight Series!

This course covers a number of Excel-style functions. The course is designed to assist Excel users who need to leverage what they already know about formula creation and use it in a SharePoint list. Functions and their syntax are covered here. Users wanting to use functions like SUM and AVERAGE should take this course.

What you’ll learn

  • Knowing when to use spreadsheets versus lists.
  • Review proper formula syntax.
  • Starting basic calculations.
  • Using Number functions.
  • Using Text functions.
  • Using Date functions.
  • Working with Conditional functions.

Course Content

  • Introduction –> 1 lecture • 2min.
  • Creating Calculations –> 8 lectures • 55min.
  • Conclusion –> 1 lecture • 2min.

Auto Draft

Requirements

This course covers a number of Excel-style functions. The course is designed to assist Excel users who need to leverage what they already know about formula creation and use it in a SharePoint list. Functions and their syntax are covered here. Users wanting to use functions like SUM and AVERAGE should take this course.

 

In this course you will learn more about the following topics:

 

  • Knowing when to use spreadsheets versus lists
  • Review proper formula syntax
  • Starting basic calculations
  • Using Number functions
  • Using Text functions
  • Using Date functions
  • Working with Conditional functions

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

Get Tutorial