Excels Scenario Manager and Goal Seek

Excels Scenario Manager and Goal Seek

Scenario Manager and Goal Seek in Excel are two very useful features and both of these function are classes as What if Analysis functions. Scenario manager can be used to save different scenarios of the same situation on the same worksheet.  For example, lets say you have a budget and you have prepared a best case […]

Wonderfully Weird function in Excel

Wonderfully Weird function in Excel

Excel is full of wonderful and weird features and functions.  With so many functions available, a lot of the time there is more than one way you can solve a problem in Excel.  Sometimes I look at functions and I wonder to myself….what problem could this solve? (that’s a bit sad to be admitting really) […]

learn Excel Pivot tables

Learn Excel Pivot Tables in less than 20 Minutes

Excel Pivot tables are a really powerful tool.  They allow you to create interactive reports on large data sets.  You can summarize, organized, and explore the information contained within the data, with just a few clicks of the mouse. To be honest a Pivot Table can be created very quickly.  Excel even offers a set […]

Introduction to Tables and Filters in Excel

Table and Filters in Excel are incredibly useful tools 5 Reasons to use Tables and filters in Excel Quick totals – it is easy to turn both on and off the totals feature of tables. But if you need to get totals quickly, convert you data into a table and the totals will be calculated […]