Menu
Close
If you start each day needing to use a frequently used workbook, e.g. daily sales report, to-do list, calendar, etc, then this tip is for you. You can automatically open these workbooks, by simply adding the workbooks or a shortcut in the XLStart folder. This is a specific folder that Microsoft® Excel® uses in which files […]
Dashboards in Microsoft® Excel® are used for visually presenting important business information. Dashboards can display current status of metrics and key performance indicators. In this tip, we look at how to enhance dashboards with a Power View report by analyzing sales data. Power View reports in Microsoft® Excel® pull your data together in tables, matrices, […]
Adding a comment to a cell in Microsoft® Excel® is a quicker way of providing feedback. Instead of typing out an email to provide feedback, you can simply enter important information straight into the spreadsheet. However, you may want to change the default font size for Excel comments because it’s currently too small for you […]
Is Microsoft® Excel® a major part of your everyday job? Would you like to hone your skills and finally master the art of using Excel like a pro? The Excel On Steroids (EOS) 2013 course may be the solution you’ve been looking for to take your business reporting skills up a notch. Am I invited? […]
Millions of people around the world use Microsoft® Excel® on a daily basis. But how many of those people can really claim to excel at Excel? I’m not just talking about getting things done, but taking full advantage of Excel’s features to work as efficiently as possible. You know the ones who have a template […]
In this tip, you’ll discover how to use Sparklines to analyze your cash flow data. First introduced in Microsoft® Excel® 2010, Sparklines are small charts that fit into a single cell in a worksheet. We’ll show you how to use them to get a quick look at trends or changes in your data that may […]
If you’ve experienced the mishap of mistakenly closing a file while working on it, or losing it due to a power failure or gremlin in your computer, you’ll know how frustrating it can be. Fortunately, changes were made in Microsoft® Excel® 2010 and 2013 which make the process to recover an unsaved workbook much simpler. […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.