Beginner’s Guide to Microsoft Excel

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Beginner's Guide to Microsoft Excel January   20 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. 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 Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   If you've never worked with Excel spreadsheets or haven't for several years, this webinar is for you. Excel expert David Ringstrom, CPA, takes you through the basics of Excel spreadsheets, so you'll be equipped to create functional spreadsheets and manipulate large lists of data. You'll learn about the different types of files you can create, Excel's rows and columns grid, and keyboard shortcuts that will help you simplify repetitive tasks. You'll also learn how to eliminate duplicates in a list, implement the Quick Analysis feature, manage column widths in spreadsheets, filter long lists of data, and more. Upon completion of this course, you'll be able to: Identify time-saving mouse tricks and keyboard shortcuts to skip confusing menus Apply the structural basics of Excel worksheets and workbooks List basic data-analysis techniques Control Excel's green error-checking prompts by managing the underlying rules Eliminate duplicates from a list with just a few mouse clicks Utilize free, prebuilt templates in Excel Identify the different types of files you can create in Excel Explain Excel's grid of rows and columns Describe how the Quick Analysis feature can Jump-start data visualization Recognize the nuances of copying formulas within Excel spreadsheets Manage column widths within your spreadsheets Master Excel's order of operations for mathematical formulas Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts Never type $ signs manually in a formula again; use a keyboard shortcut instead Create your own keyboard shortcuts to simplify repetitive tasks Enter dates in an Excel spreadsheet Use a custom number format to hide zero amounts within a specific area of a spreadsheet Wrangle long lists of data by filtering instead of sorting Course Reviews from Past Attendees 92% of attendees said they would recommend this course to others. "Clear explanations on all subjects." "It was a great refresher for me." "I learned things that I did not know." "It had a ton of info & was easy to follow." 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 850 on-demand courses Learn More Upcoming Webinars The 1099 & W-9 Annual Update Course January 3 at 3 pm ET Learn More Nexus and Drop Shipments and Sales and Use Tax January 4 at 3 pm ET Learn More Detecting & Preventing Payroll Fraud January 5 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 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.

New Year Sale: Save $300 off All-Access CPE Webinar Membership

Practical online continuing education. Manage Preferences    |    View in Browser Live   |   On-Demand   |   All-Access New Year Sale - Ends Jan. 4th   Purchase a one-year All-Access Membership for $499 ($300 off the regular price of $799) between now and midnight on January 4th. The membership allows you to access more than 1,000 on-demand courses and more than 70 live courses per month. To receive the discount, use the code NewYear17 at checkout. Learn about membership now. Upcoming CPE Webinars Attend live and/or view recording at your convenience Miles Hutchinson, CGMA, former Auditor for PriceWaterhouseCoopers The 1099 & W-9 Annual Update Course   January 3rd, 2017, 3:00 PM to 4:40 PM, ET In this webinar, you'll learn about the rules regarding paying and IRS reporting on Independent Contractors. Learn More Register Today Jim Frazier, CPA, President of Take Charge Seminars Nexus and Drop Shipments and Sales and Use Tax   January 4th, 2017, 3:00 PM to 4:40 PM, ET In this webinar, you'll learn about nexus in sales and use tax and how it affects your organization. Learn More Register Today Bob Minniti, President and Owner of Minniti CPA, LLC Detecting & Preventing Payroll Fraud   January 5th, 2017, 1:00 PM to 2:40 PM, ET In this webinar, you'll learn how to detect and prevent payroll frauds committed by employees, management and company owners. Learn More Register Today David H. Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. Designing Error-Proof Spreadsheets in Excel   January 6th, 2017, 1:00 PM to 2:40 PM, ET In this informative webcast, Excel expert David Ringstrom, CPA, shares a variety of tricks and techniques you can use to improve the integrity of your Excel spreadsheets. Learn More Register Today Matthew Lee, Partner with Fox Rothschild LLP New and Enhanced FBAR and FATCA Reporting Requirements   January 10th, 2017, 1:00 PM to 2:15 PM, ET In this course, you will learn about the the new FATCA foreign asset reporting rules and updates to the existing FBAR reporting regime for foreign bank accounts. Learn More Register Today Jeff Lenning, CPA, Founder of Click Consulting Inc. 10 Ways to Improve Excel Workbooks   January 11th, 2017, 3:00 PM to 4:40 PM, ET In this webinar, you'll learn about 10 simple ways to improve your Excel workbooks and make them easier to manage. Learn More Register Today View All Live Courses Featured Accounting On-Demand Webinars Recorded webinars available anytime Wrangling Large Spreadsheets ► Read Reviews Detecting & Preventing Expense Reimbursement Fraud ► Read Reviews Investigative Interviewing for Auditors: What Scientists Have Found Works ► Read Reviews Measuring and Managing Customer Profitability ► Read Reviews Creating an Effective Accounts Payable Policy and Procedures Manual ► Read Reviews View All On-Demand Courses All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 70 live webinars each month ● More than 1,000 on-demand courses Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 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.