Tomorrow: Wrangling Large Excel Spreadsheets

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Wrangling Large Excel Spreadsheets November   14 1 pm - 2:40 pm ET Presenter: David Ringstrom, an author and nationally recognized instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   As Excel expert, David Ringstrom says, "Either you work Excel, or it works you." After attending this live, practical webinar, you'll no longer be intimidated by large Excel spreadsheets! You will learn techniques and keyboard shortcuts that enable you to gain control over unwieldy workbooks, save time, avoid repetitive tasks, improve the integrity of your spreadsheets, and more. You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. You will learn to recognize any differences in Excel 2013, 2010, or 2007 during the presentation, and will receive detailed handouts. You will also receive an Excel workbook that includes most of the examples reviewed during the webinar. Who Should Attend: Practitioners seeking to work more efficiently in large Excel workbooks as well as improve the integrity of their spreadsheets. You will learn how to: Use the Watch Window to easily monitor the ramifications of even minor changes to your workbooks Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts Use a simple technique that can reduce the size of a large Excel workbook by 1/3 or more Avoid repetitive work by creating a keyboard shortcut for Excel's Freeze Panes feature Use Excel's OFFSET function to dynamically reference data from one or more accounting periods Differentiate between manual and automatic calculation modes in Excel Use Excel's Freeze Panes feature Use the Group and Ungroup feature to expand or collapse rows and/or columns Use the SUM Function to drill through two or more worksheets Simplify repetitive tasks by creating your own keyboard shortcuts Upon course completion, you will be able to: Apply the Watch Window feature to monitor and to navigate key worksheet cells Identify how to use Custom Views to manage the hidden or visible status of columns, rows, worksheets, print settings, and more Implement the INDIRECT worksheet function to create simpler summary spreadsheets Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars Got E-Verify? Many Federal Contractors Have To! November 26 at 1 pm ET Learn More Your New Sales & Use Tax Obligations Explained November 26 at 3 pm ET Learn More Introduction to What-If Analysis in Microsoft Excel November 27 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.