Learn QuickBooks 2016 Video Course Training Tutorial on DVD

Duration 7 Hours

Course Introduction 06:49
Course Introduction  06:49
–
The QuickBooks Environment 23:33
The Home Page and Insights Tabs 06:49
The Centers 01:18
The Menu Bar and Keyboard Shortcuts 02:29
The Open Window List 01:26
The Icon Bar 01:57
Customizing the Icon Bar 02:30
The Chart of Accounts 04:00
Accounting Methods 01:10
Financial Reports 01:54
–
Creating a QuickBooks Company29:08
Using Express Start in QuickBooks 2016 04:44
Using the EasyStep Interview 09:47
Returning to the EasyStep Interview 00:40
Creating a Local Backup Copy 04:01
Restoring a Company File from a Local Backup Copy 03:30
Setting Up Users 04:19
Single and Multiple User Modes 01:11
Closing Company Files 00:11
Opening a Company File 00:45
–
Using Lists 44:50
Using Lists 01:04
The Chart of Accounts 07:41
The Customers & Jobs List 10:27
The Employees List 06:54
The Vendors List 06:46
Using Custom Fields 04:19
Sorting Lists 02:25
Inactivating and Reactivating List Items 01:25
Printing Lists 00:38
Renaming and Merging List Items 00:54
Adding Multiple List Entries from Excel 02:17
–
Setting Up Sales Tax11:41
The Sales Tax Process 02:53
Creating Tax Agencies 00:58
Creating Individual Sales Tax Items 02:20
Creating a Sales Tax Group 02:10
Setting Sales Tax Preferences 01:49
Indicating Taxable & Non-taxable Customers & Items 01:31
–
Setting Up Inventory Items15:53
Setting Up Inventory 01:51
Creating Inventory Items 03:24
Creating a Purchase Order 02:44
Receiving Items with a Bill 02:32
Entering Item Receipts 02:09
Matching Bills to Item Receipts 01:37
Adjusting Inventory 01:36
–
Setting Up Other Items14:02
Service Items 01:52
Non-Inventory Items 01:56
Other Charges 01:45
Subtotals 00:48
Groups 02:03
Discounts 01:59
Payments 01:43
Changing Item Prices 01:56
–
Basic Sales 13:47
Selecting a Sales Form 00:53
Creating an Invoice 02:41
Creating Batch Invoices 05:44
Creating a Sales Receipt 02:33
Finding Transaction Forms 01:18
Previewing Sales Forms 00:16
Printing Sales Forms 00:22
–
Using Price Levels03:40
Using Price Levels 03:40
–
Creating Billing Statements06:13
Setting Finance Charge Defaults 01:46
Entering Statement Charges 01:07
Applying Finance Charges and Creating Statements 03:20

Payment Processing15:11
Recording Customer Payments 02:40
Entering a Partial Payment 01:34
Applying One Payment to Multiple Invoices 01:25
Entering Overpayments 01:17
Entering Down Payments or Prepayments 00:49
Applying Customer Credits 01:57
Making Deposits 02:56
Handling Bounced Checks 02:33
-
Handling Refunds03:25
Creating a Credit Memo and Refund Check 01:15
Refunding Customer Payments 02:10
-
Entering and Paying Bills09:03
Setting Billing Preferences 01:08
Entering Bills 02:15
Paying Bills 02:55
Early Bill Payment Discounts 00:54
Entering a Vendor Credit 00:57
Applying a Vendor Credit 00:54

Using Bank Accounts15:48
Using Registers 01:27
Writing Checks 02:23
Writing a Check for Inventory Items 01:07
Printing Checks 05:19
Transferring Funds Between Accounts 00:39
Reconciling Accounts 04:08
Voiding Checks 00:45

Paying Sales Tax05:31
Sales Tax Reports 01:45
Using the Sales Tax Payable Register 00:58
Paying Your Tax Agencies 02:48

