My Shopping Cart
There are no items in your shopping cart.

Microsoft Excel 2010 Bundle (8 DVDs) (PKGIME440M)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
  •  N/A
Event Description

A Comprehensive Guide of Microsoft Excel 2010

Increase your productivity and work efficiency with various features of Microsoft Excel 2010. Get in-depth understanding of Excel 2010 starting from basic tips, commands and shortcuts to advanced formulas, formatting techniques, macros and charts.

This all-inclusive package helps you to navigate seamlessly through your worksheets and manage your data effectively with simple techniques. Learn fast, efficient ways to sort data, apply filters and use valuable functions to analyze complex data. Make use of formatting techniques to optimize a worksheet’s appearance. Find out quick ways to add formatting features and present your data in a meaningful manner. You will learn how to make your worksheet visually appealing with conditional formatting, form controls, tables, sparklines and SmartArt tools. The package also helps you create a Pivot Table to organize large lists of data in a matter of minutes.

Become competent in advanced Excel formulas and functions. Find out extended uses of the IF and VLOOKUP functions. Learn how to overcome limitations of the VLOOKUP function with the frequently combined MATCH and INDEX functions. You will also become familiar with productivity tips, shortcuts and accelerator tools. Plus, you will learn how to create a macro to automate repetitive tasks and work more efficiently. The package also explains how to create charts to get significant results from your data.

Topics covered in the package:

  • Excel Tips, Tricks and Shortcuts
    1. Keystroke shortcuts
    2. Copy or move data with simple dragging
    3. Build lists of dates, times or values
  • Excel Visual Features to create more attractive worksheets
    1. Conditional Formatting
    2. Themes
    3. Form Controls
    4. Tables
    5. SmartArt
    6. Sparklines
  • Excel Database Commands and Features
    1. Sort data by content, color, random order or re-arranging columns
    2. Apply filters to display just the data you need
    3. Eliminate duplicate records from a large database
    4. Insert a row of subtotals in a sorted list
    5. Create drop-down lists
    6. Convert lists into tables to enhance visual appeal
  • Excel Pivot Tables & Pivot Charts
    1. Create a Pivot Table and change its appearance
    2. Use Slicers to trace the fields that are being currently displayed
    3. Categorize date/time data in multiple levels
    4. Develop and manage a Pivot Chart
    5. Deal with a dynamic source data and the refresh concept
  • Excel Formatting Techniques
    1. Use Conditional Formatting to add emphasis and focus to worksheets
    2. Learn multiple tools and techniques for copying formats
    3. Convert data into a table and gain valuable formatting features
    4. Create custom formats and quickly access built-in formats
  • Excel Formulas and Functions
    1. Extended uses of IF and VLOOKUP functions
    2. Learn quick formula copying methods
    3. Set up and use array formulas and array functions
  • Macro shortcuts
    1. Create a macro by recording
    2. Run a macro
    3. Use the step method to test a macro
    4. Add code to a macro
  • Excel Charts and Graphs
    1. Learn quick ways to create a chart
    2. Copy charts and adjust the chart type
    3. Insert trendlines and adjust gridlines and axes
    4. Annotate charts with data labels, arrows, and boxes
    5. Create in-cell charts with Sparklines
  • And more...

Benefit from this exhaustive guide and learn new ways to manage your data with Microsoft Excel 2010.

About Our Speaker(s)

Dennis Taylor, Microsoft Excel Training ExpertDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Microsoft Excel 2010 Bundle (8 DVDs)
    Presenter(s): Dennis Taylor Protection Status