.:: Jasa Membuat Aplikasi Website,Desktop,Android Order Now..!! | | Order Now..!! Jasa Membuat Project Arduino,Robotic,Print 3D ::.

Excel 2010 Tutorials and Training videos from Lynda.com

0 komentar


بِسْــــــــــــــــمِ اﷲِالرَّحْمَنِ اارَّحِيم
bismillaahirrahmaanirrahiim

السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Assalamu'alaikum warahmatullahi wabarakatuh







Known Trackers
#
Announce URL
Peers
Last Seen
1
http://announce.torrentsmd.com:6969/announce
128 / 37
1 hour
2
http://bt.linuxoid.in:4433/announce
0 / 2
1 hour
3
http://bt.n-torrents.ru/announce
0 / 0
18 hours
4
http://cpleft.com:2710/announce
2 / 1
26 minutes
5
http://cthulhu.regne.net:6969/announce
1 / 0
2 days
6
http://genesis.1337x.org:1337/announce
3 / 1
5 hours
7
http://linuxoid.in:4433/announce
0 / 2
8 hours
8
http://media-torrent.net:2710/announce
0 / 0
long ago
9
http://nemesis.1337x.org/announce
156 / 33
11 hours
10
http://papaja.v2v.cc:6970/announce
1 / 2
12 hours
11
http://php.hdcmct.com:2710/announce
2 / 1
4 hours
12
http://tl03.chip.de/announce
0 / 1
2 hours
13
http://tl04.chip.de/announce
1 / 0
2 days
14
http://tracker.ccc.de/announce
0 / 0
long ago
15
http://tracker.concen.cc/announce
2 / 0
8 hours
16
http://tracker.hdbbt.com:6969/announce
0 / 0
long ago
17
http://tracker.istole.it/announce
14 / 2
12 hours
18
http://tracker.kamyu.net/announce
0 / 0
long ago
19
http://tracker.publicbt.com/announce
91 / 17
3 hours
20
http://tracker.torrent.to:2710/announce
13 / 2
4 hours
21
http://tracker.torrentbay.to:6969/announce
172 / 42
8 hours
22
http://tracker.umunu.com:1984/announce
2 / 0
7 hours
23
http://tracker.zokio.net/announce
0 / 1
yesterday
24
http://tracker.zokio.net:8080/announce
1 / 0
2 days
25
udp://tracker.openbittorrent.com:80/announce
92 / 19
13 hours






Torrent Contents
 excel 2010 training videos
 1.4.Lynda.com.Excel.2010.Power.Shortcuts
 00 Introduction
 0001 Welcome.mov
18 MB
 0002 Using the exercise files.mov
339 KB
 01 Top Ten Shortcuts
 0110 Zooming in and out quickly.mov
6 MB
 0105 Instantly displaying all worksheet formulas.mov
4 MB
 0109 Undo Redo Repeat.mov
4 MB
 0103 Copying data or formulas down a column instantly.mov
3 MB
 0102 Converting formulas to values with a simple drag.mov
3 MB
 0104 Adjusting all or selected column widths or row heights in a.mov
3 MB
 0101 Entering data or formulas in non-adjacent cells simultaneou.mov
2 MB
 0107 Print Preview.mov
1 MB
 0106 Two quick shortcuts for creating charts.mov
1 MB
 0108 Instant date or time entry.mov
1 MB
 02 Ribbon and Quick Access Toolbar Tips
 0203 Quick Access toolbar display tips.mov
7 MB
 0201 Expanding and collapsing the Ribbon and Full Screen view.mov
2 MB
 0202 Keyboard command access.mov
2 MB
 03 Display Shortcuts
 0301 Split screens and frozen titles in a flash.mov
12 MB
 0302 Repeating title creation and suppression.mov
9 MB
 0303 Customizing your display of Status Bar totals.mov
2 MB
 04 Navigation Shortcuts
 0403 Navigating within worksheets.mov
7 MB
 0402 Tips for navigating between workbooks.mov
6 MB
 0401 Navigation shortcuts.mov
3 MB
 05 Selection Shortcuts
 0502 Selecting noncontiguous ranges and visible cells only.mov
6 MB
 0503 Selecting the current region and moving around region corne.mov
