TechMilestoneHub

Category: MS365 SharePoint

  • 7 – Workflows in Microsoft SharePoint

    Table of Contents

    1. Automating Email Notifications in SharePoint (Create & Test a Rule)
    2. Send Email Alerts When an Associate Is Assigned in SharePoint

    • Automating Email Notifications in SharePoint (Create & Test a Rule)

    In this section, you’ll learn how to create a simple automation rule in SharePoint that sends an email whenever a new item is added to a list. This is especially useful for tracking new customers, support tickets, requests, or any important entries.

    Instead of manually checking your list for updates, SharePoint can automatically notify you. 🚀

    🔔 Why Use Automation Rules?

    Automation rules in SharePoint help you:

    • 📩 Receive instant email notifications
    • ⏳ Reduce manual follow-ups
    • 👀 Stay informed about important changes
    • ⚙️ Turn rules on or off anytime
    • 🛠 Manage rules easily from one place

    In this example, we’ll set up a rule that sends an email whenever a new customer is added to a Customers list.

    Video Explanation

    🛠️ Create an Automation Rule (Item Created)

    Automation rules are created directly from the list where you want the trigger to happen.

    Step-by-Step Instructions

    1. Open your SharePoint list (e.g., Customers).
    2. At the top menu, click Automate.
    3. Select Rules from the dropdown.
    4. Click Create a rule.

    You will see three rule options:

    Rule TypeWhen It Triggers
    🆕 Item CreatedWhen a new item is added
    ✏️ Item ModifiedWhen an existing item is changed
    🗑 Item DeletedWhen an item is removed
    1. Choose Item Created.
    2. Select who should receive the notification (e.g., yourself or another team member).
    3. (Optional) Add a custom message.
    4. Click Create.

    ✅ Your rule is now active.

    You’ll see:

    • A short description of the rule
    • A toggle switch to turn it ON/OFF
    • The ability to manage it later via Automate → Manage Rules

    This gives you full control over your notifications.

    🧪 Test the Automation Rule

    Now that the rule is created, let’s confirm it works.

    Add a New Item

    1. Go to your list.
    2. Click Add New Item.
    3. Fill out all required fields.
    4. Click Save.

    The moment you save the new entry, SharePoint triggers the rule.

    📬 Verify the Email Notification

    1. Open your Outlook (or email client).
    2. Check your inbox.

    You should receive:

    • A notification email
    • Details about the newly created item
    • A link to open the list item directly

    🎉 If the email arrives, your automation is working perfectly.

    🔄 Managing Your Rules Later

    You can always:

    • Edit the rule
    • Disable it temporarily
    • Delete it completely

    To do this:

    • Go to Automate → Manage Rules

    This makes it easy to adjust automation as your workflow evolves.

    ✅ Quick Recap

    • Automation rules help you stay updated automatically
    • You can trigger notifications for created, modified, or deleted items
    • Rules can be enabled, disabled, or edited anytime
    • Testing confirms everything is working as expected

    By using SharePoint automation rules, you make your lists smarter and your workflow more efficient. 🚀

    Send Email Alerts When an Associate Is Assigned in SharePoint

    In this section, you’ll learn how to automatically notify an employee when they are assigned to a customer in a SharePoint list. This is a practical real-world scenario where responsibility changes need to be communicated immediately.

    Instead of manually informing associates when they are assigned to a customer, SharePoint can handle this automatically using built-in automation rules. 🚀

    🎯 Why This Rule Is Useful

    When working with a Customers list, you may have a column called Associate (Person or Group type).

    If someone changes the associate assigned to a customer:

    • 📩 The new associate needs to know immediately
    • ⏳ You avoid delays in task ownership
    • 🔄 Responsibility transitions smoothly
    • 👀 No one misses important assignments

    This rule ensures that whenever the Associate field changes, the new associate receives an automatic email notification.

    Video Explanation

    🛠️ Create a Rule for “Item Modified” (Associate Field Change)

    To notify associates when they are assigned to a customer, we need to create a rule that triggers when the Associate column is modified.

    Step-by-Step Instructions

    1. Open your SharePoint list (e.g., Customers).
    2. Click Automate in the top menu.
    3. Select Rules.
    4. Click Create a rule.
    5. Choose Item Modified.

    You will now configure the condition.

    ⚙️ Configure the Trigger Condition

    After selecting Item Modified, you’ll be asked which column change should trigger the alert.

    1. Select the Associate column from the dropdown.
    2. Set the condition so that the rule triggers when:
      • The Associate value changes (to any new value).

    💡 You do NOT need to specify a particular name.
    The goal is to notify whoever becomes the new associate.

    📩 Configure the Email Notification

    Next, set up who should receive the notification.

    • Choose to notify the Associate column value (the new assigned person).
    • Add a custom message if desired.

    Example custom message:

    “You have been reassigned to this customer.”

    This makes the email clearer and more professional.

    Finally:

    • Click Create.

    ✅ Your rule is now active.

    🧪 Test the Rule

    To confirm everything works:

    1. Open a customer item.
    2. Click Edit.
    3. Change the Associate field to another user.
    4. Click Save.

    Now check the newly assigned associate’s email inbox.

    📬 They should receive:

    • An email notification
    • The name of the customer
    • Your custom message
    • A link to the list item

    If the email arrives, your automation is working perfectly.

    🔍 What This Rule Achieves

    ScenarioResult
    Associate is reassignedNew associate gets notified
    Responsibility changesNo manual follow-up needed
    Customer ownership updatesImmediate awareness

    ✅ Quick Recap

    • Use Item Modified rules for field change notifications
    • Select the Associate column as the trigger
    • Notify the new value (the new associate)
    • Add a custom message for clarity
    • Test by editing the list item

    By using this automation, you ensure that team members are instantly informed when they are assigned new responsibilities — improving accountability and workflow efficiency. 🚀

  • 6 – Additional Useful Features in SharePoint

    Table of Contents

    1. Searching, Collaboration, Navigation & RSS Feeds in SharePoint

    • Searching, Collaboration, Navigation & RSS Feeds in SharePoint

    In this section, you’ll explore some everyday SharePoint features that help you find information faster, collaborate with your team, navigate easily, and stay updated automatically.
    These tools may look simple, but together they make SharePoint feel less like a storage system and more like a smart workspace.

    💡 Why these features matter

    Video Explanation

    🔍 Searching in SharePoint

    SharePoint includes a powerful global search system available at the top of every site. It doesn’t just search file names — it searches inside files, lists, pages, images, and even metadata tags.

    This means you can locate almost anything across your workspace in seconds.

    1. Go to the search bar at the top of SharePoint.
    2. Type your keyword or phrase.
    3. Press Enter or click the 🔍 icon.

    Refine your results

    After searching, you can narrow results using:

    Tabs

    Filters

    ➡️ Clicking a result opens the exact item location, including breadcrumbs showing where it exists in SharePoint.

    💬 Collaboration & Social Features

    Modern SharePoint pages include interactive elements similar to social media platforms. Instead of emailing updates, conversations can happen directly on the content itself.

    This keeps communication contextual and organized.

    Collaboration tools available

    How to interact with a page

    1. Scroll to the bottom of a modern page.
    2. Click Like or type a comment.
    3. Use @Name to notify someone.
    4. Click Post to share.

    📢 Mentioned users receive a notification, helping teams respond quickly without separate messages.

    Page insights you can view

    🧭 Navigating the SharePoint Home Page

    The SharePoint Home page is a global dashboard — different from a site homepage.
    It acts as your personal starting point across all sites and content.

    You can return to it anytime using the Home icon (top left).

    What you’ll find here

    Frequently used sites

    Shortcut icons

    My Lists feature

    Shows every list you created across SharePoint — even from different sites.

    Each list displays:

    Create menu

    The Create (+) button lets you quickly create:

    ➡️ Think of this page as your SharePoint control center.

    📡 Creating an RSS Feed in SharePoint

    RSS feeds automatically notify you when changes occur in a list or library.
    Instead of checking manually, updates come to your RSS reader.

    This is especially useful for tracking uploads, edits, or team activity.

    Why use RSS feeds

    1. Open your SharePoint list or library.
    2. Switch to Classic View.
    3. Click the Library/List tab in the ribbon.
    4. Select RSS Feed.
    5. Copy the generated link.

    What happens after subscribing

    Whenever content changes:

    ➡️ Your RSS reader collects these updates automatically, keeping you informed without opening SharePoint repeatedly.

    ✅ Quick Recap

    Together, these features improve productivity by reducing navigation time and keeping everyone informed.

  • 5 – SharePoint Permissions : Step-by-step Video Guide

    Table of Contents

    1. 👥 Managing User Permissions in SharePoint (Visitors, Owners & Removal)
    2. Managing Default and Custom Permissions in SharePoint

    • 👥 Managing User Permissions in SharePoint (Visitors, Owners & Removal)

    Permissions are one of the most important parts of SharePoint. They control who can view, edit, or fully manage your site.
    Instead of giving everyone the same access, SharePoint organizes users into groups — making security easier and safer to manage.

    In this section, you’ll learn how to:

    🔐 Best Practice: Always grant the least privilege first. You can increase access later, but preventing accidental edits is much harder after they happen.

    Video Explanation

    🔹 Invite a User as a Visitor (Read-Only Access)

    Visitors are users who can view content but cannot edit anything.
    This is ideal for stakeholders, auditors, or team members who only need to read information.

    When added to the Visitors group, the user can open pages, lists, and documents — but editing options are hidden.

    What Visitors Can Do

    What Visitors Cannot Do

    Steps to Add a Visitor

    1. Click the ⚙ Settings icon (top right)
    2. Select Site permissions
    3. Scroll down and click Advanced permission settings
    4. Locate the Visitors group
    5. Click Grant Permissions
    6. Enter the user’s name or email
    7. Choose the Visitors group
    8. (Optional) Add a message
    9. Click Share / OK

    The user receives an email invitation and is automatically added after opening the link.

    💡 Tip: If a user should only see information and not modify it — always use the Visitors group.

    🔹 Promote a User to Site Owner (Full Control)

    Owners have the highest level of access in SharePoint.
    They can manage permissions, edit content, and configure the site.

    Only assign this role to trusted individuals responsible for maintaining the site.

    Owners Can

    Steps to Make a User an Owner

    1. Go to ⚙ Settings → Site permissions
    2. Open Advanced permission settings
    3. Select the Owners group
    4. Click New → Add users to this group
    5. Enter the user’s name
    6. Add a message (optional)
    7. Click Share / OK

    After accepting the email invitation, the user becomes a site owner immediately.

    ⚠️ Important: Owners can grant permissions to others — only assign this role when necessary.

    🔹 Remove a User from a Permission Group

    Sometimes access needs to be revoked — for example when a project ends or a team member changes roles.
    Removing a user from a group immediately updates their permissions.

    If they belong to multiple groups, they will still keep access from the remaining groups.

    Steps to Remove a User

    1. Go to ⚙ Settings → Site permissions
    2. Click Advanced permission settings
    3. Open the group (e.g., Owners)
    4. Select the user
    5. Click Actions → Remove users from group
    6. Confirm the removal

    The permission change takes effect instantly after refresh.

    🧠 Reminder: Removing from Owners does not remove access completely if the user still belongs to Members or Visitors.

    ✅ Quick Permission Overview

    GroupAccess LevelTypical Use
    VisitorsRead-onlyStakeholders, viewers
    MembersEdit contentTeam contributors
    OwnersFull controlSite administrators

    Proper permission management keeps your SharePoint environment secure, organized, and collaborative — while preventing accidental changes or data loss.

    Managing Default and Custom Permissions in SharePoint

    In this section, you’ll learn how SharePoint permissions actually work — not just how to click buttons, but why they’re structured this way.
    SharePoint follows a security model based on permission levels → assigned to groups → groups contain users.

    Understanding this flow is important because:

    Once you understand the default permissions, creating your own secure setup becomes much easier.

    Video Explanation

    1) Understanding Default Permission Levels

    Before creating custom permissions, it’s important to understand how SharePoint’s built-in permissions are structured.

    SharePoint comes with predefined groups and permission levels:

    Default Groups

    Each group is assigned a permission level, and that permission level is actually a collection of many smaller capabilities (view, edit, delete, manage site, etc.).

    How to View Default Permission Levels

    1. Click the Settings (⚙️) icon (top-right)
    2. Select Site permissions
    3. Click Advanced permission settings
    4. In the top menu, click Permission Levels

    You will see levels such as:

    Example: What “Read” Permission Allows

    Allowed

    Not Allowed

    👉 This is why Visitors can see content but cannot modify anything.

    Key Idea:
    The Read permission is intentionally restrictive — it protects your data while still allowing access.

    2) Creating a Custom Permission Level

    Sometimes default permissions are too broad.

    Example:

    So you create a custom permission tailored exactly to your needs.

    In our case:
    We want users to read and edit items but not fully control the site.

    Steps to Create Custom Permission

    1. Go to Permission Levels page (same place as above)
    2. Open the Read permission level
    3. Click Copy Permission Level

    Now configure it:

    Name: Read and Edit
    Description: Can read and edit items

    Modify Permissions

    Keep everything from Read AND additionally enable:

    Then click Create

    You now have a new permission level available alongside default ones.

    💡 Best Practice
    Create permissions based on real job responsibilities, not convenience.

    3) Create a Group and Assign the Custom Permission

    Permissions should be assigned to groups, not directly to users.
    This keeps your site manageable as your team grows.

    Why Use Groups?

    Create a New Group

    1. Go to Advanced permission settings
    2. Click Create Group

    Fill details:

    Group Name: Read and Edit Group
    Description: Members can read and edit

    Under Give group permissions to this site
    ✔ Select Read and Edit

    Click Create

    Add a User to the Group

    Now add people who should have this access.

    1. Open the newly created group
    2. Click New
    3. Enter the user name
    4. Add a message (optional)
    5. Click Share

    The user is now part of the group and automatically inherits permissions.

    What the User Can Do Now

    Because the user belongs to the custom group:

    They CAN

    They CANNOT

    This proves the custom permission works exactly as designed.

    Key Takeaways

    Using this approach keeps your SharePoint environment secure, organized, and easy to maintain as your organization grows.

  • 4 – Lists in SharePoint: A Video Guide

    Table of Contents

    1. 📋 Creating Lists in SharePoint
    2. ✏️ Editing Lists in SharePoint
    3. 🧩 Working with SharePoint List Features
    4. ⚙️ Working with Advanced Column Types in SharePoint Lists
    5. 🧮 Working with Calculated Columns in SharePoint
    6. 🔗 Creating and Using Lookup Columns in SharePoint Lists
    7. 💬 Adding Comments and Tracking Version History in SharePoint Lists
    8. 🧩 Working with Columns and Conditional Fields in SharePoint Lists
    9. ✅ Ensuring Proper Form Validation in SharePoint Lists
    10. 📅 Calendar View in a SharePoint List
    11. 🔔 Working with Alerts in Microsoft SharePoint
    12. 📤 Working with SharePoint Lists: Exporting and Deleting Data

    • 📋 Creating Lists in SharePoint

    SharePoint Lists are like smart, collaborative tables where teams can store, track, and manage information. Think of them as an upgraded version of Excel—built directly into SharePoint with powerful features like filtering, automation, and integration with Microsoft 365 tools.

    In this section, you’ll learn the different ways to create a list:

    Video Explanation

    🚀 Why Use SharePoint Lists?

    Before jumping into the steps, here’s why lists are so useful:

    🧱 Method 1 – Create a List from Excel

    If you already have data in Excel, you don’t need to retype anything.

    Step-by-Step

    1. Prepare Excel Data
    2. Import to SharePoint
    3. Configure Columns
    4. Create the List

    ✅ Your Excel data is now a fully functional SharePoint list!

    🧱 Method 2 – Create a List from Scratch

    Perfect when starting fresh.

    Steps

    1. Go to New → List → Blank List
    2. Give your list a name
    3. By default, you’ll get a Title column
    4. Add custom columns:
    1. Add items using New Item

    💡 Tip: You can rename the Title column to something meaningful like Employee ID.

    🧱 Method 3 – Create from an Existing List

    Reuse structure without rebuilding everything.

    1. Click New → List → From Existing List
    2. Choose a list to copy
    3. Give the new list a name
    4. Click Create

    👉 The new list will contain the same columns and settings.

    🧱 Method 4 – Use SharePoint Templates

    SharePoint includes ready-made list templates like:

    Just:

    1. Select New → List
    2. Scroll to Templates
    3. Pick one
    4. Name it → Create

    Instant professional structure! 🎉

    🎯 What You’ve Learned

    You can now create SharePoint lists:

    These lists can become the backbone of tracking customers, employees, assets, projects, and more.

    ✏️ Editing Lists in SharePoint

    SharePoint lists aren’t just for storing data—they’re meant to be edited, updated, and customized as your team works. SharePoint gives you multiple ways to modify list items: quick single-item edits, bulk updates using grid view, and even advanced customization through content types and form layouts.

    Let’s walk through the most practical ways to edit and manage your SharePoint lists.

    Video Explanation

    📝 Edit a Single List Item

    This is the most common method when you need to update one record or attach supporting files.

    How to edit an item:

    1. Go to your list from Site Contents
    2. Click the item you want to update
    3. Select Edit from the top menu (or from the three dots ⋯ menu)
    4. Update the fields in the form
    5. (Optional) Upload files in the Attachments section
    6. Click Save

    💡 Best for: Quick corrections, adding documents, or updating one record at a time.

    🔓 Enable “Allow Management of Content Types”

    Sometimes you may find that certain items can’t be edited. This usually happens because content type management is turned off.

    Enable it like this:

    After this:

    💡 Why this matters:
    It unlocks deeper control over list structure and ensures full editing flexibility.

    📊 Edit in Grid View (Excel-Style Editing)

    Need to update many rows fast? Grid view turns your list into a spreadsheet.

    Steps:

    1. Open the list
    2. Click Edit in grid view
    3. Update cells directly like Excel
    4. Click Exit grid view to save

    ⚡ Best for: Bulk updates, data cleanup, and fast entry.

    🧩 Powerful Features in the Edit Form

    The SharePoint edit form includes more than just fields:

    These tools help you turn a simple list into a collaborative workspace.

    🎯 Key Takeaways

    With these options, SharePoint lists become flexible tools that adapt to how your team works—not the other way around. 🚀

    🧩 Working with SharePoint List Features

    SharePoint lists are more than simple tables—they’re interactive tools designed to help you explore, organize, and collaborate on data. In this section, we’ll look at some of the most useful built-in list features: sharing individual items, sorting and grouping, using the filter pane, and calculating column totals.

    These features make large datasets easier to understand and help teams work smarter together. 🚀

    Video Explanation

    🔗 1. Item Page in a SharePoint List

    Every list item has its own dedicated page where you can view details, track activity, and collaborate through comments.

    What you can do:

    How to share an item link:

    1. Open your list and select an item
    2. Click the three dots ⋯ next to it
    3. Choose Copy Link
    4. Share the URL with teammates

    💡 Perfect for: Sending someone directly to one record instead of the whole list.

    📊 2. Sort and Group Your Data

    Large lists can feel overwhelming—sorting and grouping help bring order.

    Benefits

    Try this:

    👉 To return to normal view, open the column menu again and uncheck Group by.

    🎯 3. Use the Filter Pane

    The filter pane lets you narrow results across multiple columns at once—great for big datasets.

    Steps

    1. Click the filter icon (top right)
    2. Select values from one or more columns
    3. Click Apply
    4. Use Clear All to reset

    Example:
    Filter Office = Toronto AND Brand = Mercedes to see only matching records.

    💡 Ideal for: Finding exactly what you need in seconds.

    ➕ 4. Column Totals

    Need quick calculations? SharePoint can show them directly in the list view.

    Available options

    How to enable totals:

    ✅ Key Takeaways

    With these features, SharePoint lists become a powerful dashboard for everyday teamwork—no technical skills required! 💪

    ⚙️ Working with Advanced Column Types in SharePoint Lists

    SharePoint lists become truly powerful when you move beyond simple text columns. By using advanced column types, you can tag items, assign ownership, and manage dates with precision—making your data easier to organize, search, and analyze.

    Let’s explore three essential column types:

    Video Explanation

    🏷 1. Multi-Select Choice Column – Smart Tagging

    Tags help categorize records so you can filter and group them later. A Choice column with multi-select lets users assign multiple labels to the same item.

    How to create it:

    1. Open your list → Add Column → Choice
    2. Name the column (e.g., Tags)
    3. Enter options such as:
    4. Enable Allow multiple selections
    5. (Optional) Turn on Allow values to be added manually
    6. Click Save

    What users see:
    When editing an item, they can pick multiple tags from a dropdown—perfect for flexible categorization.

    💡 Great for: Customer segmentation, project labels, priority flags.

    👤 2. Person or Group Column – Assign Ownership

    Need to assign a record to someone in your organization? The Person/Group column connects directly to your company directory.

    Steps to add:

    1. Click Add Column → Person or Group
    2. Name it (e.g., Associate)
    3. Enable Show profile photos (optional)
    4. Click Save

    How it works:

    💡 Perfect for: Assigning cases, owners, reviewers, or contacts.

    📅 3. Date Column – Convert Text to Real Dates

    If dates are stored as plain text, you lose sorting, filtering, and validation. Converting to a Date and Time column unlocks powerful features.

    Convert an existing column:

    1. Click the column header
    2. Select Column Settings → Edit
    3. Change type to Date and Time
    4. Optional:
    5. Click Save

    Result:
    Your dates can now be sorted chronologically, filtered by range, and used in automation.

    💡 Essential for: Birthdays, deadlines, renewals, and schedules.

    ✅ Why These Columns Make a Difference

    Column TypeBusiness Benefit
    Multi-Select ChoiceFlexible tagging & filtering
    Person/GroupClear ownership & collaboration
    DateAccurate time-based operations

    🎯 Final Thoughts

    Using the right column types transforms a basic SharePoint list into a smart information hub. You’ll get:

    Start upgrading your lists today and watch your data come to life! 🚀

    🧮 Working with Calculated Columns in SharePoint

    Ever wished SharePoint could do the math for you? That’s exactly what calculated columns are for! Instead of manually entering values like age, totals, or status messages, SharePoint can generate them automatically using formulas.

    For example, if your list has a Date of Birth column, you can create an Age column that updates itself—no manual updates needed. Let’s dive in!

    Video Explanation

    ✅ What Are Calculated Columns?

    A calculated column generates its value using data from other columns in the same list. It’s perfect for:

    🛠 How to Create a Calculated Column

    Step 1 – Add a New Column

    1. Open your SharePoint list
    2. Click Add Column
    3. Choose See all column types → click Next

    Step 2 – Select Calculated Type

    Step 3 – Enter the Formula

    To calculate age from Date of Birth:

    =DATEDIF([Date of Birth], TODAY(), "Y")

    Step 4 – Set Return Type

    Step 5 – Save 🎉

    Click OK—your Age column will now calculate automatically!

    💡 Tips for Writing Formulas

    📌 Useful Calculated Column Examples

    1. Create Full Name

    =[First Name] & " " & [Last Name]

    ➡ Combines two text fields with a space.

    2. Status Based on Percentage

    =IF([Completion] >= 100, "Completed", "In Progress")

    3. Add Price + Tax

    =[Price] + [Tax]

    4. Overdue Check

    =IF([Due Date] < TODAY(), "Overdue", "On Track")

    5. Days Remaining

    =[Due Date] - TODAY()

    6. Value Category

    =IF([Amount] >= 1000, "High Value", "Standard")

    7. Discounted Price

    =[Price] - ([Price] * [Discount]/100)

    8. Show Month Name

    =TEXT([Order Date], "mmmm")

    9. Time-Based Greeting

    =IF(HOUR(NOW())<12,"Good Morning","Good Afternoon")

    🚀 Why Calculated Columns Are Awesome

    🎯 Final Thoughts

    Calculated columns turn a simple SharePoint list into a mini application. Whether you’re calculating age, totals, statuses, or messages—SharePoint does the heavy lifting while you focus on insights.

    Start experimenting with formulas and make your lists work smarter, not harder! 💪

    🔗 Creating and Using Lookup Columns in SharePoint Lists

    Lookup columns are one of the most powerful features in SharePoint lists. They allow you to connect two lists together, so data can be reused instead of duplicated.

    For example, instead of typing the same repair shop details for every customer, you can maintain a separate Repair Shops list and simply link customers to it. Any updates to the shop details will automatically reflect in the Customers list. Smart, right? 😎

    Video Explanation

    ✅ Why Use Lookup Columns?

    1️⃣ Create a Source List (Repair Shops)

    Before creating a lookup column, we need a list that will act as the data source.

    🛠 Steps

    1. Go to your SharePoint site → New → List
    2. Choose Blank List and name it Repair Shops
    3. Add these columns:
    4. Rename the Title column → Shop ID (acts as unique identifier)

    ✏ Add Sample Data

    Shop IDShop NameEmailCity
    101QuickFix Repairsinfo@quickfix.comToronto

    🎉 This list will now be used as the lookup source.

    2️⃣ Create Lookup Column in Customers List

    Now we’ll connect the Customers list to Repair Shops.

    🛠 Steps

    1. Open the Customers list
    2. Click Add Column → See all column types → Next
    3. Configure:
    4. Under Add additional columns, select:
      ✔ Shop Name
      ✔ Email
    5. Click OK

    🎯 Result

    Your Customers list will now show:

    3️⃣ Test the Lookup Relationship

    🧪 Steps

    1. Edit a customer record
    2. In Repair Shop, choose a shop from dropdown
    3. Click Save

    ✅ The related Shop Name & Email appear automatically!

    🔄 What Happens When Source Data Changes?

    👉 If you update the email in Repair Shops,
    👉 The change instantly reflects in Customers list!

    Also:

    🚀 Key Benefits Recap

    💡 Pro Tip

    Use lookup columns for:

    Lookup columns transform SharePoint from simple lists into a mini relational database—without any coding. Start connecting your lists and make your data smarter today! 🚀

    💬 Adding Comments and Tracking Version History in SharePoint Lists

    SharePoint lists aren’t just for storing data—they’re built for team collaboration and accountability. Two standout features make this possible:

    Let’s see how these tools help keep communication clear and your data safe.

    Video Explanation

    🗨 Comments in SharePoint Lists — Collaborate in Context

    Comments let your team talk about a list item right where the data lives. No more hunting through emails or chats to find updates!

    🌟 Why Comments Are So Useful

    🧭 How to Add a Comment

    1. Open your SharePoint list
    2. Click the item you want to discuss
    3. Select Edit to open the item form
    4. On the right side, find the Comments section
    5. Type your message
    6. Use @Name to mention a colleague
    7. Click Send

    💡 Tip: When you @mention someone, they get a notification—great for quick follow-ups!

    🕓 Version History — Never Lose Track of Changes

    Version History records every update made to a list item:

    If something goes wrong, you can easily roll back to an earlier version.

    🎯 Why Use Version History?

    🧭 How to View Version History

    1. Go to your list
    2. Click the three dots (…) next to an item
    3. Select Version History

    You’ll see:

    🔁 What You Can Do from Here

    For any version, you can:

    ✅ Restoring doesn’t erase newer versions—it simply creates a new “latest” version based on the old one.

    ⚙ Pro Tip: Enable Versioning

    Make sure version history is turned on:

    List Settings → Versioning Settings → Enable versioning

    This ensures SharePoint keeps a full timeline of edits.

    🚀 Key Takeaways

    Together, these features turn SharePoint lists into a true collaboration workspace, not just a spreadsheet replacement 👍

    🧩 Working with Columns and Conditional Fields in SharePoint Lists

    SharePoint lists become truly powerful when you start customizing columns and adding smart conditional logic. Instead of overwhelming users with unnecessary fields, you can show only what’s relevant—keeping forms clean, accurate, and easy to use 👍.

    In this section, we’ll cover:

    Let’s build this step by step!

    Video Explanation

    ➕ Adding Additional Columns to a List

    As your business grows, your lists often need to capture more information. Adding new columns lets you expand without breaking existing data.

    🧪 Example Scenario

    You have a Repair Shops list with:

    Now you want to track:

    🧭 Steps to Add New Columns

    1. Open your SharePoint list
    2. Click + Add column
    3. Choose Choice
    4. Name it Shop Type
    5. Add choices:
    6. Enable: Require that this column contains information
    7. Click Save

    Now add the second column:

    1. Click + Add column
    2. Select Single line of text
    3. Name it Affiliation
    4. Click Save

    ✅ Your list now includes two new structured fields!

    ✏ Adding Values to Existing Items

    After creating columns, update current rows so they follow the new structure.

    🧭 How to Update an Item

    1. Select a row → Click Edit
    2. For an independent shop:
    3. For an affiliated shop:
    4. Click Save

    ⚠ Problem:
    Even when Independent is selected, users can still type an affiliation.
    Let’s fix that with conditional logic!

    🎯 Applying Conditional Visibility to Columns

    We can make the form smarter:

    👉 Show Affiliation field ONLY when
    Shop Type = Affiliated

    🧭 Steps to Add a Condition

    1. Click Add new item
    2. In the form, open:
      Edit Form → Edit Columns
    3. Find Affiliation column
    4. Click ⋯ → Edit conditional formula
    5. Enter a formula like:
    =if([$ShopType] == "Affiliated", true, false)
    1. Save all changes

    🧪 Test the Behavior

    Shop Type SelectedAffiliation Field
    Independent❌ Hidden
    Affiliated✅ Visible

    🎉 Now your form stays clean and error-free!

    🚀 Why This Matters

    🧠 Quick Recap

    ✅ Ensuring Proper Form Validation in SharePoint Lists

    When users enter data into a SharePoint list, there’s always a risk of missing or incorrect information. Without validation, important fields can be skipped—leading to incomplete records and messy data 😬.

    Thankfully, SharePoint provides built-in validation tools that let you:

    Let’s walk through a real-world example:
    👉 If a repair shop is marked as “Affiliated,” the Affiliation name must be required.

    Video Explanation

    ⚠ What Happens Without Validation?

    Imagine your list has:

    By default, SharePoint allows this:

    ❌ User selects Affiliated
    ❌ Leaves Affiliation blank
    ✔ The form still saves!

    This creates confusing, incomplete data—exactly what we want to avoid.

    🛠 Adding Row Validation in SharePoint

    Row validation lets you define rules that must be satisfied before an item can be saved.

    🧭 Steps to Add Validation

    1. Open your SharePoint list
    2. Click the ⚙ Settings icon
    3. Select List settings
    4. Click Validation settings

    You’ll see two fields:

    ✏ Example Validation Formula

    Rule:

    If Shop Type = “Affiliated”, then Affiliation must not be blank

    =IF([Shop Type]="Affiliated", NOT(ISBLANK([Affiliation])), TRUE)

    💬 User-Friendly Error Message

    In the User Message box, add something like:

    ❗ “Affiliation is required when Shop Type is set to Affiliated.”

    This helps users understand exactly what to fix 👍.

    🧪 Test the Validation

    Try these scenarios:

    Shop TypeAffiliationResult
    AffiliatedBlank❌ Error – cannot save
    Affiliated“Mega Repairs”✅ Saves
    IndependentBlank✅ Saves

    🎯 Perfect! The rule only applies when needed.

    🎯 Key Benefits of Validation

    🧠 Quick Recap

    📅 Calendar View in a SharePoint List

    SharePoint lists don’t have to stay as rows and columns! With Calendar View, you can transform date-based data into a visual calendar layout—making it easier to track events, deadlines, and milestones at a glance.

    Instead of scrolling through long tables, you’ll see items displayed on days, weeks, or months—just like a real calendar 🗓️.

    💡 Important: Calendar View only works if your list has at least one Date-type column. Without a date field, SharePoint won’t know what to plot on the calendar.

    Video Explanation

    🔑 Why Use Calendar View?

    Calendar View is perfect when your list contains time-based information. It helps you:

    Great for scenarios like:

    🛠 How to Create a Calendar View

    Follow these simple steps to turn your list into a calendar:

    1. Open your SharePoint list
      Go to the list that contains a date column (e.g., Sign-up Date, Due Date, Event Date).
    2. Add a New View
      At the top right—just above the column headings—click ➕ Add View.
    3. Name the View
      In the pop-up window, give it a name like:
      👉 Calendar View
    4. Select a Date Column
      Choose which date field should drive the calendar.
      Examples:
    5. Choose a Layout
      Set the default display:
    6. Click Create
      🎉 Your list now appears in a calendar format!

    🖼 Practical Example

    Imagine you have a Customer Sign-up Date column:

    Much more intuitive than reading dates in a table!

    🎯 Best Use Cases

    ScenarioWhy Calendar View Helps
    Project deadlinesSee upcoming tasks visually
    Event planningAvoid date clashes
    Support ticketsTrack SLA dates
    Employee leaveView overlaps easily

    ✅ Key Takeaways

    🔔 Working with Alerts in Microsoft SharePoint

    SharePoint alerts help you stay updated without constantly checking your lists. Once configured, SharePoint automatically notifies you whenever important changes occur—whether to a single item or the entire list. This is perfect for tracking updates like status changes, new entries, or edits made by team members.

    Video Explanation

    📌 Create an Alert for a Specific List Item

    Sometimes you only need to monitor one critical record instead of the whole list. SharePoint lets you set alerts at the item level, so you get notified only when that particular item changes.

    How to create an alert:

    1. Open your SharePoint list and locate the item.
    2. Click the three dots (…) next to the item.
    3. Select Alert me from the menu.

    You can then configure:

    Click OK to activate the alert.

    ✉ What Happens After an Update

    Whenever that item is modified, SharePoint sends an email containing:

    This keeps everyone informed without manual follow-ups.

    🧰 Manage or Remove Alerts

    As your project grows, you may want to review or clean up alerts.

    To manage alerts:

    1. Open the list
    2. Click Manage my alerts from the top menu
    3. From here you can:

    💡 Tip: List-level alerts are great when you need to track new items or bulk changes instead of one record.

    🎯 Why Use Alerts?

    ✅ Quick Recap

    📤 Working with SharePoint Lists: Exporting and Deleting Data

    Managing SharePoint lists isn’t just about adding data—you’ll often need to export information for reports or clean up outdated records. SharePoint makes both tasks simple with built-in tools, no extra software required.

    In this section, we’ll cover:

    Video Explanation

    📥 Export a SharePoint List

    Need to analyze your data in Excel or build dashboards in Power BI? Exporting lets you take your SharePoint list outside the platform in seconds.

    🚀 Why Export?

    ✅ Export Formats Available

    🧭 Steps to Export

    1. Open your SharePoint list
    2. Click the Export dropdown at the top
    3. Choose your preferred format
    4. The file downloads instantly to your device

    💡 Tip: Export to Excel keeps column structure intact, making it easy to continue working with the data offline.

    🗑 Delete a SharePoint List Item (With Restore Option)

    Cleaning up old or incorrect records keeps your list accurate and relevant. The good news? Deleted items aren’t gone forever—they go to the Recycle Bin first.

    🧹 How to Delete an Item

    1. Select the item from the list
    2. Click Delete from the top menu
    3. Confirm the action

    The item disappears from the list—but stays recoverable.

    ♻ How to Restore a Deleted Item

    1. Open the Recycle Bin (left navigation)
    2. Find your deleted item
    3. Click Restore

    The item returns exactly to its original location 🎉

    🛡 Safety Net: SharePoint’s recycle bin protects you from accidental deletions.

    ⚠ Delete an Entire SharePoint List

    If a list is no longer needed, you can remove it completely.

    Steps to Delete a List

    1. Open the list
    2. Click the Settings gear icon
    3. Select List Settings
    4. Choose Delete this list
    5. Confirm the action

    ❗ Important: Deleting a list removes all items inside it—double-check before proceeding.

    ✅ Quick Summary

    TaskBest For
    Export to ExcelReports & calculations
    Export to CSVSystem integrations
    Export to Power BIDashboards
    Delete ItemData cleanup
    Restore ItemUndo mistakes
    Delete ListRemoving unused data

  • 3 – Understanding SharePoint Pages: A Complete Guide with Video Explanation

    Table of Contents

    1. Introduction to SharePoint Pages
    2. 📄 How to Create a Wiki Page in SharePoint — Step-by-Step Guide
    3. 📁 Embedding a Document Library into a SharePoint Page
    4. 🔧 Customizing an Embedded Document Library (App Part) in SharePoint Pages
    5. 📄 How to Add Images and Links in a SharePoint Wiki Page
    6. 🔄 Viewing Page History and Embedding Content in SharePoint Pages
    7. 📄 How to Create a Modern Site Page in SharePoint
    8. 🖌️ How to Enhance a SharePoint Site Page with Layout Edits & an Embedded Picture Library
    9. 🧑‍🤝‍🧑 How to Add People to a SharePoint Site Page
    10. 🕒 How to Add a Countdown Timer to a SharePoint Site Page
    11. 🧭 How to Add Navigation Elements to a SharePoint Page
    12. 🏠 How to Create and Customize a SharePoint Home Page
    13. 🧰 Useful Menu Items on SharePoint Site Pages

    • Introduction to SharePoint Pages

    In SharePoint, pages are the foundation of how content is presented and shared across a site. They allow you to display documents, announcements, dashboards, and project information in a structured and visually organized way. Whether you’re building an internal knowledge base, a team portal, or a company intranet, pages determine how users experience and interact with your content.

    SharePoint offers several types of pages, each designed for different scenarios and levels of customization.

    Types of SharePoint Pages

    Site Pages (Modern Pages)

    These are the default and recommended page type in today’s SharePoint. Site pages are built using web parts, making it easy to add text, images, document libraries, news, and more without technical skills.

    Best features:

    Site pages are ideal for team homepages, announcements, dashboards, and general communication.

    Wiki Pages (Classic)

    Wiki pages provide more free-form editing, similar to a word processor. Users can add formatted text, tables, links, and images directly on the page without structured web parts.

    Good for:

    Although still supported, wiki pages belong to the classic SharePoint experience and are gradually being replaced by modern site pages.

    Web Part Pages (Legacy)

    Web part pages come from older versions of SharePoint and allow detailed layout control using zones and classic web parts. However, they are now considered outdated.

    Limitations:

    These pages should only be used when required for legacy systems or older integrations.

    When to Use Each Page Type

    Understanding the different SharePoint page types helps you design sites that are easy to navigate, visually appealing, and aligned with modern collaboration needs. By selecting the right page type for the right purpose, you create a better experience for everyone who uses your SharePoint site.

    📄 How to Create a Wiki Page in SharePoint — Step-by-Step Guide

    Wiki pages may be part of SharePoint’s classic experience, but they’re still useful when you need free-form editing similar to a Word document. They’re great for quick documentation, internal notes, or simple knowledge-base pages where structure matters less than flexibility.

    Let’s walk through how to create, edit, and publish a wiki page in a clear and easy way.

    Video Explanation

    🛠 Step-by-Step: Creating Your Wiki Page

    ➤ 1. Go to the Pages Library

    ➤ 2. Create a New Page

    💡 Tip: Site Pages are the modern default, but Wiki Pages are perfect when you want a simple, document-style layout.

    ➤ 3. Name Your Page

    A good name helps users find the page easily later.

    ➤ 4. Add Your Content

    You’ll now see an editor that feels a lot like Microsoft Word:

    This flexibility is what makes wiki pages great for informal documentation.

    ➤ 5. Save & Publish

    📂 How to Find Your Page Later

    To reopen or edit the page:

    1. Go back to Pages in the site menu.
    2. Click the page name (for example, Expense Page).
    3. Choose Edit if you need to make updates.

    Easy and always accessible 👍

    💬 When Should You Use a Wiki Page?

    ScenarioGood Fit?
    Quick internal documentation✅ Yes
    Knowledge base articles✅ Yes
    Modern dashboards❌ Better with Site Pages
    Mobile-friendly layouts❌ Use Site Pages

    📌 Remember: Wiki pages are classic technology. For modern, responsive designs, Site Pages are recommended—but wiki pages remain handy for simple, text-focused content.

    🎯 Summary

    📁 Embedding a Document Library into a SharePoint Page

    One of the smartest ways to make SharePoint easier for users is to bring the tools to the page instead of sending users around the site. By embedding a document library directly into a page, you can combine instructions, context, and file management in a single, friendly interface.

    This approach is perfect for scenarios like expense submissions, project file uploads, or team collaboration spaces.

    Video Explanation

    🎯 Why Embed a Document Library?

    Adding a library to a page gives you several advantages:

    Think of it like building a mini workspace inside a page instead of just a blank information screen.

    🛠 Step-by-Step: Add a Library to a Page

    1️⃣ Open the Page

    2️⃣ Switch to Edit Mode

    3️⃣ Choose a Layout

    This gives you:

    4️⃣ Add Helpful Instructions

    In the header and left column, add guidance such as:

    💬 “Upload your expense reports using the panel on the right.”
    💬 “Use this file naming format: Department_Date.pdf”

    Clear instructions = fewer mistakes 👍

    5️⃣ Insert the Document Library (App Part)

    Now for the magic part ✨

    1. Click inside the right column
    2. Open the Insert tab
    3. Select App Part
    4. Choose your library (e.g., Expenses)
    5. Click Add

    Your live document library now appears inside the page!

    6️⃣ Save & Publish

    🚀 What Users Can Do Now

    From this single page, users can:

    👉 No more jumping between Pages, Site Contents, and Libraries!

    💡 Best Use Cases

    ScenarioPerfect Fit?
    Expense submissions✅ Yes
    Project file collection✅ Yes
    HR document uploads✅ Yes
    Simple read-only info❌ Use normal page

    🧠 Final Thought

    Embedding a document library turns a simple SharePoint page into a functional workspace. It combines guidance + action in one place — exactly what end users need to stay productive without confusion.

    Give it a try on your next SharePoint page and watch how much smoother your team workflows become 🚀

    🔧 Customizing an Embedded Document Library (App Part) in SharePoint Pages

    Embedding a document library inside a SharePoint page is powerful—but the real magic happens when you customize how that library appears and behaves. You can group files, hide unnecessary columns, or even turn the library into a read-only viewer so users can’t upload or modify content.

    Let’s walk through how to fine-tune your embedded library for a cleaner and more user-friendly experience.

    Video Explanation

    🎯 What You Can Achieve

    With App Part customization, you can:

    ✅ Step 1: Create a Custom View in the Library

    The embedded library will display whatever view you choose, so start by creating one tailored for your page.

    ➤ Create the View

    1. Open your Expenses document library
    2. Click the view dropdown (e.g., All Documents)
    3. Select Create new view
    4. Name it something clear like:
      👉 Expense Page View

    ➤ Customize the View

    After creating it:

    1. Open the view dropdown again
    2. Click Edit current view

    Now configure:

    Click OK to save.

    👀 This is exactly how the library will look when embedded in the page.

    ✅ Step 2: Apply That View to the Page

    Now connect the page to this new view.

    ➤ Open the Page

    1. Go to Pages from site navigation
    2. Open your page (e.g., Expense Page)
    3. Click Edit ✏️

    ➤ Configure the App Part

    1. Click once on the embedded document library
    2. A Web Part tab appears at the top
    3. Select Web Part Properties

    In the right panel:

    Optional tweaks:

    Click Apply.

    ✅ Step 3: Make It Read-Only (Optional)

    Want users to only view files — not upload or edit?

    ➤ Turn Off the Toolbar

    In Web Part Properties:

    1. Find Toolbar Type
    2. Select 👉 No Toolbar

    ✨ Result:

    🧠 Final Result

    Your page now:

    🚀 Why This Matters

    This setup is perfect for:

    You get the best of both worlds:
    👉 Guided page experience + live library functionality

    🎉 Summary

    By customizing the embedded App Part, you transform a basic page into a purpose-built workspace that’s clear, controlled, and easy for users to navigate.

    Ready to level up your SharePoint pages? This technique is a game changer 💪

    📄 How to Add Images and Links in a SharePoint Wiki Page

    Adding images and links to a SharePoint wiki page transforms plain text into a visual, easy-to-navigate workspace. A banner image can make your page look professional, while links guide users directly to the right documents or libraries.

    Let’s walk through how to do both—step by step 👇

    Video Explanation

    🖼️ Insert an Image into a Wiki Page

    1. Open the Page

    2. Add the Image

    3. Adjust the Image

    💡 Tip: Use a wide, lightweight image for a clean banner look.

    1. Insert the Link

    2. Open in a New Tab (Recommended)

    🧭 Update Site Navigation

    Add the Page to Navigation

    Optional Cleanup

    🎯 Result

    Your wiki page now includes:

    This structure helps users understand the page quickly and reach the right content with minimal effort 🚀

    🔄 Viewing Page History and Embedding Content in SharePoint Pages

    SharePoint pages evolve over time, and it’s important to track what changes have been made and by whom. SharePoint provides a built-in Page History feature for this purpose. In addition, you can enrich your pages by embedding external content such as YouTube videos, dashboards, or other web resources using embed code.

    Video Explanation

    📖 Viewing Page History

    Page History allows you to review previous versions of a page and compare edits.

    Steps to view history:

    1. Open the SharePoint page you want to review (for example, Expense Page).
    2. Click Edit at the top-right corner.
    3. From the Page tab, select Page History.

    A panel will appear listing all saved versions of the page.

    What you can do:

    This feature is extremely useful for auditing edits or restoring previous content if needed.

    🎥 Embedding a YouTube Video or Other Content

    You can make your SharePoint pages more engaging by embedding content from external sources.

    How to embed a video:

    1. Open the YouTube video (or another service that provides embed code).
    2. Click Share → Embed and copy the HTML code.
    3. Return to your SharePoint page in Edit mode.
    4. Place the cursor where you want the video to appear.
    5. Go to the Insert tab and choose Embed Code.
    6. Paste the copied code and click Insert.
    7. Click Save and Publish to make the changes live.

    The video will now appear directly on your page and can be played without leaving SharePoint.

    ✅ Benefits

    Using these features together helps you:

    With Page History and embedding, SharePoint pages become powerful communication tools rather than simple static documents.

    📄 How to Create a Modern Site Page in SharePoint

    Modern Site Pages are the heart of today’s SharePoint experience. They let you create clean, visually appealing pages using drag-and-drop web parts—no technical skills required. Compared to older Wiki pages, Site Pages feel more like building a modern website: responsive, flexible, and easy for everyone to use.

    In this section, you’ll learn how to create a Site Page from scratch and customize it to fit your team’s needs.

    Video Explanation

    🧭 Step-by-Step: Create Your First Site Page

    Follow these simple steps to get started:

    1. Open the Pages library
    2. Create a new page
    3. Add a page title
    4. Customize the banner
    5. Add content sections
    6. Publish the page

    🚀 After You Publish

    SharePoint gives you helpful options right away:

    ✨ Why Use Modern Site Pages?

    Modern Site Pages are perfect for:

    They combine professional design + easy editing + powerful integration with the rest of Microsoft 365.

    🖌️ How to Enhance a SharePoint Site Page with Layout Edits & an Embedded Picture Library

    Modern SharePoint Site Pages are designed to look clean, visual, and professional without any technical skills. With just a few clicks, you can transform a simple page into an engaging space that combines banners, structured layouts, and live image galleries.

    In this section, you’ll learn how to upgrade an existing Site Page by customizing the banner, adjusting the layout, and embedding a picture library so users can view images directly from the page.

    Video Explanation

    ✏️ Step 1 – Open the Page in Edit Mode

    💡 Tip: Use the full-screen ↗ icon to hide navigation and focus only on the page while editing.

    🖼️ Step 2 – Customize the Banner

    The banner sets the mood of your page — make it informative and attractive.

    You can also:

    🎨 A well-designed banner gives instant context to your page visitors.

    🧩 Step 3 – Add a Structured Section

    To organize content neatly:

    1. Scroll below the banner
    2. Click the ➕ Add section icon
    3. Choose a layout such as Two Columns

    For better balance:

    📸 Step 4 – Embed the Picture Library

    Now let’s bring images directly onto the page:

    1. Inside the column, click ➕ Add web part
    2. Select Document Library
    3. Choose your Cars picture library

    ✨ Instantly, thumbnails from the library appear on the page — no manual uploads required!

    This is ideal for:

    🚀 Step 5 – Publish the Page

    When everything looks good:

    ✅ What You Get

    After these updates, your page now includes:

    This approach turns SharePoint pages into interactive visual hubs instead of plain text screens, making content easier and more enjoyable to explore.

    🧑‍🤝‍🧑 How to Add People to a SharePoint Site Page

    Adding people profiles to a SharePoint page is a great way to make your site feel more human and connected. Whether you’re building a team directory, highlighting project owners, or showing key contacts, the People web part lets you display names, photos, roles, and contact details in a professional layout.

    In this section, you’ll learn how to insert and customize a People section so visitors can easily recognize and reach the right person.

    Video Explanation

    ✅ Step-by-Step: Add the People Web Part

    1️⃣ Open the Page in Edit Mode

    2️⃣ Choose Where to Place It

    3️⃣ Insert the People Web Part

    4️⃣ Add Team Members

    💡 SharePoint automatically pulls profile photos and contact info from Microsoft 365.

    🎨 Customize the Look

    Click on the People web part and open Properties ⚙️ to adjust:

    Layout options:

    Optional descriptions:

    🚀 Publish the Changes

    👀 What Visitors Will See

    Your page will now show:

    This is perfect for:

    🌟 Why Use the People Web Part?

    🕒 How to Add a Countdown Timer to a SharePoint Site Page

    A countdown timer is a simple but powerful way to grab attention on your SharePoint site. Whether you’re counting down to a product launch, company event, project deadline, or registration closing date, this web part creates urgency and keeps everyone focused on what matters next.

    The best part? SharePoint includes a built-in Countdown Timer web part—no coding or third-party tools needed 👍.

    In this section, you’ll learn how to add, customize, and publish a live countdown timer on any modern SharePoint page.

    Video Explanation

    🔧 Step-by-Step: Add the Countdown Timer

    1️⃣ Open the Page in Edit Mode

    2️⃣ Add a New Section

    3️⃣ Insert the Countdown Web Part

    ⚙️ Customize Your Timer

    Click on the timer and open Properties ⚙️ on the right to configure:

    🎯 Set the Basics

    ⏱ Choose What to Display

    Select which units to show:

    You can keep it simple (days + hours) or ultra-precise with seconds ticking away!

    🔗 Add a Call to Action (Optional)

    Want users to take action before time runs out?

    🖼 Make It Visually Engaging

    Give your timer more impact with a background:

    This helps the timer stand out instead of looking like plain text.

    🚀 Publish the Page

    🎉 What You Get

    Your SharePoint page will now feature:

    💡 Great Use Cases

    🧭 How to Add Navigation Elements to a SharePoint Page

    Adding navigation elements like Call to Action (CTA) blocks and buttons makes your SharePoint pages easier to use and more interactive. Instead of forcing users to hunt through menus, you can guide them directly to key areas such as the Home page, Expense page, or any important resource.

    These elements act like signposts on your site—helping visitors move smoothly from one section to another.

    Video Explanation

    🚀 Why Add Navigation Elements?

    Using CTAs and buttons on your pages helps to:

    🔧 Step-by-Step: Add Navigation Elements

    1️⃣ Open the Page in Edit Mode

    2️⃣ Add a New Section

    3️⃣ Insert a Call to Action (CTA)

    Then configure it in the properties panel:

    4️⃣ Add a Navigation Button

    5️⃣ Publish and Test

    💡 Tips for Better Navigation

    🎯 What You Achieve

    With these additions your page will:

    A few well-placed navigation elements can transform a basic SharePoint page into a user-friendly hub 👍.

    🏠 How to Create and Customize a SharePoint Home Page

    Your SharePoint Home Page is the front door to your site. It’s where users land first, so it should be informative, organized, and easy to navigate. With modern SharePoint, you can build a custom homepage using web parts like News, Calendar, Quick Links, and Activity — all without any coding.

    In this section, you’ll learn how to design a professional homepage from scratch and set it as the default landing page for your site.

    Video Explanation

    ✨ What Makes a Good SharePoint Home Page?

    A well-designed homepage should:

    Let’s build one step by step 👇

    🛠 Step-by-Step: Build Your Custom Home Page

    1️⃣ Create a New Site Page

    2️⃣ Customize the Banner

    🧩 Add Useful Web Parts

    3️⃣ Add News & Calendar Section

    In the left column:

    In the right column:

    👉 This gives users a quick snapshot of what’s happening.

    4️⃣ Add Quick Navigation Cards

    Add another section with One Column layout and insert:

    For each CTA you can configure:

    These act like visual shortcuts across your site.

    5️⃣ Add Site Activity Feed

    At the bottom of the page:

    This shows:

    Great for keeping the homepage “alive” 🔄

    🚀 Publish & Set as Home Page

    When you’re happy with the design:

    1. Click Publish
    2. Go back to the Pages library
    3. Find your new page
    4. Click the three dots (…) → select Make homepage

    ✅ Now this page becomes the default landing page when users click the Home icon.

    🎯 Final Result

    Your custom homepage now includes:

    This transforms SharePoint from just a file storage space into a real digital workplace hub.

    🧰 Useful Menu Items on SharePoint Site Pages

    SharePoint Site Pages include several built-in tools that help you understand page performance, promote content, and manage page details—all from the top menu. These features make it easy to turn a simple page into a well-managed, high-impact resource.

    Let’s explore the three most useful options 👇

    Video Explanation

    📊 1. Page Analytics — Understand Your Audience

    The Analytics option gives you valuable insights into how users interact with your page.

    When you click Analytics, you can see:

    💡 Great for:
    Checking whether important pages are actually being used and identifying the best time to post updates.

    📣 2. Promote — Share Your Page with the Team

    The Promote button helps you surface your page in different places without extra effort.

    From the promote panel you can:

    💡 Great for:
    Turning a normal page into a highlighted announcement or reusable template.

    🗂 3. Page Details — Manage Metadata

    The Page Details option opens a side panel with important information about the page.

    Here you can:

    💡 Great for:
    Keeping pages structured and searchable across your SharePoint site.

    🎯 Why These Tools Matter

    Using these menu features helps you:

    With just a few clicks, you can manage your SharePoint pages like a pro 👍.

  • 2 – Understanding Document Library In SharePoint; With Video Explanation

    Table of Contents

    1. Managing Files in SharePoint
    2. Editing Files and Using Version History in SharePoint
    3. Versioning and Check-In/Check-Out in SharePoint
    4. Accessing SharePoint Files Offline with OneDrive
    5. Using Templates and Managing the New Menu in SharePoint
    6. Associating Metadata with Uploaded Files in SharePoint
    7. Organize SharePoint Files Smarter with Metadata
    8. Track and Analyze Expenses in SharePoint Using Currency Metadata
    9. Visually Enhance SharePoint Lists with Conditional Formatting and Column Styling
    10. Customizing Columns in a SharePoint Document Library
    11. Creating and Managing Custom Views in SharePoint Document Libraries
    12. Document Library Top Menu: A Quick Guide
    13. Organize Your SharePoint Site with a New Document Library
    14. Create and Manage Site Navigation Links in SharePoint
    15. Create and Use a Picture Library in SharePoint
    16. A Quick Guide to SharePoint Library Settings

    • Managing Files in SharePoint

    Microsoft SharePoint provides a simple and powerful way to store, organize, and collaborate on files with your team. You can upload documents, create new ones directly in the site, edit files in your browser, and share them with others—all in one place.

    In this section, we’ll look at how to navigate the Documents library and how to work with files effectively, including organizing and opening them.

    Video Explanation

    The Documents library is the main area where files are stored and managed in a SharePoint site. It’s designed to make adding and organizing files easy.

    You can create new content or upload existing files from your computer.

    👉 How to add documents:

    1. Open your SharePoint site.
    2. Select Documents from the left menu.
    3. Click the New button at the top left.
    4. Choose one of the following:
    5. When uploading, choose either:

    Once uploaded, your files appear in the document library and are ready to use.

    ✨ Example: You might upload a Word file, an Excel sheet, and a PowerPoint file to quickly build your document library.

    Working with Files in SharePoint

    After files are added, you can work with them directly online. This allows quick collaboration without needing to download files first.

    👉 Common file actions:

    Open and Edit Online

    Share with Colleagues

    View File Details

    Quick Access from the Homepage

    ✨ This makes editing, sharing, and reviewing files smooth and collaborative.

    Creating Files and Folders

    You don’t always need to upload files—SharePoint lets you create them directly.

    However, relying only on folders is considered an older method of organization in SharePoint.

    Organizing with Metadata (Columns)

    SharePoint offers metadata features to organize files more effectively than folders alone.

    Using metadata helps teams find files faster without deep folder structures.

    Opening and Reading Files

    SharePoint provides multiple ways to open and read files:

    1. Open in App
    2. Open in Browser
    3. Immersive Reader

    By using document libraries, online editing, sharing tools, and metadata, SharePoint makes file management organized and team-friendly.

    Editing Files and Using Version History in SharePoint

    Microsoft SharePoint makes file editing and collaboration simple by allowing you to work directly in your browser or in desktop apps. There’s no need to download and re-upload files after every change. Even better, SharePoint automatically saves your work and supports real-time collaboration, so teams can edit together without confusion.

    Another key feature is Version History, which quietly tracks changes and lets you restore earlier versions if needed. Together, these tools make file management safer and more efficient.

    Video Explanation

    Editing Files in SharePoint

    One of the biggest advantages of SharePoint is how easy it is to edit files. You can open a file and start working immediately, with changes saved automatically.

    How editing works:

    👉 Steps to edit a file:

    1. Go to your Documents Library.
    2. Click the file name (for example, a Word or Excel file).
    3. The file opens in a new browser tab.
    4. Start typing or making changes — they save automatically.

    More editing options:

    When others are editing the same file, you’ll see their initials or cursors in real time. This makes teamwork smooth and avoids duplicate versions.

    File Version History in SharePoint

    Version History is a built-in safety feature. Every time a file is saved, SharePoint keeps a record of previous versions. This allows you to review or restore older copies if needed.

    Why Version History matters:

    👉 Steps to access Version History:

    1. In the Documents Library, find your file.
    2. Click the three dots (…) next to it.
    3. Select Version History.
    4. A list of saved versions appears.

    Options for each version:

    If you restore a version, SharePoint rolls the file back while still keeping newer versions stored. This ensures you never permanently lose important work.

    Versioning and Check-In/Check-Out in SharePoint

    Versioning is one of the most valuable features in Microsoft SharePoint for managing files. It helps teams track edits, collaborate confidently, and restore earlier versions when needed. Instead of saving files as “v1,” “v2,” or “final-final,” SharePoint automatically keeps a history of changes for you.

    In this section, we’ll look at how versioning works, how check-out/check-in supports controlled editing, and how versioning applies to non-Office files.

    Video Explanation

    Understanding Versioning

    Versioning allows you to track and manage changes made to a file over time. Every time a file is edited and saved, SharePoint records a new version in the background.

    Why versioning is useful:

    SharePoint also supports simultaneous editing, meaning multiple users can work on the same file at the same time. You may see another user’s cursor or presence indicator while they are editing, which helps avoid conflicts.

    If unwanted edits are made, you can simply restore a previous version from the version history.

    Check-Out and Check-In

    Sometimes, you may want to prevent others from editing a file while you work on it. That’s where check-out and check-in come in.

    How it works:

    When checking a file back in, you can add comments describing your changes. These comments appear in the version history and help track what was updated.

    When to use check-out/check-in:

    Versioning for Non-Office Files

    Versioning also works for non-Office files such as videos, images, or PDFs. The main difference is that these files cannot be edited by multiple users at the same time in SharePoint.

    How versioning works for non-Office files:

    SharePoint recognizes this as a new version of the file.

    You can then:

    This is especially helpful for files like videos or design assets that go through multiple revisions.

    Using versioning together with check-in and check-out gives teams strong control over file edits while still supporting collaboration. It ensures that changes are tracked, recoverable, and organized without extra manual effort.

    Accessing SharePoint Files Offline with OneDrive

    Working offline doesn’t mean you have to stop using SharePoint. With OneDrive integration, you can sync your SharePoint document libraries to your computer and access them directly from File Explorer—even without a constant internet connection. Any changes you make offline will automatically sync once you’re back online.

    In this section, you’ll learn how to add a SharePoint library shortcut to OneDrive and then access those files from your PC.

    Video Explanation

    Add a SharePoint Library Shortcut to OneDrive

    Adding a shortcut connects your SharePoint document library to your OneDrive. This lets you view and manage the same folders from both SharePoint and OneDrive.

    👉 Steps to add the shortcut:

    1. Open your SharePoint document library.
    2. At the top, click Add shortcut to OneDrive.
    3. Wait for the confirmation notification.

    👉 Verify in OneDrive:

    1. Sign in to the Microsoft 365 portal.
    2. Open OneDrive from the side navigation.
    3. Click the folder icon in the OneDrive menu to view your files.
    4. Look for a folder named after your SharePoint site followed by the library name.
    5. Open it to confirm the folder structure matches SharePoint.

    ✅ Key Point: The folder structure you see in OneDrive mirrors your SharePoint library.

    Access OneDrive from Your Windows PC

    Once synced, you can access your SharePoint files directly from your PC using OneDrive.

    👉 Steps to access files from a PC:

    1. Log into a Windows PC using your organizational account.
    2. Complete multi-factor authentication if prompted.
    3. Open File Explorer.
    4. Select OneDrive from the left sidebar.
    5. Sign in if requested.

    You’ll now see the same folders that appear in OneDrive on the web, including your SharePoint site folders.

    Creating and Syncing Files Offline

    You can create or edit files locally, and they will sync automatically.

    👉 Example workflow:

    When you later open SharePoint in your browser and navigate to the same folder, you’ll see that file there.

    ✅ Key Point: Any changes made on your PC sync seamlessly to SharePoint, keeping files updated across devices.

    Using OneDrive with SharePoint gives you the flexibility to work from your desktop while still benefiting from cloud storage and collaboration features provided by Microsoft 365.

    Using Templates and Managing the New Menu in SharePoint

    Templates and the New menu in Microsoft SharePoint are simple features that can make a big difference in daily work. They help teams create consistent documents, save time, and reduce repetitive formatting. Instead of starting from scratch each time, users can begin with a ready-made structure.

    In this section, you’ll learn how to upload and use templates, and how to control what appears in the New menu so it fits your team’s needs.

    Video Explanation

    Why this matters:

    Upload and Use a Template File

    Templates are pre-formatted files that users can open, fill in, and save as new documents. They’re useful for quotes, forms, reports, or any document with a standard layout.

    A template can be almost any file type, such as Word, Excel, or PowerPoint.

    How templates help:

    👉 Steps to upload a template:

    1. Open any document library.
    2. Click the New button at the top.
    3. From the dropdown, select Add template (usually at the bottom).
    4. Upload your desired file.

    Once uploaded, your template appears as an option under the New button.

    👉 How it’s used in practice:

    This keeps documents uniform and organized.

    Edit the New Menu

    The New menu appears in every document library and lets users quickly create files, folders, or template-based documents. If the menu shows options you don’t need, you can customize it.

    Why edit the New menu:

    👉 Steps to edit the New menu:

    1. Open your document library.
    2. Click the New button.
    3. Select the Edit option in the menu.
    4. A panel opens on the right with checkboxes.
    5. Check or uncheck items to show or hide them.
    6. Save your changes.

    If a template is no longer needed, simply uncheck it so it doesn’t appear in the New menu.

    Using templates together with a well-managed New menu helps teams work faster, stay consistent, and keep document creation simple.

    Associating Metadata with Uploaded Files in SharePoint

    Using metadata in SharePoint is a powerful way to organize files beyond simple folder structures. Instead of relying only on file names or deep folders, metadata lets you tag files with useful information like department, project, or document type. This makes searching, filtering, and managing documents much easier as your library grows.

    In this section, you’ll learn how to upload files and assign metadata so your documents stay organized and easy to find.

    Video Explanation

    Why metadata is important:

    Upload Files to a Document Library

    Before adding metadata, you first need files in your library.

    👉 Steps to upload files:

    1. Open any document library.
    2. (Optional) Open a folder if you want to upload there.
    3. Click Upload.
    4. Choose Files or Folder from your computer.
    5. Wait for the upload to complete.

    Once uploaded, you’ll see files in the library with default columns such as:

    At this point, filenames may be the only clue about content—but metadata will improve that.

    Create a Metadata Column

    Metadata is added through columns in the document library. Each column stores a specific type of information.

    👉 Example: Create a “Department” column

    1. In the document library, click Add column.
    2. Choose a column type.
    3. Click Next.

    👉 Configure the column:

    1. Click Save.

    Your new metadata column is now ready.

    Assign Metadata to Files

    After creating the column, you need to assign values to your files.

    Method 1: File Details Panel (One-by-One)

    Best for small updates.

    1. Click the three dots (…) next to a file.
    2. Select Details.
    3. In the panel, choose the correct department.

    Method 2: Edit in Grid View (Bulk Editing)

    Best for multiple files.

    1. Click Edit in Grid View from the top menu.
    2. The library switches to an Excel-like view.
    3. Click cells under the Department column.
    4. Assign departments to multiple files quickly.
    5. Exit grid view when finished.

    This method is much faster when tagging many files.

    Good Practice Tips

    Adding metadata transforms a simple document library into a smart, searchable system. With the right columns in place, teams can quickly filter, group, and find files without digging through folders.

    Organize SharePoint Files Smarter with Metadata

    In Microsoft SharePoint, organizing documents doesn’t have to rely on folders alone. Instead, you can use metadata—custom fields such as Department or Expense Type—to tag files with meaningful information. This approach is far more flexible than traditional folders and makes it easier to search, filter, group, and manage large volumes of documents.

    Metadata helps you see your files from different perspectives without moving or duplicating them. The same document can belong to multiple logical views, something folders simply can’t handle well.

    Video Explanation

    Filtering Files Using Metadata

    Once files are tagged with metadata, you can quickly narrow down what you see.

    How filtering works:

    Steps to filter files:

    1. Go to the column header (for example, Department).
    2. Click the dropdown arrow.
    3. Select Filter.
    4. In the right-hand pane, check the values you want to see (for example, Accounting).
    5. Click Apply.

    Now, only files tagged with that department are displayed.

    To clear filters:

    Grouping Files by Metadata

    Grouping lets you visually organize files into expandable sections based on metadata values. This is especially useful when working with many related documents.

    How grouping helps:

    Steps to group files:

    1. Click the dropdown on a metadata column (for example, Department).
    2. Select Group by Department.

    Files are now grouped under headers like Accounting, Sales, or HR. Each group has an arrow that lets you collapse or expand it.

    You can also:

    Switching Between Different Metadata Views

    You’re not limited to one way of grouping.

    At the top of the file list, you’ll also find:

    These options help you quickly switch between a high-level overview and a detailed view.

    By using metadata with filtering and grouping, SharePoint turns a simple document library into a powerful, flexible file management system—making it much easier to find, organize, and work with your files at scale.

    Track and Analyze Expenses in SharePoint Using Currency Metadata

    Microsoft SharePoint can do much more than store documents—it can also help you track and analyze financial data using metadata. Instead of organizing expense files with folders or relying on filenames, you can use structured metadata such as Department, Expense Type, and Currency (Amount) to gain clear, real-time insights directly within a document library.

    This approach turns a standard SharePoint library into a lightweight financial tracking and reporting tool that’s easy for teams to use.

    Video Explanation

    Add a Currency Metadata Column

    To begin tracking expenses, you first need a currency-based metadata column.

    Steps to create a currency column:

    1. Open your SharePoint document library.
    2. Click Add column.
    3. Select Currency as the column type and click Next.
    4. Enter a column name such as Amount.
    5. Choose the currency format (for example, USD or EUR).
    6. Optionally set a default value or description.
    7. Click Save.

    The new Amount column will now appear alongside your files.

    Enter Financial Values

    Once the column exists, you can start adding values to your files.

    Efficient data entry:

    This method is ideal for entering or updating values across many files at once.

    Sort, Filter, and Group Expense Data

    With currency values in place, SharePoint’s built-in tools let you analyze the data quickly.

    Using the Amount column, you can:

    Grouping makes it easy to compare expenses across teams or cost categories without exporting data.

    Use Totals for Instant Insights

    One of the most powerful features is Totals, which provides quick summaries directly in the library view.

    How to enable totals:

    1. Click the dropdown on the Amount column.
    2. Select Totals.
    3. Choose a calculation such as:

    When combined with grouping, totals become even more valuable. For example:

    You can remove summaries at any time by setting totals back to None.

    Why This Approach Works

    Using currency metadata in SharePoint allows you to:

    With metadata, filtering, grouping, and totals, SharePoint becomes a practical and flexible solution for managing and analyzing expense-related documents.

    Visually Enhance SharePoint Lists with Conditional Formatting and Column Styling

    Microsoft SharePoint makes it easy to store and manage data—but good visual design makes that data far easier to understand and act on. By using view formatting and column styling, you can highlight important information such as high expenses, specific categories, or outliers directly within a list or document library.

    In this section, you’ll learn how to apply alternating row styles, conditional formatting, and column-level styling to make your SharePoint lists more readable, informative, and user-friendly.

    Video Explanation

    Open the Format Current View Panel

    All list-level formatting starts from the same place.

    Steps to open formatting options:

    1. Go to your SharePoint list or document library.
    2. In the top menu, click the All Documents (or current view) dropdown.
    3. Select Format current view.

    You’ll see two tabs:

    Apply Alternating Row Styles

    Alternating row styles improve readability by visually separating rows.

    How to apply:

    1. In the Format view tab, choose Alternating row styles.
    2. Select background colors for:
    3. Click Save to apply.

    ⚠️ This styling is purely visual and does not depend on data values.

    Use Conditional Formatting (Row-Level)

    Conditional formatting lets you style rows based on metadata values such as Expense Type or Department.

    Steps to apply conditional formatting:

    1. In Format view, select Conditional formatting.
    2. Reset any default styling by choosing No style.
    3. Click Add rule.
    4. Choose a column (for example, Expense Type).
    5. Set a condition (for example, equals Travel).
    6. Choose a background color.
    7. Save the rule.

    Only rows matching the condition will be highlighted, making important entries stand out instantly.

    Workaround: Enable Formatting for Currency Columns

    By default, Currency columns cannot be used in view-level conditional formatting. A simple workaround solves this.

    Steps to update the column:

    1. Click the dropdown on the Amount column.
    2. Select Column settings → Edit.
    3. Change the column type from Currency to Number.
    4. In More options, enable Require that this column contains information.
    5. Choose a currency symbol if needed.
    6. Click Save.

    The column will now be available for conditional formatting rules.

    Add Conditional Formatting Based on Amount

    Now you can highlight high-value items automatically.

    Example: highlight large expenses

    1. Open Format current view → Conditional formatting.
    2. Clear any default styles.
    3. Click Add rule.
    4. Choose the Amount column.
    5. Set a condition (for example, Amount is greater than 3000).
    6. Choose a strong color such as red.
    7. Save.

    Any row exceeding that amount will be visually emphasized—even when sorting or filtering the list.

    Use Column Formatting for Individual Cells

    If you prefer to highlight only one column instead of the entire row, use column formatting.

    Steps:

    1. Click the dropdown on the Amount column.
    2. Select Column settings → Format this column.

    You’ll see two powerful options:

    Data bars are especially useful for financial data:

    Reset the View to Default

    If you want to remove all formatting and return to the standard view:

    1. Open Format current view.
    2. Disable Conditional formatting.
    3. Click Save.

    Your list will return to the default white-background layout.

    Why Formatting Matters

    Using conditional formatting and column styling in SharePoint helps you:

    With the right formatting in place, SharePoint lists become easier to scan, analyze, and act on—right where your data lives.

    Customizing Columns in a SharePoint Document Library

    Microsoft SharePoint document libraries become far more useful when columns are arranged and displayed in a way that matches how people actually work. SharePoint provides simple, built-in options to move, hide, show, and pin columns—allowing users to personalize their views without writing code or changing advanced settings.

    In this section, you’ll learn how to adjust column layouts to create a cleaner, more productive document library experience.

    Video Explanation

    Reorder Columns (Move Left or Right)

    Reordering columns helps bring the most important information into focus.

    Method 1: Use Column Settings

    1. Click the dropdown arrow next to the column header.
    2. Select Column settings.
    3. Choose Move left or Move right.

    Method 2: Drag and Drop

    Both methods instantly update the column order in the current view.

    Hide and Show Columns

    If certain columns are not relevant, hiding them reduces clutter and makes the list easier to read.

    Hide a column:

    1. Click the dropdown on the column header.
    2. Select Column settings → Hide this column.

    The column is removed from the view but not deleted.

    Show hidden columns:

    1. Click the dropdown on any visible column.
    2. Go to Column settings → Show/Hide columns.
    3. In the panel that appears, check the columns you want to display (for example, Modified or File size).
    4. Click Apply.

    This is a quick way to bring back hidden columns or add built-in ones.

    Pin Columns to the Filter Pane

    Pinning columns makes filtering faster and more intuitive for users.

    How to pin a column:

    1. Click the dropdown on the column header.
    2. Select Column settings → Pin to filter pane.

    Once pinned:

    To unpin a column:

    Why Column Customization Matters

    Customizing columns in SharePoint helps you:

    With just a few clicks, you can transform a crowded document library into a clean, organized, and highly usable workspace tailored to your team’s needs.

    Creating and Managing Custom Views in SharePoint Document Libraries

    Microsoft SharePoint document libraries can quickly become crowded as files and metadata grow. Views solve this by letting you present the same data in different ways—using filters, sorting, grouping, and totals—without changing the underlying files. Each view is simply a saved configuration, making it easy to tailor what different users see based on their needs.

    Video Explanation

    What Is a View in SharePoint?

    A view is a customized way to display files in a list or document library. With views, you can:

    Views are especially useful for role-based work—finance, sales, or managers can all look at the same library through different lenses.

    Create and Save a Filtered View

    You can quickly turn a temporary filter into a reusable view.

    Steps:

    1. Open the document library.
    2. Click the dropdown arrow on a column header (for example, Department).
    3. Choose Filter by and select the value you want (for example, Sales).
    4. Once the list updates, open the view selector at the top (usually labeled All Documents).
    5. Select Save view as….
    6. Enter a name (for example, Sales Files) and click Save.

    The view is now saved and available in the view selector.

    Create a New View from Scratch

    For more control, you can build a view with detailed settings.

    Steps:

    1. Open the view selector and choose Create new view.
    2. Enter a name and click Create.
    3. Open the view selector again and choose Edit current view.

    From the configuration page, you can customize:

    1. Click OK to save the view.

    Switching Between Views

    All saved views appear in the view selector at the top of the library. You can switch between them at any time, and each view keeps its own layout, filters, grouping, and totals.

    Best practice: Use views where files are consistently tagged with metadata. Views rely on metadata to work correctly and are most effective in well-organized libraries.

    By using custom views strategically, you can transform a single SharePoint document library into multiple, purpose-built workspaces—each tailored to how different teams need to see and analyze the same information.

    Document Library Top Menu: A Quick Guide

    The top menu in a Microsoft SharePoint document library provides quick access to the most important file and metadata management actions. Understanding what each option does helps you work faster, keep files organized, and take full advantage of SharePoint’s document management capabilities.

    In this section, we’ll walk through the key options you’ll find in the document library’s top menu and when to use them.

    Video Explanation

    New, Upload, and Edit in Grid View

    These options focus on adding content and managing metadata.

    These options help you share access without moving files.

    Sync and Add Shortcut to OneDrive

    These options connect your document library to OneDrive and your local machine.

    Download vs. Export to Excel

    These options are often confused but serve different purposes.

    View Options (List, Compact, Tiles)

    You can change how files are visually displayed.

    Files That Need Attention

    Sometimes you may see a red dot next to the All Documents (view selector) dropdown.

    This often happens when:

    Best practice:
    If different document types require different metadata, place them in separate document libraries (for example, one for expense files and another for contracts).

    By using the document library top menu effectively, SharePoint becomes more than file storage—it becomes a structured, metadata-driven document management system that supports collaboration, reporting, and long-term organization.

    Organize Your SharePoint Site with a New Document Library

    When working with different types of files in Microsoft SharePoint, placing everything inside the default Documents library can quickly lead to clutter. Files with different purposes often require different metadata, views, and permissions. A much cleaner and more scalable approach is to create separate document libraries for distinct categories—such as one dedicated library for expense files.

    Using multiple document libraries keeps content organized, simplifies metadata management, and makes the site easier to maintain over time.

    Video Explanation

    Why Create a New Document Library?

    Creating a dedicated document library allows you to:

    For example, storing all expense-related documents in an Expenses library keeps them isolated from contracts, project files, or general documents.

    Steps to Create a New Document Library

    Follow these steps to create a new document library in your SharePoint site:

    1. Go to Site Contents
    2. Click New → App
    3. Switch to Classic Experience (if needed)
    4. Select the Document Library App
    5. Name Your Library
    6. Click Create

    Set Up and Use the New Library

    Once the library is created, you can:

    The new library will always be available under Site Contents, making it easy to return to and manage.

    Best Practice for Long-Term Organization

    Instead of using folders to separate file types, use multiple document libraries with clear purposes. This approach scales better, keeps metadata clean, and makes SharePoint easier for users to understand and use.

    Creating dedicated document libraries is one of the most effective ways to keep a SharePoint site organized, structured, and ready for growth.

    Site navigation links in Microsoft SharePoint make it easy for users to move around a site and quickly access important resources such as document libraries, lists, pages, or even external websites. A well-organized navigation panel improves usability and helps users find what they need without searching.

    In this section, you’ll learn how to add, edit, and remove links from the left-hand site navigation.

    Video Explanation

    You can add links to both internal SharePoint content and external websites.

    Steps to add a navigation link:

    1. Open your SharePoint site.
    2. Go to the left-hand navigation panel.
    3. Scroll to the bottom and click Edit.
    4. Hover between two existing links until a “+” (plus) icon appears.
    5. Click the + icon and select Link.
    6. Enter the link details:
    7. Click OK.
    8. When finished adding links, click Save at the bottom of the navigation panel.

    The new link will now appear in the site navigation.

    If a link is no longer needed, you can remove it easily.

    Steps to remove a link:

    1. Click Edit at the bottom of the navigation panel.
    2. Locate the link you want to remove.
    3. Click the trash (delete) icon next to it.
    4. Click Save to apply the change.

    The link will be removed from the navigation.

    Tip: Get the URL for a Document Library

    To add a navigation link to a document library (for example, Expenses):

    1. Go to Site Contents.
    2. Click the document library you want to link to.
    3. Copy the URL from the browser’s address bar
    4. Use this URL when creating the navigation link.

    By customizing site navigation links, you create a cleaner, more intuitive SharePoint site that helps users access important content quickly and efficiently.

    Create and Use a Picture Library in SharePoint

    A Picture Library in Microsoft SharePoint is a specialized type of library designed specifically for storing and viewing images. Unlike a standard document library, it provides a more visual, gallery-style experience, making it ideal for photos, graphics, or any image-heavy content.

    In this section, you’ll learn how to create a picture library, upload images, browse them easily, and optionally add the library to your site navigation for quick access.

    Video Explanation

    What Is a Picture Library?

    A Picture Library is optimized for images and offers features such as:

    It’s best used when the primary purpose of the library is to view and browse images, not documents.

    Steps to Create a Picture Library

    1. Go to Site Contents
    2. Create a New App
    3. Switch to Classic Experience
    4. Select Picture Library
    5. Name the Library

    Your new picture library is now created and listed under Site Contents.

    Upload and View Images

    1. Open the picture library from Site Contents.
    2. Click Upload and select image files from your computer.
    3. After uploading, images appear as tiles by default.

    Viewing images:

    This gallery-style navigation is what makes picture libraries different from standard document libraries.

    Change the Display Layout

    You can change how images are displayed based on your preference:

    These options let you balance visual appeal with organization.

    (Optional) Add the Picture Library to Site Navigation

    To make the picture library easy to access from anywhere on the site:

    1. Open the picture library and copy its URL (up to the library name, such as /Cars).
    2. Go to the left navigation menu.
    3. Click Edit at the bottom.
    4. Click the + (plus) icon where you want the link.
    5. Paste the URL and enter a display name (for example, Cars).
    6. Click OK, then Save.

    The picture library will now appear in the site navigation.

    When to Use a Picture Library

    A picture library is a great choice when:

    By using a picture library, you give users a clean, visual way to manage and explore images directly within SharePoint.

    A Quick Guide to SharePoint Library Settings

    In Microsoft SharePoint, document and picture libraries are more than just places to store files. Each library comes with a comprehensive Library Settings area that allows you to control behavior, structure, permissions, and user experience. Understanding these settings helps you design libraries that are secure, well-organized, and easy to use.

    This section provides a clear overview of how to access library settings and what each major area is used for.

    Video Explanation

    How to Access Library Settings

    Library settings are only available inside a library—they won’t appear if you’re on the site homepage.

    Steps to access:

    1. Open the document or picture library you want to manage (for example, Documents, Expenses, or Pictures).
    2. Click the Gear icon in the top-right corner.
    3. Select Library settings.
    4. On the settings page, click More library settings to open the full classic settings view.

    This classic page is where most configuration options live.

    General Settings

    General settings control the basic identity and behavior of the library.

    Common options include:

    Versioning is especially important for collaboration, auditing, and rollback.

    Advanced Settings

    Advanced settings define how the library behaves behind the scenes.

    Key options include:

    Most advanced settings can remain at their defaults unless you have specific requirements.

    Validation and Form Settings

    These settings help control how users enter data.

    These options are useful when accuracy and consistency are critical.

    Permissions and Management

    This section controls access and lifecycle management.

    Includes:

    Library-level permissions are helpful when access needs differ from the rest of the site.

    Column and View Settings

    This area controls how metadata and views work.

    You can:

    This is where libraries become structured, searchable, and user-friendly.

    Final Notes

    Library settings give you full control over how files are stored, accessed, and managed. Whether you’re building an HR document library, a finance repository, or a team knowledge base, properly configuring these settings ensures a secure, organized, and efficient SharePoint environment.

  • 1 – Creating and Familiarizing A Simple SharePoint Site

    Table of Contents

    1. Accessing SharePoint and Creating a Site
    2. Familiarizing Yourself with the SharePoint Site Interface

    • Accessing SharePoint and Creating a Site

    Microsoft 365 includes powerful tools for collaboration, and SharePoint is one of the most useful among them. It allows teams to share documents, organize information, and create dedicated spaces for projects or departments.

    In this section, you’ll learn how to log in to your Microsoft 365 portal and create a new SharePoint site. Even if you’re completely new, the process is simple and guided.

    Video Explanation

    Logging in to the Office Portal

    Before using SharePoint, you first need to sign in to your Microsoft 365 account. Once logged in, you can access all available apps from one place.

    Steps to log in:

    1. Open your browser and go to office.microsoft.com.
    2. Enter your work or school email and password.
    3. After signing in, you may be redirected to a different Microsoft 365 URL — this is normal.
    4. Use your organization account when prompted.
    5. After login, you’ll see the Microsoft 365 app launcher with apps like Outlook, Word, Teams, and SharePoint.
    6. Click SharePoint to open it.

    ✅ Key Point: SharePoint is included with Microsoft 365, so one login gives you access to all apps.

    Creating a SharePoint Site

    A SharePoint site acts as a central hub where your team can store files, share updates, and collaborate.

    Steps to create a site:

    1. On the SharePoint home page, click Create site (top-left corner).
    2. Choose Team site when asked for the site type.
    3. Select the default team template and click Use template.

    Configure your site:

    1. Click Create site.
    2. You can skip adding members for now and add them later.

    ✅ Key Point: A Private site keeps access limited to invited members, which is ideal for most teams and projects.

    Familiarizing Yourself with the SharePoint Site Interface

    A SharePoint site in Microsoft 365 is designed to make navigation and collaboration simple. Once you understand the layout, it becomes much easier to find information, manage files, and move between different areas of your site.

    In this section, we’ll walk through the main parts of a SharePoint site interface so you know what each area does and how it helps with daily work.

    Top Bar and Global Navigation

    At the very top of a SharePoint site, you’ll find tools that help you search and navigate across sites.

    Key areas:

    Site Home Page

    The site home page is made up of web parts, which you can think of as widgets that display different types of content.

    Common web parts include:

    1. News – Displays announcements and updates
    2. Quick Links – Provides shortcuts to important resources
    3. Documents – Shows recent or pinned documents
    4. Activity – Highlights recent actions on the site

    The home page acts like a dashboard where important information is grouped in one place.

    Site Apps and Left Navigation

    A SharePoint site is essentially a collection of apps (also called site contents). Each app serves a specific purpose and has its own screen and menu.

    The left-side navigation menu helps you move between these apps.

    Common apps include:

    To explore available content types, you can click New inside Site Contents and see what can be created.

    How Apps Work

    Each app in SharePoint has:

    For example, the Home page itself is an app with a layout and menu options.

    Understanding that a SharePoint site is built from apps makes it easier to manage and customize your site as your needs grow.

    Once you’re familiar with these areas, navigating SharePoint becomes much more intuitive, helping you find information faster and work more efficiently.