Location

$79/Person

Overview

Discover the basics, plus expert power tips!

Starting with the basics and moving to more advanced features, you'll learn how to turn Excel into your most powerful productivity tool. If you're only tapping into a few of the features of this powerful and versatile software, get set for a productivity explosion! You'll learn hundreds of ways to work faster, smarter and savvier with Excel!

You don't have to waste hours wading through thick manuals … sitting in classes for days, even weeks … fruitlessly punching keys in trial and error learning efforts — forget all that! Our guaranteed one-day computer training gives you the most information possible in the least amount of time. Most of us don't have time in our busy workdays for extended training or on-the-job learning. Enroll in Excel Basics today, and you'll master the basics and move on to the tough stuff — away from deadlines, demands, and office pressures.

So many of us work by habit — doing things the same old way we learned to do them the first time. Break free of old habits and discover the Excel power tools that are available and just waiting to be used! You'll learn the ABCs of using charts, graphs, fonts, borders, shading, and more — and produce spreadsheets that communicate better and really get attention! You'll leave the seminar with a pack of professional tips for brilliant, distinctive output every time, on every worksheet!

This one-day seminar is for beginning to intermediate users. Learn how to set up Excel to meet your personal needs at work or at home, and customize its many features so that it works for you!

Master an array of Excel formulas and functions that put spreadsheet power at your fingertips!

Design and organize the best possible worksheet — before you enter the first number

Solve common printing problems and end irritating output surprises once and for all

Macros now! Even if you're a beginner, create and use simple macros that save time and sidestep mistakes!

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.

Excel is one of today's most powerful and versatile business tools, but if you're not familiar with its basic functions, formulas, commands, and keystrokes, you're setting yourself up for frustration and disappointment. This Excel training gives you strong fundamentals to build on, leads you through more advanced concepts, reveals the most important new features of Excel, and sends you home with a concise, information-packed workbook that summarizes everything you've learned.

*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.

Agenda

Take a quick tour of Excel basics!

Shortcut menus: the most efficient way to access commands for any task

Help for Help! How to find what you need in Help without the endless searching and scrolling

How to select cells or ranges of cells — two methods to choose from

How to find a single file or a particular workbook in record time

Build a worksheet from the ground up

What to consider before you create a worksheet — expert advice on building a worksheet framework that will accomplish your objectives

Tips for entering text and numbers, and a super-quick way to cancel or confirm your entry

The view you need — how to zoom in and zoom out of your worksheet

When titles and labels keep moving out of view: techniques to freeze them in place while you move around your worksheet

Harness the real power behind the numbers

Formula and Function basics — on-the-mark advice that will end confusion once and for all

Mathematical formulas made easy: how to subtract, multiply, or divide data

Basic Excel functions that let you calculate averages, percentages, and much more using built-in predefined formulas

Learn the techniques that produce visually exciting worksheets!

The secrets to attractive, readable worksheets: five formatting guidelines that apply to any worksheet you produce

How to control alignment, decimals, dollar signs and more — in one easy operation

Fonts, shading and borders that increase the readability and attractiveness of your worksheet

Get the output you want without trial-and-error printing

Print Options: the many choices Excel gives you to customize your printing. Plus, how to add headers, footers, and page numbers to a worksheet

No more strange page breaks — how to set manual page breaks and ensure that your titles and labels print on every page

Add impact and visual punch to your data!

An easy-to-understand glossary of the terms used in charting and graphing data

The Chart Wizard — how to easily produce vivid, exciting charts to accompany your data, even if you're a total novice

Where to actually put your chart: all about embedded charts, separate charts, and chart sheets within a workbook

Gain speed, efficiency, and ease at every session!

Large worksheets with Split Windows — the best way to effortlessly view distant figures side by side

For mouse-haters: a quick guide to shortcuts that keep your hands on the keyboard

An end to macro mystery — how you can automate many tasks using macros

"I have been a member of Fred Pryor for almost three years now and I have yet to attend a class that didn't have valuable information that would benefit my company and/or our employees."

— Teri M.

"Excellent!! As always, Fred Pryor's courses are easy to follow, very informative and presented in a format that keeps your attention!!"

— Cynthia S.

"I enjoy all of the seminars that I attend through the Fred Pryor Training Rewards program. They are very informative and the instructors are very knowledgeable and helpful."

— Tasha M.

"Excellent info for all levels of users. There are always things to add to your "bag of tricks"."

— Wendy S.

"Wow! I have taken many wonderful courses through Fred Pryor; this one takes the cake!!"

— Dana N.

"Top notch! Thank you Fred Pryor, this is the best investment my boss could have made."

— Lewis C.

"I received a lot of great information in this training. Several co-workers went with me which was a great help for me to start implementing some of the changes we need to do at the office. It was very eye opening for them to realize the things that we need to do at the office. It was very eye opening for them to realize the things that need to get to me. It was like Fred Pryor and the trainer had my back!"

Additional Resources

About Us

Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 11+ million learners and 300,000+ businesses achieve meaningful and lasting success. Pryor Learning Solutions delivers 10,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access 7,000+ live seminars across the U.S. and Canada and more than 4,700 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 40 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.