Questions: I have 8 variables in columns A, 1,2,3,4,5, and A, B, C.My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: But what the code does is filters variables 1 to 5 and display them. I want to do the opposite but yield Read More
Category: Microsoft Office
How to Connect Buddi to a smart TV
Solution 1 – for those TV with URL launcher Uninstall the existing app if any Input “app.buddi.io” as the URL in settings Login with the staff id Click “View Board” Solution 2 – for those TV with Google Chrome Uninstall the existing Google Chrome Refresh, download and install Google Chrome Input “app.buddi.io” Login with the Read More
How to Connect to Power BI Dataset from Excel as a TABLE, not PIVOT.
Ok, here is an excellent solution. – open the pivot table – put a measure – double click a number in the PivotTable – you get a new worksheet with the details of the measure you double-clicked – right-click any cell of the table you see and click “Edit Query…” – replace the query content Read More
How to Select Multiple Worksheets in Excel VBA
Sometimes, you may want to select a group of worksheets in Excel. Below is the way how to do this. Sheets(Array(“sheetname1”, “Sheetname2”, etc…) Below, please see a sample.
How to Reduce the Excel File Size? – 7 Ways!
SaveShare Excel is an amazing tool for analyzing and visualizing data sets. To visualize and make report we often need to save small chunks of data. These small chunks of data grow over time and make the files heavier. But data is not the only reason behind the large size of your excel file. There Read More
How to Change Your Two-step Verification Method and Settings in Office 365
After you set up your security verification methods for your work or school account, you can update any of the related details, including: Default security verification method Security verification method details, like your phone number Authenticator app setup or deleting a device from the authenticator app Using the Additional security verification page If your organization Read More