My Profile   |   Contact Us   |   Your Cart   |   Sign In
Excel Tips, Tricks, and Techniques for Accountants - Kenner (EXL114)
Tell a Friend About This EventTell a Friend
 

Based on over 20 years of experience teaching accountants, this highly acclaimed course contains hundreds of tips, tricks, and techniques to improve your productivity and accuracy. It focuses on six major areas: productivity tips and tricks, formatting essentials, customizing Excel, formula-building essentials, three-dimensional workbooks, and printing essentials.

9/25/2014
When: 9/25/2014
8:30 am until 4:30 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  

Excel is the accountant's tool of choice for analyzing and reporting financial data, yet most accountants have never received any formal Excel training. As a result, many accountants use time-consuming and error-prone processes to complete everyday tasks. This highly acclaimed course contains hundreds of tips, tricks, and techniques to improve your productivity and accuracy. Its content is based on over 20 years of experience in delivering Excel training to accountants and on feedback from tens of thousands of accounting and financial professionals just like you. The course has six major areas of topical coverage: productivity tips and tricks, formatting essentials, customizing Excel, formula-building essentials, three-dimensional workbooks, and printing essentials. If you are an Excel user, regardless of your level of experience, and you have never taken a formal Excel training course for accountants, you need this course! Participants will have access to sample data files. 

 

Designed for: Accounting and financial professionals who want to learn how to use Excel more efficiently and effectively

 

Objectives:

  • Identify tips and tricks in Excel such as Freeze Panes, Split Windows, Selecting Cells with Special Characteristics, Using AutoCorrect, Adding Date and Time Stamps, Working with the Office Clipboard, and Paste Special and describe how to use each to increase productivity with Excel
  • Describe tools and techniques for formatting in Excel, including Multiline Column Headings, The Accounting Format, Custom Date and Number Formats, The Hidden Format, and Conditional Formatting
  • Identify opportunities to customize Excel and describe procedures for Customizing the Ribbon, Customizing the Quick Access Toolbar, Adjusting Excel’s Options, Using Templates to Increase Productivity, Modifying Excel’s Global Templates, and Working with Custom Themes
  • Describe Excel’s formula building tools, including Absolute vs. Relative Cell References, The Formula Bar, The Formula Tab, Performing Calculations on Dates, Splitting and Combining Text Strings, Using the Text to Columns Wizard, Working with Defined Names, Conditional Calculations, VLOOKUPs and HLOOKUPs, and Circular References
  • Describe how to link data from multiple Excel workbooks, including Creating Links, Updating Links, Managing Links, Handling Broken Links, Combining Single-Sheet Workbooks, Creating Sum-through Formulas and Rolling Reports
  • Define the process for printing data from Excel, including describing How to Adjust Various Print Settings, Using the Camera Feature to Create Report Forms, and Working with Custom Views to Automate Print Settings

 

Highlights:

  • Productivity tips and tricks
  • Formatting essentials
  • Customizing Excel
  • Formula building essentials
  • 3-D workbooks
  • Printing Essentials

 

Requisite Knowledge: Fundamental knowledge of Excel operations

 

Speaker: Will Fleenor

Vendor: K2

Field of Study: Management

Level: Intermediate

CPE Credits: 8

 

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

 

Testimonials:

“I have taken other Excel classes, but they were not geared toward Accountants. This seminar provided practical & relevant information for use in my daily work.”

--A.S., CPA MI

 

“This is the most effective CPE course I have ever attended. It will truly help me be more efficient & effective at work.”

--E.K., CPA PA

 

Registration Fees:

 

Members

CPA Non-Members

Early Bird (through 9/10)

$179

$279

Standard (after 9/10)

$229

$329

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