Prideema's Pro-Tip

I receive Covid-19 patients report everyday that I save in a folder. These reports have similar data-set and I have to create a consolidated report using these multiple files. How I do: I have to manually save each report in a folder than copy paste its data to a Master sheet which takes considerable amount of time. How can I do it better : You can create a Master Sheet with Power Query in Microsoft Excel and Power BI that consolidates your excel/ csv file reports at one plae and also provides option like Refresh . Power Query comes with the feature of Refresh that you can use to either refresh your Master Sheet data to update changes in your existing reports or to update data of new file from your Master folder. To know how to do above action, click on the tab according to your software preferences Microsoft Excel Power BI Microsoft Excel ABOUT: With Power Query, you can search for data sources, make links, and then form the data in ways the suit y

  I always book my calendar when I am on leave or holiday. But, I forget to set up automatic reply Outlook Pro Tip: Microsoft flow can setup your automatic reply automatically. STEP 1:  Open Microsoft flow, and click  New  >  Automated-from blank . Click "When an upcoming event is starting soon". Enter Look-Ahead time. STEP 2:  Click New Step   and select Condition . Choose a value as Show as and select is equal to . Enter value according to list:   Status  Value  Free 0  Tentative 1  Busy 2  Out of Office 3 STEP 3: In If Yes tab, click Add an action  and select Set up automatic reply . Enter your message in Internal Reply Message and External Reply Message box. Save your template.

  I am receiving lot of change requests from my Customers - Microsoft Form. Creating and tracking each task becomes difficult. Prideema's PRO-TIP Traditionally, you might use advance tracking tools to do so and might end up paying lot for such tools. Assigning tasks to your team members is an extra effort.So if you have Office 365 in your PC, you can automatically create a task and assign it to your team members as soon as you receive response. Pre-requisites Microsoft Form as Customer Change request form Microsoft Planner to assign tasks STEP 1: Open Microsoft flow, and click  New > Automated-from blank .  Select "When a new response is submitted" trigger. Choose your Microsoft form. STEP 2: Add action "Get Response Details". STEP 3: Add Action "Create Task". Enter details like Group ID and Plan ID . Click Save .