Microsoft Excel Telephone Seminars

Utilizing Macros in Microsoft Excel BenefitsWhen you find yourself repeating actions in Excel - whether it's a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, and print multiple worksheets once a week, the possibility exists that you can automate these actions in the form of a macro. Thereafter, you can perform these sets of actions with a simple keystroke combination, a  more...

Utilizing Formulas in Microsoft Excel BenefitsAnyone using 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 a 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  more...

De-Mystifying The Excel(R) Real Estate Pro-Forma ...nstalled user base in the hundreds of millions worldwide, Microsoft Excel is the primary tool of choice for spreadsheet-based analysis. This is the case in real estate development and investment, yet many practitioners are still not very familiar with how projection models are built or work. This audio conference breaks down the real estate pro-forma into its essential components, analyzes the  more...

Utilizing Graphs and Charts in Microsoft Excel BenefitsAny 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  more...

Advanced Microsoft Excel Formulas and Functions BenefitsEven if you are fairly 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  more...