Loading...

Follow Trump Excel - Latest Excel tips, tutorials, and vi.. on Feedspot

Continue with Google
Continue with Facebook
or

Valid

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 […]

The post How to Make a PIE Chart in Excel (Easy Step-by-Step Guide) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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, […]

The post Count Distinct Values in Excel Pivot Table (Easy Step-by-Step Guide) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post How to Delete a Pivot Table in Excel (Easy Step-by-Step Guide) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post How to Delete a Pivot Table in Excel (Easy Step-by-Step Guide) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post How to Sort By Color in Excel (in less than 10 seconds) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post How to Add a Secondary Axis in Excel Charts (Easy Guide) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Excel allows having hyperlinks in cells which you can use to directly go to that URL. For example, below is a list where I have company names which are hyperlinked to the company website’s URL. When you click on the cell, it will automatically open your default browser (Chrome in my case) and go to […]

The post Hyperlinks in Excel (A Complete Guide + Examples) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Watch Video – How to Unhide Columns in Excel If you prefer written instruction instead, below is the tutorial. Hidden rows and columns can be quite irritating at times. Especially if someone else has hidden these and you forget to unhide it (or even worse, you don’t know how to unhide these). While I can’t […]

The post How to Quickly Unhide COLUMNS in Excel (A Simple Guide) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having used Excel for 10+ years). And among all these amazing functions, the INDEX MATCH functions combo stands out. I […]

The post Using Index & Match Functions Combo in Excel (10 Easy Examples) appeared first on Trump Excel.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Looking to recover unsaved Excel file, click here to jump to all the possible options you have to get the file back. Let me tell you the shortest horror story ever. Excel Crashed! Imagine working on that urgent report or that extremely important dashboard where you have done such a fantastic job. You are proud […]

The post How to Recover Unsaved Excel Files [All Options + Precautions] appeared first on Trump Excel.

Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview