Excel Blog - Latest Excel tips, tutorials, and videos.

0 10 Advanced Excel Charts that You Can Use In Your Day-to-day Work

While Excel is mostly used for data entry and analysis, it also has some great chart types that you can use to make your reports/dashboards better. Apart from the default charts that are available in Excel, there are many advanced charts that you can easily create and use in your day-to-day work. In this tutorial, […]

0 Combine Data From Multiple Worksheets into a Single Worksheet in Excel

Combine Data from Multiple sheets into one single sheet

I recently got a question from a reader about combining multiple worksheets in the same workbook into one single worksheet. I asked him to use Power Query to combine different sheets, but then I realized that for someone new to Power Query, doing this can be tough. So I decided to write this tutorial and […]

0 Excel Sparklines – A Complete Guide with Examples

Sparklines feature was introduced in Excel 2010. In this article, you’ll learn all about Excel Sparklines and see some useful examples of it. This Tutorial Covers: What are Sparklines?Types of Sparklines in ExcelInserting Sparklines in ExcelEditing the DataSet of Existing SparklinesHandling Hidden and Empty CellsChanging the Sparkline TypeHighlighting Data Points in SparklinesSparklines Color and StyleAdding […]

0 Excel VBA Split Function – Explained with Examples

VBA Split Function - address in separate lines formula

When working with VBA in Excel, you may have a need to split a string into different parts based on a delimiter. For example, if you have an address, you can use the VBA Split function to get different parts of the address that are separated by a comma (which would be the delimiter in […]

9 Find the Last Occurrence of a Lookup Value a List in Excel

In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as the ‘Meeting Chair’. […]

2 100+ Excel Interview Questions & Answers To Make You Job Ready

Excel Questions for Job Interview - Cover

Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the work […]

0 Excel VBA Events – An Easy (and Complete) Guide

When you create or record a macro in Excel, you need to run the macro to execute the steps in the code. A few ways of running a macro includes using the macro dialog box, assigning the macro to a button, using a shortcut, etc. Apart from these user-initiated macro executions, you can also use VBA […]

1 2 3 … 48 Next »