Lynda-Excel 2010 Essential Training

seeders: 0
leechers: 0
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.



Lynda-Excel 2010 Essential Training (Size: 470.76 MB)
 0001 Welcome.mov7.26 MB
 0002 Using the exercise files.mov756.53 KB
 0102 Touring the interface.mov7.18 MB
 0105 Maintaining file compatibility.mov7.16 MB
 0103 Finding the commands you need.mov5 MB
 0104 Using Backstage view or the File tab.mov3.92 MB
 0101 Exploring three common uses for Excel.mov3.27 MB
 0204 Targeting large data groups.mov6.07 MB
 0203 Entering data automatically with Auto Fill.mov5.76 MB
 0201 Creating a worksheet.mov5.38 MB
 0202 Techniques for copying and pasting.mov4.3 MB
 0205 Changing a worksheet's structure.mov3.68 MB
 0304 Adding numbers using Sum and AutoSum.mov6.72 MB
 0307 Preventing errors using absolute references.mov6.07 MB
 0310 Using SUMIF and AVERAGEIF.mov5.55 MB
 0306 Working with numbers in columns.mov5.11 MB
 0303 Adding numbers manually.mov4.86 MB
 0309 Using IF.mov4.83 MB
 0301 Understanding formulas and functions.mov4.63 MB
 0311 Naming and using cell ranges.mov4.11 MB
 0308 Working with times and dates.mov3.38 MB
 0302 Entering data in a worksheet.mov3.33 MB
 0305 Adding a whole worksheet.mov1.86 MB
 0406 Adding pictures and shapes.mov9.81 MB
 0401 Formatting numbers and dates.mov7.81 MB
 0405 Using custom conditional formatting.mov7.72 MB
 0403 Adjusting columns, rows, and text.mov5.59 MB
 0404 Using conditional formatting.mov5.5 MB
 0402 Applying fonts, background colors, and borders.mov5.38 MB
 0501 Inserting SmartArt.mov8.56 MB
 0504 Creating and sharing styles.mov7.31 MB
 0502 Coordinating a look using themes.mov4.82 MB
 0503 Applying built-in styles.mov4.68 MB
 0505 Using templates.mov4.56 MB
 0506 Creating and using original templates.mov3.06 MB
 0601 Making the pieces fit.mov6.11 MB
 0603 Printing and PDFs.mov5.13 MB
 0602 Inserting headers and footers.mov4.43 MB
 0704 Creating multiple custom worksheet views.mov8.78 MB
 0706 Managing worksheets.mov7.79 MB
 0705 Hiding or grouping rows and columns.mov7.51 MB
 0707 Calculating formulas across worksheets.mov7.06 MB
 0702 Freezing panes.mov4.86 MB
 0703 Repeating row and column titles.mov4.34 MB
 0701 Finding and replacing data.mov3.97 MB
 0806 Saving files in shared locations.mov12.08 MB
 0801 Importing and exporting data in Excel.mov10.1 MB
 0803 Inserting and editing comments.mov8.46 MB
 0802 Setting workbook permissions.mov7.35 MB
 0805 Tracking changes.mov3.65 MB
 0804 Sharing a workbook.mov1.76 MB
 0903 Basic and multi-field sorting.mov8.32 MB
 0906 Creating lookup tables.mov6.78 MB
 0904 Using tables to sort and filter data.mov6.67 MB
 0902 Joining data from multiple cells.mov5.18 MB
 0905 Inserting automatic subtotals.mov4.69 MB
 0901 Splitting cell data into multiple cells.mov3 MB
 1006 Exploring the Analysis Toolpak.mov8.96 MB
 1001 Using auditing to diagram.mov7.07 MB
 1004 Using data tables in formulas.mov6.51 MB
 1005 Using scenarios in formulas.mov5.94 MB
 1003 Working with Goal Seek.mov5.8 MB
 1002 Using evaluation in Excel.mov2.24 MB
 1103 Modifying a PivotTable.mov7.64 MB
 1104 Creating and modifying a PivotChart.mov7.14 MB
 1102 Creating a basic PivotTable.mov3.03 MB
 1101 Discovering PivotTables.mov2.28 MB
 1205 Creating and modifying a pie chart.mov8.13 MB
 1204 Modifying a column chart.mov6.84 MB
 1206 Placing Excel charts into other Office applications.mov5.83 MB
 1202 Inserting Sparklines.mov4.52 MB
 1203 Creating a column chart.mov3.66 MB
 1201 Choosing chart types.mov1.73 MB
 1302 Recording and using a simple macro.mov14.08 MB
 1303 Editing a macro.mov7.21 MB
 1301 Understanding macros.mov2.8 MB
 1402 Customizing the Ribbon bar.mov13.18 MB
 1403 Setting Excel options.mov9.69 MB
 1401 Customizing the Quick Access toolbar.mov4.31 MB
 1501 Goodbye.mov244.38 KB
 Comments.xlsx201.43 KB
 permissions.xlsx144 KB
 SHARING.xlsx138.76 KB
 protecting.xlsx138.75 KB
 import into this.xlsx136.31 KB
 export this.xlsx135.95 KB
 kalamata.jpg62.34 KB
 multi-pack 1.jpg31.38 KB
 saving shared locations.xlsx11.88 KB
 import data.txt2.11 KB
 import data.csv2.11 KB
 logo.jpg160.84 KB
 custom styles.xlsx137.97 KB
 styles.xlsx137.69 KB
 merge styles.xlsx137 KB
 smart art.xlsx135.87 KB
 turn into template.xlsx135.62 KB
 GARLIC.jpg50.95 KB
 Gift Pack.jpg31.38 KB
 Themes.xlsx25.47 KB
 Herbs.jpg19.33 KB
 editing macro.xlsm156.54 KB
 west data.xlsx135.21 KB
 overseas data.xlsx135.07 KB
 recording macro.xlsx134.74 KB
 northeast data.xlsx134.73 KB
 southeast data.xlsx134.72 KB
 pivot table.xlsx155.76 KB
 pivot chart.xlsx147.5 KB
 modifying a pivottable.xlsx140.87 KB
 create pivot table.xlsx136.04 KB
 freezing panes.xlsx153.39 KB
 3D formulas.xlsx151.87 KB
 views.xlsx140.17 KB
 grouping.xlsx137.57 KB
 repeating rows.xlsx137.26 KB
 find and replace.xlsx137.24 KB
 managing worksheets.xlsx136.53 KB
 backstage view.xlsx151.49 KB
 ribbon bar.xlsx151.46 KB
 current format.xlsx146.3 KB
 what is excel for.xlsx143.51 KB
 touring the interface.xlsx136.93 KB
 older format workbook.xls34.5 KB
 tables.xlsx139.67 KB
 subtotals.xlsx139.44 KB
 sorting.xlsx139.02 KB
 merging.xlsx139.02 KB
 Splitting.xlsx138.79 KB
 lookups.xlsx135.1 KB
 data tables.xlsx138.97 KB
 analysis toolpack.xlsx138.12 KB
 auditing.xlsx138 KB
 goal seek.xlsx135.09 KB
 Scenarios.xlsx133.17 KB
 evaluate.xlsx22.08 KB
 setting options.xlsx138.28 KB
 customizing ribbon.xlsx138.28 KB
 customizing QAT.xlsx138.28 KB
 Bob's Customizations.exportedui1.06 KB
 SUMIF.xlsx137.79 KB
 if.xlsx135.75 KB
 creating range names.xlsx20.64 KB
 sum.xlsx12.62 KB
 whole worksheet.xlsx12.6 KB
 AVERAGE.xlsx12.6 KB
 dates.xlsx11.43 KB
 Manual.xlsx11.25 KB
 absolute refs.xlsx11.15 KB
 Expense Report.xlsx9.39 KB
 formulas and functions.xlsx9.33 KB
 placing chart.xlsx137 KB
 modifying a chart.xlsx136.59 KB
 sparklines.xlsx136.5 KB
 column chart.xlsx134.82 KB
 Pie chart.xlsx134.82 KB
 insert pie chart.pptx75.16 KB
 insert pie chart.docx43.22 KB
 Rows and Columns.xlsx136.93 KB
 Selections.xlsx11.55 KB
 autofill.xlsx9.19 KB
 Clipboard.xlsx8.77 KB
 custom conditional formatting.xlsx136.56 KB
 conditional formatting.xlsx136.5 KB
 pictures - finished.xlsx73.98 KB
 bottle.jpg48.46 KB
 Pictures.xlsx14.51 KB
 adjusting.xlsx12.13 KB
 Fonts.xlsx11.76 KB
 formatting numbers.xlsx11.62 KB
 create PDFs.xlsx89.16 KB
 headers and footers.xlsx67.83 KB
 page size.xlsx67.65 KB
 logo.jpg24.15 KB

Description

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

Software:
Excel
Author:
Bob Flisser

Source Page


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
470.76 MB
seeders:0
leechers:0
Lynda-Excel 2010 Essential Training