Questions?

1.800.258.7246


home  |  about us  |  view cart  |  search

Follow us on: FacebookTwitterGoogle+LinkedIn
National Seminars Training - Your Complete Learning Center SEMINAR FINDER
State:
ZIP:
Sign Up for Emails or Special Offers
Email:
ZIP:
Getting the Most From Microsoft Excel
Learn practical techniques and skills that will help you accomplish more in less time — with impressive results!


Program Description:
One-Day Seminar

In Getting the Most From Microsoft® Excel®, you’ll learn ...

  • How to customize the ribbon to increase your productivity and even create new tabs and hide the ones you never use
  • Data, reports, graphs and formulas — how to make the most of Excel’s many talents
  • How to solve print problems and get your information to look the way you want it to
  • Spreadsheets, charts and more — easy ways to make spreadsheets and figures into colorful, clear and precise presentations
  • And much more

Do you ever find yourself searching through an Excel manual ... wishing you had an Excel expert to ask ... or even giving up in frustration by working around features that you know Excel is capable of because you don’t know how to use them? This workshop will show you how to end your Excel frustrations for good by providing the how-to’s for breezing through spreadsheets, forecasts, graphs and financial reporting, plus little-known shortcuts and time-saving techniques. Work smarter, not harder, by enrolling in this workshop today!

Agenda:

GETTING STARTED—Excel® essentials
In this informative first session, we’ll show you how to get started on the right foot. You’ll explore the start screen in Excel and how you can get a jump on your project by taking advantage of a collection of professionally designed templates, including budgets, calendars, forms, reports and more. You’ll also find out how to customize the interface to make working with Excel even easier. You’ll also discover ...

  • What you need to know about the Excel interface including working with the ribbon
  • How to customize the ribbon to increase your productivity and even create new tabs and hide the ones you never use
  • What you need to know about the changes in the Backstage view
  • Workbook and worksheet essentials—how to create, manage, save and rename workbooks and worksheets
  • How to increase your productivity with special keyboard shortcuts and mouse techniques
  • How to make sense out of the huge number of file types when it comes to saving your work
  • How to uncover all the different Options settings and find out which ones you may want to change depending on how you use Excel

FORMATTING AND STYLES—Getting the look you want
In this session, you’ll learn how to create professional-looking worksheets that are easier to read and understand. You’ll find out how to use predefined styles and how to manually create your own unique styles that dramatically improve the appearance of your worksheets. You’ll learn ...

  • How to modify the format of numerical data in your worksheets
  • How to format large blocks of cells quickly and efficiently with the power of Format Painter
  • How to use the Themes option to quickly change the overall appearance of your worksheet
  • How to implement conditional formatting, take advantage of icon sets, utilize improved data labels and a dozen other formatting tips and techniques for making your data stand out
  • Quick cell formatting from predefined styles
  • How to easily select a range of cells and convert it into a great-looking table that stands out on your worksheet
  • Secrets of the Merge and Center button and how to use it to create professional-looking headings
  • How to use the Format option to modify cell sizes and visibility and organize and protect your worksheets

FORMULAS AND FUNCTIONS—The real power of Excel
In this session, you’ll uncover the real power of Excel. You’ll learn how to create formulas using the functions built into Excel to really make sense out of your data. You’ll learn about the functions contained in the Function Library, including many of the newest ones, and how to correctly use them in your formulas. You’ll also find out how to troubleshoot formula errors and how to quickly resolve them. Also in this session ...

  • Master the mysteries of relative and absolute cell references—“must-know” information for working with formulas
  • Discover the Function Library and how to add functions to your formulas and make sure you’re using the correct syntax
  • How to use the Insert Function dialog box and quickly get help on how the selected function works
  • How to use the Name Manager to name a data range and use it in your formulas to save time and effort
  • How to use the Error Checking feature to spot common errors in formulas
  • How to use the Watch Window to see the values of selected cells as you change values on your worksheet
  • How to use the Evaluate Formula dialog box to check each part of your complex formulas individually to locate and correct any errors
  • How to take advantage of the Quick Analysis tool to get instant data analysis

