SharePoint 365: Use Excel Functions in Lists
SharePoint 365 Spotlight - Creating Calculations in Lists with Excel Functions
Get access to this course
Included with any Intellezy plan.
Course description
SharePoint supports a surprisingly large number of Microsoft Excel functions. Excel users who need to collaborate on their worksheets have the option to import the data as a SharePoint list and use those functions there. 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. Function syntax is examined and demonstrated. Similarities and differences are noted as they are compared to their Excel counterparts. Importing data is reviewed along with the process for adding columns. Several use case scenarios are examined and used throughout the course during the demonstrations. There is focus on why things are being done as well as how. Specific number functions are covered next, including: SUM, AVERAGE, MAX, and MIN. Then, text functions are covered: TRIM, PROPER, CONCATENATE, RIGHT. Date functions are also included in the course: DATE, YEAR, MONTH, and DAY. Finally, IF, AND, and OR are covered to handle simple conditions and more. After covering these functions, students will understand how to use the many other functions that are not covered in this course. The concepts apply to the other functions supported by SharePoint.
What you’ll learn
- Understand the fundamentals of SharePoint 365 Spotlight - Creating Calculations in Lists with Excel Functions
- Work confidently with the core tools and features
- Build toward intermediate-level fluency
- Apply skills to real, on-the-job tasks
- Follow best practices and avoid common pitfalls
Course outline
-
Preview
Related courses
SharePoint 365 - Creating and Working with Libraries
SharePoint 365 Site User - Introduction to Document Libraries
SharePoint 365 Site User - Integration with Microsoft Office
SharePoint 365 Site User - Document Versions, Alerts, and Rules
SharePoint 365 Site User - Create, Modify and Format Views
SharePoint 365 Site User - Calendar, Gallery and Board Views
SharePoint 365 - Communication Sites, Subsites, and Site Usage
SharePoint 365 - Configuring Permissions and Site Navigation
Ready to get started?
Schedule a complimentary scoping call and we'll help you find the right plan.
Employee Training Video Library Pricing
Every Intellezy plan includes unlimited access for your entire workforce.
Agreement term
Full Library
Every course, every lesson, every update — one flat annual fee.
- AI, M365, Google Workspace, Adobe, and Business Skills Courses
- Content Available in 40 Languages
- SCORM-Compatible Courses
- WCAG AA Compliance
- New Courses and Consistent Updates
- SSO
- Onboarding Support
- User Management
- Robust Reporting
- Dedicated CSM
Select 50
Choose the 50 courses that matter most — a focused program at a lower price.
- 50 custom-selected courses
- Content Available in 40 Languages
- SCORM-Compatible Courses
- WCAG AA Compliance
- Course swapping at renewal
- New Courses and Consistent Updates
More than 250 users? We’ll tailor volume pricing to your rollout with a custom quote.
Not sure which plan is right for your organization? We'll help you find the best fit.