eXBii

Go Back eXBii > Technology > E-books > Useful Ebooks - Megathread

Reply
Page 7 of 25 « First < 456 7 891017 > Last »
 
Thread Tools
  #61   Gift FQ Bandwidth  
Old 16th September 2009
abc420 abc420 is offline
www.BollyGallery.com
  
VCash
600000
Join Date: 8th March 2009
Posts: 101
Rep Power: 3 Points: 108
abc420 is beginning to get noticed
UL: 696.45 mb DL: 1.25 gb Ratio: 0.54
excel video training for intermediate to advance user
Course: MS Excel Automation

Author: Lauri Matson

Release Date: 2009-01-30

Duration: 5 hrs / 71 tutorials


VTC's MS Excel Automation course is intended for intermediate and advanced users who wish to increase their efficiency, accuracy, and productivity. Students should have already completed Excel introduction courses or have equivalent knowledge. Created for all versions of Excel, this course will help students master the art of spreadsheet design and will provide comprehensive instruction in the automation and simplification of even the most complex data. Expanding upon our basic Excel courses, Lauri Matson explores the more advanced features of Excel such as VLookup functions, validation, pivot tables, analysis tools, charting, and more.

Introduction
Course Objectives (04:43)
Command Reference (2003 - 2007) (01:35)

Time Saving Techniques
Shortcuts & Quick Tips (04:44)
Auto Correct Options (03:30)

