×
Your location has been changed to Philadelphia area.
This Event has Passed
Tuesday, May 14, 2013
1:00 PM - 2:00 PM
1:00 PM - 2:00 PM See all dates and Times
http://www.audiosolutionz.com/850-conference-power-skills-for-intermediate-excel-users.php
Taking Intermediate users Excel Skills to the next level Microsoft Excel is a powerful database application which offers a host of inbuilt features enabling users to make intelligent use of available data. Most users are not cognizant of available tools within Microsoft Excel. This webinar is aimed for intermediate users who can look forward to broaden their skills.
Join Microsoft Excel expert David Ringstrom (CPA and owner of Accounting Advisors, Inc), for an informative webinar on May 14, 2013 at 1:00 pm EDT as he unravels the less-known techniques including an introduction to Macro Recorder feature, use of pivot tables and much more. Get your queries answered for all the dominant versions of Microsoft Excel.
In this instructive and interactive session, you will learn:
Multiple techniques for managing large worksheets, including keyboard shortcuts, Excel's Group and Ungroup feature, and Custom Views
How you can hide and unhide multiple worksheets at once by making a choice from a drop-down list
To streamline repetitive tasks with Excel's Macro Recorder
To make your macros available anywhere in Excel by adding your own icon to the Excel's Quick Access Toolbar
Putting charts on auto-pilot by having Excel make the charts expand automatically when you add data-your chart titles will update themselves, too!
To master Excel's Pivot Table feature to quickly summarize data by simply dragging and dropping fields
Take pivot tables further by transforming a staid accounting report into an instant summary of how long a customer has been with you and their total spending
Discover how the Table feature in Excel can help you avoid a common data integrity pitfall related to Pivot tables
Join Microsoft Excel expert David Ringstrom (CPA and owner of Accounting Advisors, Inc), for an informative webinar on May 14, 2013 at 1:00 pm EDT as he unravels the less-known techniques including an introduction to Macro Recorder feature, use of pivot tables and much more. Get your queries answered for all the dominant versions of Microsoft Excel.
In this instructive and interactive session, you will learn:
Multiple techniques for managing large worksheets, including keyboard shortcuts, Excel's Group and Ungroup feature, and Custom Views
How you can hide and unhide multiple worksheets at once by making a choice from a drop-down list
To streamline repetitive tasks with Excel's Macro Recorder
To make your macros available anywhere in Excel by adding your own icon to the Excel's Quick Access Toolbar
Putting charts on auto-pilot by having Excel make the charts expand automatically when you add data-your chart titles will update themselves, too!
To master Excel's Pivot Table feature to quickly summarize data by simply dragging and dropping fields
Take pivot tables further by transforming a staid accounting report into an instant summary of how long a customer has been with you and their total spending
Discover how the Table feature in Excel can help you avoid a common data integrity pitfall related to Pivot tables
