Featured Tutorials
Over 200 Free Excel Tutorials in 1 Place
Over 200 Excel Tutorials in ONE Place The links in this file are updated on a quarterly basis. Check back to get the latest file. On my YouTube channel, I often get questions like: "Do you have a video on *specific* topic?" or "How can I do *this* Excel task?" Actually, a lot of the videos on my channel are from you.
Formulas
Excel’s New LET Function
The new Excel LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster. How should you use this function and does it really make your files faster?
Excel Filter Function Trick Using Non-Adjacent Columns
Are you up for a really cool trick with Excel's new FILTER function? With this, you can get multiple match results from non-adjacent columns in a simple, dynamic way! You can also use it to get unique values from different columns. Check out the full article.
Excel IFS Function
The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.
Dashboards
Excel Hidden Dashboard Tips
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.
Understanding and Creating Barcodes in Excel
Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.
Excel Calendar with Holidays and Appointments
Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification (Risk Management Professional) working for Williams, a natural gas
POWER QUERY
Excel Pivot Tables from Multiple Sheets
This is a simple but advanced Pivot Table technique in Excel. If you'd like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.
Import PDF to Excel
Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.
Power Query – Time Calculations
Working with time in Excel - for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Did you know you can do this with a click of a few buttons? Let me show you how Power Query can easily do these for you.
Charts
Excel Histogram Chart
Histogram charts are easy to make in Excel. It might not be straightforward though how to adjust the bin numbers. It's really easy once you know. Check out this quick tutorial.
Excel Conditional Bar Charts
Properly show the variance to previous period using conditionally formatted bar charts. There is a simple trick to getting the negative bars in a different color to positive bars. You'll also discover a bonus trick to conditionally format any bars based on a logic.
Excel Filled Map Chart Using Power Query
Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.
Features
Excel Conditional Formatting with Formula
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.
Office App Convert Image to Table Excel
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.
Microsoft Forms
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.
VBA
Excel VBA Progress Bar
A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It's also quite easy to add. You can create your progress bar once and reuse it in your Excel vba projects.
Understanding and Creating Barcodes in Excel
Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.
Excel Get External Links
Get ALL External Links with THIS Simple Excel Trick (as NEVER seen before!) A terrific feature of Excel is the ability to pull data from external sources, like other Excel files. But with any benefit, there comes a cost. In this case, keeping track of the links and where the links
DYNAMIC ARRAYS
Yearly Calendar in Excel with Formula
Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.
Excel Filter Function Trick Using Non-Adjacent Columns
Are you up for a really cool trick with Excel's new FILTER function? With this, you can get multiple match results from non-adjacent columns in a simple, dynamic way! You can also use it to get unique values from different columns. Check out the full article.
Excel Top N with FILTER function
Create an Excel report with the top values and categories. What makes this impressive is that you will allow the user to define how many records are returned, such as the Top 5, Top 10, or any number they choose.
GOOGLE SHEETS
Create QR Code for Free
Easily create QR codes for free. You can copy and paste the QR code into any application including Microsoft Word, Excel and PowerPoint. I use a function in Google Sheets to set this up. You can grab your copy and replace the URLs with your own.
Google Sheets Filter Function
Learn how to properly use the Filter Function in Google Sheets. You can use the FILTER function to check for one condition or apply the FILTER function to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.
Google Sheets Column Stats Cleanup
Cleanup Suggestions and Column Statistics in Google Sheets In late 2020, Google released a new feature to Sheets called Smart Clean-up. Smart Clean-up has two main purposes: Cleanup Suggestions – Examine the dataset for potential problems, like duplicate rows in a table, extra spaces in the data, apply number formatting, or
POWERPOINT
5 PowerPoint Tips
In this post I share 5 PowerPoint tips and tricks you wished you knew sooner (At least I did!). These apply for PowerPoint business presentations as well as for students and teachers.
PowerPoint Slide Design Tips
How do you create professional looking PowerPoint slides? It comes down to small things. Most of which we don't notice when we watch presentations we love. I've broken it down into 5 tips which you can apply to your PowerPoint slides.
PowerPoint Hacks
Do you know these 5 PowerPoint hacks? With these you can get your PowerPoint presentation done a lot faster. Not only that, but your presentation will also look more professional.
Accounting & Finance
Time Value of Money
Time Value of Money “A dollar today is worth more than a dollar tomorrow.” It’s a saying that is true for any business as well as your own personal finances. It’s a simple principle that has a fancy name…Time Value of Money. Take this example: You’re selling a product for $10,000.
Calculating Returns for a Rental Property
Properly calculate returns on your rental property investment. This free Excel ROI calculator, makes it easy for you. In fact, you can use it to calculate the returns on any type of investment.
Cash Flow Statement
The Cash Flow Statement The Cash Flow statement is one of the three main financial statements, but it is often overshadowed by its companion statements – the Income Statement and Balance Sheet. The Income Statement provides information on Revenue and Profit over a certain period of time The Balance Sheet gives
OTHER NEWS
Electronic Signatures
In this tutorial I'll show you 3 free options you can use to create and insert your electronic signature in a PDF document, WORD or any other document of your choice. This makes it easy to sign pdf or other documents really fast.
Excel vs. Google Sheets
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.
Google Sheets vs Excel
Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.