Excel Telephone Seminars - Training Resources

Discover the Secrets of Microsoft(R) Excel Pivot Tables ...Excel user who maintains database-like data invariably needs tools to manage and analyze the data beyond mere sorting and filtering. Excel 's pivot table feature gives you a quick and powerful way to create summary cross-totals combined with an enormous flexibility to restructure your results with simple dragging of fields. Whether you need the ability to create a quick look at the data for  more...

Utilizing Graphs and Charts in Microsoft Excel ...Excel user who needs quick methods to show numerical information in a visual way needs to know the basics of chart creation; how (and why) to use different chart types; and how to alter the look of a chart with layout, color and content changes. Depicting data in a chart may reveal a trend that was not so obvious in the numerical data, which often can be dry and boring. That elusive meaning,  more...

Advanced Microsoft Excel Formulas and Functions: Master Your Usage of Excel's More Powerful Formulas and Functions ...airly comfortable with building formulas and functions in Excel , you might still be missing out by having overlooked some powerful functions or just not be aware of special capabilities, like array formulas. There's no question that Excel's 300+ functions give you tremendous capabilities to tackle a myriad of statistical, mathematical and financial challenges, not to mention functions that  more...

Excel Formulas and Functions De-Mystified: Manage Your Excel Worksheets With Power and Confidence as You Master Formulas and Fun ...Excel invariably needs to create and understand how to use formulas and functions. For some Excel users, it is the centerpiece of what they do on daily basis. Many Excel formulas involve simple mathematical constructions using addition, subtraction, multiplication and division, but sometimes you need more complex formulas to reach an answer. Excel has more than 300 built-in functions that  more...