To Play BrittBrief, click on video above
2/16/2011
Class Description
Do you ever need to create various “what-if” calculations in your Excel spreadsheets? If so, there is a tool in Excel that allows you to easily generate various what-if analyses or scenarios.
This webcast class will provide valuable tips and tricks so that you can immediately use Excel’s Scenario Manager tool.
You will learn about:
- Goal Seek – a simple tool for basic what-if analysis
- Scenario Manager Basics – setting up and displaying multiple scenarios for a spreadsheet.
- Scenario Manager Output – creating reports and charts to display scenarios.
- and more!
Class Handouts
Learn More
Microsoft Excel – How to use Date Math and Functions to Solve Practical Business Problems in Excel
In this month’s Microsoft Excel webcast class, you’ll learn “How to Use Date Math and Functions to Solve Practical Business Problems in Excel.”
Microsoft Excel – How To Automate Spreadsheets with Conditional Expressions and Lookup Tables in Excel
The IF function is one many people shy away from, but this is one function that will truly make every Excel user’s life much easier. Excel’s VLookup is a handy tool that helps you compare data in two spreadsheets
Microsoft FRx -How to Analyze Frx Report Data using Excel Pivot Tables
Imagine the power of analyzing your FRx report data using the “slice-and-dice” power of Excel pivot tables.The “secret” is in properly configuring your FRx reports with pivot tables in mind. Simply exporting a typical FRx report can yield meaningless results. But a proper design in FRx will deliver insightful, information-rich pivot tables and charts.
Microsoft Excel – What’s New & Different in Excel 2007
Whether you already have Excel 2007, or plan to upgrade, this webcast class will provide valuable tips and tricks you can use immediately.
Microsoft Excel – How to Create and Use Pivot Tables – Part II
Excel’s Pivot Tables enable you to slice, dice and present data from a variety of perspectives.
Microsoft Excel -How to Create and Use Pivot Tables – Part I
Microsoft Excel Pivot tables are a tremendous tool for ad-hoc analysis and reporting of data from almost any source. Excel’s Pivot Tables enable you to slice, dice and present data from a variety of perspectives.
Microsoft FRx – How to Link Excel Spreadsheets to Your FRx Reports
Are you reporting using both Excel and FRx – separately? Many times, it’s better to pull your Excel data – from one or multiple spreadsheets – into your FRx reports.
Microsoft Excel – Sorting, Querying, and Subtotaling an Excel Database
nage data in Excel? If you aren’t using the “Database” feature in Excel, you could be missing out on a tool to finally give you mastery over lists of data.
Microsoft Excel – How to Optimize your Data Management with Excel’s Database Feature
Do you manage data in Excel? If you aren’t using the “Database” feature in Excel, you could be missing out on a tool to finally give you mastery over lists of data. Join the inaugural class of the Excel Advanced Learning Program from Brittenford Systems, and learn the secret!
Dynamics GP – How to Integrate Excel Reports with Dynamics GP
Are you exporting from Dynamics GP to Excel? Using Smartlists to send data to Excel? Rekeying data? Hmmm…you could be wasting time and resources! learn how to use 190 out-of-the-box Excel reports with live connections to data in Dynamics GP. Talk about a time-saver….
No comments yet.