6 MB
 0501 Selecting an entire row column or worksheet.mov
5 MB
 06 Data Entry and Editing Shortcuts
 0604 Custom lists for rapid entry.mov
11 MB
 0601 Accelerating data entry.mov
7 MB
 0602 Auto-Fill techniques for entering dates.mov
6 MB
 0605 Cell editing tips.mov
3 MB
 0603 Auto-Fill techniques for entering times.mov
2 MB
 07 Drag-and-Drop Techniques
 0703 Dragging and inserting variations.mov
4 MB
 0704 Instantly displaying Paste Special options.mov
4 MB
 0701 Copy Move acceleration tips.mov
4 MB
 0702 Worksheet Copy Move shortcuts.mov
3 MB
 08 Formula Shortcuts
 0802 Selecting all cells that depend on the active cell.mov
6 MB
 0805 Rounding shortcuts.mov
5 MB
 0801 Rapid formula creation.mov
4 MB
 0807 Counting unique entries.mov
4 MB
 0806 Generating random numbers.mov
3 MB
 0808 Performing calculations without formulas.mov
3 MB
 0803 Selecting all cells that can affect the active cell.mov
3 MB
 0804 AutoSum shortcuts.mov
3 MB
 09 Operational Shortcuts
 0901 Controlling rows and columns.mov
11 MB
 0903 Handling blank cells.mov
7 MB
 0904 Collapsing and expanding detail.mov
5 MB
 0902 Realigning imported text.mov
2 MB
 10 Formatting Shortcuts
 1001 Formatting numbers.mov
10 MB
 1005 Creating custom formats.mov
8 MB
 1003 Adding background color for readability.mov
8 MB
 1002 Aligning data.mov
5 MB
 1007 Applying strikethroughs and borders.mov
4 MB
 1006 Formatting periods over 24 hours.mov
3 MB
 1004 Formatting data conditionally.mov
2 MB
 11 Database Techniques
 1102 Cleaning up spaces.mov
8 MB
 1103 Identifying duplicates.mov
6 MB
 1104 Splitting columns.mov
5 MB
 1106 Forcing dates to be weekdays only.mov
4 MB
 1101 Sorting shortcuts.mov
3 MB
 1105 Ensuring unique entries.mov
2 MB
 1107 Displaying unique items from large lists.mov
1 MB
 12 Charting and Visual Object Tips
 1204 Linking and unlinking pictures.mov
12 MB
 1203 Creating and manipulating shapes.mov
6 MB
 1201 Placing and adjusting charts.mov
3 MB
 1202 Creating chart titles from cell content.mov
2 MB
 13 Conclusion
 1301 Goodbye.mov
131 KB
 Exercise Files
 Chapter04.xlsx
597 KB
 Chapter11.xlsx
282 KB
 Chapter10.xlsx
227 KB
 Chapter01.xlsx
158 KB
 Chapter06.xlsx
118 KB
 Chapter07.xlsx
116 KB
 Chapter09.xlsx
115 KB
 Chapter03.xlsx
114 KB
 Chapter12.xlsx
112 KB
 Chapter08.xlsx
106 KB
 Chapter02.xlsx
105 KB
 Chapter05.xlsx
105 KB
 Chapter04A.xlsx
26 KB
 jgtiso.nfo
7 KB
 Lynda.com - Migrating from Excel 2003 to Excel 2010
 00 Introduction
 0001 Welcome.mov
8 MB
 0002 Using the exercise files.mov
764 KB
 01 Getting Started
 0103 Controlling Excel 2010 with keyboard shortcuts.mov
6 MB
 0104 Understanding the new file formats.mov
5 MB
 0102 Exploring the new Ribbon and Backstage view.mov
5 MB
 0101 Understanding the reasons to switch.mov
3 MB
 02 Using Excel 2003 and Excel 2010 in a Mixed Environment
 0203 Changing the default file format in Excel 2010.mov
4 MB
 0201 Saving Excel 2010 spreadsheets to Excel 2003.mov
3 MB
 0204 Managing Excel 2003 files in Compatibility Mode.mov
3 MB
 0205 Working with Excel 2010 files in older versions of Excel us.mov
3 MB
 0202 Converting older spreadsheets to Excel 2010.mov
3 MB
 0206 Best practices for managing files in a mixed environment.mov
