Featured Tutorials
More than 100 Free Excel Tutorials in 1 Place
Over 100 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 3-D Formulas
With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.
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
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
Dashboards
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
Excel Spreadsheet Design
Good Spreadsheet Design Principles There are “Dos” and “Don’ts” when creating Excel spreadsheets. These can be categorized into two main areas: Workbook Structure Visual Design of Excel Worksheets Putting into practice and making a habit of as many of the following principles outlined in this post will elevate your spreadsheets miles/kilometers
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
Charts
Cash vs Accrual Accounting
There are 2 different accounting methods: Cash Accounting and Accrual Accounting. Check out this article which explains the difference with a story. This makes it really easy to understand the difference between cash basis and accrual method of accounting.
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.
Progress Circle using Excel Doughnut Chart
Progress Circle using Excel Doughnut Chart When displaying progress, it is common to represent the percentage complete with an advancing bar. To make the visual more interesting, we can connect the ends together and form a circle. This looks eerily like an Excel Doughnut chart.
Features
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.
Printing Tips
Your Excel Printing Problems, Solved! “Why is printing such an issue in Excel? This is one of the most common statements made by new, and veteran, Excel users. We write a document in Word, we hit “Print”, and the document comes out as expected. But why is that not the case
Import Data from Web to Excel
Easily Import Data from Web to Excel (2 Practical Examples) This post will demonstrate how to import data from the Web into Excel. There are many techniques available for this task; some are better than others, depending on the dynamic/changing nature of the Web data. For our examples, we will use
VBA
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
Sum Cells by Color
Sum Cells by Color In this VBA tutorial we will look at a way to sum cells based on their background color. Unfortunately, Excel does not possess a function that will provide this functionality. So how will we get this to work? Good question. We will write and build our OWN
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
Balance Sheet Secrets REVEALED with a Fun Demo
Balance Sheet Secrets REVEALED with a Fun Demo In this post, we're going to cover the basics of the balance sheet. It's also called the statement of financial position. This is where many people get confused. I'm going to be honest with you; it confused me for many years. I'm going
PROPERLY Record Debits and Credits with Examples
PROPERLY Record Debits and Credits with Examples (EASIEST Method) Today we're going to apply our knowledge of debits and credits. I'll show you how this translates into recording actual example transactions. We're going to use T-accounts in the beginning and move on to journal entries afterwards.
Debits and Credits MADE EASY with ADEx LER
Debits and Credits MADE EASY with ADEx LER If you want to learn accounting, the concept of debits and credits is one of the most important to understand. But, many struggle with it and for me, it was the same in the beginning because it's not something that's completely explainable with
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
Excel Dynamic Arrays – Excel will never be the same
Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything will change! You'll be using simple Excel formulas for