ABTrainingCenter.com provides CE (continuing education), professional development, and NASD and insurance licensing and designation study courses such as Series 7, CFP, CLU, and CPCU designations for brokers, agents, and financial service providers
Course/Product Description
Title:

Microsoft® Excel® 2007/2010: Beyond The Basics

SKU:SM-1003621
Format: In-Person Seminar
Find A Class Near You: View Dates And Locations For This Seminar
Description:

Work Faster And Smarter With Excel!

It's frustrating to know what Excel can do, but not understand the techniques to accomplish it.

In one day, you will learn not only the formulas, database techniques, and macro commands that make work go faster, but you will also learn the tips and keystroke commands the pros rely on to make data more useful and worksheets easier to manipulate.

It's A Wise Investment!

One day never delivered so much practical, real-world computer skills training. You'll improve your productivity tenfold. Complicated charts and graphs that once took hours to compile will now take only minutes to set up and assemble.

You'll learn when it makes sense to use a macro, how to debug a macro, and how to create and manage a PivotChart. Key code shortcuts you learn will transform multistep processes into single, simple moves. Even the advanced linking and data exchange operations you once dreaded will become easier.

The skills you'll gain in this one-day advanced program make it the single best investment you can make in Excel training. Not only will you leave with a wealth of exciting new techniques and shortcuts, but you'll also receive a handy workbook guide that summarizes key tips for easy reference. It's a lot of value for your investment.

An Accelerated One-Day Workshop To Make You A Microsoft Excel Pro!

  • Improve the quality, accuracy, and usefulness of every Excel worksheet!
  • Use the Visual Basic Editor to eliminate repetitive keystrokes and save time
  • Create visually exciting charts by adding graphics with customized drawing tools!
  • Discover the most important database functions and how they work
  • Collect and format data the easiest way!
  • Develop PivotCharts® and manage them in a snap

You'll learn from a business professional who speaks your language and has extensive experience using Excel in a real-world office like yours. Our hands-off teaching methods ensure you won't waste valuable time entering data, correcting mistakes, and waiting for other seminar attendees to catch up.

We'll cover as much material as possible together and let you practice on your own back at work.

AGENDA

Setup and Editing Success

  • 7 Rules that make worksheet setup easy
  • How to conceal data in cells, columns, and rows without losing it
  • 3 steps to protect your data
  • 9 keyboard shortcuts that will cut hours from your work
  • Tips on changing chart attributes without losing data
  • How to manipulate multiple ranges with Autofill
  • The overlooked problem-solver for naming ranges
  • The end of data entry drudgery — how to get the software to do it for you

Formulas and Functions That Cut Work Down to Size

  • Tips for building complex formulas quickly and accurately
  • How to utilize the hundreds of functions at your fingertips
  • How to use absolute and mixed cells
  • Logic Functions — the If, And, and Or statements that make data more usable
  • 7 formulas you can use right away to select, extract, and combine text entries

How to Make the Most of Macros

  • When to use an automated procedure or macro — and when not to
  • Tips for recording a complex macro and ensuring it runs easily
  • How to assign command buttons to macros
  • Techniques for debugging a macro, as easy as 1, 2, 3
  • How to start — and use — the Visual Basic Editor

Data Exchange with Other Applications

  • Specific steps for sharing data with Microsoft PowerPoint®, Access®, Word, and other platforms
  • How to save your Excel work in a web-friendly format

The Power of Tables, Databases and Lists

  • How to sort to maximize the data's usability
  • Auditing: a visual map of your formulas
  • How to build and manage a PivotChart that's everything management wants
  • The best way to analyze equations with scenarios
  • A shortcut for calculating trends and projecting future ones


CPE CREDIT

Fred Pryor Seminars and CareerTrack are registered with the National Association of State Boards of Accountancy (NASBA), as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.

CPE certificates will be available 10 days after your event has ended.

