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 …
Author: moon
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. …
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, …
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 …
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 …
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. …
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 …
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 …
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. …
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 …