Learning Visual Basic for Microsoft Excel Video Training DVD Rs 300/-

Course details 

Duration: 8 hours 
90 tutorial videos 
Released: 2012
Works on: Windows PC or Mac 
Video Format: MP4
Instructor: Guy Vaccaro



Table of Contents

01. Getting Started

• 0101 What Will I Get Out Of This Course
• 0102 About The Author
• 0103 The Working Files Explained
• 0104 What Is VBA?
• 0105 Excel 2010 Security Settings And Macro Files
• 0106 The Developer Ribbon

02. Macros

• 0201 Recording And Running A Simple Macro
• 0202 Editing An Existing Macro In The Visual Basic Editor
• 0203 The New Macro Enabled File Type
• 0204 Quick Tour Of The Visual Basic Editor
• 0205 Watch A Macro Write Your VBA

03. Procedures And Functions

• 0301 What Is A Module?
• 0302 Creating A Sub Procedure Manually
• 0303 How To Call A Sub Procedure
• 0304 Creating A Function Procedure
• 0305 How To Call A Function

04. Getting Started With VBA Programming

• 0401 Using Comments Within Your VBA Code
• 0402 Declaring Variables And Data Types
• 0403 The Scope Of A Variable
• 0404 The Static Declaration And Variable Expiry
• 0405 Constants Instead Of Variables
• 0406 An Intrinsic Constant
• 0407 String And Date Types Expanded
• 0408 VBA Operators
• 0409 Arrays
• 0410 Multi-Dimensional Arrays
• 0411 Dynamic Arrays

05. Manipulating Excel Objects

• 0501 Referencing Cells Using The Range Object
• 0502 The CELLS Property
• 0503 The OFFSET Property
• 0504 The VALUE Of Ranges
• 0505 The TEXT Object Of The RANGE
• 0506 A Number Of Read Only RANGE Properties
• 0507 The FONT Property And Colors
• 0508 Formatting Numeric Values
• 0509 Add Formulas To Cells Through VBA Code
• 0510 Common METHODS Of The RANGE Object

06. Working With Excel VBA Functions

• 0601 What Is A Function?
• 0602 Built In VBA Date Functions
• 0603 Text Manipulation With VBA Functions
• 0604 Determining File Sizes Using FILELEN
• 0605 Using Worksheet Excel Functions In VBA Code
• 0606 User Defined Functions

07. Controlling Program Flow And Execution

• 0701 Using GOTO And Labels
• 0702 Controlling The Program Flow With IF THEN ELSE
• 0703 Multiple Criteria Plus Nested IFs
• 0704 Adding ELSEIF To Speed Up Execution
• 0705 SELECT CASE As An Alternative To IF
• 0706 The FOR NEXT Loop
• 0707 FOR NEXT With A VBA Collection
• 0708 DO WHILE Loop

08. Events

• 0801 How To Create An Event
• 0802 WorkBook Events - Open
• 0803 Workbook Events - Closing And Saving
• 0804 Workbook Triggers - Activate And Deactivate
• 0805 Worksheet Triggers - Activate And Deactivate
• 0806 Other Useful Worksheet Triggers
• 0807 Using Application Events

09. Debugging And Error Handling

• 0901 Error Trapping the Easy Way
• 0902 Make The VBA Ignore Errors
• 0903 Interact With The User When An Error Occurs
• 0904 Making Use Of The ERR Object
• 0905 Debugging Techniques
• 0906 Using Breakpoints To Help Debug
• 0907 Setup And Use A Watch
• 0908 Speeding Up The VBA Tips

10. Interacting With Users Through Forms

• 1001 Using MSGBOX To Interact With Users
• 1002 Use INPUTBOX For Accepting Values From Users
• 1003 Selecting A Range With The INPUT Box
• 1004 An Introduction To UserForms
• 1005 Creating A UserForm
• 1006 Using Command Buttons
• 1007 Adding Option Buttons In A Frame
• 1008 Adding The Code That Makes The Form Work
• 1009 Calling Your UserForm And Validating Content
• 1010 UserForm Controls - The CheckBox
• 1011 UserForm Controls - ListBox And/Or Combo Box
• 1012 Images On UserForms
• 1013 Labels And Text Boxes
• 1014 Multiple Tabs On A UserForm
• 1015 Allowing The User To Highlight A Range
• 1016 Scrollbar And Spin Controls
• 1017 Controlling Tab Order And Aligning Controls

