My Profile   |   Contact Us   |   Your Cart   |   Sign In
Excel Tables - Revolutionize How You Work with Excel (EXT414)
Tell a Friend About This EventTell a Friend
 

Much more than just a formatting tool, Tables will revolutionize how you work with data in Excel. Tables can serve as data sources that automatically and dynamically re-size to match the volume of data under analysis, they provide a simplified means of writing formulas known as Structured Referencing, and they streamline the process of working with large volumes of data. If you’re using Excel and are not working with Tables, you need this course to increase your efficiency and proficiency.

9/24/2014
When: 9/24/2014
8:30 am until 12:00 pm
Where: LCPA Training Center
2400 Veterans Memorial Blvd
Ste 500
Kenner, Louisiana  70062
Presenter: Will Fleenor


Online registration is closed.
« Go to Upcoming Event List  

Added to Excel with the 2007 release, Tables are one of Excel’s best features about which most users know very little and, therefore, fail to experience the benefits of working with this great feature. Much more than just a formatting tool, Tables will revolutionize how you work with data in Excel. Tables can serve as data sources that automatically and dynamically re-size to match the volume of data under analysis; Tables provide a simplified means of writing formulas known as Structured Referencing; Tables contain advanced filtering and sorting capabilities; and Tables streamline the process of working with large volumes of data.   If you are using Excel 2007 or newer versions and are not working with Tables, then you need this four-hour course to increase your efficiency and proficiency with Excel. 

 

Designed for: Accounting and financial professionals seeking to become more efficient and proficient with Excel

 

Objectives:

  • Describe Excel’s Table feature including how to create Tables in Excel 2007 and newer versions
  • List five key advantages of working with Tables
  • Create formulas in Tables using Structured References, including formulas that refer to Tables in other worksheets and workbooks
  • Use Tables as automatic re-sizing data sources for other objects, including PivotTables and PivotCharts
  • Describe how to sort and filter data in Tables, including using external criteria to filter data inside a Table

Highlights:

  • Introducing tables
  • Sorting and filtering in tables
  • Building structured reference formulas
  • Using tables as data sources
  • Advanced table techniques

 

Requisite Knowledge: Fundamental knowledge of Excel 2007 or newer version

Speaker: Will Fleenor

Vendor: K2

Field of Study: Management

Level: Intermediate

CPE Credits: 4

 

Instructional delivery method: Group/live demo and discussion using color computer projection – NOT a hands-on course

 

Testimonials:

“Even though I consider myself an Advanced Excel user, I still learned some great tips.”

--L.D., MN 

 

“Excellent and immediately useful presentation.”

--M.D., CPA AL

Registration Fees:

 

Members

CPA Non-Members

Early Bird (through 9/9)

$99

$149

Standard (after 9/9)

$149

$199

 

 

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