Fred Pryor Seminars & CareerTrack
  HELP   |   FAQ   |   ABOUT US   |   SHARE PAGE   |   HOME
Search by keyword: 
Find a Seminar:
Zip/Postal Code:
Event #:
 
 Seminars
 CareerStore
 Audio Conferences
 Webinars
 Special Offers
 On-Site Training
 On-Line Training
 Advanced Search
 View Shopping Cart
   0 item(s) in shopping cart
 View Wish List
   0 item(s) in wish list
 Subscriber Login
 Request Catalog
 Free Online Course

Call Toll-Free
1-800-780-8476


Managing Financial Data with Excel®

Managing Financial Data with Excel brochure

Time-saving techniques for easy and accurate financial analysis and reporting

 

1-Day Seminar - US $149.00; For groups of 5 or more, 139.00


Finally — an Excel program created with a financial emphasis!

  • Transform raw data into sophisticated financial presentations with just a few clicks of your mouse!
  • Create financial statements, projections charts, budgets, business plans, and more
  • Learn how to automate repetitive tasks with macros
  • Easily track and organize critical accounting data such as payables, receivables, inventory, customer records, and sales data
  • Use Excel's pre-defined formulas to perform complicated number-crunching tasks swiftly and accurately
  • Create Excel worksheets that do much of your calculations for you!
  • Boost the visual appeal of your reports and financial documents with colorful, easy-to-understand tables, charts, and graphs
Learn to use Excel's extraordinary capabilities to analyze, track, and present all kinds of financial data — clearly and accurately!

Excel has always been uniquely suited to the needs of financial professionals. In Managing Financial Data with Excel, you'll learn how to tap into the power of Excel to work with all types of financial data. Discover how easy it is to utilize Excel for accounting and complex calculations with user-friendly formulas and built-in functions. After one day of high-impact training, you'll be able to create financial documents, reports, and presentations that transform raw data into a variety of sophisticated business tools!

We'll show you how to use Excel's many tools, features, formulas, and functions to organize, manipulate, store, and present financial data. Managing Financial Data with Excel will swiftly familiarize you with the functions, formulas, commands, and keystrokes most useful in financial analysis and reporting. You'll learn to perform complex calculations at the click of a mouse and use filters, queries, and searches to further refine your work.

Put this powerful training to work for you ... and take your Excel knowledge to a whole new level!

You'll learn to build "smart" spreadsheets that do much of your work for you ... track and analyze financial data ... automate repetitive tasks with macros ... use embedding and referencing ... create reports, tables, charts, and graphs in a way that's catered to your business needs ... and much, much more. With our Excel experts at the helm, you're in for a super-productive, fast-paced learning experience that will put the power of Excel at your fingertips and give you a greater understanding of how this essential software can reshape the financial data of your organization.



Managing Financial Data with Excel — Seminar Overview

  • Become familiar with Excel's capabilities in financial analysis and reporting
  • Use formulas and references to quickly calculate percentages, sums, averages, interest, statistics, and more
  • Understand Excel's tools and how they can help you: PivotTables, PivotCharts, DataTables, GoalSeek, Solver, and Scenario Manager — all demystified!
  • Benefit from Excel's auditing and checking features
  • Learn the difference between Query and Lookup — which are you using, and which is better?
  • Understand conditional logic — how to make the most of complex functions
  • Use macros to automate tedious and repetitive tasks
  • Stop comparing data sets manually — learn to use Excel functions to easily compare two sets of information
  • Perform conditional formatting for at-a-glance analysis
  • Discover the advantages of templates pre-built into Excel!
  • Use Excel's database features to create lists, use forms, filter records, and sort all types of data and information
  • Dramatically increase the quality of financial analysis by using data entry forms to reduce errors
Find a Seminar Near You
USA     
CANADA 
   
POSTAL CODE (US, UK, or Canada)
  + Miles
Back to top


To find out more about Managing Financial Data with Excel, contact our customer service department at customerservice@pryor.com or by phone at 1-800-780-8476.



Buyer Satisfaction Guarantee | Policies and Security | FAQ

Continuous learning from pryor.com. © 1999-2008 All rights reserved.



Share this Page
Contact Customer Service

On-Site Training

Public seminars and other training

Microsoft Excel training

Advanced Excel training



Unlocking the Secrets of Microsoft Excel
Unlocking the Secrets of
Microsoft Excel

CD-ROM CD-ROM

Unlocking Excel: Shortcuts, Tips, & Tricks
Unlocking the Secrets of
Microsoft Excel:
Shortcuts, Tips & Tricks

CD-ROM CD-ROM

Budgeting & Finance Templates
Budgeting & Finance Templates for Managers, Supervisors, & Business Owners

CD-ROM CD-ROM