11. Running And Storing VBA Code

• 1101 Trigger A Procedure From The Quick Access Toolbar
• 1102 Customizing The Ribbons
• 1103 Adding Buttons To Sheets
• 1104 Adding A Keyboard Shortcut Trigger
• 1105 Where To Store Your VBA Code
• 1106 Adding Code To The PERSONAL File

12. Summary

• 1201 So What's Next?

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

Payment mode : Pay on my account ,Buying via ebay or Paypal  


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs

MS OFFICE Project 2010 Essential Training Video Tutorial DVD Rs 300/-

In Project 2010 Essential Training, project management expert Bonnie Biafore shows how individuals and teams can use Microsoft Project to manage any level of project. The course demonstrates setting up projects, adding tasks, assigning resources, fixing scheduling issues, dealing with resource conflicts, and tracking project progress. It also covers the new Project interface, featuring the new Ribbon and Backstage view, and explains how to use new features like user-controlled scheduling, the Timeline, and Team Planner. Exercise files accompany the course.


Topics include:

    * Setting up projects and calendars
    * Creating tasks and milestones
    * Linking tasks
    * Setting start and finish dates using manual and automatic scheduling
    * Setting up and assigning resources
    * Understanding duration, work, and units
    * Filtering and grouping items
    * Modifying project views
    * Using the Task Inspector
    * Splitting and delaying items
    * Making tasks inactive
    * Updating progress and costs
    * Viewing project status
    * Running reports

Contents of DVD

Introduction3m 25s

• Welcome1m 23s
• Choosing the right Project edition1m 23s
• Using the exercise files39s

1. Setting Up Project Files 46m 33s

• Using the Ribbon 8m 4s
• Navigating the Backstage view 3m 37s
• Creating a project 9m 42s
• Saving a project 8m 50s
• Defining project information 3m 39s
• Setting up the project calendar 12m 41s

2. Creating Tasks 37m 16s

• Creating a new task 7m 12s
• Creating a milestone 1m 21s
• Creating a summary task 3m 20s
• Creating a recurring task 3m 26s
• Copying and organizing tasks 5m 11s
• Displaying summary tasks and WBS codes 6m 21s
• Linking tasks 4m 14s
• Setting task dates 4m 1s
• Switching between manual and automatic scheduling 2m 10s

3. Creating Resources 20m 50s

• Understanding resources 3m 51s
• Creating a work resource 5m 14s
• Creating a material resource 3m 23s
• Setting up resource costs 5m 13s
• Creating a cost resource 3m 9s

4. Assigning Tasks to Resources 28m 0s

• Understanding duration, work, and units 4m 47s
• Assigning resources to tasks 6m 21s
• Viewing resource assignments and finding over-allocations 6m 49s
• Modifying resource assignments 5m 49s
• Using Team Planner to assign resources 4m 14s

5. Working with Views 49m 38s

• Choosing a different view 7m 0s
• Choosing a different table in a view 2m 53s
• Inserting and rearranging columns in a table 5m 39s
• Sorting tasks, assignments, and resources 5m 14s
• Grouping tasks, assignments, and resources 6m 32s
• Filtering tasks, assignments, and resources 6m 53s
• Modifying task bar styles, text, and layout 6m 44s
• Modifying text styles and text formatting 3m 55s
• Using the Timeline view to summarize a project 4m 48s

6. Fine-Tuning the Project Schedule 26m 34s

• Using the Task Inspector to handle scheduling issues 6m 6s
• Splitting and delaying tasks and assignments 4m 49s
• Adjusting a work contour 4m 54s
• Leveling resources 6m 51s
• Inactivating tasks 3m 54s

7. Tracking and Managing Projects 34m 4s

• Understanding baseline, scheduled, and actual values 4m 58s
• Saving and clearing a baseline 3m 20s
• Editing tasks and adding them to a baseline 2m 26s
• Updating the schedule 4m 51s
• Using overtime 5m 25s
• Updating costs 2m 45s
• Making global progress updates to a project 4m 21s
• Using earned value 5m 58s

8. Viewing and Sharing Project Information 34m 56s

