Excel Telephone Seminars

Utilizing Macros in Microsoft Excel ...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 button in a worksheet, or by using a button in  more...

Utilizing Formulas in Microsoft Excel ...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 functions that  more...

Excel Power Tips and Shortcuts ...Excel productivity boost? You can now learn simple tricks and many shortcuts that will make you instantly more proficient using Excel ! Most Excel users are underutilizing this software. Start using the full power of Excel , and learn cool Excel tips and tricks that will make you the 'go-to' person in your office! Master more than 100 tips to make you a Power User! This live audio conference  more...

De-Mystifying The Excel(R) Real Estate Pro-Forma ...ser 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 pieces  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...

Upgrading to Microsoft Office 2010: What's New and Improved? ...ing email, PowerPoint , Access , SharePoint workspace and Excel . Join us to learn the new and improved features on November 17th! This audio conference will be displayed for attendees via GoToWebinar's interactive component, for which Lorman will provide access and installation instructions in advance. GOTOWEBINAR is a registered trademark of Citrix Online, LLC and this event is not  more...

New Features and Functions in Updating to Excel 2007 ...Excel user who is making the transition into Excel 2007 needs to get up to speed and needs help in locating familiar features that have been redesigned or relocated. Version 2007 is the biggest change in Excel's history and without a road map to its new features, you will waste a lot of time and be inefficient - you need this teleconference! We will give you indispensable tips for navigating  more...

Utilizing Data in Microsoft Access ...rm that allows information workers to extend the power of Excel into database applications. Nonprofessional developers can create their own tables, queries, forms and reports to automate their processes. They can even write their own macros and VBA code to implement custom behaviors. Microsoft Access can store its own data in its Jet Database format or link to databases on SQL Server, Oracle  more...

Advanced Microsoft Excel 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...

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...