SharePoint: Build List Calculations with Formulas
SharePoint 365 Spotlight - Creating Calculations in Lists with Basic Formulae
Get access to this course
Included with any Intellezy plan.
Course description
SharePoint can do a surprising number of calculations within a list. While it cannot do everything that Microsoft Excel can do, SharePoint can still do much more than most users realize. This course introduces calculations in lists. At the start, topics include the pros and cons of lists, and scenarios where Excel is compared to SharePoint to determine which home is best for data and calculations. Calculations are performed in columns, and columns are controlled by Views. This course reviews the process of creating customized Views so that column layout is easily maintained. Excel users always appreciate this. Views themselves have calculation features that enable subtotals and grand totals within lists. Proper syntax is covered next, with similarities to other Microsoft products being noted along the way. While this course focuses on calculations, functions are mentioned as a point of instruction when considering syntax. A list may be created from scratch or imported from Excel or another file. This process is explained and demonstrated. Formulae are created next, with all basic types of operations being covered. Multiple formulae are created accompanied by explanations and demonstrations. Finally, subtotals and grand totals are enabled to complete a worksheet as a list. To remove any fear that data is now trapped in SharePoint, lists with calculations are exported to Excel for further manipulation if necessary.
What you’ll learn
- Understand the fundamentals of SharePoint 365 Spotlight - Creating Calculations in Lists with Basic Formulae
- 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.