1 MB
 03 Performing Common Excel 2003 Tasks in Excel 2010
 0305 Customizing the Ribbon and the Quick Access toolbar.mov
8 MB
 0306 Creating macro-enabled workbooks and templates.mov
7 MB
 0302 Using Excel tables to manage lists of data.mov
6 MB
 0304 Using conditional formatting.mov
5 MB
 0303 Formatting a workbook.mov
4 MB
 0301 Working with formulas and functions.mov
3 MB
 04 Conclusion
 0401 Goodbye.mov
324 KB
 Exercise Files
 Chap01
 01_02
 TT Billing Statement1.xls
66 KB
 TT Billing Statement1.xlsx
36 KB
 01_03
 TT Billing Statement2.xls
66 KB
 TT Billing Statement2.xlsx
36 KB
 01_04
 TT Billing Statement3.xls
66 KB
 Chap02
 02_01
 Expense Report.xlsx
56 KB
 02_02
 ExpenseBudget.xls
55 KB
 02_03
 ExpenseBudget.xlsx
20 KB
 02_04
 ExpenseBudget.xls
41 KB
 02_05
 ExpenseBudget.xlsx
20 KB
 Chap03
 03_01
 TTExpenses.xls
55 KB
 03_02
 RevTable.xls
26 KB
 03_03
 Sales Report1.xls
63 KB
 Sales Report1.xlsx
30 KB
 03_04
 TTExpenses.xls
48 KB
 TTExpenses.xlsx
24 KB
 03_05
 TTExpenses.xls
48 KB
 TTExpenses.xlsx
25 KB
 03_06
 TTExpenses.xls
48 KB
 TTExpenses.xlsm
29 KB
 TTExpenses.xlsx
24 KB
 Lynda.com Excel 2010 Working with Dates and Times
 00 Introduction
 0001 Welcome.mov
9 MB
 0002 Using the exercise files.mov
362 KB
 01 Excel's Date Time Entries
 0101 Understanding how Excel records and stores dates.mov
4 MB
 0102 Understanding how Excel records and stores times.mov
1 MB
 02 Creating Date Time Entries
 0204 Using Auto Fill to enter date and time series.mov
6 MB
 0203 Using TODAY and NOW functions for dynamic date time entry.mov
3 MB
 0201 Looking at standard date time entry options and acceptable alternatives.mov
3 MB
 0202 Using instant date time entry.mov
1 MB
 03 Date Time Formatting
 0303 Creating custom date formatting.mov
2 MB
 0302 Formatting time for hours over 24.mov
2 MB
 0301 Exploring keystroke shortcuts.mov
2 MB
 04 Excel's Date Time Functions
 0401 EOMONTH and EDATE Setting ends of months and future past dates.mov
4 MB
 0402 DATEDIF Calculating date differences by year, month, day, and more.mov
4 MB
 0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov
3 MB
 0404 NETWORKDAYS Calculating working days.mov
2 MB
 0405 WORKDAY Calculating an ending date.mov
1 MB
 0403 WEEKDAY Determining the day of the week.mov
1 MB
 05 Calculating with Dates and Times
 0503 Calculating fiscal years and quarters.mov
6 MB
 0502 Calculating time differences within and across days.mov
5 MB
 0504 Rounding time calculations to convenient intervals.mov
5 MB
 0505 Using times with currency calculations.mov
2 MB
 0501 Calculating date differences across days, months, and years.mov
2 MB
 0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov
1 MB
 06 Using Dates and Times with Excel Commands
 0602 Using date controls in data validation rules.mov
6 MB
 0601 Using special date filters with date data.mov
4 MB
 0604 Converting unusually formatted dates into usable data (text to columns).mov
4 MB
 0603 Using date functions in data validation rules.mov
3 MB
 07 Conclusion
 0701 Goodbye.mov
269 KB
 Exercise Files
 Chapter01
 02_BusinessData.xlsx
132 KB
 01_BusinessData.xlsx
132 KB
 Chapter02
 04_BusinessData.xlsx
134 KB
 01_BusinessData.xlsx
132 KB
 02_BusinessData.xlsx
132 KB
 03_BusinessData.xlsx
132 KB
 Chapter03
 02_BusinessData.xlsx
