– Excel 2010 Training

July 28, 2012 · 0 comments

in Software Training – Excel 2010 Training
English| Audio: aac, 48000 Hz, mono (eng)
MP4| Video: h264, yuv420p, 960×540, 15.00 fps(r) (eng)| 1.81GB
Genre: Video Tutorial

1. Excel 2010 Essential Training With Bob Flisser (876MB)
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics include:
Copying and pasting techniques
Working with formulas and functions
Dealing with formula errors
Creating lookup tables
Naming cell ranges
Formatting data and worksheets
Finding and replacing data
Creating SmartArt diagrams
Creating charts and PivotTables
Recording macros
Sharing workbooks

2. Excel 2010: Macros in Depth with Dennis Taylor (639MB)
In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions that can’t be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario. Exercise files are included with the course.

Topics include:
Understanding what a macro does
Recording and adding functionality to a macro
Running macros
Creating non-recordable VBA code
Testing a macro in Step mode
Joining two macros
Using loop structures
Streamlining macros
Creating a Personal Macro Workbook

3. Excel 2010: Managing Multiple Worksheets and Workbooks with Dennis Taylor (346MB)
In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course.

Topics include:
Navigating across worksheets and workbooks
Displaying multiple worksheets or workbooks simultaneously
Inserting, deleting, moving, and copying sheets
Changing sheet names and tab colors
Showing and hiding worksheets
Creating linkage formulas among workbooks
Locating and managing links

From 2010.part1.rar 2010.part2.rar 2010.part3.rar 2010.part4.rar


Added 3% Recovery. All Links Are Interchangeable!

Default password :

Links are died? Don't worry, Click here!

Purchase an premium account through our links means that you have contributed to the maintenance of our server and keep Tutolearning alive and grown :

Additional Reading...

Previous post:

Next post: