Cisco Training Courses

Insoft has been serving IT community with official Cisco training offering since 2010. Find all the relevant information on Cisco training on this page.

View More

Cisco Certifications

Experience a blended learning approach that combines the best of instructor-led training and self-paced e-learning to help you prepare for your certification exam.

View More

Cisco Learning Credits

Cisco Learning Credits (CLCs) are prepaid training vouchers redeemed directly with Cisco that make planning for your success easier when purchasing Cisco products and services.

Have CLCs and want to redeem them?

Cisco Continuing Education

The Cisco Continuing Education Program offers all active certification holders flexible options to recertify by completing a variety of eligible training items.

View More

Cisco Digital Learning

Certified employees are VALUED assets. Explore Cisco official Digital Learning Library to educate yourself through recorded sessions.

Browse CDLL Catalogue

Cisco Business Enablement

The Cisco Business Enablement Partner Program focuses on sharpening the business skills of Cisco Channel Partners and customers.

View More

Fortinet Technical Certifications

The Fortinet Network Security Expert (NSE) program is an eight-level training and certification program to teach engineers of their network security for Fortinet FW skills and experience.

View More

Fortinet Technical Courses

Insoft is recognised as Fortinet Authorized Training Center in selected locations across EMEA.

View More

Official ATC Status

Check our ATC Status across selected countries in Europe.

View More

Fortinet Services Packages

Insoft Services has developed a specific solution to streamline and simplify the process of installing or migrating to Fortinet Products.

Browse Packages

Prepforce Bootcamp

The only comprehensive source available today to prepare for Fortinet NSE 8 certification globally.

View More

Microsoft Training

Insoft Services provides Microsoft training in EMEAR. We offer Microsoft technical training and certification courses that are led by world-class instructors.

View More

Technical Training

The evolution of Extreme Networks Technical Training provides a comprehensive progressive pathway from Associate to Professional accreditation.

View More

ATP Accreditation

As an authorised training partner (ATP), Insoft Services ensures that you receive the highest standards of education available.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

Our Mission: Provide an expert set of modern & leading edge Network Automation skills to the market through professional services.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

We help organisations to deploy Software-Defined Networking (SDN) solutions, such as Cisco DNA. Besides, our team has extensive experience in integrating Cisco DNA Center with third-party systems.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

About Us

Our training portfolio includes a wide range of IT training from IP providers, including Cisco, Extreme Networks, Fortinet, Microsoft, to name a few, in EMEA.

View More

Microsoft Lists for End Users

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Microsoft Lists for End Users

Enroll Now
Microsoft Lists for End Users
Duration
1 Days
Delivery
(Online and onsite)
Price
Price Upon Request
This course delivers an instructor-led breakdown of Microsoft Lists. Students will be taught how to empower their data and become organised with a rich range of customisable table types. We will take users through a selection of well-crafted lessons to help design modern ways of working with data for their business that will include blending your list with other Office 365 services.
  • Understand where to set up a list and its availability.
  • Implement a range of templates.
  • Design visual characteristics.
  • Manage your favourite lists.
  • Configure list settings.
  • Customise existing columns.
  • Add new columns.
  • Design calculated columns.
  • Use lookup columns.
  • Add managed metadata.
  • Format your columns.
  • Design new views.
  • Format existing views.
  • Remove components of a list.
  • Use lists on mobile devices.
  • Design custom forms
  • Integrate lists with business processes.

Module 1: An Introduction to Microsoft Lists

Let’s get started with an introduction to Microsoft Lists. In this module you will learn more about the origins of the Microsoft Lists product and where it fits in Office 365. You will discover the business benefits of this tool and how it can be integrated into other Office 365 services. Lists is an incredibly versatile tool and can form the backbone of many customised business services when combined with the power platform and other apps.

Lessons

  • What is Microsoft Lists?
  • How can lists help me in my role?
  • How does lists benefit other Office 365 services?
  • Introducing Microsoft SharePoint
  • How does Microsoft Lists fit into SharePoint?
  • Types of lists
  • An overview of columns and views
  • An overview of list settings

Lab 1: Setting up a new Team

  • Download our training files
  • Create a new Microsoft Team

