Reader small image

You're reading from  Data Modeling with Microsoft Excel

Product typeBook
Published inNov 2023
PublisherPackt
ISBN-139781803240282
Edition1st Edition
Right arrow
Author (1)
Bernard Obeng Boateng
Bernard Obeng Boateng
author image
Bernard Obeng Boateng

Bernard Obeng Boateng is a Microsoft Excel MVP, Microsoft Certified Trainer, with over 10 years work experience in Banking, Insurance and Business Development. He is founder of Finex Skills Hub an approved Training Provider of the Financial Modeling Institute, Canada. Finex Skills Hub runs the Finex Project in Ghana, a pro bono student training outreach program for students in Data Analytics and Financial Modeling. Bernard also provides consultancy services for SMEs (start-ups and existing) in Financial Management, Business Planning and Research. He has an active audience online with about 17,000 followers on his LinkedIn Account. where he shares tips and tricks on Microsoft Excel and other Office Apps.
Read more about Bernard Obeng Boateng

Right arrow

Collaboration

Working together in Excel can make your projects better. It’s easy for everyone to chip in with their ideas when they can work on the dashboard at the same time. When you use platforms such as OneDrive or SharePoint with Excel, many people can work on the same workbook all at once. This helps get things done faster and makes sure the data is accurate. The Share feature in Excel lets you invite others to view or edit your workbook. This is great for big projects with many people involved.

Figure 10.15 – Accessing the Share option

Figure 10.15 – Accessing the Share option

You can set different permission levels, such as Can view or Can edit. This way, you control who can change your workbook.

Figure 10.16 – Setting permission levels

Figure 10.16 – Setting permission levels

Before allowing others to collaborate with you on your workbook or dashboard, let’s look at a few considerations:

  • Determine access levels: Decide who needs edit access versus who only needs...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Data Modeling with Microsoft Excel
Published in: Nov 2023Publisher: PacktISBN-13: 9781803240282

Author (1)

author image
Bernard Obeng Boateng

Bernard Obeng Boateng is a Microsoft Excel MVP, Microsoft Certified Trainer, with over 10 years work experience in Banking, Insurance and Business Development. He is founder of Finex Skills Hub an approved Training Provider of the Financial Modeling Institute, Canada. Finex Skills Hub runs the Finex Project in Ghana, a pro bono student training outreach program for students in Data Analytics and Financial Modeling. Bernard also provides consultancy services for SMEs (start-ups and existing) in Financial Management, Business Planning and Research. He has an active audience online with about 17,000 followers on his LinkedIn Account. where he shares tips and tricks on Microsoft Excel and other Office Apps.
Read more about Bernard Obeng Boateng