Reporting33:11
Graph and Report Preferences 03:29
Using QuickReports 01:10
Using QuickZoom 01:27
Preset Reports 02:47
Modifying a Report 11:42
Rearranging and Resizing Report Columns 01:08
Memorizing Reports 00:54
Memorized Report Groups 01:10
Printing Reports 00:36
Batch Printing Forms 00:25
Exporting Reports to Microsoft Excel 01:30
Saving Forms and Reports as PDF Files 00:35
Comment on Report 04:24
Process Multiple Reports 01:54

Using Graphs06:44
Using Graphs 02:33
Company Snapshot 04:11
-
Customizing Forms24:41
Creating New Form Templates 02:42
Performing Basic Customization 03:02
Performing Additional Customization 02:15
The Layout Designer 02:32
Changing the Grid and Margins in the Layout Designer 01:32
Selecting Objects in the Layout Designer 01:22
Moving and Resizing Objects in the Layout Designer 01:03
Formatting Objects in the Layout Designer 03:07
Copying Objects and Formatting in the Layout Designer 01:21
Adding and Removing Objects in the Layout Designer 01:40
Aligning and Stacking Objects in the Layout Designer 02:55
Resizing Columns in the Layout Designer 01:10

Estimating 16:25
Creating a Job 02:19
Creating an Estimate 01:52
Duplicating Estimates 01:17
Invoicing from an Estimate 03:07
Updating Job Statuses 00:42
Inactivating Estimates 01:18
Making Purchases for a Job 01:17
Invoicing for Job Costs 02:24
Using Job Reports 02:09
-
Time Tracking12:42
Tracking Time and Printing a Blank Timesheet 01:57
Weekly Timesheets 01:24
Time/Enter Single Activity 01:20
Invoicing from Time Data 02:00
Using Time Reports 01:14
Tracking Vehicle Mileage 02:57
Charging Customers for Mileage 01:50

Payroll26:11
The Payroll Process 03:21
Creating Payroll Items 01:10
Setting Employee Defaults 01:14
Setting Up Employee Payroll Information 02:58
Creating Payroll Schedules 01:21
Creating Scheduled Paychecks 02:09
Creating Unscheduled Paychecks 01:10
Creating Termination Paychecks 01:21
Voiding Paychecks 00:48
Tracking Your Tax Liabilities 01:00
Paying Payroll Tax Liabilities 02:33
Adjusting Payroll Liabilities 01:27
Entering Liability Refund Checks 01:16
Process Payroll Forms 00:45
Tracking Workers Compensation 03:38

Using Credit Card Accounts06:14
Creating Credit Card Accounts 01:03
Entering Charges on Credit Cards 03:15
Reconciling and Paying Credit Cards 01:56

Assets and Liabilities19:18
Assets and Liabilities 02:29
Creating and Using Other Current Asset Accounts 02:15
Removing Value from Other Current Asset Accounts 02:58
Creating Fixed Asset Accounts 04:11
Creating Liability Accounts 01:01
Setting the Original Cost of the Fixed Asset 00:28
Tracking Depreciation 00:34
The Loan Manager 04:20
The Fixed Asset Item List 01:02

Equity Accounts02:40
Equity Accounts 01:14
Recording an Owner’s Draw 00:27
Recording a Capital Investment 00:59

Writing Letters with QuickBooks02:43
Using the Letters and Envelopes Wizard 00:55
Editing Letter Templates 01:48

Company Management08:29
Viewing Your Company Information 00:30
Setting Up Budgets 01:37
Using the To Do List 01:50
Using Reminders and Setting Preferences 00:34
Making General Journal Entries 00:59
Using the Cash Flow Projector 02:59

Using QuickBooks Tools22:34
Company File Cleanup 01:55
Exporting List Data to an IIF File 00:47
Advanced Importing of Data 02:28
Updating QuickBooks 00:33
Using the Calculator 00:16
Using Portable Company Files 03:04
Using the Calendar 01:49
The Income Tracker 03:20
The Bill Tracker 03:27
The Lead Center 04:55
-
Using the Accountant’s Review06:29
Creating an Accountant’s Copy 01:21
Transferring an Accountant’s Copy 02:31
Importing Accountant’s Changes 01:39
Removing Restrictions 00:58
-
Using the Help Menu01:39
Using Help 01:39