After completing this module, students will be able to:

  • Understand when and where to use a list
  • Describe how columns and views make up a list
  • Explain how lists can benefit other Office 365 services
  • Set up a SharePoint site or Team for collaborative lists

 

Module 2: Getting Started with Microsoft Lists

To begin our journey through the Microsoft Lists product, we will begin by looking at some of the templates that are available to view and edit. Microsoft’s templates are a good starting point for discovering what the product is capable off and how that can be achieved. We will also take the chance to have a tour of alist and where we can customise the list so that students are familiar with the interface that they will be using over the one-day course. We will also build our first list from an Excel file, showing students how to upgrade their existing data sources into a new list. We will also discuss how to configure your list settings and how to introduce new types of columns and views.

Lessons

  • Navigating to Microsoft Lists
  • Creating a new list
  • My lists vs SharePoint lists
  • Creating a new list
  • Creating a new list from an Excel file
  • Customising list settings
  • Adding columns
  • Managing and removing columns
  • Creating views
  • Managing and removing views
  • Adding data to a list
  • Editing single or multiple records
  • Version history
  • Delete and restore records
  • Delete and restore lists
  • Embed your lists into other Office 365 services

Lab 1: Getting Started

  • Create a new list from a template
  • Add new columns
  • Customise your default view
  • Add a new view
  • Add records to your list
  • Recover from a mistake
  • Delete and recover a record
  • Embed a list in a Team

After completing this module, students will be able to:

  • Build a useful list using templates in minutes
  • Make simple changes to existing list
  • Know how columns and views are used in Microsoft Lists
  • Be able to add new records to a list
  • Restore a previous version of a records
  • Remove lists, columns and views

 

Module 3: Advanced columns and formatting

In our next module we will be looking at more advanced logic within Microsoft Lists. This will include a range of advanced columns that are derived by SharePoint that will greatly benefit your end users experience when using your list. This is a low-code/no-code module so only simple formulas will be leveraged to bring calculations to your columns. We will also explore formatting which helps you control the look and feel of your list based on the data within it. We will earn about how to use design mode to implement these changes and how more advanced users can leverage advanced mode to apply JSON code to a column or view.

Lessons

  • Advanced column types
  • Managed metadata
  • Calculated columns
  • Using lookup columns
  • Geolocation columns
  • Implementing formatting
  • Using design mode for columns
  • Using design mode for views
  • How to use advanced mode

Lab 1: Add advanced columns and apply formatting

  • Create a new list from an Excel file
  • Add advanced column types to the list
  • Format your columns and views

After completing this module, students will be able to:

  • Add a range of advanced column types to your list
  • Understand the managed metadata service and its benefits
  • Use formatting to customise list columns and views
  • Understand where JSON code can be used to format a list

 

Module 4: Customise your data entry form

The gateway to adding data to your list is its form. If you would like to customise this form there are a couple of ways to do this. You may choose to simply reorder or remove fields and this can be done directly from the form. For more advanced scenarios like branding a form or adding additional logic, you will need to use Power Apps. Power Apps works hand in hand with lists, offering a range of ways to improve your end user form experience. In this module we will show you how to make quick changed to your form directly in Microsoft Lists and how to enhance a form even further with Power Apps. We will also discuss how Power Apps can turn your list into a new mobile app.

Lessons

  • Customising a list form
  • Introducing Power Apps
  • Editing a form in Power Apps
  • Adding images
  • Changing colours
  • How to manage input visibility
  • Using conditional formatting
  • Adding screens
  • Building a navigation
  • Publishing your updates
  • Reverting back to the default form
  • Turning your list into a mobile app

Lab 1: Customise your form

  • Remove unwanted fields from your form
  • Open your form using Power Apps
  • Apply a business logo to the form
  • Hide a control based on another control
  • Highlight a field as red if empty
  • Publish and test your form

After completing this module, students will be able to:

  • Understand when to make changes to a form in Microsoft Lists and when to use Power Apps
  • Be aware of what Power Apps can deliver to both your list form and to your list as a whole
  • Be able to make customisations to a list form using Power Apps
  • Turn a list into a custom mobile app in minutes

 