137 KB
 03_BusinessData.xlsx
137 KB
 01_BusinessData.xlsx
132 KB
 Chapter04
 06_BusinessData.xlsx
157 KB
 01_BusinessData.xlsx
136 KB
 03_BusinessData.xlsx
135 KB
 02_BusinessData.xlsx
133 KB
 04_BusinessData.xlsx
133 KB
 05_BusinessData.xlsx
133 KB
 Chapter05
 05_BusinessData.xlsx
157 KB
 06_BusinessData.xlsx
156 KB
 04_BusinessData.xlsx
156 KB
 03_BusinessData.xlsx
151 KB
 01_BusinessData.xlsx
151 KB
 02_BusinessData.xlsx
144 KB
 Chapter06
 02_BusinessData.xlsx
147 KB
 03_BusinessData.xlsx
146 KB
 04_BusinessData.xlsx
145 KB
 01_BusinessData.xlsx
144 KB
 quasar.nfo
3 KB
 Lynda.com.Excel.2010.Essential.Training-QUASAR
 00 Introduction
 0001 Welcome.mov
7 MB
 0002 Using the exercise files.mov
756 KB
 01 Getting Started
 0102 Touring the interface.mov
7 MB
 0105 Maintaining file compatibility.mov
7 MB
 0103 Finding the commands you need.mov
4 MB
 0104 Using Backstage view or the File tab.mov
3 MB
 0101 Exploring three common uses for Excel.mov
3 MB
 02 Worksheet Basics
 0204 Targeting large data groups.mov
6 MB
 0203 Entering data automatically with Auto Fill.mov
5 MB
 0201 Creating a worksheet.mov
5 MB
 0202 Techniques for copying and pasting.mov
4 MB
 0205 Changing a worksheet's structure.mov
3 MB
 03 Excel Formula Basics
 0304 Adding numbers using Sum and AutoSum.mov
6 MB
 0307 Preventing errors using absolute references.mov
6 MB
 0310 Using SUMIF and AVERAGEIF.mov
5 MB
 0306 Working with numbers in columns.mov
5 MB
 0303 Adding numbers manually.mov
4 MB
 0309 Using IF.mov
4 MB
 0301 Understanding formulas and functions.mov
4 MB
 0311 Naming and using cell ranges.mov
4 MB
 0308 Working with times and dates.mov
3 MB
 0302 Entering data in a worksheet.mov
3 MB
 0305 Adding a whole worksheet.mov
1 MB
 04 Essential Formatting
 0406 Adding pictures and shapes.mov
9 MB
 0401 Formatting numbers and dates.mov
7 MB
 0405 Using custom conditional formatting.mov
7 MB
 0403 Adjusting columns, rows, and text.mov
5 MB
 0404 Using conditional formatting.mov
5 MB
 0402 Applying fonts, background colors, and borders.mov
5 MB
 05 Advanced Formatting
 0501 Inserting SmartArt.mov
8 MB
 0504 Creating and sharing styles.mov
7 MB
 0502 Coordinating a look using themes.mov
4 MB
 0503 Applying built-in styles.mov
4 MB
 0505 Using templates.mov
4 MB
 0506 Creating and using original templates.mov
3 MB
 06 Printing Preparation
 0601 Making the pieces fit.mov
6 MB
 0603 Printing and PDFs.mov
5 MB
 0602 Inserting headers and footers.mov
4 MB
 07 Large Excel Projects
 0704 Creating multiple custom worksheet views.mov
8 MB
 0706 Managing worksheets.mov
7 MB
 0705 Hiding or grouping rows and columns.mov
7 MB
 0707 Calculating formulas across worksheets.mov
7 MB
 0702 Freezing panes.mov
4 MB
 0703 Repeating row and column titles.mov
4 MB
 0701 Finding and replacing data.mov
3 MB
 08 Collaborating with Others
 0806 Saving files in shared locations.mov
12 MB
 0801 Importing and exporting data in Excel.mov
10 MB
 0803 Inserting and editing comments.mov
8 MB
 0802 Setting workbook permissions.mov
7 MB
 0805 Tracking changes.mov
3 MB
 0804 Sharing a workbook.mov
1 MB
 09 Exploring Excel's Database Features
 0903 Basic and multi-field sorting.mov