Conclusion00:39
Course Conclusion 00:39
-
Instruction Manuals00:00
Introductory QuickBooks Manual 148 pages
Advanced QuickBooks Manual 142 pages

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

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

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

Learn Advanced Formulas and Functions On Excel 2013 Video Course DVD Rs 300/-

Introduction 1m 23s
Welcome 58s
Using the exercise files 25s

1. Formula and Function Tips and Shortcuts 37m 48s

• Displaying and highlighting formulas 5m 10s
• Auditing tools 4m 38s
• Using entire row/column references 3m 43s
• Copying column formulas instantly 3m 11s
• Converting formulas to values with a simple drag 3m 32s
• Updating values without formulas 2m 55s
• Simplifying debugging formulas 3m 51s
• Enhancing readability with range names 5m 50s
• Creating 3D formulas to gather data from multiple sheets 4m 58s

2. Formula and Function Tools 24m 12s

• Understanding the hierarchy of operations in Excel formulas 3m 19s
• Using the Formulas tab on the Ribbon for locating functions 3m 14s
• Using the Insert Function button for guidance with unfamiliar functions 4m 36s
• Using and extending AutoSum button capabilities 5m 6s
• Using absolute and relative references in formulas 3m 30s
• Using mixed references in formulas 4m 27s

3. IF and Related Functions 15m 42s

• Exploring IF logical tests and using relational operators 3m 33s
• Creating and expanding the use of nested IF statements 4m 22s
• Using the AND and OR functions with IF to create compound logical tests 7m 47s

4. Lookup and Reference Functions 41m 58s

• Looking up information with VLOOKUP and HLOOKUP 3m 57s
• Finding approximate matches with VLOOKUP 7m 27s
• Finding exact matches with VLOOKUP 4m 47s
• Nesting lookup functions 4m 11s
• Using VLOOKUP with large tables 3m 23s
• Finding table-like information within a function with CHOOSE 3m 34s
• Locating data with MATCH 4m 35s
• Retrieving information by location with INDEX 2m 46s
• Using MATCH and INDEX together 7m 18s

5. Power Functions 10m 22s

• Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF 5m 9s
• Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS 5m 13s

6. Statistical Functions 18m 57s

• Finding the middle value with MEDIAN 2m 46s
• Ranking data without sorting with RANK 4m 24s
• Finding the largest and smallest values with LARGE and SMALL 2m 19s
• Tabulating blank cells with COUNTBLANK 5m 43s
• Using COUNT, COUNTA, and the status bar 3m 45s

7. Math Functions 36m 59s

• Working with ROUND, ROUNDUP, and ROUNDDOWN 6m 5s
• Working with MROUND, CEILING, and FLOOR for specialized rounding 5m 21s
• Using the INT and TRUNC functions to extract integer data 3m 2s
• Finding the remainder with MOD and using MOD with conditional formatting 5m 26s
• Practical uses for the random number functions RAND and RANDBETWEEN 6m 8s
• Converting a value between measurement systems with CONVERT 3m 17s
• Using the powerful AGGREGATE function to bypass errors and hidden data 4m 55s
• Using the ROMAN and ARABIC functions to display different numeral systems 2m 45s

8. Date and Time Functions 39m 44s

• Understanding Excel date/time capabilities in formulas 9m 2s
• Using TODAY and NOW functions for dynamic date/time entry 3m 55s
• Identifying the day of the week with WEEKDAY 4m 8s
• Counting working days with NETWORKDAYS 3m 32s
• Determining a completion date with WORKDAY 3m 38s
• Tabulating date differences with DATEDIF 5m 43s
• Calculating end-of-month and future/past dates with EDATE and EOMONTH 5m 0s
• Converting text entries into dates and times with DATEVALUE and TIMEVALUE 4m 46s

