Welcome to the official THAT OFFICE GUY channel where you will learn all about the various Microsoft 365 apps and more! Many of our videos cover the popular Microsoft Excel, Microsoft Teams, Microsoft Planner, Power BI, Power Automate, and all other basics in Microsoft 365.
With the Excel tips and tricks, you get to significantly improve your Excel reports - not just in terms of analysis but also visualization & VBA automation.
With Microsoft Teams you'll be able to achieve greater levels of communications with your colleagues - and with all the other Microsoft 365 applications you'll learn how to embed processes that cross the apps and increase productivity!
Subscribe if you'd like to improve your skills.
New videos are uploaded each week and live streams coming soon!
I have made about 4 different attempts to do this in the past over 2 years. This is the first video that I have come across that was successful at this. Thank you!
I followed the steps but some how the Planner date keeps showing 1 day behind after running the flow. Any advise? For example the dates on the form are 9/9/2024 - 9/10/2024. After flow the dates are 9/8/2024-9/9/2024.
hello I had some ideas to do automation with tools of our codes in a WordPress database, could you help me understand if the ideas I had are good and feasible
Can you help me solve this question? Using appropriate spreadsheet and database application 1. Create a database on a spreadsheet table such that update of the records in the spreadsheet table should not affect records in the database Secondly, The records of the spreadsheet table should consist of five columns of which the first three accepts text and the last two takes numeric data
To achieve this, you can use Microsoft Excel as your spreadsheet application and Microsoft Access as your database application. **Here's a step-by-step guide:** **1. Create the Excel Spreadsheet Table:** * Open a new Excel workbook. * Create a new sheet and name it "Spreadsheet Table". * In the first row, enter the column headers for your table: * Column 1: **Text Column 1** * Column 2: **Text Column 2** * Column 3: **Text Column 3** * Column 4: **Numeric Column 1** * Column 5: **Numeric Column 2** * Enter data into the remaining rows, ensuring that the data types match the specified column headers (text for the first three columns and numbers for the last two). **2. Create the Access Database:** * Open Microsoft Access and create a new blank database. * Create a new table and name it "Database Table". * Add five fields to the table, corresponding to the columns in your Excel spreadsheet: * **Field 1:** Text (specify the appropriate text length) * **Field 2:** Text (specify the appropriate text length) * **Field 3:** Text (specify the appropriate text length) * **Field 4:** Number (specify the appropriate data type and size) * **Field 5:** Number (specify the appropriate data type and size) **3. Establish a Link Between the Excel Table and the Access Database:** * In Excel, go to the **Data** tab and click **From Other Sources**. * Select **From Access**. * Browse to the location of your Access database file. * Choose the "Database Table" and click **OK**. * In the Import dialog, select **Create a new table**. * Click **OK**. * The Excel table will now be linked to the Access database. **4. Update Records in the Excel Table:** * Make any necessary changes to the data in the Excel table. * When you save the Excel workbook, the changes will be reflected in the linked Access database table. **Key Points:** * The link between the Excel table and the Access database ensures that changes made in Excel are automatically updated in the database. * This approach prevents accidental overwriting of data in the database, as the Excel table acts as a separate data source. * You can use Access to perform more complex database operations, such as querying, filtering, and reporting, on the linked data. By following these steps, you can effectively create a spreadsheet table and a linked database that allows you to update records in the spreadsheet without affecting the database directly.
This is not a great solution because it does not sync changes from Outlook into Google Calendar and it also leaves your Outlook calendar publically accesible.
Hi.. i created my flow to save attachments from email in sharepoint and post a message in teams, but it is posting 5 messages in teams same the email content only one attachments, how can i make to send only 1 message in teams and not 5? Maybe my signatures is being considered as attachments, right?
Hi... thank you so much for this video. However, I am trying to copy calendar from an .ost file to my google calendar. Is that something that can be done? Thank you.
I receive a warning message that hinders the flow from running. It says the following in the "Create an approval" section: "Power Automate Approvals has not been installed for this environment. Run this approval flow to initiate provisioning." Please help.
1. how to remove/delink it from file explorer without disturbing or editing/removing any file from teams/sharepoint? 2. how to get the latest updated file copy from teams sharepoint to file explorer if that file have red cross status( having sync problems) need the cloud copy instead of local?