• Viewing project status 4m 40s
• Looking for schedule and cost problems 3m 57s
• Running a text-based report 4m 37s
• Generating a visual report 6m 34s
• Working with the Global Template 4m 15s
• Importing and exporting information 5m 38s
• Sharing project information in other ways 5m 15s
• Conclusion 39s
• Goodbye 39s

==================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

==================================================

Payment mode : Pay on my account ,Buying via ebay or Paypal  


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days



For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs

Learn Excel 2013 and Excel Power Shortcuts Video Training DVD Rs 350/-

Lear Excel 2013 Essential Training


Level - Appropriate for all
Duration - 6h 32m



Video Lessons

Introduction 1m 6s
1. Getting Started with Excel 2013 29m 37s
2. Entering Data 24m 1s
3. Creating Formulas and Functions 30m 7s
4. Formatting 46m 7s
5. Adjusting Worksheet Layout and Data 20m 40s
6. Printing17m 51s
7. Introduction to Charting30m 30s
8. Adjusting Worksheet Views12m 49s
9. Multiple Worksheets and Workbooks23m 0s
10. IF, VLOOKUP, and Power Functions 20m 25s
11. Security and Sharing 23m 50s
12. Database Features28m 32s
13. PivotTables35m 2s
14. Data Analysis Tools 23m 29s
15. Introduction to Macros24m 31s
Conclusion29s


Excel 2013 Power Shortcuts

Author - Curt Frye
Subject - Business, Spreadsheets
Software - Excel 2013, Office 2013, Office 365 
Level - Intermediate
Duration - 3h 16m
Released - Feb 28, 2013

Topics include:

• Entering a data series using the fill handle
• Creating hyperlinks
• Setting a print area
• Applying a table style
• Creating substitute data sets using scenarios
• Wrapping and shrinking text
• Creating a data entry form
• Removing duplicate values
• Inserting the current date or time
• Generating a list of unique random numbers
• Calculating running totals
• Analyzing a formula for errors
• Summarizing data with charts and PivotTables

Table of Contents

1. Top Ten Shortcuts32m 35s
2. Controlling the Excel Program and Interface16m 33s
3. Managing Workbooks and Worksheets13m 48s
4. Organizing Data22m 59s
5. Entering and Formatting Data 24m 22s
6. Managing a Data Series13m 3s
7. Working with Dates and Times13m 8s
8. Creating Useful Formulas21m 39s
9. Managing Formulas17m 37s
10. Summarizing Data Using Charts and PivotTables18m 17s
Conclusion56s

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

======================================================================

Payment mode : CASH ON DELIVERY , Prepaid ,Buying via ebay or ShopClues or Snapdeal

Payments :

Credit Card , Debit Card , Net Banking , EMI , Cash on Delivery

Shipping : By Courier through all over India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

Place your Order On

www.easylearningdvds.in

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDVDs

Fast Track Excel Training - Beginner & Advanced Excel Training Course + Bonus Fast Track to Outlook Training 2 Video DVDs Rs 400/-

Volume 1: Beginner Excel Training

• Basic spreadsheet usage and terms
• The new Excel interface
• Basic spreadsheet functions (cells, formulas, data entry, calculations)
• How to format your spreadsheet to make it look like a million bucks
• Creating charts from your data
• 2 1/2 hours of hands on, in depth Excel training that will get you up to speed with most of the uses of Excel

Let's take a look at the videos in this powerful, easy to learn first module (and you can actually watch some samples below):

Video Title Length (min:sec)

• Introduction To Excel 2:19
• The Ribbon 2:34
• Spreadsheets & Cells 5:13
• The Formula Bar 4:51
• The Information Bar 3:07
• Entering Data 4:59
• Data & Autofill 5:26
• Formatting 4:15
• Formatting Cells 9:20
• Introduction To Formulas 6:05
• Range Reference & Functions 10:27
• More Formulas 5:48
• Formatting For Currency 2:26
• Conditional Formatting 7:36
• Absolute References 12:09
• Borders 9:45
• Filling Cells 5:11
• Styles 5:55
• More Functions 10:08
• Illustrations 8:08
• Introduction To Charts 12:38
• Printing 6:38
• Closing Statements 0:58

Volume 2: Advanced Excel Training