9. Array Formulas and Functions 28m 34s

• Extending formula capabilities with arrays 8m 27s
• Counting unique entries in a range with an array formula 5m 46s
• Determining frequency distributions with FREQUENCY 3m 54s
• Flipping row/column orientation with TRANSPOSE 3m 27s
• Building analysis via regression techniques with TREND and GROWTH 2m 31s
• Using array formula techniques with the MATCH function for complex lookups 4m 29s

10. Reference Functions 16m 38s

• Getting data from remote cells with OFFSET 6m 16s
• Returning references with INDIRECT 3m 50s
• Using INDIRECT with data validation for two-tiered pick list scenarios 6m 32s

11. Text Functions 34m 3s

• Locating and extracting data with FIND, SEARCH, and MID 5m 4s
• Extracting specific data with LEFT and RIGHT 2m 29s
• Removing extra spaces with TRIM and removing hidden characters with CLEAN 5m 5s
• Using ampersands and CONCATENATE to combine data from different cells 5m 38s
• Adjusting the case within cells with PROPER, UPPER, and LOWER 3m 6s
• Adjusting character content with REPLACE and SUBSTITUTE 5m 56s
• Using other utility text functions: LEN, REPT, VALUE, TEXT 6m 45s

12. Information Functions 19m 55s

• Extracting information with the CELL and INFO functions 5m 47s
• Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER 5m 20s
• Using error-checking functions ISERR, ISERROR, IFERROR, ISNA, and IFNA 6m 18s
• Using the ISFORMULA function with conditional formatting 2m 30s
• Conclusion 26s
• Goodbye 26s

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

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

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

Payment mode : CASH ON DELIVERY , Pay on my account ,Buying via ebay or ShopClues


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

The Ultimate Collection of SAP eBooks in Single DVD Rs 300/-

•  ABAP Objects ABAP Programming in SAP NetWeaver - 2007.pdf 279.66 Mb
• 
  
•  The Official ABAP Reference (3rd Edition), 2011.pdf 266.17 Mb

The Ultimate SAP Training Course DVD Rs 300/-

Working Only on Window Xp or Vista PC

Working Only on Window Xp or Vista PC


This Course Installation Video
This is ultimate Sap training , which Includes all the modules , and set by set instruction,, GREAT STUFF for Those struggling with SAP. 

What’s Included

• Project Systems SAP Computer Based Training Modules
• Strategic Enterprise Management Database Administration and Monitoring
• Production Planning and SOP Database Administration Made Easy
• Cost Centre Accountant Financial Accountant
• Shipping Clerk Customer Relationship Management (CRM)
• CO CCA Periodical Processing MM Invoice Verification
• AR Accountant CO CCA Master Data
• Cust Order Processing Advanced Administration and CCMS
• Cust Ship and Delivery CO CCA Peridoical Allocations & Reports
• SAP BW Configuration 1 SAP BW Configuration 2
• Structure and Operations System Management: Systems Admin
• FSCM Biller Consolidator SAP Finance In-House Cash
• SAP Finance Biller Direct Purchaser, Billing & Controlling
• Finanacial Management Inventory Management
• FSCM In-House Cash FSCM Biller Direct
• Mat Acq & Payment Production Planning
• Product Costing Financial Supply Chain Management
• Materials Requirements FSCM Collaborative Business Scenario
• ExtractOnDemand for SAP R/3 Planning Business Process Management
• TMS Configuration Warehouse Management
• Fundamentals Asset Accounting

You’ll Also Learn …

• SAP R/3 Style Guide
• ABAP Programming
• SAP Open Information Management
• SAP Installation
• SAP Tips and Tricks SAP R3 3.0 Working With SAP
• MM Inventory Management MM Purchasing
• MM Invoices FI Receivables Payables
• FI General Ledger FI Payments
• FI Balance Sheet CO Cost Center Acctg 1
• CO Cost Center Acctg 2 PM Overview
• PM Plant Maint. Proc PS Overview
• CO-OP Internal Orders PP Material Req. Planning
• PP PO Processing ABAP 4 Overview

