If you want to speed up processes in Excel then you'll want to know how to record macros in Excel. Related videos: Where to find the developer tab:http://youtu.be/XXJHiXXkKAE Input boxes (InoutBox): http://youtu.be/q5QygD7dvds Message boxes (MsgBox): http://youtu.be/kamx7NnsCZI Gary Schwartz from http://www.jargonfreehelp.com shows us how. This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

Using a message box in an Excel macro can be a really useful way of interacting with whoever is using it. It is done by using MsgBox and there are various parameters to make it work. You can display a simple message or get it to get a response which you can then use to get it to do various tasks. Gary Schwartz from http://www.jargonfreehelp.com shows us how. Related videos: Recorded macro, finished version used in this video http://youtu.be/Lod7Mp-VLx0 Input boxes: http://youtu.be/q5QygD7dvds This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

Using input boxes in Excel macros are a great way of interacting with users, inputting data and inputting options. Gary Schwartz from http://www.jargonfreehelp.com shows us how. Related videos: Recording Macros: http://youtu.be/Lod7Mp-VLx0 MsgBox (message box): http://youtu.be/kamx7NnsCZI This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

Excel has lots and lots of functions but you might find that there is not one that suits your needs. You may also have a formula you are creating using an IF function but it is either looking a bit difficult to do in the formula bar or you have run out of using the IF function, there are a limit of up to seven IFs that you can nest. A good solution is to use a custom function, these allow you to create a function, add arguments and have as many conditions as you like. You can also create your own calculation based on your needs. You can then share the workbook so that others can use it on their workbooks and you can use it across many workbooks too rather than having to copy the formula or functions across. If you want to have the functions, or macros, open up so they are always available you can do this using the Addin feature. To see how to do that check out this video https://youtu.be/MB5p7MAfQTQ Chapters 0:00 Start 1:00 Enabling content 3:28 Displaying the Developer tab (Windows version) 3:53 Displaying the Developer tab (Mac version) 10:16 Sample 2, calculating commission 14:27 Saving as a macro enabled workbook If you want to see more then check out my website http://www.jargonfreehelp.com

If you want to speed up how you do repetitive tasks when you are using Excel then you might want to consider using Macros to help you out here. What a Macro does is remember what you do and then recall it whenever you want. So if you want to save a film print it and have to always choose the particular print settings then you can get Excel to remember that and play it back for you at the click of a button. The same principles apply to Excel 2007 and 2010 so you could have a go, although an updated tutorial is on its way. Here Gary Schwartz from http://www.jargonfreehelp.com show you how in this video tutorial.

Using the IF statement in Excel allows it to do different things based on conditions you have set such as displaying whether a student has passed or failed an exam. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.

You might want to use add-ins if you have created your own macro or custom function and you want it to always be available when you open up Excel. Or maybe it is from someone or somewhere else that you have got them from. By using Add-ins you can make this and other tools available whenever you open Excel. This can be very useful if you are creating your own functions and macros and you want them available to your team, throughout your company, collaborators or just your friends. If you want to know how to create a custom function check out this video https://youtu.be/-i_xEVQ5l6Y If you want to see more then check out my website http://www.jargonfreehelp.com

If you have created a custom function in Excel you may want to have it available in all your workbooks or perhaps you want to distribute to a group of people such as colleagues or fellow classmates. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. Other related tutorials: How to create a custom function: http://youtu.be/3tmfXXOr6Eg

Excel has lots of built in functions but sometimes it doesn't have what you want or perhaps you need to create a formula that uses lots of IF functions and it is either going to get confusing or you are going to hit the limit of the amount of conditions you are allowed. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. Other useful tutorials: How to turn a custom function into an add-in http://youtu.be/O_wqEkypuP4

If you are using macros in Excel, Word, PowerPoint, Access or MS Project then you will need to know how to dimension variables in VBA. Visual Basic for Applications can help you do a lot to speed up your work and this quick overview of variable will help. Here Gary Schwartz from http://www.jargonfreehelp.com explains them.

If you have Excel for Windows you might be wondering where the macros have gone. They are still there but you have to make the developer tab visible to access them. If you want to record macros you will need this available. Gary Schwartz from http://www.jargonfreehelp.com shows us how. How to record a macro in Excel: https://youtu.be/Lod7Mp-VLx0

We all like to speed up how we work. So wouldn't it be good if you are using Excel to take some of the repetitive tasks out of your workload. Well you can by using macros. Macros are a set of instructions that can be played over and over such as importing data, then formatting it and saving in a particular format such as a PDF, or maybe printing it. Thankfully you don't need to be a computer programer to do this. You can simply get Excel to remember it by recording what you do. This works almost identically on both the Windows and Mac versions so I have made a video that shows you both. They really are very small differences. If you want to see more then check out my website http://www.jargonfreehelp.com This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.