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

Learning QuickBooks 2011 Video Tutorial DVD Rs 300/-

Training Welcome

introduction,welcome,

Ch1-Get Started 36:00

Ch1 Introduction
financial records,
Why Use QuickBooks?
accounting,bookkeeping,
What Is Accounting?
accounting,bookkeeping,
Start & Grow Business
new business,
EasyStep Interview
EasyStep Interview,new company file,company file-create,
ESI-Company Info
new company file,company file-create,company information,accountant,EasyStep Interview,
ESI-Password/Save
EasyStep Interview,new company file,company file-create,administrator,password,
ESI-Customize-I
new company file,company file-create,customize QuickBooks,preferences,accounts,EasyStep Interview,
ESI-Customize-II
new company file,company file-create,customize QuickBooks,preferences,EasyStep Interview,
ESI-Define Start Date
EasyStep Interview,new company file,company file-create,start date,accountant,
ESI-Using Accounts
EasyStep Interview,new company file,company file-create,add accounts,account-add,start date,bank account-opening balance,chart of accounts,
QB Setup-Intro
set up,new company,getting started,
QB Setup-Names
set up,new company,contacts,names,vendors,employees,customers,getting started,import contacts,import email,import e-mail,
QB Setup-Opening Bal.
set up,opening balances,enter opening balances,new company,getting started,
QB Setup-Items
set up,new company,items,products,services,getting started,
QB Setup-Bank Accts.
set up,new company,bank account,checking account,getting started,
QB Setup-Start Work
set up,new company,start working,Quick Start Center,new user,getting started,
Customize Home Pg-I
set up,new company,customize home page,home page,getting started,
Customize Home Pg-II
set up,new company,customize home page,home page,preferences,getting started,
New File-Finish
set up,setup,new company,list,modify lists,balance sheet,start date,opening balances,getting started,
Create New Company


Ch2-Orientation 24:00


Ch2 Introduction
interface,moving around,
Move Around-Home Pg
interface,moving around,home page,customize home page,employees,vendors,customers,
Move Around-Icon Bar
interface,moving around,Icon Bar,home page,centers,
Move Around-Centers
interface,moving around,centers,employees,customers,vendors,new transactions button,report center,home page,
Move Around-Menus
interface,moving around,menu,
What's on Screen-I
one window-view,multiple windows-view,title bar,drop-down list,clear button,QuickFill,
What's on Screen-II
clear button,revert,next button,previous button,save & close button,save & new button,
Lists-Intro
lists,center-based lists,menu-based lists,
List Types
lists,center-based lists,menu-based lists,customer center,customers,chart of accounts,
Names Lists-Intro
lists,center-based lists,customers,vendors,employees,other names list,W2s,1099s,subcontractor,
Names Lists-Rules-I
lists,center-based lists,customers,vendors,employees,W2s,1099s,subcontractor,customer center,vendor center,
Names Lists-Rules-II
lists,menu-based lists,other names list,vendor center,employee center,change type button,
Add Entry
lists,center-based lists,customer center,customers,QuickAdd,
Work with Centers

Ch3-Bookkeeping Basics 20:00

Ch3 Introduction
financial statements,chart of accounts,
Financial Statements
financial statements,chart of accounts,
Balance Sheet
balance sheet,financial statements,chart of accounts,assets,liabilities,equity,
Profit & Loss
profit and loss statement,income statement,financial statements,chart of accounts,income,expenses,cost of goods sold,
Account Types
account types,accounts,chart of accounts,accountant,assets,liabilities,income,expenses,cost of goods sold,equity,
Accounts-Add
accounts,opening balance-account,chart of accounts,balance sheet,financial statements,account-add,add accounts,
Subaccounts-Intro
subaccounts,accounts,chart of accounts,profit and loss statement,income statement,financial statements,
Subaccounts-Add
subaccounts,accounts,chart of accounts,account-add,add accounts,
Subaccounts-Shortcut
subaccounts,accounts,chart of accounts, 2
Collapse Reports
collapse report,expand report,accounts,subaccounts,reports,chart of accounts,
Add an Account

Ch4-Make Sales/Get Paid 29:00


