Microsoft Excel 365 gives us a new function – LET(). It is not available for every Microsoft 365 subscriber though. A few weeks ago my Excel did not have this function, but now I can work with it. I did a few examples when I was learning this feature and want to share them with…Read More LET function in EXCEL 365
Last release note for Azure Data Studio was about the update the SQL Server Import extension that was moved to General Availability last month. From now on it is possible to import flat files like *.txt or *.csv into SQL table using Azure Data Studio. Download a new version Azure Data Studio. At first, I…Read More Azure Data Studio – extension for SQL Server Import
This month Rob Volk (blog|twitter) hosts the #TSQL2SDAY event (see the invitation). I am going to tell you about how I was learning SQL JOIN. Very often I used analogies to learn or understand something. In my work, I tried to find a similar example fitted to a job that I was currently dealing with.…Read More T-SQL Tuesday #131: Data Analogies, or: Explain Databases Like I’m Five! – Magda
Today I have learned how I can use and change the tooltip in my visualizations in Power BI Desktop. So far I have used them with the default settings. From now on my charts could be much prettier when I change or add some details even other visualization. What is tooltip and what is for?…Read More Tooltip in Power BI Desktop.
I always used VLOOKUP formula, I could do it even with my eyes closed, but now when I have Excel 365 I can use XLOOKUP, which is similar but not the same. When I have learned this new functionality I found out that I also have an option to use dynamic array formulas in a…Read More XLOOKUP function and dynamic array formulas – Excel 365.
I found the CTRL+D shortcut key as an interesting feature in many programs. It can duplicate without using copy and paste. But not always. It is also D like DELETE, DISPLAY, or HIGHLIGHT… Microsoft Office Excel and Google Docs Spreadsheets. In Excel or Google Spreadsheet, CTRL +D duplicates content from the cell/cells row above. We need to…Read More D like Duplicate.
While I was preparing to work in the new (for me) Microsoft Office 365, I learned that Excel 365 already has the “built-in” Power Query add-in. It does not appear directly on the ribbon. It is located under the DATA tab. For previous versions of Excel, the Power Query add-in should be downloaded from the…Read More Power Query installation.
Many times happened to me when I received a PDF file with a table that I had to “type” into the program manually. Fortunately, the data didn’t have too many lines 10-20 at most, so it wasn’t time-consuming, but it was frustrating and it could cost a mistake. I wish I knew that before.This option…Read More Microsoft Excel functionality – Data import from PDF – very useful tool.
Hi, I am Magda and this is my first blog post. I have seen #TSQL2SDAY invitation from Elizabeth Noble (blog|twitter) for September and thought I would give it a try. I am going to tell you about my adventures in improving things at work. Intro As a non-technical worker, I can’t do changes on my…Read More T-SQL Tuesday #130: Automate Your Stress Away – Magda