Microsoft Excel Blog Posts

In order to create relational databases using Excel 2013, there are actually some factors to remember in order to correctly create these databases. They can be summarised into these points. Do you know what these factors are? Relational databases are databases that are specifically structured to recognise relations in the data stored inside. This is the type of database usually used for large amounts of ...
Read More

Think you have a good grasp on the basics of Excel and looking for more information to practice on? Here are some intermediate level excel practice tips for you to consider when exploring the rest of Excel’s capabilities: Generating unique values In cases where you need to have unique values filtered from your data, you should be making use of the Advanced filter feature. Select ...
Read More

If you are just getting started with Excel, there’s no need to fear. While it can seem rather stressful, what with the overload of information you’ll mostly get when searching through tutorials, here is a good place to start learning about the software. Here are 5 basic excel practice tips to learn: Ribbon customisation One of the most helpful excel practise tips that are first ...
Read More

While Microsoft Excel is a good software on it’s own, the number of add in programs designed and developed to further increase it’s use is even better. Here’s how you can begin experimenting and freeing up your time by loading add in programs into Excel: Excel Add In Programs Look for your File tab and choose Excel options. Look for the category for add ins ...
Read More

Save yourself some time when it comes to work and presentations by making it quick to access external information when you need to. Here’s how you can make things convenient by connecting your external data to Excel in 5 steps: Important Tips When you create a connection to external data, it provides the additional security that you will always have up to date data to ...
Read More

The number of Excel users switching to the Excel 2013 version have only been steadily growing by leaps and bounds even after all these years, and for good reason too- here are 5 reasons why you should also be considering switching to Excel 2013: Flash Fill Working with Excel is so much more convenient now that Excel 2013 has introduced the Flash Fill feature. Introduced ...
Read More

The pursuit for further clarification and knowledge should not be lost even after you have gained a fair degree of understanding. If you feel up to the challenge and are ready to delve into deeper exploration in Excel, why not consider practising these 5 advanced excel practise tips here: Avoiding broken formulas Perhaps one of the most standard excel practise tips- broken formulas are meant ...
Read More

Excel Power Maps is a nifty Excel feature that has been introduced in the later series of Microsoft Excel. Created as a 3D visualisation tool for data, Excel Power Maps allows users to assess data in different methods unique to that perspective, which can otherwise go unnoticed if relying only on 2D tables/charts. With Excel Power Maps, data representation is made easy by enabling users ...
Read More

SmartArt Graphics is a convenient Excel feature that allows excel users to make organisation charts for better data representation or keeping track of who does what in their corporation. When effectively used, it can save users a lot of time and effort in tidying up their data and charts, thereby allowing users to not only explain information clearly but also for their audience to better ...
Read More

Regularly backing up data as a safety measure is insufficient. There are no perfect solutions or impenetrable software programs in the world, and you may one day find your workbook files at the mercy of bugs or other problems like hackers. Secure and safeguard sensitive data in Excel with these 5 Excel security measures and earn yourself peace of mind even while away from the ...
Read More