Ch4 Introduction
customers,sales,
Items-Intro
items,
Understand Items-I
items,
Understand Items-II
Items,
Items-Add
items,
Billing/Invoicing-Intro
invoice,accounts receivable,sales receipt,
Invoice from Scratch
invoice,accounts receivable,items,
Print Invoices
invoice,print invoices,to be printed-invoice,Mastering QuickBooks-Level 1,additional learning,
Receiving Payments
receiving payments,accounts receivable,preferences,undeposited funds,
Make Deposits
deposit,make deposit,undeposited funds,
Open Invoice Report
open invoices,customer balances,reports,accounts receivable,
A/R Aging Summary
QuickZoom,a/r aging summary,reports,accounts receivable,
Customizing Forms
customize QuickBooks,
Create an Invoice

Ch5-Pay Bills/Checks 18:00


Ch5 Introduction
vendors,expenses,accounts payable,
Should You Track A/P?
accounts payable,bills,pay bills,enter bills,vendors,expenses,
Enter Bills
accounts payable,bills,enter bills,vendors,expenses,
Review Unpaid Bills
accounts payable,bills,enter bills,vendors,expenses,unpaid bills detail,reports,
Pay Bills
accounts payable,bills,pay bills,vendors,expenses,partial bill payments,checks,
Print Checks
checks,print checks,voucher checks,
Write Checks
checks,write checks,to be printed-checks,print checks,
Void vs. Delete Checks
void check,delete check,checks,
Void Check
void check,checks,
A/P Aging Summary
a/p aging summary,reports,accounts payable,
Void a Check

Ch6-Essential Tasks 23:00


Ch6 Introduction
reconciling,bank reconciliation,back up,
Reconcile Bank Acct.
reconciling,bank reconciliation,
Bank Rec.-Begin
reconciling,bank reconciliation,reconciliation beginning balance,
Bank Rec.-Continue
reconciling,bank reconciliation,clearing transactions,
Bank Rec.-Finish
reconciling,bank reconciliation,reconciliation detail report,reports,
Back Up-Why
back up,
Back Up-Intro
back up,qbb,qbw,verify data,
Back Up-I
back up,qbb,qbw,verify data,
Back Up-II
back up,qbb,qbw,verify data,
Consult Accountant
accountant,client-accountant agreement,Mastering Accounting Basics,additional learning,
Back Up File

Ch7-Manage Business 30:00


Ch7 Introduction
trends,balance sheet,profit and loss statement,variable expenses,analysis,reports,income statement,
Snapshot-Company
company snapshot,snapshot,interface,centers,
Snapshot-Pmts./Cust.
company snapshot,snapshot,interface,centers,payments,customer
Report Center
report center,reports,
Interpret Fin. Stmts.
balance sheet,profit and loss statement,analysis,reports,income statement,
Analyze Trends-I
balance sheet,analysis,trends,reports,
Analyze Trends-II
profit and loss statement,analysis,trends,reports,income statement,
Analyze Trends-III
sales,analysis,trends,sales by customer,sales by month,reports,
Variable Expenses
trends,analysis,profit and loss statement,variable expenses,expenses,percent of income,reports,income statement,
Interpret Graphs
graphs,reports,income & expense graph,analysis
Financial Ratios-Intro
financial ratios,reports,analysis,ratios,
Learning QuickBooks
Financial Ratios
financial ratios,reports,analysis,ratios,solvency,acid test,current ratio,return on equity,return on investment,gross profit,profit-gross margin,net profit margin,profit-net profit margin,Business Planning
budget,business plan,accountant,
Analyze Trends
Course Conclusion
evaluation,feedback,website,live seminar,additional learning,

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


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

Mastering Intuit QuickBooks Pro 2009 Video Tutorial DVD Rs 300/-

Description: This series will open your eyes to just how easy using QuickBooks® Pro® can be to manage, record and understand your company's finances. After watching this training, you will master QuickBooks software skills, as well as learn basic accounting concepts that will allow you to use QuickBooks efficiently and accurately to manage financial information. From creating a company file to tracking products, vendors, customers, assets and liabilities, along with building customized reports, this course allows you to master QuickBooks software so you can master your business.
Highlights

