Welcome Hello, I am Radu and I live in Oradea, Romania. I created this site to help you be more productive with the office software you use most often. Let’s keep in touch, follow me on Facebook or YouTube.
Power Query with source from a cell How can I import a file with Power Query with a custom file path, one that is in a cell in my Excel file? Good question, here is how. Select file macro code I showed you a button in the video that enabled you to select the file you wanted to import and put the […]
Airtable Tutorial – Getting Started If you’re one of those people (like me) that constantly push Excel to its limits, you really should check out Airtable. It’s a web app that looks like Access and Google Sheets’s baby. 🙂 No, really? Yes, it’s an online DB app that enables you create really cool tools using DB features. I know that […]
Compare Excel tables using Consolidate Ever needed to compare tables in Excel. Hope you never did it row by row. 🙂 If you know a few things about Excel, you probably know hot to compare tables using VLOOKUP. You need 2 of them actually and then with a filter, you can get the job done. Comparing using Consolidate This method […]
Free Excel online course: the ultimate guide Searching for a free Excel online course? Check out my collection of Excel tutorials that will help you go from zero to ninja in Excel. Best I could find As there are lots of free tutorials about Excel on YouTube what I did in this article was to put the best together into a framework […]
Protect sheet structure in Excel A lot about my work is related to delivering MS Excel trainings, the last one was just yesterday actually. I get all kinds of questions, one that stuck with me was: Radu, how can I prevent someone from inserting new rows or columns in a sheet and, in the same time, enable them to fill […]
Get decimal value in Excel Radu, how do I get the decimal value from a number using Excel? Well, there is the short answer and then there is the long answer. Here is the short one, see image bellow. And in case you missed the formula here it is. If you are familiar with Excel, probably it’s pretty easy to […]
How to send emails from Excel (VBA code included) Radu, is there a simple way to send emails from Excel? I have a file with approvals and I want the people involved in the process to be nitified when we someone hits the “approve” button. This was a question I received from one of the participants in one of my advanced Excel courses. My […]
PowerPoint 2016 Zoom – aka Prezi in PowerPoint Would it be possible to create the cool zooming effects we have in Prezi in PowerPoint? Well, actually, if we have the latest version of PowerPoint we can, with the new PowerPoint 2016 zoom feature. New features in PowerPoint Usually I don’t get really excited about new features in PowerPoint because they usually are just gimmicks. PowerPoint […]
Advanced Excel Filters – Tips and Tricks Advanced Excel filters? what can be advanced about Excel filters? Yes, filters are a pretty simple part of Excel, we don’t struggle with them, until we want to do something more complex. Advanced filters? Ok, Radu, what are we talking about? Maybe you are wondering: How to filter numbers on a column between 2 values? […]