Overview of SAP Modules

Here is a brief overview of most of the modules and there processes in SAP. This should give you a brief outline of what each module is about and also makes you understand as to what each module does.

Materials Management (MM)

The grouping of management functions supporting the complete cycle of material flow, from the purchase and internal control of production materials to the planning and control of work in process to the warehousing, shipping, and distribution of the finished product.

Sales and Distribution (SD)

This module includes the business processes used to sell and deliver products and services to customers and business partners. Information about the product and customers (both of which are stored in the master data) is used in SD.

Production Planning (PP)

This module supports functions for the overall level of manufacturing output and other activities to best satisfy the current planned levels of sales (sales plan or forecasts), while meeting general business objectives of profitability, competitive customer lead times as expressed in the overall business plan. One of its primary purposes is to establish production rates that will achieve management’s objective of satisfying customer demand, by maintaining, raising or lowering inventories or backlogs, while usually attempting to keep the workforce relatively stable.

Plant Maintenance (PM)

Supports the planning, processing, and completion of plant maintenance tasks
Allows for planners to schedule routine maintenance in a way that is least disruptive for manufacturing and sales requirements

Quality Management (QM)

Supports the quality inspection aspects of the business, including purchasing, research, and sales
Allows for buyers and manufacturing personnel to track inspection lots and test results


Financial Accounting (FI)

Designed for automated management and external reporting of General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), and Asset Management (AM) with a user-defined chart of accounts.
External reporting, such as income statement and balance sheet Represents cost and revenue flows throughout the organization
Aids in organizational decision making
Supports internal reporting such as cost center reports

Asset Accounting (AA)

AA provides tools to acquire, depreciate, evaluate, and retire assets. The kinds of assets covered are fixed, low value, leased, and real estate.
Low value assets depreciate in the year they are bought and are often aggregated as a single asset master record.
Depreciation often needs to be tracked (for more than one reason), so SAP R/3 allows you to depreciate the same piece of equipment in several parallel ways.

Human Resources (HR)

Takes care of payroll, time recording, applicant administration, and organization data. It supports the planning and control of personnel activities.
Industry Solutions (IS)
IS is scaleable and flexible, and can be tailored to the specific needs of each business. 

Examples are:
SAP Aerospace and Defense
SAP Automotive
SAP Banking
SAP Chemicals
SAP Consumer Products
SAP Engineering and Construction
SAP Telecommunication
SAP Utilities
SAP Service Provider

Work Flow (WF)

Links the integrated SAP R/3 application modules with cross-application technologies, tools, and services, including e-mail.
Work flow allows you to set up the followings:
Maintain your company’s organization structure according to responsibility.
Link the predefined standard tasks with the authorized agents in your company.
Activate existing event receiver links between triggering events and consuming workflow tasks.
Name a technical person responsible for each standard workflow template.

Project System (PS)

Helps you to plan, manage, control, and figure the cost of R&D projects, and so on. The common tasks revolve around allocation of people, resources, and money within the framework of schedule and task relationships.


1. Install the Remote SkillVantage Manager ( sap1 -> SETUP.exe )
2. Install the material ( sap1 -> INSTALL -> INSTALL.EXE )
3. Run the tutorial: logon and take the course which is installed before

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

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 MS Word 2013 & MS Access 2013 Video Training DVD Rs 350/-

Duration : 5h 9m


Released : Jan 29, 2013

Introduction1m 47s
Welcome 1m 7s  
Using the exercise files 40s  

1. Getting Started with Word 2013 - 29m 15s

• Launching Word and touring the interface 5m 37s  
• Opening, closing, and reading documents 4m 32s  
• Using the new bookmark feature 2m 19s  
• Creating new documents with templates 6m 5s  
• Saving documents 3m 41s  
• Opening and editing PDF documents 3m 5s  
• Printing documents 3m 56s  

