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

3 How to Automatically Open Specific Excel File on Startup

Excel Startup Screen you see when you start it

Want some Excel files to open automatically when you start Excel? These could be files the that you open every day in the morning (such as tracking sheet or timesheet), or some project related files that you need to open as soon as you start Excel. While you always have the option to open these […]

1 How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)

Sorting data in Excel has been made quite easy with all the in-built options. You can easily sort your data alphabetically, based on the value in the cells, or by cell and font color. You can also do multi-level column sorting (i.e., sorting by column A and then by column B) as well as sorting […]

5 How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)

Excel has a variety of in-built charts that can be used to visualize data. And creating these charts in Excel only takes a few clicks. Among all these Excel chart types, there has been one that has been a subject of a lot of debate over time. …the PIE chart (no points for guessing). Pie […]

4 Count Distinct Values in Excel Pivot Table (Easy Step-by-Step Guide)

Distinct Count Helper Column in Pivot Table Data

Excel Pivot Tables are amazing (I know I mention this every time I write about Pivot Tables, but it’s true). With a basic understanding and a little drag and drop, you can get a bucket-load of work done in a few seconds. While a lot can be done with a few clicks in Pivot Tables, […]

0 How to Delete a Pivot Table in Excel (Easy Step-by-Step Guide)

Pivot Table is one of the best features in Excel. You don’t need to know any formula or coding to quickly crunch thousands of rows of data and create quick summaries out of it. All you need to know is how to drag and drop and a little bit of knowledge of how to create […]

2 How to Sort By Color in Excel (in less than 10 seconds)

Sort by multiple colors - select Green in the drop down

Excel has a lot of options when it comes to sorting data. And one of those options allows you to sort your data based on the color of the cell. For example, in the below dataset, you can sort by color to get the names of all the students who scored above 80 together at […]

0 How to Add a Secondary Axis in Excel Charts (Easy Guide)

Excel charts allow you to do a lot of customizations that help in representing the data in the best possible way. And one such example of customization is the ease with which you can add a secondary axis to Excel charts. But before I get into the mechanics of adding a secondary axis, let me […]

1 2 3 … 52 Next »