Microsoft Excel Blog Posts

One of the most inconvenient and yet unfortunately common problems when it comes to using Microsoft Excel would be Excel files opening blank when users attempt to open them. While frustrating, there’s actually a way to resolve and troubleshoot this problem. Here’s how you can go about troubleshooting blank excel files: DDE One of the very first steps when it comes to troubleshooting blank excel ...
Read More

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