Why You Should Be Using INDEX MATCH instead of VLOOKUP
Excel
After using Excel for many years, its power continues to surprise me on a constant basis. One of the best formulas and a personal favorite that’s included in almost every Excel 101 article is VLOOKUP. But what if I told you there are two other formulas, when used together, that make the VLOOKUP pretty much obsolete. While VLOOKUP is excellent …
Incredibly Useful Examples Of Excel User Defined Functions
Excel
In this post, we’re going to see how we can build our own custom functions in Excel with VBA, and we will look at some incredibly useful Excel User Defined Function examples that you can try in your everyday work. VBA has a special type of procedure which allows you to build your own functions for use in the workbook. …
The Beginner’s Guide to Excel Charts
Excel
In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, …
How to Create a Pivot Table in 5 Easy Steps
Excel
The pivot table is one of Microsoft Excel’s most powerful — and intimidating — functions. Powerful because it can help you summarize and make sense of large data sets. Intimidating because you’re not exactly an Excel expert, and pivot tables have always had a reputation for being complicated. The good news: Learning how to create a pivot table in Excel …
How to Create an Excel Dashboard in 7 Steps
Excel
Raw data can be hard to look at. Sure, the need-to-know digits are there. But, all of those rows and columns are often impossible to process and understand. This is where dashboards come into play. They turn data into information (yes, those are two different things!) by creating different charts, tables, and other visual elements that give you a high-level …
33 Excel Business Templates for Workplace Productivity (2020 Update)
Excel
1. Timeline template Time is a resource that can’t be gained back, which is why it’s essential to track it. This timeline template by Vertex42 gives you an overview of the milestones and events that team members should be aware of. 2. Gantt chart template Need something more sophisticated than a project timeline? Look no further than this Gantt chart template by Vertex42. …
The Beginner’s Guide to Excel Macros
Excel
With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. First, turn on the Developer tab. Where to access macros To get started, you first need to ensure that you have access to the various buttons …
Excel VBA – Advanced Filtering Tutorial
Excel
VBA stands for Visual Basic for Applications. Excel VBA is Microsoft’s programming language for Excel and all the other Microsoft Office programs, like Word and PowerPoint. The Office suite programs all share a common programming language. What is advanced filtering? VBA advanced filtering is used for more complex filtering needs that the AutoFilter in Excel cannot complete. You can filter …
A Beginner’s Guide to VLOOKUP vs Pivot Tables
Excel
What is VLOOKUP? VLOOKUP is a lookup and reference function in Excel. It is commonly used in a worksheet to look up and pull data from another Excel table or worksheet. For example, we have an Excel table named “Sales” which contains details of product sales for all months of the year. And another table named “Products” with product details. …
5 Tips to Conquer Your Taxes in Excel (Free Template Included)
Excel
Take your budget spreadsheet to a whole new level Budget spreadsheets are a great way to keep track of your finances. You can add up all of your income and expenses in one place and be well prepared to drop your final numbers into your tax prep software. While a basic budget spreadsheet is great, it is a rather manual …