Choose an Event
LIVE ONLINE SEMINARS
PRIVATE TEAM TRAINING
Bring this topic or 200+ other training opportunities to your location in-person or online.
Already attended this seminar?
"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!"”
— Tasha C.
This one-day seminar is for the beginning to intermediate user interested in being more proficient in Excel.
Seminar highlights include:
- Learn the necessary insight and knowledge you need to make your way around Excel quickly and efficiently
- Master the important initial set up to build your database successfully
- Build your own professional spreadsheets. What does that mean? More than you think!
- Calculating in Excel is more than addition, subtraction, multiplication and division. Learn how to make complex formulas and calculate percentages to help you make budget decisions
- The need for speed is true in the car and with the computer. Discover quick tips, shortcuts and functions that make you as fast as you want to go
- And so much more!
Take a quick tour of Excel basics!
- The first thing you see in Excel 2013 is that it has many new features, including a new start screen that will help you get to work faster.
- Explore Excel and customize your working environment so this program can work for you and utilize your work style to become more intuitive.
- Learn the seven steps to spreadsheet success. The key is to begin the right way, so you don’t spend time redoing or undoing work.
- Discover tips for planning ahead. A little pre-planning goes a long way when your spreadsheet needs to be built for maximum utility and usability.
Build Professional Spreadsheets
- There are templates already there - should you use them? This component will help you determine whether you should create a new workbook from a template, or build one specific to your needs from the ground up.
- Formatting is an important step to make the data communicate in the simplest form. Learn to format your data so it’s easy for you, and others, to understand what your data is saying.
- Uncover some terrific time-savers that get every workbook off to a great start.
- Discover the tools to format your work so your data doesn’t just speak - it sings!
- With proper instruction, you will be able to optimize and improve your workbooks for further effectiveness.
Calculate Your Data
- Learn from real life examples that actually apply to you, and broaden your understanding as you use it to create your own data masterpiece.
- Master Excel language and syntax to start building formulas like a pro. It’s tricky, but it can be done and you can do it!
- Who doesn’t want to work smarter and faster? Now you can with built-in formulas.
Save, Output and Present
- We can show you the best practices for organizing data to help you with business decisions. Who is your best customer? Depending on the data, the answer may surprise you!
- Choosing the right chart every time is a learned skill we can help you with!
- Print only what you want: worksheets, charts and reports exactly the way you intend - the first time!
- We will show you how to design dynamic diagrams, and provide great guidelines to create assessable data.
- Learn how chart tools have become smarter - using Recommended Charts, your data display is clear and concise for anyone to understand.
Streamline and Automate
- Familiarize yourself with shortcut menus and quick keys for efficiency and speed. You can uncover the power of your favorite shortcuts and will learn some new ones along the way!
- Demystify macros - what it can mean for your spreadsheet.
- Change your perspective: Use the various views Excel has to offer.
- Take advantage of time-savers like Flash Fill.
- Learn the power of the "Magic" ALT key!