8 MB
 0906 Creating lookup tables.mov
6 MB
 0904 Using tables to sort and filter data.mov
6 MB
 0902 Joining data from multiple cells.mov
5 MB
 0905 Inserting automatic subtotals.mov
4 MB
 0901 Splitting cell data into multiple cells.mov
3 MB
 10 Analyzing Data
 1006 Exploring the Analysis Toolpak.mov
8 MB
 1001 Using auditing to diagram.mov
7 MB
 1004 Using data tables in formulas.mov
6 MB
 1005 Using scenarios in formulas.mov
5 MB
 1003 Working with Goal Seek.mov
5 MB
 1002 Using evaluation in Excel.mov
2 MB
 11 Advanced Analysis with PivotTables
 1103 Modifying a PivotTable.mov
7 MB
 1104 Creating and modifying a PivotChart.mov
7 MB
 1102 Creating a basic PivotTable.mov
3 MB
 1101 Discovering PivotTables.mov
2 MB
 12 Creating and Using Charts
 1205 Creating and modifying a pie chart.mov
8 MB
 1204 Modifying a column chart.mov
6 MB
 1206 Placing Excel charts into other Office applications.mov
5 MB
 1202 Inserting Sparklines.mov
4 MB
 1203 Creating a column chart.mov
3 MB
 1201 Choosing chart types.mov
1 MB
 13 Creating and Using Macros
 1302 Recording and using a simple macro.mov
14 MB
 1303 Editing a macro.mov
7 MB
 1301 Understanding macros.mov
2 MB
 14 Customizing Excel
 1402 Customizing the Ribbon bar.mov
13 MB
 1403 Setting Excel options.mov
9 MB
 1401 Customizing the Quick Access toolbar.mov
4 MB
 15 Conclusion
 1501 Goodbye.mov
244 KB
 Exercise Files
 chapt 1
 backstage view.xlsx
151 KB
 ribbon bar.xlsx
151 KB
 current format.xlsx
146 KB
 what is excel for.xlsx
143 KB
 touring the interface.xlsx
136 KB
 older format workbook.xls
34 KB
 chapt 10
 data tables.xlsx
138 KB
 analysis toolpack.xlsx
138 KB
 auditing.xlsx
138 KB
 goal seek.xlsx
135 KB
 scenarios.xlsx
133 KB
 evaluate.xlsx
22 KB
 chapt 11
 pivot table.xlsx
155 KB
 pivot chart.xlsx
147 KB
 modifying a pivottable.xlsx
140 KB
 create pivot table.xlsx
136 KB
 chapt 12
 placing chart.xlsx
136 KB
 modifying a chart.xlsx
136 KB
 sparklines.xlsx
136 KB
 column chart.xlsx
134 KB
 pie chart.xlsx
134 KB
 insert pie chart.pptx
75 KB
 insert pie chart.docx
43 KB
 chapt 13
 editing macro.xlsm
156 KB
 west data.xlsx
135 KB
 overseas data.xlsx
135 KB
 recording macro.xlsx
134 KB
 northeast data.xlsx
134 KB
 southeast data.xlsx
134 KB
 chapt 14
 setting options.xlsx
138 KB
 customizing ribbon.xlsx
138 KB
 customizing QAT.xlsx
138 KB
 Bob's Customizations.exportedUI
1 KB
 chapt 2
 rows and columns.xlsx
136 KB
 selections.xlsx
11 KB
 autofill.xlsx
9 KB
 clipboard.xlsx
8 KB
 chapt 3
 sumif.xlsx
137 KB
 if.xlsx
135 KB
 creating range names.xlsx
20 KB
 sum.xlsx
12 KB
 whole worksheet.xlsx
12 KB
 average.xlsx
12 KB
 dates.xlsx
11 KB
 manual.xlsx
11 KB
 absolute refs.xlsx
11 KB
 expense report.xlsx
9 KB
 formulas and functions.xlsx
9 KB
 chapt 4
 custom conditional formatting.xlsx
136 KB
 conditional formatting.xlsx
136 KB
 pictures - finished.xlsx
73 KB
 bottle.jpg
48 KB
 pictures.xlsx
14 KB
 adjusting.xlsx
12 KB
 fonts.xlsx
