Author: Bob Lin

• 1. Navigate to Office.com, sign in using your Microsoft credentials, and open the Admin app.

2. Open the SharePoint admin center

3. Click Policies, then click Sharing

4. Move the SharePoint slider to Anyone or New and existing guests.

5. Click Save

Situation: The client would like to know if there is a way to sum total expenses from different receipts and Invoices.

Resolution: In this example, we will use PDF files as receipts and Invoices format, combine them and export them to an Excel file. Then submit the Excel file to ChatGPT to sum total expenses. Here are the steps.

Step 1: How to convert PDF files into Excel spreadsheets

Step 2: Submit exported Excel file to ChartGPT to sum total amount. This is the example result.

Note: these is no way to upload the file to ChtGPT so that you need to copy and paste. And you may not be able to copy and paste a big file. You may separate the file, for example, into monthly data.

1. Combine all PDF files: In the left, click on Combine files.

Click on Add Files.

Select all PDF files.

Click on Combine.

2. In All tools, click on Export a PDF.

Select Microsoft Excel XLSX and then Convert to XLSX.

3. Save the converted file and Name your new Excel file and click the Save button. That’s it.

4. The new created Excel will open automatically.

Quoted from Microsoft:

Exchange Online

Expand table

SharePoint Online and OneDrive for Business

Expand table

Skype for Business Online and Microsoft Teams

Expand table

Microsoft 365 Common and Office Online

Expand table

 Note

Step 1: Create a network shared folder in your PC or server.

Step 2: Configure Scan to network Folder in Sharp MXC357F

1. Open the device web GUI by typing the IP address into a web browser.

2. On the left an, click Apps.

3. Click Scan Center-Network Folders.

4. Click Configure.

6. In the new tab, click Create Network Folder.

7. Enter Display Name, the domain, and the shared folder address. Change authentication options to Use static user name and password and enter a username and password that has access to the shared folder, then click Save.

8. Under Scan Center click Create Shortcut.

9. Enter Shortcut Name, check both the Display on Home Screen and Start scan immediately boxes, then click Add Network Folder.

10. Save the settings.

Step 3: Scan from panel.

1. To scan from the panel, load your originals head first into the document feeder, then touch the Advanced button.

2. Swipe to the left to move the menu to the second page, then touch the Shortcut key you just created to scan your document.

3. Fild the scanned file in your PC or server shared folder.

1. Type a word and highlight it.
2. Click on Insert and then Bookmark.

3. Type the Bookmark name and then Add.

4. Type words and click Link under Insert.

5. Click on Insert Link.

6. highlight the Bookmark you just added and click OK to save it.

7. Test it by Ctrl+Click.

1. Open Outlook and go to the People tab.

2. Select Home > New Contact Group.

3. In the Contact Group box, type the name for the group, for example chicagotech.

4. Click on Add Members , and you have 3 options:

Select From Outlook Contacts.

Select From Address Book.

Select New E-mail Contact.

5. Add people from your address book or contacts list, and choose OK. To select multiple people, hold down the Ctrl key as you choose members. 

6. Choose Save & Close.

To share a contact list that you created and stored in “Your Contact Lists” in Outlook, you can follow these steps:

1. Open Outlook and go to the People tab.

2. Select the contact list that you want to share from My Contacts.

3. Right click on the Contact folder you want to share and select Share>Share Contacts.

4. In the “Share Contacts” dialog box, enter the email addresses of the people you want to share the contact list with.

5. Add a message (optional) and click “Send”.

6. The recipients will receive an email with a link to the shared contact list. They can then open the link and access the contact list in their own Outlook for Windows account.

Step 1. Create a Public Folder

Go to the Exchange Admin Center by clicking “Admin”, then select “Exchange” from the drop down.

Step 1: Check if your system is compatible

1. Type msinfo32 in the search bar and click on Open.

2. make sure hypervisor has been detected.

Step 2: Enable Hyper-V on Windows 11

1. Type optionalfeatures and press Enter.