Module 5: Trigger business processes

In our last module we will explore using our lists to trigger common business processes. These could range from a simple notification to pop up in a Microsoft Teams chat to an approval request sent to a users mailbox. The benefit of our lists is that it contains a wealth of information that can be leveraged in an automated business process. Using Microsoft Power Automate, directly from your list, we can begin to explore how we can use helpful templates to quickly implement common business processes based around events in our list, for example submitting a new record.

Lessons

  • What is Power Automate?
  • How do flows start in a list
  • How to add design-free workflows to a list
  • How to add flow templates to a list
  • Working with actions in a flow
  • Save and test a flow
  • Turn off or delete a flow

Lab 1: Design an approval process

  • Create a new flow based on an existing tempalte
  • Customise the flow to combine Teams with an approval process
  • Save and test your flow

After completing this module, students will be able to:

  • Understand how to trigger processes from your list using Power Automate
  • Feel comfortable adding, editing and removing actions in a flow
  • Know how to manage a flow associated with a list

This class can benefit a wide range of users that are looking at modern ways of working with data. This may be tracking assets, tasks, events and more in an engaging way that keeps people aware of evolving business narrative.

  • No previous experience of Microsoft Lists is required
This course delivers an instructor-led breakdown of Microsoft Lists. Students will be taught how to empower their data and become organised with a rich range of customisable table types. We will take users through a selection of well-crafted lessons to help design modern ways of working with data for their business that will include blending your list with other Office 365 services.
  • Understand where to set up a list and its availability.
  • Implement a range of templates.
  • Design visual characteristics.
  • Manage your favourite lists.
  • Configure list settings.
  • Customise existing columns.
  • Add new columns.
  • Design calculated columns.
  • Use lookup columns.
  • Add managed metadata.
  • Format your columns.
  • Design new views.
  • Format existing views.
  • Remove components of a list.
  • Use lists on mobile devices.
  • Design custom forms
  • Integrate lists with business processes.

Module 1: An Introduction to Microsoft Lists

Let’s get started with an introduction to Microsoft Lists. In this module you will learn more about the origins of the Microsoft Lists product and where it fits in Office 365. You will discover the business benefits of this tool and how it can be integrated into other Office 365 services. Lists is an incredibly versatile tool and can form the backbone of many customised business services when combined with the power platform and other apps.

Lessons

  • What is Microsoft Lists?
  • How can lists help me in my role?
  • How does lists benefit other Office 365 services?
  • Introducing Microsoft SharePoint
  • How does Microsoft Lists fit into SharePoint?
  • Types of lists
  • An overview of columns and views
  • An overview of list settings

Lab 1: Setting up a new Team

  • Download our training files
  • Create a new Microsoft Team

After completing this module, students will be able to:

  • Understand when and where to use a list
  • Describe how columns and views make up a list
  • Explain how lists can benefit other Office 365 services
  • Set up a SharePoint site or Team for collaborative lists

 

Module 2: Getting Started with Microsoft Lists

To begin our journey through the Microsoft Lists product, we will begin by looking at some of the templates that are available to view and edit. Microsoft’s templates are a good starting point for discovering what the product is capable off and how that can be achieved. We will also take the chance to have a tour of alist and where we can customise the list so that students are familiar with the interface that they will be using over the one-day course. We will also build our first list from an Excel file, showing students how to upgrade their existing data sources into a new list. We will also discuss how to configure your list settings and how to introduce new types of columns and views.

Lessons

  • Navigating to Microsoft Lists
  • Creating a new list
  • My lists vs SharePoint lists
  • Creating a new list
  • Creating a new list from an Excel file
  • Customising list settings
  • Adding columns
  • Managing and removing columns
  • Creating views
  • Managing and removing views
  • Adding data to a list
  • Editing single or multiple records
  • Version history
  • Delete and restore records
  • Delete and restore lists
  • Embed your lists into other Office 365 services

Lab 1: Getting Started

  • Create a new list from a template
  • Add new columns
  • Customise your default view
  • Add a new view
  • Add records to your list
  • Recover from a mistake
  • Delete and recover a record
  • Embed a list in a Team

