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 monthly 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 Dependent Drop Down Lists on Every Row
Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.
Excel Dynamic Sorted Chart
Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.
Excel’s Secret Count Text Trick
Check out this Excel formula hack to count text cells only. This mysterious syntax, excludes blank cells, numbers and also cells with formulas that result in an empty string.
Dashboards
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
Practical Excel Dashboard (Excel Hash 2019)
A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given four Excel features and asked to create a solution
Charts
Excel Dynamic Sorted Chart
Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.
Excel Dynamic Organizational Chart
Quickly create a data linked organizational chart in Excel with this new free tool available in Excel for Office 365. This free Visio addin can take data from an Excel table and visualize it as an Org chart.
Excel DGET Function
Quickly learn how to use Excel's DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It's a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.
Features
Windows 10 Top Tips & Tricks
Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!
Highlight Range with Blank Cells
You probably know the quickest way to select a column of data in Excel is with the shortcut CTRL + Shift + ⯆. But what do you do if that column includes blank cells and you'd like to highlight the entire column of data? Check out this post to find out.
Excel Printing Repeat Header Rows
As explored in a previous post (Your Excel Printing Problems, Solved!), we outlined the reasons why printing in Excel is a bit trickier than printing in Word.
VBA
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
Excel VBA GetOpenFileName to Browse and Select File
Dynamic User File Selection Using Excel VBA GetOpenFilename Method This post will demonstrate how we can allow a user to select a file using a traditional “open file”-type dialog box. This has tremendous advantages over hard-coded solutions where the filename and its location are statically defined in either VBA code... ...or
DYNAMIC ARRAYS
Excel FILTER Function
Excel's New Dynamic Array FILTER Function The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for data in a table. Situations you will benefit from when using the FILTER function include: Cases when you need
Practical Excel Dashboard (Excel Hash 2019)
A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given four Excel features and asked to create a solution
Excel’s XLOOKUP – 5 Examples
Excel's XLOOKUP 5 Examples By now, you may have read about Excel’s new super lookup function called XLOOKUP. XLOOKUP has the promise of becoming the only lookup function you’ll ever need for virtually any lookup problem you encounter. This will be a welcomed addition to Excel for those that struggle with
POWERPOINT
PowerPoint Merge Shapes Feature
PowerPoint Merge Shapes Feature This post will highlight one of the most useful, yet underutilized tools in PowerPoint when it comes to bringing your slides to the next level. The Merge Shapes Tool We are often advised not to get too fancy with our slides when working in a professional setting.
Use PowerPoint SLIDE ZOOM the RIGHT WAY
Use PowerPoint SLIDE ZOOM the RIGHT WAY Imagine walking into a meeting and seeing that the speaker is about to embark on a PowerPoint journey. The first thought you may have is, “Oh, no! Not another PowerPoint slideshow. I’d rather watch a slideshow of my grandparents vacation photos.” This common reaction
CHOOSE the RIGHT Chart Animation in PowerPoint
CHOOSE the RIGHT Chart Animation in PowerPoint Have you ever been tasked with presenting a chart or a graph in a meeting? If you are using PowerPoint during the presentation, the way you setup the PowerPoint slide matters. Let’s look and a normal (otherwise known as “boring and confusing”) slide and
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
Practical Excel Dashboard (Excel Hash 2019)
A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given four Excel features and asked to create a solution
Top 5 Excel Interview Questions
Top 5 Excel Interview Questions Over the past three decades, Excel has become the de facto standard spreadsheet program for businesses and individuals around the world. Excel accounts for an estimated 800 million users which translates to approximately 80% of all spreadsheet users. When entering the business world, a user whose
Over 200 Free Excel Tutorials in 1 Place
Over 200 Excel Tutorials in ONE Place The links in this file are updated on a monthly 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,