Microsoft Excel Blog Posts

Microsoft Excel has introduced a feature known as Sparklines, which are essentially mini-charts that are inserted into worksheet cells to act as a visual representation or help reveal data trends. Sparklines are also a good feature to use when you need to highlight certain things or draw attention to something. Start by selecting the cell you wish to apply sparkline to, locate the Insert tab ...
Read More

Maintain the accuracy and quality of your data files by keeping track, spotting and resolving unprotected formulas in Excel. This process is recommended to be performed every once in a while to ensure that your data is still accurate and can be used for future purposes. While it sounds awfully complicated, achieving this is actually fairly straightforward. Here’s how you can handle these tricky formulas: ...
Read More

When using formulas in Excel, the best possible outcome would be that the software program is able to resolve the formulas in your stead. In the event that it is unable to do so, you will typically receive error messages with the section and formula it has difficulty resolving. Here’s how you can improve your excel reports by fixing these broken formulas: Assess Reassess your ...
Read More

The truth of the matter is that no software is complete without flaws. Even popular software programs like Microsoft Excel is not invulnerable to the occasional bugs and errors. Thankfully, instead of having to put up with that and allow these problems to hinder your progress, there are some quick fixes and workarounds that you can use to still access the software. Here are 5 ...
Read More

Better manage your company communications and details by mail merging your outlook contacts to Microsoft Excel. Save time from having to manually edit recipient information, gain better control over mail distribution to the masses and perform repetitive actions in no time with this little nifty trick. Here’s how to mail merge your outlook contacts to Excel: Export Once you are sure you have all your ...
Read More

When it comes to spreadsheet programs, opinions are immensely divided. Some users swear by Microsoft Excel. Others have no qualms about ditching Excel in favour for Google Sheets. So it begs the question- Excel or Google Sheets? Which is the superior spreadsheet program? And which should you use? Here are some things to know: Accessibility When it comes to accessibility, Google Sheets hold a slight ...
Read More

One of the reasons for the creation of Macros is that they are the best when it comes to freeing up a sizable fraction of your time for more productivity. Macros are designed to auto complete tasks that are repetitive so that users can devote their time to other things with a peace of mind, knowing that work is still being done without their supervision ...
Read More

The recent introduction of Excel 2016 grants users access to numerous new and useful features, including a total of 6 new chart types! Today, we’ll focus on the 3 new Excel 2016 chart types that you definitely have to try out for yourself: Pareto Pareto charts are the excel chart types that combine both the use of bar and line graphs to reveal data with ...
Read More

Keep your Excel spreadsheet organised by making use of grouping and outlining. Not only will information be registered easier, you will find that these subtle tricks help to engage your audience’s attention and refocus attention to the right parts. Here are 5 Excel grouping and outlining tips to learn: Adding Group Select the cells you wish to consolidate into a group and locate the ‘Data’ ...
Read More

Histograms are typically used whenever there is a need to predict and look at data frequency. They often come in the form of a column chart for easy analysis. Histograms also happen to be a chart option in Microsoft Excel - here’s how you can create a histogram in Excel: Basics Before being able to create a histogram in Excel, you will be required to ...
Read More