Loading...

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

Continue with Google
Continue with Facebook
or

Valid

Sparklines feature was introduced in Excel 2010. In this article, you'll learn all about Excel Sparklines and see some useful examples of it. What are Sparklines? Sparklines are tiny charts that reside in a cell in Excel. These charts are used to show a trend over time or the variation in the dataset. You can […]

The post Excel Sparklines – A Complete Guide with Examples appeared first on Trump Excel.

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

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

The post Excel VBA Split Function – Explained with Examples appeared first on Trump Excel.

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

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

The post Find the Last Occurrence of a Lookup Value a List in Excel appeared first on Trump Excel.

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

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

The post 100+ Excel Questions To Make You Interview Ready appeared first on Trump Excel.

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

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

The post Excel VBA Events – An Easy (and Complete) Guide appeared first on Trump Excel.

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

I recently had to get myself a Goods and Services Tax (GST) registration so that I can tax on my earnings. Once you have a GST number, you need to file your tax return every month. So every month, my Charted Accountant would reach out to me asking for sales invoices so that he can […]

The post [FREE Invoice Generator Template] Save Excel Invoice as PDF appeared first on Trump Excel.

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

With VBA, you can create a custom Function (also called a User Defined Function) that can be used in the worksheets just like regular functions. These are helpful when the existing Excel functions are not enough. In such cases, you can create your own custom User Defined Function (UDF) to cater to your specific needs. […]

The post Creating a User Defined Function (UDF) in Excel VBA [Ultimate Guide] appeared first on Trump Excel.

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

In this tutorial, I will cover the how to work with workbooks in Excel using VBA. In Excel, a ‘Workbook' is an object that is a part of the ‘Workbooks' collection. Within a workbook, you have different objects such as worksheets, chart sheets, cells and ranges, chart objects, shapes, etc. With VBA, you can do […]

The post Using Workbook Object in Excel VBA (Open, Close, Save, Set) appeared first on Trump Excel.

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

Apart from cells and ranges, working with worksheets is another area you should know about to use VBA efficiently in Excel. Just like any object in VBA, worksheets have different properties and methods associated with it that you can use while automating your work with VBA in Excel. In this tutorial, I will cover ‘Worksheets' in detail […]

The post Working with Worksheets using Excel VBA (Explained with Examples) appeared first on Trump Excel.

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

When working with Excel, most of your time is spent in the worksheet area – dealing with cells and ranges. And if you want to automate your work in Excel using VBA, you need to know how to work with cells and ranges using VBA. There are a lot of different things you can do […]

The post Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit) appeared first on Trump Excel.

Read Full Article
Visit website

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