Search courses 👉
Professional Course

Microsoft® Excel®: Beyond the Basics

Pryor Learning, Online
Length
1-Day Seminar
Price
149 USD
Next course start
22 November, 2024 (+8 start dates)
Delivery
Virtual Classroom
Length
1-Day Seminar
Price
149 USD
Next course start
22 November, 2024 (+8 start dates)
Delivery
Virtual Classroom
Visit this course's homepage on the provider's site to learn more or book!

Course 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!

Our Excel training is just what you'll need to increase your productivity and take your current Excel skills to the next level! Save when you attend both Microsoft Excel Basics and Microsoft Excel: Beyond the Basics.

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.

*NOTE: This is not a hands-on workshop. You'll learn more in less time with our dynamic hands-off teaching approach — without wasting valuable time entering data, correcting mistakes, or waiting for other seminar attendees to catch up. Your workbook provides all the information you need to try everything you've learned later, at your own speed and convenience.

Upcoming start dates

Choose between 8 start dates

22 November, 2024

  • Virtual Classroom
  • Online
  • English

3 December, 2024

  • Virtual Classroom
  • Online
  • English

5 December, 2024

  • Virtual Classroom
  • Online
  • English

6 December, 2024

  • Virtual Classroom
  • Online
  • English

11 December, 2024

  • Virtual Classroom
  • Online
  • English

13 December, 2024

  • Virtual Classroom
  • Online
  • English

17 December, 2024

  • Virtual Classroom
  • Online
  • English

19 December, 2024

  • Virtual Classroom
  • Online
  • English

Course delivery details

Setup and Editing Success

  • Seven Rules that make worksheet setup easy
  • How to conceal data in cells, columns, and rows without losing it
  • Three steps to protect your data
  • Nine 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
  • Seven 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

Contact this provider

Contact course provider

Fill out your details to find out more about Microsoft® Excel®: Beyond the Basics.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Pryor Learning

Pryor Learning

Founded more than 50 years ago when Fred Pryor pioneered the "one-day seminar", Pryor Learning has become one of the nation's leading corporate training providers, offering in-person and online training to millions of individuals and organizations — from small and...

Read more and show all training delivered by this supplier

Ads