Microsoft Excel 2010 Bundle (8 DVDs) (PKGIME440M)

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.