After completing this module, students will be able to:

  • Build a useful list using templates in minutes
  • Make simple changes to existing list
  • Know how columns and views are used in Microsoft Lists
  • Be able to add new records to a list
  • Restore a previous version of a records
  • Remove lists, columns and views

 

Module 3: Advanced columns and formatting

In our next module we will be looking at more advanced logic within Microsoft Lists. This will include a range of advanced columns that are derived by SharePoint that will greatly benefit your end users experience when using your list. This is a low-code/no-code module so only simple formulas will be leveraged to bring calculations to your columns. We will also explore formatting which helps you control the look and feel of your list based on the data within it. We will earn about how to use design mode to implement these changes and how more advanced users can leverage advanced mode to apply JSON code to a column or view.

Lessons

  • Advanced column types
  • Managed metadata
  • Calculated columns
  • Using lookup columns
  • Geolocation columns
  • Implementing formatting
  • Using design mode for columns
  • Using design mode for views
  • How to use advanced mode

Lab 1: Add advanced columns and apply formatting

  • Create a new list from an Excel file
  • Add advanced column types to the list
  • Format your columns and views

After completing this module, students will be able to:

  • Add a range of advanced column types to your list
  • Understand the managed metadata service and its benefits
  • Use formatting to customise list columns and views
  • Understand where JSON code can be used to format a list

 

Module 4: Customise your data entry form

The gateway to adding data to your list is its form. If you would like to customise this form there are a couple of ways to do this. You may choose to simply reorder or remove fields and this can be done directly from the form. For more advanced scenarios like branding a form or adding additional logic, you will need to use Power Apps. Power Apps works hand in hand with lists, offering a range of ways to improve your end user form experience. In this module we will show you how to make quick changed to your form directly in Microsoft Lists and how to enhance a form even further with Power Apps. We will also discuss how Power Apps can turn your list into a new mobile app.

Lessons

  • Customising a list form
  • Introducing Power Apps
  • Editing a form in Power Apps
  • Adding images
  • Changing colours
  • How to manage input visibility
  • Using conditional formatting
  • Adding screens
  • Building a navigation
  • Publishing your updates
  • Reverting back to the default form
  • Turning your list into a mobile app

Lab 1: Customise your form

  • Remove unwanted fields from your form
  • Open your form using Power Apps
  • Apply a business logo to the form
  • Hide a control based on another control
  • Highlight a field as red if empty
  • Publish and test your form

After completing this module, students will be able to:

  • Understand when to make changes to a form in Microsoft Lists and when to use Power Apps
  • Be aware of what Power Apps can deliver to both your list form and to your list as a whole
  • Be able to make customisations to a list form using Power Apps
  • Turn a list into a custom mobile app in minutes

 

Module 5: Trigger business processes

In our last module we will explore using our lists to trigger common business processes. These could range from a simple notification to pop up in a Microsoft Teams chat to an approval request sent to a users mailbox. The benefit of our lists is that it contains a wealth of information that can be leveraged in an automated business process. Using Microsoft Power Automate, directly from your list, we can begin to explore how we can use helpful templates to quickly implement common business processes based around events in our list, for example submitting a new record.

Lessons

  • What is Power Automate?
  • How do flows start in a list
  • How to add design-free workflows to a list
  • How to add flow templates to a list
  • Working with actions in a flow
  • Save and test a flow
  • Turn off or delete a flow

Lab 1: Design an approval process

  • Create a new flow based on an existing tempalte
  • Customise the flow to combine Teams with an approval process
  • Save and test your flow

After completing this module, students will be able to:

  • Understand how to trigger processes from your list using Power Automate
  • Feel comfortable adding, editing and removing actions in a flow
  • Know how to manage a flow associated with a list

This class can benefit a wide range of users that are looking at modern ways of working with data. This may be tracking assets, tasks, events and more in an engaging way that keeps people aware of evolving business narrative.

  • No previous experience of Microsoft Lists is required
    Upcoming Dates
  • ` Feb 13 2023
  • ` Mar 13 2023
  • ` Apr 10 2023
  • ` May 8 2023
  • ` Jun 5 2023
  • ` Jul 3 2023