Excel tutorials, functions and advanced formula examples, page 9

How to group and ungroup worksheets in Excel

Have you ever found yourself in a situation when you need to perform the same tasks on multiple sheets? That's very easy to do with the Group Worksheets feature. If your sheets have the same layout and structure, just group them together, and any changes you make on one sheet will be automatically applied to all other worksheets in the group. Continue reading

How to enable and disable macros in Excel

Like almost any technology, macros can be used for both good and evil. Therefore, in Microsoft Excel, all macros are disabled by default. This tutorial covers different ways to enable macros in Excel and explains potential risks associated with that. Continue reading

How to record a macro in Excel

Macros are a great way to automate repetitive tasks in Excel. If you find yourself doing the same things over and over again, simply record your actions as a macro and run it with a keystroke. Continue reading

How to export and import contacts between Outlook and Google Gmail

Switching between Microsoft Outlook and Google Gmail is a very common trend these days. Some people are migrating from a desktop-oriented Outlook app to a cloud-based Gmail while others are using different email clients for their personal and business communication. Luckily, both Outlook and Gmail make it possible to transfer all your contacts in one go. Continue reading

How to export contacts from Outlook

Whether you are migrating to another email service or making a regular backup of your data, it is crucial to transfer all contact details without any fail. This tutorial will teach you a few easy ways to export Outlook contacts into a .csv or .pst file, so that you could later import them anywhere you need. Continue reading