• Learn new functions and formulas that will save you time and make you look like a 'number crunching genius' to your collegues...
• Discover advanced text manipulation and formatting that will enable you to do things with spreadsheets most people only dream of...
• Create complicated, problem-solving formulas with advanced logic that will send other people into a 'brain spinning whirlwind' - but you'll do it with ease once you see these videos...
• Master Pivot Tables to sort through vast amounts of data and find exactly what you need, instantly...
• How would you like to automate complex tasks with ease through Excel Macros? These powerful workhorses are explained in detail in this Advanced course...
• And much more in this 4 hour Home Study course...

Video Title Length (min:sec)

• Introduction 3:19
• The ROUND Function 7:07
• Using ROUND 3:47
• TEXT 3:41
• Using TEXT 5:29
• The LEN Function 3:42
• The REPLACE Function 5:19
• Using REPLACE And LEN 7:11
• The IF Function 5:34
• Using IF 6:40
• More On IF 9:36
• Using LEFT, RIGHT & MID 3:48
• The CONCATENATE Function 2:23
• Using UPPER, LOWER & PROPER 3:17
• The TRIM Function 4:52
• Using VALUE 7:18
• Working With Multiple Sheets 4:29
• Drop Down 6:05
• A Real World Scenario 3:13
• Using COUNTIF & COUNTA 7:26
• COUNT Together 9:45
• Relative & Absolute 4:20
• Mulitiplying Text 4:03
• The PMT Function 11:28
• Introduction To Macros 9:40
• More On Macros 9:46
• Editing Macros 7:36
• Macro Notes 3:41
• Using VLOOKUP 5:33
• Creating a VLOOKUP Invoice 5:55
• VLOOKUP & IF 6:42
• SUBTOTAL 8:04
• Using HLOOKUP 11:15
• Introduction To Pivot Tables 4:53
• Pivot Table Options 9:36
• Pivot Charts 4:07
• Goal Seek 6:40
• Conclusion 0:54

Bonus DVD

Fast Track to Outlook Training 

Outlook 2007 is the latest version of Microsoft's Office email client. It does much more than just email though. Outlook is a complete contact manager, keeping track of contacts, appointments, tasks, and more.
Join Microsoft Certified Professional, Ken Walker as he guides you through Outlook's interface in a 'real-world' setting showing you how to use Microsoft Outlook 2007 for every day tasks.
This course includes 54 information rich videos for a total of over 4 hours of video training! You'll learn everything you need to know about Microsoft Outlook 2007 - in just one weekend.

The Fast Track to Outlook 2007 is part of a series of training videos on the Microsoft Office family of products. Outlook is an email client, a contact manager, a task manager and an appointment manager, all rolled into one.
Outlook 2007 has many new features and is designed by Microsoft to streamline many typical email related tasks. Instructor Ken Walker takes you through the new features of Outlook 2007 as well as the basics of email. You'll learn how to integrate your notes, tasks, emails and appointments.
Be more productive and have more time to do the things you enjoy.
Never miss an appointment or forget to reply to an email.
Learn how to customize your email signature, background, and much more.

========================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

Payment mode : Pay on my account ,Buying via ebay or Paypal  
Shipping : By Courier through all over India
Shipping charge : Rs 50/- Flat Rate shipping anywhere in India
You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more Training DVDs
http://www.easylearningdvds.in/Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs

Place Your Order On

​

Advanced Microsoft Excel 2013 Tutorial Video DVD Rs 300/-

Duration: 10 hours - 128 tutorial videos | Date Released: 2013-01-29
Works on: Windows PC or Mac | Format: DVD | Instructor: Guy Vaccaro

In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.

You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow.

By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.


00. Free Videos From This Course
01. Getting Started
02. Using Mathematical Functions
03. IF Functionality
04. Performing Data Lookups
05. Sparklines
06. Further Mathematical Functions
07. Outlining
08. Scenarios
09. Custom Views
10. Functions For Manipulating Text
11. Arrays
12. Useful Data Functions
13. Some Other Useful Functions
14. Auditing And Troubleshooting Formulas
15. PivotTables
16. PivotCharts
17. Goal Seek And Solver
18. Macros
19. Summary And Credits


======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

Payment mode : Pay on my account ,Buying via ebay or Paypal  


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs