Details for this torrent 

Lynda.com Excel 2010 Essential Training + 2 Extra Courses REUP
Type:
Other > Other
Files:
104
Size:
1.08 GiB (1163732621 Bytes)
Tag(s):
excel training
Uploaded:
2016-06-05 15:26:52 GMT
By:
stegguntbc
Seeders:
0
Leechers:
1
Comments
0  

Info Hash:
9B43E891FCFD219C37BEFF59ADB6598936221BA0




(Problems with magnets links are fixed by upgrading your torrent client!)
this is a re-up of this torrent, the last half of the videos were not fully loaded in the previous torrent (https://piratebayproxy.live/torrent/6234771/Lynda_com_Excel_2010_Essential_Training___2_Extra_Courses_-_Team)

so if you want, you can use the ones you have previously downloaded and just link them to this torrent.

enjoy


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.

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

Introduction
1. Getting Started
2. Worksheet Basics
3. Excel Formula Basics
4. Essential Formatting
5. Advanced Formatting
6. Printing Preparation
7. Large Excel Projects
8. Collaborating with Others
9. Exploring Excel�s Database Features
10. Analyzing Data
11. Advanced Analysis with PivotTables
12. Creating and Using Charts
13. Creating and Using Macros
14. Customizing Excel
Conclusion

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.

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

Introduction
1. Mastering the Utility Tasks Associated with Multiple Worksheets
2. Working with Multiple Worksheets
3. Linking Worksheets with Formulas
4. Working with Multiple Workbooks
5. Linking Formulas Across Multiple Workbooks
Conclusion

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.

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

1. Getting Started
Understanding what a macro does
Reviewing macro examples
Understanding security
Reviewing the recording method
Understanding other techniques for macros

2. Running a Macro (Execute, Play Back, Etc.)
Running macros from the View tab
Running macros from a keyboard shortcut
Running macros from the Quick Access toolbar button
Running macros from an object or clip art

3. Using Visual Basic for Applications (VBA)
Introducing the VBA environment
Viewing the VBA components
4. Recording a Macro in Stages
Recording a simple macro
Adding functionality to a macro

5. Creating Non-Recordable VBA Code
Understanding absolute and relative references
Using For and For�Next statements
Using Do�While and Do�Until statements
Creating interactive macros

6. Macro Project: Converting a Mailing List into a Database List
Planning a macro
Recording partial code
Using loop structures in context
Testing a macro in Step mode
Pulling the data together
Joining two macros
Streamlining macros

7. The Personal Macro Workbook
Creating a personal macro workbook for macros with wide applicability
Closing and updating the personal macro workbook

Excel 2010 Macros in Depth/lce2010m.cue74 B
Essential Training/15 Conclusion/1501 Goodbye.mov244.38 KiB
Essential Training/00 Introduction/0002 Using the exercise files.mov756.53 KiB
Managing Multiple Worksheets and Workbooks/00 Introduction/0002 Using the exercise files.mov1.36 MiB
Essential Training/12 Creating and Using Charts/1201 Choosing chart types.mov1.73 MiB
Essential Training/08 Collaborating with Others/0804 Sharing a workbook.mov1.76 MiB
Essential Training/03 Excel Formula Basics/0305 Adding a whole worksheet.mov1.86 MiB
Essential Training/10 Analyzing Data/1002 Using evaluation in Excel.mov2.24 MiB
Essential Training/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov2.28 MiB
Managing Multiple Worksheets and Workbooks/06 Conclusion/0601 Final thoughts.mov2.71 MiB
Essential Training/13 Creating and Using Macros/1301 Understanding macros.mov2.8 MiB
Essential Training/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov3 MiB
Essential Training/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov3.03 MiB
Essential Training/05 Advanced Formatting/0506 Creating and using original templates.mov3.06 MiB
Essential Training/01 Getting Started/0101 Exploring three common uses for Excel.mov3.27 MiB
Essential Training/03 Excel Formula Basics/0302 Entering data in a worksheet.mov3.33 MiB
Essential Training/03 Excel Formula Basics/0308 Working with times and dates.mov3.38 MiB
Managing Multiple Worksheets and Workbooks/Exercise Files/Exercise Files.rar3.54 MiB
Essential Training/08 Collaborating with Others/0805 Tracking changes.mov3.65 MiB
Essential Training/12 Creating and Using Charts/1203 Creating a column chart.mov3.66 MiB
Essential Training/02 Worksheet Basics/0205 Changing a worksheet's structure.mov3.68 MiB
Essential Training/01 Getting Started/0104 Using Backstage view or the File tab.mov3.92 MiB
Essential Training/07 Large Excel Projects/0701 Finding and replacing data.mov3.97 MiB
Essential Training/03 Excel Formula Basics/0311 Naming and using cell ranges.mov4.11 MiB
Essential Training/02 Worksheet Basics/0202 Techniques for copying and pasting.mov4.3 MiB
Essential Training/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov4.31 MiB
Essential Training/07 Large Excel Projects/0703 Repeating row and column titles.mov4.34 MiB
Essential Training/06 Printing Preparation/0602 Inserting headers and footers.mov4.43 MiB
Essential Training/12 Creating and Using Charts/1202 Inserting Sparklines.mov4.52 MiB
Essential Training/05 Advanced Formatting/0505 Using templates.mov4.56 MiB
Essential Training/03 Excel Formula Basics/0301 Understanding formulas and functions.mov4.63 MiB
Essential Training/05 Advanced Formatting/0503 Applying built-in styles.mov4.68 MiB
Essential Training/09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov4.69 MiB
Essential Training/05 Advanced Formatting/0502 Coordinating a look using themes.mov4.82 MiB
Essential Training/03 Excel Formula Basics/0309 Using IF.mov4.83 MiB
Essential Training/07 Large Excel Projects/0702 Freezing panes.mov4.86 MiB
Essential Training/03 Excel Formula Basics/0303 Adding numbers manually.mov4.86 MiB
Essential Training/01 Getting Started/0103 Finding the commands you need.mov5 MiB
Essential Training/03 Excel Formula Basics/0306 Working with numbers in columns.mov5.11 MiB
Essential Training/06 Printing Preparation/0603 Printing and PDFs.mov5.13 MiB
Essential Training/09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov5.18 MiB
Essential Training/02 Worksheet Basics/0201 Creating a worksheet.mov5.38 MiB
Essential Training/04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov5.38 MiB
Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0104 Changing tab colors and renaming sheets.mov5.39 MiB
Essential Training/04 Essential Formatting/0404 Using conditional formatting.mov5.5 MiB
Essential Training/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov5.55 MiB
Essential Training/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov5.59 MiB
Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0202 Copying, moving, and inserting data on different sheets.mov5.61 MiB
Essential Training/02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov5.76 MiB
Essential Training/10 Analyzing Data/1003 Working with Goal Seek.mov5.8 MiB
Essential Training/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov5.83 MiB
Essential Training/10 Analyzing Data/1005 Using scenarios in formulas.mov5.94 MiB
Essential Training/02 Worksheet Basics/0204 Targeting large data groups.mov6.07 MiB
Essential Training/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov6.07 MiB
Essential Training/06 Printing Preparation/0601 Making the pieces fit.mov6.11 MiB
Essential Training/10 Analyzing Data/1004 Using data tables in formulas.mov6.51 MiB
Essential Training/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov6.67 MiB
Essential Training/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov6.72 MiB
Essential Training/09 Exploring Excel's Database Features/0906 Creating lookup tables.mov6.78 MiB
Essential Training/12 Creating and Using Charts/1204 Modifying a column chart.mov6.84 MiB
Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0301 Creating linkage formulas.mov6.84 MiB
Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0401 Navigating between open workbooks.mov7 MiB
Essential Training/07 Large Excel Projects/0707 Calculating formulas across worksheets.mov7.06 MiB
Essential Training/10 Analyzing Data/1001 Using auditing to diagram.mov7.07 MiB
Essential Training/11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov7.14 MiB
Essential Training/01 Getting Started/0105 Maintaining file compatibility.mov7.16 MiB
Essential Training/01 Getting Started/0102 Touring the interface.mov7.18 MiB
Essential Training/13 Creating and Using Macros/1303 Editing a macro.mov7.21 MiB
Essential Training/00 Introduction/0001 Welcome.mov7.26 MiB
Essential Training/05 Advanced Formatting/0504 Creating and sharing styles.mov7.31 MiB
Essential Training/08 Collaborating with Others/0802 Setting workbook permissions.mov7.35 MiB
Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0203 Applying global changes to worksheets.mov7.37 MiB
Essential Training/07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov7.51 MiB
Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0103 Copying and moving sheets within a workbook.mov7.55 MiB
Essential Training/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov7.64 MiB
Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0501 Creating formulas that link worksheets in different workbooks.mov7.71 MiB
Essential Training/04 Essential Formatting/0405 Using custom conditional formatting.mov7.72 MiB
Essential Training/07 Large Excel Projects/0706 Managing worksheets.mov7.79 MiB
Essential Training/04 Essential Formatting/0401 Formatting numbers and dates.mov7.81 MiB
Essential Training/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov8.13 MiB
Essential Training/Exercise Files/Exercise Files.rar8.22 MiB
Essential Training/09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov8.32 MiB
Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov8.33 MiB
Essential Training/08 Collaborating with Others/0803 Inserting and editing comments.mov8.46 MiB
Essential Training/05 Advanced Formatting/0501 Inserting SmartArt.mov8.56 MiB
Essential Training/07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov8.78 MiB
Essential Training/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov8.96 MiB
Essential Training/14 Customizing Excel/1403 Setting Excel options.mov9.69 MiB
Essential Training/04 Essential Formatting/0406 Adding pictures and shapes.mov9.81 MiB
Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0402 Displaying multiple worksheets from different workbooks.mov9.97 MiB
Essential Training/08 Collaborating with Others/0801 Importing and exporting data in Excel.mov10.1 MiB
Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0302 Creating 3D formulas for worksheets with identical layouts.mov10.32 MiB
Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0502 Locating and managing links between multiple workbooks.mov11.02 MiB
Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov11.09 MiB
Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0403 Copying and moving data and entire worksheets across different workbooks.mov11.98 MiB
Essential Training/08 Collaborating with Others/0806 Saving files in shared locations.mov12.08 MiB
Managing Multiple Worksheets and Workbooks/00 Introduction/0001 Welcome.mov12.33 MiB
Essential Training/14 Customizing Excel/1402 Customizing the Ribbon bar.mov13.18 MiB
Essential Training/13 Creating and Using Macros/1302 Recording and using a simple macro.mov14.08 MiB
Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0201 Displaying multiple worksheets from the same workbook.mov17.55 MiB
Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0101 Learning basic navigation tips.mov18.34 MiB
Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov19.17 MiB
Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov19.51 MiB
Excel 2010 Macros in Depth/lce2010m.bin435.07 MiB