Microsoft 365 & Power Platform Training and Consulting

Tag: excel

3 Easy Ways to Import Excel Data into SharePoint or Microsoft Lists: Step-by-Step Guide

October 3, 2024
How to export SharePoint or Microsoft Lists data into Excel or CSV

September 26, 2024
Microsoft Lists vs Excel: When to use which

September 19, 2024
How to use Excel’s SUMIF function to calculate totals by category

March 23, 2023
How to get a distinct count of unique values in Excel

September 22, 2022
How to get total week days or business days between dates in Excel

December 10, 2021
Delete random blank Excel cells and shift remaining cells left to fill the gaps

September 30, 2020
Workaround: Export to Excel not working in Safari, Chrome, or other non-IE browsers for SharePoint server list exports

December 10, 2019
Capitalize whole words or first letters of each word in Excel cells

June 24, 2019
Filter even or odd rows in Excel

June 23, 2019