Licenses / Designations / Educational Credits:CEU
All US States: 0.6

CPE
All US States: 6

PDU
All US States: 6
About The Provider: Fred Pryor Seminars and CareerTrack, divisions of PARK University Enterprises, Inc., create one of the most respected international providers of professional seminars.

Since pioneering the one-day seminar in 1970 as Fred Pryor Seminars, our organization has built a reputation for high-quality, convenient, and practical business-skills training around the world, in every industry and sector.

Today, with more than 8 million satisfied customers, we continue to pride ourselves in providing the superior training you've come to expect from Fred Pryor Seminars and CareerTrack. Our cutting-edge research and course development are designed to meet the adult learning needs of your employees and your organization.

Fred Pryor Seminars and CareerTrack are your number one choices for training because we offer:
  • In-depth experience in the training industry
  • Consistent and comprehensive course offerings
  • High-energy and content-rich presentations
  • Multiple training tools, including on-site training, on-line learning, seminars, and A/V products
  • 100% Satisfaction Guaranteed!
As we continue to grow, expand, and change to meet client and market needs, we always remember that every individual customer matters and that collectively, they are our most valuable assets. That's why our goal is the same today as it was 30 years ago — to provide the best choice in business skills training with maximum convenience to help you — our customer — achieve success!
Price: $99.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Seminar
Course TitleCity/StateDate
Microsoft® Excel® 2007/2010: Beyond The BasicsDUBOIS, PA12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsPROVIDENCE, RI12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsCONCORD, CA12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsGREENSBORO, NC12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsANNAPOLIS, MD12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsRUTLAND, VT12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsNEW HAVEN, CT12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsTOPEKA, KS12/7/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsLEXINGTON, KY12/8/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsMODESTO, CA12/8/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsREADING, PA12/8/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsBLOOMINGTON, IL12/8/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsSACRAMENTO, CA12/8/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsFREDERICK, MD12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsMILFORD, CT12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsWORCESTER, MA12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsSPRINGFIELD, MO12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsSPRINGFIELD, MA12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsFRESNO, CA12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsLITTLE ROCK, AR12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsRALEIGH, NC12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsWILLIAMSPORT, PA12/9/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsST. LOUIS, MO12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsLEOMINSTER, MA12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsCOLUMBIA, SC12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsALLENTOWN, PA12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsSAN FRANCISCO, CA12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsST. JOSEPH, MO12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsCUMBERLAND, MD12/13/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsWINCHESTER, VA12/14/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsRICHMOND, VA12/14/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsMUNCIE, IN12/14/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsATLANTIC CITY, NJ12/14/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsVISALIA, CA12/14/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsCAPE GIRARDEAU, MO12/14/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsCHARLOTTE, NC12/15/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsDANBURY, CT12/15/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsCHICO, CA12/15/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsSTATE COLLEGE, PA12/15/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsKANSAS CITY, MO12/15/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsPRINCETON, NJ12/15/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsMEMPHIS, TN12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsFAIRFAX, VA12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsWICHITA, KS12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsINDIANAPOLIS, IN12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsFREDERICKSBURG, VA12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsWILMINGTON, DE12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsBAKERSFIELD, CA12/16/2016
Microsoft® Excel® 2007/2010: Beyond The BasicsAKRON, OH1/10/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsEAU CLAIRE, WI1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSALT LAKE CITY, UT1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsUNIONDALE, NY1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSOUTHFIELD, MI1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsLEWISTON, ID1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsMERRILLVILLE, IN1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsHOUSTON, TX1/11/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsCINCINNATI, OH1/12/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsKENNEWICK, WA1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSADDLE BROOK, NJ1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsST. PAUL, MN1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsDENVER, CO1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsANN ARBOR, MI1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsCOLLEGE STATION, TX1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsCHICAGO, IL1/13/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsST. CLOUD, MN1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsGRAND RAPIDS, MI1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsGREEN BAY, WI1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsFORT COLLINS, CO1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsLONGMONT, CO1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsHOUSTON, TX1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsELK GROVE VILLAGE, IL1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsEDISON, NJ1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsHELENA, MT1/18/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsAUSTIN, TX1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsGREAT FALLS, MT1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsPARSIPPANY, NJ1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsKALAMAZOO, MI1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsLAKEWOOD, CO1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsBLOOMINGTON, MN1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsAPPLETON, WI1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsKENOSHA, WI1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSCOTTSBLUFF, NE1/20/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsBRAINERD, MN1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsNEW YORK, NY1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsJOLIET, IL1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsBOISE, ID1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsOREM, UT1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsTROY, MI1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSAN ANTONIO, TX1/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsMADISON, WI1/25/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsWILLISTON, ND1/25/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsKALISPELL, MT1/25/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsDAYTON, OH1/25/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsEAST LANSING, MI1/26/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsMELVILLE, NY1/26/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsOGDEN, UT1/26/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsOAKBROOK TERRACE, IL1/26/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsDULUTH, MN1/26/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsMCALLEN, TX1/26/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsCOLUMBUS, OH1/27/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsYAKIMA, WA1/27/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsMILWAUKEE, WI1/27/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsBISMARCK, ND1/27/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSPOKANE, WA1/27/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSALEM, OR1/31/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsBURBANK, CA1/31/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSARASOTA, FL2/1/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsONTARIO, CA2/1/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsTAMPA, FL2/2/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsLONG BEACH, CA2/2/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsMEDFORD, OR2/2/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsANAHEIM, CA2/3/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsLAKELAND, FL2/7/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsBATON ROUGE, LA2/8/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSIOUX CITY, IA2/8/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsWEST PALM BEACH, FL2/9/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsTULSA, OK2/10/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsANCHORAGE, AK2/10/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsDES MOINES, IA2/10/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsGULFPORT, MS2/14/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSEATTLE, WA2/14/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsALBUQUERQUE, NM2/14/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsFORT WORTH, TX2/15/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSIOUX FALLS, SD2/15/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSCOTTSDALE, AZ2/16/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsJACKSON, MS2/16/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsOMAHA, NE2/17/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsLAS VEGAS, NV2/22/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsCHANDLER, AZ2/22/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsCLEARWATER, FL2/22/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsPORTLAND, OR2/22/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsDENTON, TX2/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsJACKSONVILLE, FL2/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsPHOENIX, AZ2/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsPALM SPRINGS, CA2/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsSAN DIEGO, CA2/24/2017
Microsoft® Excel® 2007/2010: Beyond The BasicsEUGENE, OR2/24/2017

Securities Licensing
Securities Licensing

Insurance License
Insurance License

Adjuster Licensing
Adjuster Licensing

Texas All-Lines Adjuster Pre-Licensing ONLINE Course
Texas All-Lines Adjuster Pre-Licensing ONLINE Course

Associate in General Insurance (AINS)
Associate in General Insurance (AINS)

ARM
ARM

Associate in Premium Auditing (APA)
Associate in Premium Auditing (APA)

Surplus Lines Online Exam Prep Course
Surplus Lines Online Exam Prep Course

FMLA Training &Certification Program
FMLA Training &Certification Program

ADA Training &Certification Program
ADA Training &Certification Program

COBRA Training &Certification Program
COBRA Training &Certification Program

Basics Of Affirmative Action Planning
Basics Of Affirmative Action Planning

Cafeteria Plan Training &Certification Program
Cafeteria Plan Training &Certification Program

Business Writing for Results
Business Writing for Results

Earn Your CFP
Earn Your CFP

Qualified Financial Advisor (QFA)
Qualified Financial Advisor (QFA)

Google+ABTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9375 | support@ABTrainingCenter.com
Copyright ABTrainingCenter.com 2016 | Web Site Development by OTAU
Facebook