Show navigation

Available in:

Online Manual

Microsoft® Excel® in Pennsylvania

Need an Excel® productivity boost? You can now learn simple tricks and understand new features that will make you instantly more proficient using Excel®! Most Excel® users are underutilizing this software. Start using the full power of Excel®, and learn cool Excel® tips that will make you the "go-to" person in your office! Purchase these reference materials today and get the information to make you a power user of Excel®. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week. Benefits for You •Discover how to manipulate worksheets to create a more useable workbook •Confidently create data tables to easily read and analyze data •Add both functionality and eye-appeal to your charts with simple formatting techniques •Explore hidden functions that will make your usage of Excel® even more powerful and efficient
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Agenda

This seminar will be presented by Brad Tornberg and Marc Wasserman, CPA.
Working With Multiple Worksheets
  • Worksheet Tabs
  • Worksheet Names
  • Moving Worksheets Within a Workbook
  • Moving or Copying Worksheets Between Workbooks
  • Inserting New Worksheets
  • Deleting Worksheets
  • Working With Data
    • Simultaneous Data Entry
    • Formulas
Using Microsoft® Excel® for Accounting
Importing Data
Data Tables
  • Create a One-Variable Data Table
  • Create a Two-Variable Data Table
Macros: Automating Tasks You Perform Frequently
  • Record a Macro to Do a Task in One Step
    • Record a Macro
  • Make a Macro Easy to Run
    • Run a Macro From a Keyboard Shortcut
    • Run a Macro From a Button or Graphic Control
Charts
  • Forming the Embedded Chart (In the Same Sheet)
  • Forming the Chart (In a New Sheet)
  • Continuing the Chart
  • Changing the Type of Chart
  • Adding Titles and XY Axis Labels
  • Changing Chart Formatting (Fonts and Line and Bar Styles, Scale)
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Credits

Online Manual

This program does NOT qualify, nor meet the National Standard for NASBA accreditation.

Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Faculty

Marc Wasserman

Marc Wasserman PC CPA

Marc Wasserman, CPA

  • Owner of Marc Wasserman, P.C., C.P.A. with more than 23 years of experience
  • Certified Public Accountant
  • Provides help in small business, trusts, estates and individuals with accounting requirements
  • M.B.A. and B.S degrees, Drexel University, Philadelphia, Pennsylvania
  • Can be contacted at [email protected]
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today
With This Course

Access to all training products for one year
$699/year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.

Product ID: 389629
Published 2013
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!