SkillPath Seminars
Call us: 1-866-222-6315

In Microsoft® Excel® 2010 Advanced, participants will learn...

  • Time-saving techniques that’ll allow more work to get done faster with Excel
  • Adding and using the Analysis ToolPak to make complex data analysis a snap
  • How to create a PivotTable report to quickly analyze volumes of data, generate summary views, see comparisons and reveal patterns in data
  • How to add power to spreadsheets with Visual Basic for Applications, including a quick way to learn VBA syntax

Your employees most likely use Excel daily, or maybe only casually, but one thing’s for sure—they probably wished they knew more about this dynamic program. That’s why this training course is the perfect solution! In it, they’ll learn ways to make their job easier and increase the sophistication of their data reporting and analyzing. Each session focuses on time-saving techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, they’ll learn how to integrate their work within the Office “family” for even greater results. If they’ve ever been frustrated using Excel because they knew there had to be a better way of accomplishing tasks, they’ll soon be on their way to getting more done—and more efficiently—with this power-boosting training course.




    SkillPath Training Information

    SkillPath Enterprise Solutions can bring the following topic to your company: Microsoft® Excel® 2010 Advanced

    Click on the link below for more information. http://www.skillpath.com/index.cfm/on-site/training/topic/Microsoft-Excel-2010-Advanced



    TRAINING AGENDA

    Click on a title to view details

    Time-saving techniques

    +
    • Quick and easy techniques to import data from virtually any kind of file or database system, such as Microsoft SQL Server, into Excel
    • How to format large blocks of cells quickly and efficiently with the power of Format Painter
    • Make titles and headings stand out by using the Merge and Center formatting feature
    • Simple techniques to import and export data to and from XML files
    • Merge data from multiple worksheets and keep the information up to date using external references
    • How to quickly create custom AutoFilters to view data in a way that takes advantage of the new search filter

    Designing forms and formatting

    +
    • How to create stunning 3-D effects with cells and implement the new artistic effects on images in worksheets
    • Using templates to create a worksheet that can help finish the next project in a fraction of the time
    • How to use Excel to quickly create professional-looking forms in minutes (not hours!)
    • How to implement conditional formatting, take advantage of the new icon sets and a dozen other formatting tips and techniques for making data stand out
    • How to add control items to worksheets, including combo boxes, option buttons and many others

    Data analysis and formulas

    +
    • A technique that sums only the data that meets conditions specified
    • Using the Goal Seek function to help determine how to get a desired result
    • The right way to use the Lookup Wizard to help write a formula that finds the value at the intersection of a column and a row
    • What the Excel Solver is, how to load it and how to take advantage of the new user interface to get the most out of it
    • How to use the Scenario tool to do a what-if analysis

    Advanced charting and graphing functions

    +
    • How to quickly create a basic chart with a single keystroke
    • Use pictures to create exciting charts that are even more descriptive than typical line and bar charts
    • How to insert a Sparkline into a cell to instantly reveal patterns in data
    • How to know which chart or graph type to use
    • How to add a chart—or virtually any kind of image—to a comment that displays when the user moves the mouse over a cell

    Getting the most out of PivotTable and PivotChart reports

    +
    • The in’s and out’s of Excel PivotTable and PivotChart reports, including the terminology used in PivotTable reports
    • How to use slicers and other techniques to quickly drill down in a PivotTable without having to go back to source data to identify specific information
    • The quick and easy way to create a PivotTable using the PivotTable Wizard
    • The techniques that allow instantly restructuring a PivotTable and changing the information reported
    • How to change PivotTable field settings to a variety of options such as average, minimum, maximum or even custom settings

    Maximizing the power of Excel with VBA and macros

    +
    • A simple tool for learning VBA syntax, including how to reference specific cells, a range of cells, worksheets and more
    • How to use loops to repeat commands multiple times
    • View and modify modules, forms and other worksheet code using the Project Explorer and Visual Basic® Editor
    • How to write conditional If/Then statements in code that can be used to execute other functions, control program flow, allow user input and perform many other functions
    • How to programmatically customize both the ribbon and the new Backstage view

    Excel and the Internet

    +
    • How to get continuously updated data from a Web site into a worksheet
    • Creating a macro that will update a chart published to a Web page at regular intervals
    • How to make the right choices when saving data to a Web page
    • Save time with the Excel Web Data add-in feature by using Web page data as a data source in a spreadsheet
    • Understanding how to collaborate and share a workbook both with and without using Excel Services

    Validating and securing data

    +
    • How to lock values and formulas in Excel worksheets
    • Track down mistakes in a worksheet using the Formula Auditing tools
    • How to use Information Rights Management (IRM) to protect Excel files
    • How to share an Excel workbook and not worry about someone making changes that’ll ruin your work
    • How to use Data Validation to make sure the data going into any cell meets the criteria specified