1. Learn how to create a company file and manage vendors, customers and products.
2. Get an overview of the Company Snapshot, a new QuickBooks feature that shares all key aspects of your business in one screen.
3. See how to enter vendors, customers, items, inventory and transactions as accurately as possible with as much detail as possible.
4. Learn how to secure your financial files, share QuickBooks files with multiple users and back them up in order to secure your data.
5. Discover how Centers work to provide easy access to an overview of or specific information for Vendors, Customers and Employees.

Chapter 1: QUICKBOOKS OVERVIEW (13 min)

1. QuickBooks Versions
2. Tour of the Interface

Chapter 2: THE COMPANY FILE (25 min)

1. Opening an Existing Company
2. Preparing to Set Up a New Company
3. Creating a New Company File

Chapter 3: THE CHART OF ACCOUNTS (24 min)

1. Accounting Primer
2. Adding New Accounts
3. Editing Accounts
4. Displaying & Adding Account Numbers

Chapter 4: PREFERENCES & SECURITY (21 min)

1. Customizing Preferences
2. Security Overview
3. Establishing Security

Chapter 5: COMPANY LISTS (17min)

1. Working with Lists
2. Organizing Lists

Chapter 6: IMPORTING DATA (23 min)

1. General Import Strategies
2. Installing the Conversion Tool
3. Starting the Conversion Tool
4. Importing from Microsoft® Excel®

Chapter 7: BANK ACCOUNTS (19 min)

1. Creating & Using Accounts
2. Writing Checks
3. Transferring Funds between Accounts

Chapter 8: SERVICES & INVENTORY (46 min)

1. Inventory Accounts Overview
2. Entering Products & Services
3. Working with the Vendor List
4. Ordering & Receiving Products
5. Making Inventory Adjustments
6. Returning Items to Vendors
7. Inventory Reports

Chapter 9: CUSTOMERS (16 min)

1. Adding Customers
2. Defining Jobs
3. Adding Custom Fields

Chapter 10: RECORDING SALES (29 min)

1. Making Cash Sales
2. Using Estimates
3. Working with Progressive Invoicing
4. Sending Invoices

Chapter 11: SALES ADJUSTMENTS & STATEMENTS (27 min)

1. Adjusting for Credits & Returns
2. Creating Credit Memos
3. Working with Finance Charges
4. Creating Statements

Chapter 12: CUSTOM SALES FORMS (30 min)

1. Customizing a Product Invoice
2. Using the Layout Designer & Downloading Templates
3. Assigning & Managing Templates

Chapter 13: ACCOUNTS RECEIVABLE (24 min)

1. Receiving Payments
2. Making Deposits
3. Streamlining Payments & Deposits
4. Viewing A/R Reports

Chapter 14: ACCOUNTS PAYABLE (16 min)

1. Entering Bills
2. Paying Bills

Chapter 15: SALES TAX (19 min)

1. Setting Up Sales Tax
2. Applying Sales Tax
3. Determining & Paying Sales Tax

Chapter 16: MANAGING EMPLOYEE DATA (33 min)

1. Getting Ready for Payroll
2. Setting Up Payroll
3. Adding Employees
4. Creating & Using Timesheets
5. Preparing Paychecks
6. Paying Payroll Liabilities

Chapter 17: CREDIT CARDS (08 min)

1. Creating Credit Card Accounts & Entering Charges
2. Reconciling & Paying Credit Card Accounts

Chapter 18: OTHER ENTRIES (16 min)

1. Assets & Depreciation
2. Creating Liability & Equity Accounts

Chapter 19: ONLINE BANKING (09 min)

1. Setting Up for Online Access
2. Working with Online Data

Chapter 20: SHARING INFORMATION (30 min)

1. Writing Letters
2. Synchronizing with Microsoft® Outlook®
3. Customizing & Sharing Reports
4. Working with an Accountant's Copy

Chapter 21: FINALIZING YOUR ACCOUNTING (23 min)

1. End of Year Activities
2. Preparing Forms & Closing Periods
3. Backing Up Data
4. Cleaning Up Company Data
5. 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

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

​