Microsoft® Excel® Basics

9:00 am - 4:00 pm

Check in at 8:30 am

$79/Person

$74 for groups of 5 or more

Continuing Education Credits: CEU: 0.6 CPE: 6.00 PDU: 6.00 

Choose an Event

Events Near

Ashburn, VA 20149

Change Location

25 More Dates and Locations

Microsoft® Excel®: Beyond the Basics

9:00 am - 4:00 pm

Check in at 8:30 am

$99/Person

$89 for groups of 5 or more

Continuing Education Credits: CEU: 0.6 CPE: 6.00 PDU: 6.00 

Choose an Event

Events Near

Ashburn, VA 20149

Change Location

25 More Dates and Locations


Select an Event to Continue

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
  • Give your worksheets visual punch with exciting charts and graphs, step by step, the easy way!
  • Make editing easy — fearlessly copy, move, delete, insert, or replace anything in your worksheet!
  • 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

Overview

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.

Agenda

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