RISE Urban Nation

Ditching Excel: How Thurman Trotman Automates Business Solutions with SharePoint

• 2 minute read

High-Level Summary

In this episode of the Rise Urban Nation podcast, host Taryell Simmons interviews IT consultant Thurman Trotman, also known as Mr. SharePoint, about replacing inefficient spreadsheets with powerful Microsoft SharePoint solutions. Thurman explains how SharePoint lists, custom views, and Power Automate workflows eliminate data chaos, while sharing invaluable insights on self-education, networking, and business growth.

Key Takeaways

  • Ditch Spreadsheet Chaos: Managing business data through emailed spreadsheets creates version conflicts and data entry errors that centralized SharePoint lists completely eliminate.

  • Independent User Views: SharePoint list views enable team members to filter, sort, and visualize data in table or calendar formats without altering the data display for other collaborators.

  • Seamless Workflow Automation: Combining SharePoint with Power Automate allows organizations to automate multi-step email notifications and internal workflows out of the box.

  • Continuous Self-Education: Maximizing business efficiency does not require costly new software because most companies already have access to the full Microsoft 365 suite.

Detailed Outline & Topic Breakdown

Discovering SharePoint

Thurman shares how he transitioned from manual conference room scheduling as a government IT contractor to mastering SharePoint 2007 in 2009 after discovering automated calendar workflows.

Streamlining the Military Van Pool

Thurman describes building the Vehicle and Driver Management System (VDMS) on SharePoint for a colleague's van pool business, replacing disjointed spreadsheets with automated expiration alerts and linked records.

The Power of SharePoint Lists and Permissions

Thurman outlines the core architecture of SharePoint—websites, document libraries, and lists—and explains how role-based permissions allow departments like HR and finance to collaborate securely on a single intranet.

The Netflix Analogy and Data Integrity

Using Netflix as an example, Thurman illustrates why web forms are superior to emailing spreadsheets, highlighting how SharePoint prevents the creation of duplicate files and conflicting edits.

Automating Tasks with Power Automate

Thurman discusses practical automation scenarios, including podcast tracking and workplace mediation management, demonstrating how Power Automate triggers customized emails from list data.

Entrepreneurship, Mindset, and Career Journey

Thurman reflects on growing up in the Bronx, his military service, and how reading Rich Dad Poor Dad shifted his mindset to asking "How can I?" while emphasizing the value of over-delivering for clients.

Memorable Quotes

  • Thurman Trotman: "SharePoint is the way that you would use, is the way that you think you should be using Excel."

  • Thurman Trotman: "The gap between what I'm talking about and where you are now is just education. It's not money. You're already paying for the 365 suite."

  • Taryell Simmons: "A lot of my best deals came because I had a network that was working for me and my name got mentioned in rooms that my feet never even touched."

Resources, Tools, & Recommendations Mentioned

  • Microsoft SharePoint

  • Microsoft Power Automate

  • Microsoft 365 Suite

  • Rich Dad Poor Dad by Robert Kiyosaki

  • SharePoint Help Desk: https://bio.site/SPHD

Read more posts