Here are some of the major categories. Each have thousands of methods.
1) Use Worksheet Functions.
2) Create Pivot Tables.
3) Create Charts.
4) Perform Text to columns
5) Import External data (Data - Import External Data). This is performed
using Queries
6) Create your own worksheet functions whicb arte called UDF (User Defined
functions)
7) Create Events. There are lots of events which are VBA macros.
8) Create your own macro in VBA (Visual Basic)
9) Create Userforms either in worksheet or using VBA.
Here are some of the major categories. Each have thousands of methods.
1) Use Worksheet Functions.
2) Create Pivot Tables.
3) Create Charts.
4) Perform Text to columns
5) Import External data (Data - Import External Data). This is performed
using Queries
6) Create your own worksheet functions whicb arte called UDF (User Defined
functions)
7) Create Events. There are lots of events which are VBA macros.
8) Create your own macro in VBA (Visual Basic)
9) Create Userforms either in worksheet or using VBA.
This is a "how long is a piece of string" question. The answer can only be
something like in many, many ways limited to the requirement of the job and
your imagination.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
