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!
*Price may vary by location and date.