11 KB
 formatting numbers.xlsx
11 KB
 chapt 5
 logo.jpg
160 KB
 custom styles.xlsx
137 KB
 styles.xlsx
137 KB
 merge styles.xlsx
137 KB
 smart art.xlsx
135 KB
 turn into template.xlsx
135 KB
 garlic.jpg
50 KB
 gift pack.jpg
31 KB
 themes.xlsx
25 KB
 herbs.jpg
19 KB
 chapt 6
 create PDFs.xlsx
89 KB
 headers and footers.xlsx
67 KB
 page size.xlsx
67 KB
 logo.jpg
24 KB
 chapt 7
 freezing panes.xlsx
153 KB
 3D formulas.xlsx
151 KB
 views.xlsx
140 KB
 grouping.xlsx
137 KB
 repeating rows.xlsx
137 KB
 find and replace.xlsx
137 KB
 managing worksheets.xlsx
136 KB
 chapt 8
 comments.xlsx
201 KB
 permissions.xlsx
144 KB
 sharing.xlsx
138 KB
 protecting.xlsx
138 KB
 import into this.xlsx
136 KB
 export this.xlsx
135 KB
 kalamata.jpg
62 KB
 multi-pack 1.jpg
31 KB
 saving shared locations.xlsx
11 KB
 import data.csv
2 KB
 import data.txt
2 KB
 chapt 9
 tables.xlsx
139 KB
 subtotals.xlsx
139 KB
 sorting.xlsx
139 KB
 merging.xlsx
139 KB
 splitting.xlsx
138 KB
 lookups.xlsx
135 KB
 quasar.nfo
3 KB
 Lynda.com.Excel.2010.New.Features-QUASAR
 00 Introduction
 0001 Welcome.mov
7 MB
 0002 Using the exercise files.mov
574 KB
 01 File Tab, AKA Backstage View
 0101 Customizing the Ribbon bar.mov
10 MB
 0103 Maintaining compatibility.mov
7 MB
 0107 Preparing to share a document.mov
6 MB
 0104 Making templates easier.mov
6 MB
 0105 Handling document versions.mov
5 MB
 0106 Changing the file type and converting to Adobe PDF.mov
4 MB
 0108 Making printing easier.mov
4 MB
 0102 Looking at Backstage view.mov
3 MB
 02 Collaboration Tools
 0203 Sharing a document on the free Microsoft SkyDrive web site.mov
10 MB
 0204 Sharing a document through a Microsoft SharePoint portal.mov
6 MB
 0202 Sharing a document by email.mov
4 MB
 0201 Setting document permissions.mov
3 MB
 03 Data Tools
 0301 Using enhanced smart tags and the Paste preview.mov
3 MB
 0302 Filtering a table by searching.mov
3 MB
 04 Graphic Features
 0403 Formatting math equations with the improved equation tools.mov
6 MB
 0401 Inserting Sparklines.mov
6 MB
 0404 Editing pictures with the improved picture tools.mov
5 MB
 0402 Applying the enhanced conditional formatting features.mov
2 MB
 05 Pivot Tables
 0502 Analyzing data from multiple sources using the PowerPivot plug-in.mov
14 MB
 0501 Using the Slicer to make PivotTables more interactive.mov
2 MB
 06 Going Beyond the Desktop
 0601 Editing a worksheet in the Excel Web App.mov
10 MB
 07 Conclusion
 0701 Goodbye.mov
199 KB
 Exercise Files
 chapt 1
 01_06_converting.xlsx
396 KB
 01_05_properties.xlsx
396 KB
 03 older format workbook.xls
260 KB
 01_03_current format.xlsx
161 KB
 01_02_backstage.xlsx
151 KB
 01_08_printing.xlsx
151 KB
 01_04_turn into template.xlsx
150 KB
 01_07_preparing.xlsx
146 KB
 chapt 2
 02_02_sharing.xlsx
150 KB
 02_01_permissions.xlsx
150 KB
 02_04_sharepoint.xlsx
11 KB
 02_03_sky drive.xlsx
11 KB
 chapt 3
 03_01_smart tags.xlsx
150 KB
 03_02_filter.xlsx
135 KB
 chapt 4
 04_03_equations.xlsx
153 KB
 04_02_conditional formatting.xlsx
