TheITTrainingCenter.com provides CE (continuing education), professional development, and designation study courses for IT professionals

Format: Seminar


The following provides course information and pricing information for the course you selected.

Course/Product Description
Title:

Microsoft® Excel®: Beyond The Basics

Duration: 1 day
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 multi-step 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.

More Details: Agenda/Table Of Contents/Course Outline
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








Currently Scheduled Locations & Dates For This Seminar

Course Title Date City/State Price
Microsoft® Excel®: Beyond The Basics 3/21/2019 Sheridan, WY $99.00
Microsoft® Excel®: Beyond The Basics 3/21/2019 College Station, TX $99.00
Microsoft® Excel®: Beyond The Basics 3/21/2019 Augusta, GA $99.00
Microsoft® Excel®: Beyond The Basics 3/21/2019 Casper, WY $99.00
Microsoft® Excel®: Beyond The Basics 3/21/2019 San Francisco, CA $99.00
Microsoft® Excel®: Beyond The Basics 3/21/2019 Arlington, TX $99.00
Microsoft® Excel®: Beyond The Basics 3/21/2019 Lima, OH $99.00
Microsoft® Excel®: Beyond The Basics 3/22/2019 Everett, WA $99.00
Microsoft® Excel®: Beyond The Basics 3/22/2019 Amarillo, TX $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Oklahoma City, OK $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Yuba City, CA $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Greeley, CO $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Scottsbluff, NE $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Sacramento, CA $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 San Antonio, TX $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Sandusky, OH $99.00
Microsoft® Excel®: Beyond The Basics 3/26/2019 Fairbanks, AK $99.00
Microsoft® Excel®: Beyond The Basics 3/27/2019 Medford, OR $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 Fort Collins, CO $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 Akron, OH $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 Tulsa, OK $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 Palo Alto, CA $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 McAllen, TX $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 Reno, NV $99.00
Microsoft® Excel®: Beyond The Basics 3/28/2019 Aurora, CO $99.00
Microsoft® Excel®: Beyond The Basics 3/29/2019 Salem, OR $99.00
Microsoft® Excel®: Beyond The Basics 3/29/2019 Juneau, AK $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Emporia, KS $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Raleigh, NC $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Columbia, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Princeton, NJ $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Elk Grove Village, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Evansville, IN $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Wausau, WI $99.00
Microsoft® Excel®: Beyond The Basics 4/2/2019 Kalamazoo, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Madison, WI $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Troy, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Dover, DE $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Appleton, WI $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Greenville, NC $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Wichita, KS $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Springfield, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/4/2019 Indianapolis, IN $99.00
Microsoft® Excel®: Beyond The Basics 4/9/2019 Lansing, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/9/2019 Great Falls, MT $99.00
Microsoft® Excel®: Beyond The Basics 4/9/2019 Cherry Hill, NJ $99.00
Microsoft® Excel®: Beyond The Basics 4/9/2019 Quincy, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/9/2019 Chicago, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/9/2019 St. Joseph, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/10/2019 Greensboro, NC $99.00
Microsoft® Excel®: Beyond The Basics 4/11/2019 Merrillville, IN $99.00
Microsoft® Excel®: Beyond The Basics 4/11/2019 Chillicothe, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/11/2019 Burlington, IA $99.00
Microsoft® Excel®: Beyond The Basics 4/11/2019 Jackson, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/11/2019 York, PA $99.00
Microsoft® Excel®: Beyond The Basics 4/11/2019 Helena, MT $99.00
Microsoft® Excel®: Beyond The Basics 4/12/2019 Rocky Mount, NC $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Rolla, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Harrisburg, PA $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Greenville, SC $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Effingham, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Oakbrook Terrace, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Rockford, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Traverse City, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/16/2019 Pendleton, OR $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Boise, ID $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Kirksville, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Lancaster, PA $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Springfield, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Charlotte, NC $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Petoskey, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 Brookfield, WI $99.00
Microsoft® Excel®: Beyond The Basics 4/18/2019 La Salle, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Kennewick, WA $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Grand Rapids, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Urbana, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Allentown, PA $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Louisville, KY $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Columbia, SC $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Overland Park, KS $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 West Chester, PA $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Fort Wayne, IN $99.00
Microsoft® Excel®: Beyond The Basics 4/24/2019 Kenosha, WI $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Atlantic City, NJ $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Lafayette, IN $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Philadelphia, PA $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Ann Arbor, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 St. Louis, MO $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Janesville, WI $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Bloomington, IL $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Spokane, WA $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Farmington Hills, MI $99.00
Microsoft® Excel®: Beyond The Basics 4/26/2019 Charleston, SC $99.00
Microsoft® Excel®: Beyond The Basics 4/30/2019 Providence, RI $99.00
Microsoft® Excel®: Beyond The Basics 4/30/2019 Flagstaff, AZ $99.00
Microsoft® Excel®: Beyond The Basics 4/30/2019 Lancaster, CA $99.00
Microsoft® Excel®: Beyond The Basics 4/30/2019 Santa Clarita, CA $99.00
Microsoft® Excel®: Beyond The Basics 4/30/2019 Towson, MD $99.00
Microsoft® Excel®: Beyond The Basics 5/1/2019 Fayetteville, AR $99.00
Microsoft® Excel®: Beyond The Basics 5/1/2019 Melbourne, FL $99.00
Microsoft® Excel®: Beyond The Basics 5/1/2019 Edison, NJ $99.00
Microsoft® Excel®: Beyond The Basics 5/2/2019 San Luis Obispo, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/2/2019 Hartford, CT $99.00
Microsoft® Excel®: Beyond The Basics 5/2/2019 Winchester, VA $99.00
Microsoft® Excel®: Beyond The Basics 5/2/2019 Mesa, AZ $99.00
Microsoft® Excel®: Beyond The Basics 5/2/2019 Santa Barbara, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/3/2019 Little Rock, AR $99.00
Microsoft® Excel®: Beyond The Basics 5/3/2019 Clearwater, FL $99.00
Microsoft® Excel®: Beyond The Basics 5/3/2019 New York, NY $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Annapolis, MD $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Bangor, ME $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Las Vegas, NV $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Richmond, VA $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 El Paso, TX $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Los Angeles, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Grand Island, NE $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Chattanooga, TN $99.00
Microsoft® Excel®: Beyond The Basics 5/7/2019 Honolulu, HI $99.00
Microsoft® Excel®: Beyond The Basics 5/8/2019 Woburn, MA $99.00
Microsoft® Excel®: Beyond The Basics 5/8/2019 Tampa, FL $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Washington, DC $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Omaha, NE $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 San Diego, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Knoxville, TN $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Albuquerque, NM $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Frederick, MD $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Augusta, ME $99.00
Microsoft® Excel®: Beyond The Basics 5/9/2019 Saint George, UT $99.00
Microsoft® Excel®: Beyond The Basics 5/10/2019 Portland, ME $99.00
Microsoft® Excel®: Beyond The Basics 5/10/2019 La Jolla, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/10/2019 Orlando, FL $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Cedar Rapids, IA $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Fort Lauderdale, FL $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Saddle Brook, NJ $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Farmington, NM $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Worcester, MA $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Carlsbad, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Nashville, TN $99.00
Microsoft® Excel®: Beyond The Basics 5/14/2019 Springfield, MA $99.00
Microsoft® Excel®: Beyond The Basics 5/15/2019 Fredericksburg, VA $99.00
Microsoft® Excel®: Beyond The Basics 5/15/2019 Lake Havasu City, AZ $99.00
Microsoft® Excel®: Beyond The Basics 5/15/2019 Elizabeth City, NC $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Mason City, IA $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Santa Fe, NM $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Memphis, TN $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Leominster, MA $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Middletown, NY $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Pasadena, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 Taunton, MA $99.00
Microsoft® Excel®: Beyond The Basics 5/16/2019 West Palm Beach, FL $99.00
Microsoft® Excel®: Beyond The Basics 5/17/2019 Palm Springs, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/17/2019 Roanoke, VA $99.00
Microsoft® Excel®: Beyond The Basics 5/17/2019 Norfolk, VA $99.00
Microsoft® Excel®: Beyond The Basics 5/21/2019 Ontario, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/21/2019 Tucson, AZ $99.00
Microsoft® Excel®: Beyond The Basics 5/21/2019 Long Beach, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/21/2019 Fairfax, VA $99.00
Microsoft® Excel®: Beyond The Basics 5/21/2019 Norwich, CT $99.00
Microsoft® Excel®: Beyond The Basics 5/21/2019 Uniondale, NY $99.00
Microsoft® Excel®: Beyond The Basics 5/23/2019 Natick, MA $99.00
Microsoft® Excel®: Beyond The Basics 5/23/2019 Phoenix, AZ $99.00
Microsoft® Excel®: Beyond The Basics 5/23/2019 Burbank, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/23/2019 Hauppauge, NY $99.00
Microsoft® Excel®: Beyond The Basics 5/23/2019 Anaheim, CA $99.00
Microsoft® Excel®: Beyond The Basics 5/23/2019 Columbia, MD $99.00
Microsoft® Excel®: Beyond The Basics 6/6/2019 Mankato, MN $99.00
Microsoft® Excel®: Beyond The Basics 6/11/2019 Bellingham, WA $99.00
Microsoft® Excel®: Beyond The Basics 6/12/2019 Birmingham, AL $99.00
Microsoft® Excel®: Beyond The Basics 6/19/2019 Pittsburgh, PA $99.00
Microsoft® Excel®: Beyond The Basics 6/20/2019 Willmar, MN $99.00
Microsoft® Excel®: Beyond The Basics 6/26/2019 Fargo, ND $99.00


Feature Items
Cisco Certifications
Cisco Certifications
Project Management
Project Management
Microsoft Certification Paths
Microsoft Certification Paths
Cisco Certified Network Professional (CCNP) Certificate Program
Cisco Certified Network Professional (CCNP) Certificate Program
Cisco Certified Network Associate (CCNA) Certificate Program
Cisco Certified Network Associate (CCNA) Certificate Program
Cisco Certified Entry Networking Technician (CCENT) Certificate Program
Cisco Certified Entry Networking Technician (CCENT) Certificate Program
Certified Information Systems Security Professional (CISSP) Certificate Program
Certified Information Systems Security Professional (CISSP) Certificate Program
Oracle Certifications
Oracle Certifications
IT Audit School
IT Audit School
IT Auditing And Controls
IT Auditing And Controls
Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing
Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors
Auditing Business Application Systems
Auditing Business Application Systems
Fraud Auditing Boot Camp
Fraud Auditing Boot Camp
Adobe Training
Adobe Training