My Profile   |   Contact Us   |   Your Cart   |   Sign In
Webcast: Advanced Excel Workshop (CAAEXW16)
Tell a Friend About This EventTell a Friend
 

Learn how to leverage Excel to the fullest from Pivot Tables to digital reporting, and from macros to custom menus in this hands-on workshop. A laptop is required, as you'll work through various exercises and use your new knowledge.

1/12/2016
When: 01/12/2016
8:30 AM until 4:00 PM
Where: Webcast
Louisiana
United States
Presenter: Jeff S. Lenning, CPA, CITP


Online registration is closed.
« Go to Upcoming Event List  

Registration Fees
Members $275
Non-Members $375

CPE: 8 hours
Level: Advanced
Vendor: CalCPA
Category: Management
Prerequisites: General working knowledge of Excel, including how to set up new workbooks and worksheets, and be familiar with basic formulas and navigation within Excel.
Advanced prep: None

Who should attend: CPAs and other business and finance professionals.

Learn how to leverage Excel to the fullest from Pivot Tables to digital reporting, and from macros to custom menus in this hands-on workshop. A laptop is required, as you'll work through various exercises and use your new knowledge. Note: All spreadsheets will be available for download prior to the class.

Objectives

  • Determine how to improve efficiency when using Excel.
  • Identify which Excel features can be used together in worksheets.
  • Recall selected functions and shortcuts.


Major Topics
  • Power play: Pivot Tables and external data
  • Paperless office and digital reporting with Excel: Hyperlinks, dynamic and static workbooks, worksheet and workbook protection
  • Power play: VLOOKUP and named ranges macros and custom menus auto filter, subtotals and data validation
  • Other programs: QuickBooks, QODBC, Lacerte and text files, Microsoft Access import/export
  • Efficiency gains: concatenate, IF function


 

Community Search
Sign In


Forgot your password?

Not a member? Join now!

News & Tax Alerts
CPE/Events

Society of Louisiana
Certified Public Accountants

2400 Veterans Memorial Blvd., Suite 500
Kenner, LA 70062-4739

504.464.1040
800.288.5272 Map/Directions


Advertise/Exhibit

Classifieds

CPA Locator

Press Room

Staff Directory

Facility Rental

Privacy & Terms

About LCPA