Validation & Protection
Introducing Data Validation (03:04)
Creating a List with Validation (02:16)
Setting up Protection (04:3

Named Ranges
Defining a Name (04:12)
Editing & Using Names (02:5
Name Manager (04:11)

Security
Adjusting Security Levels (04:13)
Using Macro Extension (04:1

Introduction to Macros
Tools Menu vs. Developer Toolbar (02:49)
Storing Macros (04:29)
Working with a Startup Folder (03:40)

Macros
Getting Started (03:36)
Absolute vs. Relative Reference (03:46)

Practice with Macros
Creating a Routine (03:29)
Automating Formats (03:06)
Creating a Template for Headers/Footers (03:13)

Understanding Macro Code
Editing Macros with VBA (04:06)
Introduction to Reading Code (05:11)

Buttons vs. Command Buttons
Creating a Button (04:12)
Creating a Command Button (05:44)

The VBA Screen
The Explorer & Properties (04:53)
Objects & User Forms (05:46)

Creating a Routine
Creating an Object pt. 1 (03:04)
Creating an Object pt. 2 (04:3
Adding Code to an Object (06:05)

Adding Controls
Creating Dropdown Lists (04:23)
Viewing the Code (04:34)

Designing a Pop-Up Calendar
Creating the Calendar Form (05:13)
Writing the Code (05:17)

Writing Code
Coding with VBA (03:37)
Examples (05:14)

Formulas & Functions
Formulas vs. Functions (03:49)
Tips for Formulas (04:47)

Three Dimensional Formulas
Formulas from Other Worksheets (03:4
Linking External Workbooks (05:1

Popular Functions
Conditional Statements (02:43)
Nested Statements (04:40)
Introduction to V-Lookup (05:21)
Tips for Working with V-Lookup (03:29)

VBA & Functions
Using Functions (05:00)
Creating a Custom Function (04:44)

Using an Add-In
Explaining Add-In (03:59)
Creating an Add-In for a Custom (02:37)
Using a Function with Goal Seek (04:21)

Pivot Tables
Using Pivot Tables (05:01)
Working with Outside Data (04:40)
Formats & Features of Pivots (04:30)

Automating Pivot Tables
Adding a Pivot Chart (04:06)
Macros & Code for Automation (05:54)

Advanced Charts & Graphs
Single Point Charts (05:39)
Specialty Charts (05:44)
Combination Charts (04:44)

Automating Charts & Graphs
Creating a Dynamic Chart (04:12)
The Offset Command (04:51)

Pivots & Charts in Legacy Versions
Creating Pivots in Earlier Versions (04:13)
Charts & Graphs in Prior Versions (05:39)

Working with Other Programs
Linking to PowerPoint (03:41)
Dressing up Your Spreadsheets (05:40)

Importing/Exporting Data
Working with External Data (05:33)
Exporting from Excel (03:56)

Analysis Tools
Understanding the Add-In Tools (02:1
Descriptive Statistics (03:36)
Histogram (03:21)

Looking for Help
The Help Menu for Excel & VBA (05:16)
The MS Interactive Tool (02:32)

Wrap Up
Conclusion (03:01)
About the Author (03:06)

each file cover 2 topics except the last one which also contains exercise file. all the files are separately playable.
here are the links which i found during internet surfing.

http://rapidshare.com/files/244697111/1.rar
http://rapidshare.com/files/244704748/2.rar
http://rapidshare.com/files/244713528/3.rar
http://rapidshare.com/files/244942168/4.rar
http://rapidshare.com/files/245051010/5.rar
http://rapidshare.com/files/246240970/6.rar
http://rapidshare.com/files/246243966/7.rar
http://rapidshare.com/files/246245767/8.rar
http://rapidshare.com/files/246254237/9.rar
http://rapidshare.com/files/246256921/10.rar
http://rapidshare.com/files/246266327/11.rar
http://rapidshare.com/files/246270852/12.rar
http://rapidshare.com/files/246274491/13.rar
http://rapidshare.com/files/246297110/14.rar
http://rapidshare.com/files/246322839/15.rar
Reply With Quote
  #62   Gift FQ Bandwidth  
Old 16th September 2009
abc420 abc420 is offline
www.BollyGallery.com
  
VCash
600000
Join Date: 8th March 2009
Posts: 101
Rep Power: 3 Points: 108
abc420 is beginning to get noticed
UL: 696.45 mb DL: 1.25 gb Ratio: 0.54
AutoCAD 2010 Essentials
"AutoCAD 2010 Essentials"

June 2009 | English | ISBN-13: 978-0-7637-7629-9 | 384 Pages | PDF | 6.79 MB
Unlike many AutoCAD competitors, this book covers only the basics and uses mixed units _ inches, meters, feet, kilometers, etc., to illustrate the myriad drawing and editing tools for this popular application. AutoCAD 2010 Essentials includes 21 workshops, that complete small projects _ from concept through actual plotting. Solving all of the workshops will simulate the creation of a real life project from beginning to end, without overlooking any of the basic commands and functions in AutoCAD 2010.
here is the link which i found during internet search. so credit goes to the original uploader.
http://rapidshare.com/files/280799432/ac2010et.rar
Reply With Quote
  #63   Gift FQ Bandwidth  
Old 16th September 2009
ravinder_tigh ravinder_tigh is offline
KING...
  
VCash
600000
Join Date: 16th December 2007
Posts: 7,267
Rep Power: 12 Points: 1996
ravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our community
UL: 7.30 gb DL: 6.83 gb Ratio: 1.07
thanks man much needed
__________________
Bumpy
Reply With Quote
  #64   Gift FQ Bandwidth  
Old 16th September 2009
ravinder_tigh ravinder_tigh is offline
KING...
  
VCash
600000
Join Date: 16th December 2007
Posts: 7,267
Rep Power: 12 Points: 1996
ravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our community
UL: 7.30 gb DL: 6.83 gb Ratio: 1.07
thanksssssssssssss
__________________
Bumpy
Reply With Quote
  #65   Gift FQ Bandwidth  
Old 16th September 2009
klp09 klp09 is offline
www.FilesQuick.com
  
VCash
600000
Join Date: 16th August 2008
Posts: 18
Rep Power: 0 Points: 26
klp09 is an unknown quantity at this point
UL: 31.08 gb DL: 38.97 gb Ratio: 0.80
thanx~~~~~~~~~
Reply With Quote
  #66   Gift FQ Bandwidth  
Old 17th September 2009
abc420 abc420 is offline
www.BollyGallery.com
  
VCash
600000
Join Date: 8th March 2009
Posts: 101
Rep Power: 3 Points: 108
abc420 is beginning to get noticed
UL: 696.45 mb DL: 1.25 gb Ratio: 0.54
Fluid Mechanics by FM White 5th edition Solution Manual
FLUID MECHANICS BY FM WHITE 5th Edition Solution MAnual
here is the link of fm white fluid mechanics which i found from internet search

http://rapidshare.com/files/280113234/01fm.rar
http://rapidshare.com/files/280118144/02fm.rar
http://rapidshare.com/files/280120013/03fm.rar
http://rapidshare.com/files/280123968/04fm.rar
http://rapidshare.com/files/280125955/05fm.rar
Reply With Quote
  #67   Gift FQ Bandwidth  
Old 17th September 2009
ravinder_tigh ravinder_tigh is offline
KING...
  
VCash
600000
Join Date: 16th December 2007
Posts: 7,267
Rep Power: 12 Points: 1996
ravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our community
UL: 7.30 gb DL: 6.83 gb Ratio: 1.07
thankssssssssssssss
__________________
Bumpy
Reply With Quote
  #68   Gift FQ Bandwidth  
Old 17th September 2009
abc420 abc420 is offline
www.BollyGallery.com
  
VCash
600000
Join Date: 8th March 2009
Posts: 101
Rep Power: 3 Points: 108
abc420 is beginning to get noticed
UL: 696.45 mb DL: 1.25 gb Ratio: 0.54
Mathematics by Physics Formulary (excellent books)
Mathematics Formulary
by
J.C.A Wavers

here is the link which i found during internet search

http://rapidshare.com/files/280895278/330.rar


2) Physics Formulary
by
J.C.A Wavers

http://rapidshare.com/files/280891553/329.rar
Last edited by abc420 : 21st September 2009 at 10:35 PM.
Reply With Quote
  #69   Gift FQ Bandwidth  
Old 17th September 2009
abc420 abc420 is offline
www.BollyGallery.com
  
VCash
600000
Join Date: 8th March 2009
Posts: 101
Rep Power: 3 Points: 108
abc420 is beginning to get noticed
UL: 696.45 mb DL: 1.25 gb Ratio: 0.54
sorry for typing mistakes it's mathematics and physics formulary two seperate books.
Reply With Quote
  #70   Gift FQ Bandwidth  
Old 17th September 2009
ravinder_tigh ravinder_tigh is offline
KING...
  
VCash
600000
Join Date: 16th December 2007
Posts: 7,267
Rep Power: 12 Points: 1996
ravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our communityravinder_tigh is a pillar of our community
UL: 7.30 gb DL: 6.83 gb Ratio: 1.07
thankssssssssssssssssss
__________________
Bumpy
Reply With Quote
Reply
Page 7 of 25 « First < 456 7 891017 > Last »

« Previous Thread | Next Thread »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


One of the largest message boards on the web ! All times are GMT +5.5. The time now is 02:42 AM.
Contact Us - Forums Home - Privacy Statement - Top
Page generated in 0.23620 seconds with 8 queries