OBJECTS, CHARTS AND SPARKLINES
In this session, you’ll learn how to create stunning visual effects by adding objects, charts and Sparklines to your worksheets. You’ll learn how to make your worksheets come alive with 2-D and 3-D charts, Sparklines and other objects that can instantly convey the information contained in your data. You’ll learn ...

  • How to quickly insert objects such as pictures, clip art, shapes and more with just a few clicks of the mouse
  • How to insert complex mathematical equations and symbols into your worksheets
  • How to use the Screenshot feature to quickly insert a screenshot of any open application
  • How to quickly select your data and insert a chart into your worksheet
  • The best way to visualize your data in a chart by using the Recommended Charts feature
  • How to use the Chart Tools to create stunning charts that have that professional look
  • The changes to the Chart Ribbon and how to create a combo chart
  • Stock, Surface, Doughnut, Bubble and Radar—how using advanced chart types can capture your audience’s attention

MANAGING YOUR DATA—Connections, sorting, filtering and data tools
Have you ever retyped data from a text file, database or other application into Excel®? Well, we’ll show you how to automatically import data from a variety of sources directly into Excel and save hours of work. Once you’ve got your data into Excel, you need to know how to sort and filter the data to pull up only the information you need, and that’s also included in this session. In this session, you’ll learn ...

  • How to connect to a variety of data sources, such as SQL Server®, Windows Azure® Marketplace and others, and import data into Excel
  • How to use the Sort feature to sort on not only values of cells but the color of the cells, color of the cell font and more
  • How to prevent bad data from being entered by using the Data Validation feature
  • How to automatically add subtotals to several rows of related data with just a couple of mouse clicks
  • How to use the powerful filter features of Excel to view only the data you have need of
  • How to insert a slicer to interactively filter data
  • How to easily separate the contents of one cell into multiple columns such as first and last names
  • How to take advantage of the Flash Fill tool to quickly fill out an entire column of data
  • How to create custom lists for use in sorts and fill sequences

REVIEWING, SHARING AND PRINTING
In this session, you’ll learn how to easily share your workbook with others, but you’ll have the confidence to know that your data is secure. You’ll also find out how to review a worksheet, add comments, track changes and finally how to print an entire worksheet or only the portion you need. Included in this session ...

  • How to add comments to a worksheet
  • Keeping track of the changes made to a spreadsheet by others so you can decide which to keep and which to discard
  • How to protect a workbook so that only those you choose can open it
  • The steps you’ll need to take in order to share your workbook with others, including how to use the OneDrive® for Business feature
  • How to quickly check for issues such as compatibility with previous versions before you share your workbook
  • How to create a range of cells that other users can edit while the rest of the worksheet is locked
  • How to save time by creating a custom view to select a print area you need to print on a regular basis
  • How to use the Print Titles feature to specify rows and columns to repeat on each printed page
  • How to use the Browser View Options feature to pick what users can see when the workbook is viewed on the Web
QUICK LINKS

STAR12

Corporate Training

CEU/CPE Information

Cancellation Details


SEMINAR SCHEDULE

Click "+" to see cities

+ Alabama
+ Arkansas
+ Arizona
+ California
+ Colorado
+ Connecticut
+ Delaware
+ Florida
+ Georgia
+ Hawaii
+ Illinois
+ Indiana
+ Kansas
+ Kentucky
+ Massachusetts
+ Minnesota
+ Missouri
+ Mississippi
+ New Hampshire
+ New Jersey
+ New Mexico
+ Nevada
+ New York
+ Ohio
+ Oklahoma
+ Oregon
+ Pennsylvania
+ South Carolina
+ South Dakota
+ Tennessee
+ Texas
+ Virginia

NO EVENTS SHOWING IN YOUR AREA?
We can bring this training to you! We can tailor this (or any) program to meet your organization’s exact needs. Call one of our training consultants today at 1-800-344-4613 for more information!

RELATED WEBINARS

Need training, but don’t have time to get out of the office? Then take a look at our related webinars. They are a fast and convenient way to get the training you need ... right from your own computer.

03/06/18
Maximizing the Power of Excel® With Macros and Modules

03/09/18
Mastering Microsoft® Outlook®

03/20/18
How to Avoid the Worst PowerPoint® Mistakes People Make

03/22/18
Mastering Excel Functions & Formulas

04/19/18
Advanced Techniques for Microsoft® PowerPoint®

CUSTOMER SERVICE: 1.800.258.7246
National Seminars Training
1.800.258.7246