Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.
With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding!
Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows or format values based on another cell. Using the formula feature in conditional formatting is tricky. I share the secret to getting it right every time.
With the Office mobile app you can easily convert an image or a photo (jpeg, png or gif) into an editable Word document. You can also use this technique to convert an image into an Excel spreadsheet.
With Microsoft Forms you can easily create surveys & quizzes to share with others. You can export the results to Excel (You can also create an automatic connection between Forms and Excel online). Check out the complete tutorial to find out more.
Let's take a look at 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.
There are some things we wished we could do in Excel. Did you know you have access to absolutely FREE Excel add-ins which can improve your reporting, data analysis and make your life a LOT easier? I share my top 6 picks in this post.
Learn how to use Excel Pivot Tables to quickly summarize your data and create meaningful reports. In 10 minutes we cover everything you need to know about Pivot Tables.
You can spend a lot of time on design and formatting when you create dashboards in Excel. Discover 4 hidden tips that will make the process a lot easier.
Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized but it has a lot of hidden features. Read the article to find out more.