Sage Intelligence - 2015 Excel Tips and Tricks
Excel on Steroids is an advanced and specialized training program providing in-depth coverage of key Microsoft Excel functionality relevant to business reporting. If you use Excel for financial or operational reporting, this advanced program will help you take full advantage of the powerful reporting and analysis capabilities of Excel.
Unlike other advanced Excel training programs, Excel on Steroids is not a general tour of Excel functionality. It especially focuses only on the functionality that is relevant to business reporting. And, instead of covering everything all at once, Excel on Steroids is covered in three focused workshops for undivided focus on each topic.
If you often think “there must be a quicker way to do this in Excel”, then you are spending too much time manually sorting and manipulating data instead of using the functionality available in Excel to perform those tasks quicker. Inefficiencies in Excel cost time and money which you could invest in other areas.
Formulas and Functions
Formulas are instructions or expressions that you define according to what you need to calculate; functions are predefined formulas that are readily available in Excel. In this workshop you will learn how to customize and manipulate worksheets and how to calculate values in cells using basic and complex formulas.
Data Lists and Macros
Data lists are ideal for storing large amounts of similar information. In this workshop you will learn how to sort your data lists, how to view and analyze different variables of your data, and how to automate tasks that you perform repeatedly in Excel to save you time.
PivotTables and PivotCharts
PivotTables and PivotCharts enable you to make informed decisions about critical data in your enterprise. In this workshop you will learn how to summarize, analyze, explore, and present summary data using PivotTables, and how to graphically represent summary data using PivotCharts which allow you to easily see comparisons, patterns, and trends.