2. Editing Text-18m 22s

• Inserting new text 2m 19s  
• Selecting text with the mouse or keyboard 2m 45s  
• Rearranging text with Cut, Copy, and Paste 4m 0s  
• Finding and replacing text 6m 13s  
• Undoing and redoing actions 3m 5s  

3. Formatting Text-19m 51s

• Introduction to fonts 5m 44s  
• Choosing the right font and font style 6m 37s  
• Changing text case 2m 27s  
• Adding pizzazz with special text effects 5m 3s  

4. Using Paragraph Formatting-21m 35s

• Changing paragraph alignment and justification 3m 32s  
• Adjusting line spacing 5m 39s  
• Keeping text together across page breaks 3m 29s  
• Applying paragraph shading and borders 3m 11s  
• Using tab stops and indents 5m 44s  

5. Formatting Pages-24m 36s

• Changing page size, margins, and orientation 6m 44s  
• Using headers, footers, and page numbers 7m 24s  
• Organizing a document with sections 4m 54s  
• Adding page backgrounds, borders, and watermarks 5m 34s  

6. Formatting Efficiently with Styles and Themes-18m 41s

• Applying a theme to a document 3m 38s  
• Applying Quick Styles to text 5m 48s  
• Creating your own Quick Styles 5m 15s  
• Restricting formatting to a selection of styles 4m 0s  

7. Creating Bulleted and Numbered Lists-15m 59s

• Creating a bulleted or numbered list 4m 42s  
• Changing the format of a bulleted or numbered list 4m 51s  
• Creating levels in a list 2m 40s  
• Creating a multilevel list with styles 3m 46s  

8. Working with Tables-32m 11s

• Creating new tables from scratch 4m 43s  
• Converting existing text to a table 2m 7s  
• Formatting table appearance 5m 17s  
• Using Quick Tables 2m 45s  
• Adding and removing columns and rows 3m 48s  
• Sorting data in a table 2m 27s  
• Merging and splitting cells 2m 55s  
• Converting a table to text 2m 28s  
• Inserting an Excel table 5m 41s  

9. Illustrating Your Documents-47m 54s

• Illustrating with pictures, shapes, and clip art 4m 37s  
• Positioning and cropping graphics 6m 24s  
• Using a table to organize text and graphics 5m 6s  
• Applying special effects to graphics 4m 4s  
• Adjusting photos in a document 5m 21s  
• Illustrating with WordArt 4m 32s  
• Inserting online video into a document 2m 30s  
• Diagraming with SmartArt 6m 49s  
• Inserting screenshots 2m 34s  
• Inserting a chart 5m 57s  

10. Using Macros and Building Blocks-19m 7s

• Creating a macro 3m 28s  
• Finding and running a macro 2m 56s  
• Editing a macro 2m 28s  
• What are building blocks? 4m 58s  
• Creating and saving Quick Parts 5m 17s  

11. Proofing Your Documents-13m 7s

• Checking spelling and grammar 4m 10s  
• Setting proofing and autocorrect options 4m 31s  
• Using the thesaurus, research, and translation tools 4m 26s  

12. Reviewing Documents with Others-15m 10s

• Inserting and reviewing comments 3m 23s  
• Tracking changes and showing markup 6m 58s  
• Comparing and combining documents 4m 49s  

13. Sharing Documents with Others-17m 44s

• Getting documents ready for sharing 5m 43s  
• Saving documents to SkyDrive 4m 15s  
• Sending documents via email 2m 24s  
• Password protecting a document 1m 49s  
• Restricting editing for part or all of a document 3m 33s  

14. Customizing Word-14m 5s

• Changing general settings 2m 42s  
• Changing advanced settings 4m 24s  
• Customizing the Ribbon 4m 17s  
• Customizing the Quick Access Toolbar 2m 42s  
• Conclusion24s
• What's next? 24s  