151 KB
 04_01_sparklines.xlsx
151 KB
 04_04_olive_tree_valley.jpg
47 KB
 04_04_bottles.jpg
31 KB
 chapt 5
 Finished
 05_02_powerpivot analysis.xlsx
276 KB
 05_02_product codes.accdb
412 KB
 05_01_slicer.xlsx
140 KB
 05_02_powerpivot sales volume.xlsx
12 KB
 05_02_powerpivot sales reps.xlsx
12 KB
 chapt 6
 06_01_web app.xlsx
12 KB
 quasar.nfo
3 KB
 Lynda.com.Excel.VBA.in.Depth-QUASAR
 00 Introduction
 0001 Welcome.mov
4 MB
 0002 Using the exercise files.mov
279 KB
 01 Introducing Visual Basic for Applications
 0105 Creating, exporting, and deleting code modules.mov
6 MB
 0106 Creating a subroutine or function.mov
5 MB
 0103 Working in the Visual Basic editor.mov
4 MB
 0109 Running a VBA routine.mov
4 MB
 0102 Examining the Excel object model.mov
3 MB
 0108 Adding comments to the code.mov
3 MB
 0107 Controlling procedure scope and visibility.mov
3 MB
 0110 Adding code to a recorded macro.mov
3 MB
 0104 Setting VBA project properties.mov
2 MB
 0101 Introducing object-oriented programming.mov
1 MB
 02 Defining Variables, Constants, and Calculations
 0206 Defining arrays.mov
7 MB
 0201 Introducing Excel VBA data types.mov
6 MB
 0204 Defining static variables and constants.mov
5 MB
 0202 Declaring variables and requiring declaration before use.mov
4 MB
 0203 Managing variable scope.mov
3 MB
 0208 Streamlining code references using With End With statements.mov
3 MB
 0205 Creating a calculation using mathematical operators.mov
3 MB
 0207 Defining and using object variables.mov
2 MB
 03 Adding Logic to Your VBA Code
 0304 Performing a task when conditions are met using If Then.mov
7 MB
 0303 Repeating a task with a Do loop.mov
5 MB
 0302 Stepping through all items of a collection using a For Each loop.mov
3 MB
 0301 Repeating a task using a For Next loop.mov
2 MB
 0305 Selecting which action to take using a Case statement.mov
1 MB
 04 Debugging You VBA Code
 0402 Stepping through a subroutine or function.mov
5 MB
 0401 Managing errors using On Error statements.mov
4 MB
 0404 Verifying output using the Immediate window.mov
3 MB
 0405 Watching a value in a routine.mov
2 MB
 0403 Setting breakpoints in the code.mov
2 MB
 05 Managing Workbook Elements and Data in VBA
 0507 Managing worksheets with VBA.mov
5 MB
 0502 Cutting, copying, and pasting cell data.mov
5 MB
 0503 Finding values in cells.mov
4 MB
 0505 Concatenating text strings.mov
4 MB
 0508 Managing workbooks with VBA.mov
3 MB
 0501 Writing a value to a cell.mov
3 MB
 0504 Referring to cells using the Offset function.mov
2 MB
 0506 Returning part of a string.mov
2 MB
 06 Adding Advanced Elements to Your Workbook
 0603 Acquiring values using an input box or message box.mov
5 MB
 0601 Turning off screen updating within a macro.mov
2 MB
 0602 Using worksheet functions in a macro.mov
2 MB
 0604 Calling a subroutine from another subroutine.mov
2 MB
 07 Using Excel Events in Your VBA Code
 0702 Running a procedure when a cell range changes.mov
4 MB
 0701 Running a procedure when you open, close, or save a workbook.mov
4 MB
 0703 Triggering a procedure using a specific key sequence.mov
3 MB
 08 Putting it All Together
 0801 Applying techniques in a Capstone project.mov
6 MB
 09 Conclusion
 0901 Goodbye.mov
250 KB
 Exercise Files
 Ch01
 Scope.xlsm
41 KB
 Comments.xlsm
39 KB
 RunAMacro.xlsm
39 KB
 Commission.xlsm
37 KB
 Scope.xlsx
37 KB
 RecordFirst.xlsm
17 KB
 ProjectProperties.xlsm
15 KB
 VBEditor.xlsm
13 KB
 ModulesManaged.xlsm
9 KB
 VBEditor.xlsx
9 KB
 Ch02
 Operators.xlsm
40 KB
 ConstantStatic.xlsm
39 KB
 DimVariables.xlsm
39 KB
 VariableScope.xlsm
37 KB
 MonthlySales.xlsm
18 KB
 ShippingCharges.xlsm
18 KB
 Types.xlsm
15 KB
 WithExample.xlsm
8 KB
 Ch03
 Suggestions.xlsm
40 KB
 IfThen.xlsm
39 KB
 Case.xlsm
38 KB
 ForEach.xlsm
18 KB
 ForNext.xlsm
17 KB
 Ch04
 Stepping.xlsm
42 KB
 Immediate.xlsm
42 KB
 Breaking.xlsm
41 KB
 Watch.xlsm
16 KB
 CheckError.xlsm
13 KB
 Ch05
 Writing.xlsm
39 KB
 Offset.xlsm
39 KB
 Worksheets.xlsm
38 KB
 CutPaste.xlsm
17 KB
 Concatenate.xlsm
15 KB
 Find.xlsm
13 KB
 CutStrings.xlsm
12 KB
 Workbooks.xlsm
12 KB
 Ch06
 Flashing.xlsm
41 KB
 Boxes.xlsm
40 KB
 Calling.xlsm
40 KB
 WorksheetFunctions.xlsm
38 KB
 Ch07
 .TEMP_com.apple.iWork.Numbers_1443_296003542_1
 image1.tiff
1 MB
 ManipulateWorkbook.xlsm
41 KB
 OnKey.xlsm
39 KB
 ChangeRange.xlsm
39 KB
 Ch08
 Capstone.xlsm
45 KB
 quasar.nfo
3 KB
 Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO
 00.01.Introduction
 60273_00_01_MM01_welcome.mov
2 MB
 60273_00_02_SC11_exerfiles.mov
516 KB
 00.02.Microsoft Excel
 60273_01_05_SC11_pasting.mov
5 MB
 60273_01_04_SC11_visual.mov
5 MB
 60273_01_03_SC11_pivot.mov
5 MB
 60273_01_02_SC11_custom.mov
5 MB
 60273_01_01_SC11_sparklines.mo.mov
4 MB
 00.03.Conclusion
 60273_02_01_SC11_goodbye.mov
193 KB
 00.04.Exercise Files
 AllData.xlsx
1 MB
 Hydrangeas.jpg
581 KB
 GreenhouseTiming.xlsx
63 KB
 SalesPerformance.xlsx
20 KB
 Customizing.xlsm
19 KB
 Hydrangea.xlsx
8 KB
 NewProductReports.xlsx
8 KB
 ironiso.nfo
6 KB
 i.nfo
1 KB


Update Contact :
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email : Fajarudinsidik@gmail.com
NB :: Bila Sobat tertarik Ingin membuat software, membeli software, membeli source code, membeli hardware elektronika untuk kepentingan Perusahaan maupun Tugas Akhir (TA/SKRIPSI), Insyaallah Saya siap membantu, untuk Respon Cepat dapat menghubungi kami, melalui :

No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email: Fajarudinsidik@gmail.com


atau Kirimkan Private messanger melalui email dengan klik tombol order dibawah ini :

ٱلْحَمْدُ لِلَّهِ رَبِّ ٱلْعَٰلَمِين
Alhamdulilah hirobil alamin

وَ السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
wassalamualaikum warahmatullahi wabarakatuh


Artikel Excel 2010 Tutorials and Training videos from Lynda.com, Diterbitkan oleh scodeaplikasi pada Jumat, 24 Juni 2011. Semoga artikel ini dapat menambah wawasan Anda. Website ini dipost dari beberapa sumber, bisa cek disini sumber, Sobat diperbolehkan mengcopy paste / menyebar luaskan artikel ini, karena segala yang dipost di public adalah milik public. Bila Sobat tertarik Ingin membuat software, membeli software, membeli source code ,Dengan Cara menghubungi saya Ke Email: Fajarudinsidik@gmail.com, atau No Hp/WA : (fajar) : 085369237896, (puat) : 085267792168.

Tawk.to