MS Excel macros can boost your productivity, saving you a lot of the time you spend on doing boring tasks, such as formatting or printing. If you didn’t know by now, find out how you can use a macro across all worksheets:
After you choose Tools, Macros, Record New Macro, in the dialog box, at [...]
Do you know what a macro is? Or how to make a MS Excel macro? Have you ever made a macro? If you had, it means you use it frequently, this is why you made it, isn’t it? It must be boring though, every time you want to run it, to go to the main [...]
This simple exercise supposes that you already know what a MS Excel formula is and that you currently work with formulas. If you do so, then you know that formulas in cells can be seen. A click on the respective cell makes the contained formula visible in the formula bar, just above the worksheet. It [...]
Pivot table is a command in MS Excel which allows thorough analyses of a given database. It can help you group the information in a table by dynamic criteria. As an example, supposing that you have recorded all the sales you had over the past two years, you can group them to see how much [...]
Working in a team can be irritating if some of the team members don’t play by the rules you all agreed when you started a project. Imagine this situation: for this team, you created some Excel templates which the other members need to fill in and return them to you, so you can put them [...]
It happens many times that we have to accomplish boring repetitive tasks in MS Excel, such as formatting cells in lots of tables, to make them look more professional, in order to print, let’s say, a report for a client. Those tasks, although easy to do, require a lot of time to complete. Repetitive tasks [...]
I don’t know how many Microsoft Excel users take advantage of all its features or even know such features exist. Probably very few ones. Although I have used this software a lot, for many years, I still discover new things everyday.
I put together here a list of shortcuts which proved very useful to me, especially [...]