Microsoft Access 2013 Essential Training

Duration : 5h 4m 

Level : Beginner

Introduction 1m 47s

Welcome 1m 5s

Using the exercise files 42s

1. Getting Started 23m 43s

Key database concepts 4m 21s

Launching Access and the Backstage screen 1m 41s

Creating the database file 3m 25s

Understanding the Trust Center 3m 2s

Digging in to Ribbon tabs 3m 39s

Using the Navigation pane 3m 36s

Using the Quick Access Toolbar 1m 14s

Signing in to Microsoft Live 50s

Taking backups 47s

Accessing help 1m 8s

2. Creating Tables 23m 54s

Understanding table structure and relationships 4m 18s

Creating a table and setting data types 4m 15s

Entering data 4m 0s

Understanding primary and foreign keys 6m 24s

Importing tables 4m 57s

3. Setting Field Properties 29m 37s

Establishing relationships and maintaining referential integrity 6m 28s

Editing table structure in Design view 3m 58s

Controlling input with masks 5m 4s

Setting the default value 2m 15s

Establishing validation rules 3m 21s

Creating lookup fields 4m 29s

Setting additional field properties 4m 2s

4. Organizing Records 11m 3s

Formatting columns 2m 52s

Sorting table data 3m 18s

Filtering table data 2m 21s

Searching and replacing values 2m 32s

5. Using Queries 39m 35s

Understanding queries 2m 2s

Creating queries with the Simple Query Wizard 4m 24s

Building queries in Design view 4m 58s

Establishing constraints with criteria 4m 14s

Specifying criteria with wildcards 3m 50s

Leveraging multiple criteria with AND and OR statements 4m 32s

Filtering with mathematical comparisons 2m 20s

Creating flexible queries with parameter requests 3m 45s

Building expressions 5m 23s

Obtaining summary statistics 4m 7s

6. Working with Specialty Queries 19m 13s

Using update queries 3m 21s

Using make table queries 2m 57s

Using delete queries 2m 48s

Using append queries 2m 49s

Getting a different look with crosstab queries 2m 58s

Creating a union query in SQL view 4m 20s

7. Creating Forms 12m 47s

Understanding the role of forms 2m 52s

Generating forms from tables 3m 10s

Adjusting form elements in Layout view 4m 7s

Using the Form Wizard 2m 38s

8. Designing Forms 44m 23s

Creating forms in Design view 3m 50s

Exploring the form property sheet 3m 13s

Setting data sources 5m 39s

Adding components with form controls 6m 8s

Understanding input boxes 3m 31s

Recording navigation 2m 36s

Adding buttons 4m 18s

Assigning tab order 4m 5s

Checking out the More Forms options 7m 27s

Creating a navigation form 3m 36s

9. Creating Reports 32m 56s

Introducing reports 2m 15s

Using the Report Wizard 5m 9s

Creating a report in Design view 5m 20s

Grouping and sorting records 4m 5s

Creating calculated totals 3m 32s

Applying conditional formatting rules 5m 19s

Creating labels 4m 18s

Adjusting print settings 2m 58s

10. Working with Macros 25m 0s

Creating macros 5m 3s

Embedding macros into buttons 7m 50s

Attaching data macros to tables 9m 5s

Launching macros at startup 3m 2s

11. Integrating Access with the Office Suite 12m 12s

Exporting tables to Excel 3m 8s

Emailing with macros 4m 4s

Linking to data in an Outlook database 2m 18s

Setting up labels and mail-merge documents in Word 2m 42s

12. Maintaining the Database 27m 24s

Organizing the Navigation pane with custom groups 2m 59s

Compacting and repairing the database 1m 20s

Examining database object relationships 2m 58s

Documenting your work 4m 41s

Printing the blueprint of your database with the Database Documenter 2m 40s

Splitting a database into front and back ends 2m 34s

Protecting the database with a password 2m 55s

Creating custom Ribbon tabs 3m 35s

Setting startup options and custom icons

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

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