Search This Blog

Showing posts with label MS Office Tutorial. Show all posts
Showing posts with label MS Office Tutorial. Show all posts

Thursday, December 20, 2018

Mastering Office 365 Complete 16 masterclass Video Training Courses on 3 DVDs





Index of Courses

01_Office 2016 and Office 365 New Features 
Duration  : 47 minutes

02_Learning Office 365 
Duration  : 1 Hour 41 minutes

03_Office 365 - Word Essential Training 
Duration  : 2 Hour 36 minutes

04_Office 365 - Excel Essential Training 
Duration  : 2 Hours 4 minutes

05_Office 365 - PowerPoint Essential Training
Duration  : 2 Hours 17 minutes

06_Office 365 - Outlook Essential Training 
Duration  : 2 Hours 17 minutes

07_Office 365 - OneNote Essential Training 
Duration  : 3 Hours 46 minutes

08_Office 365 Publisher Essential Training 
Duration  : 4 Hours 19 minutes

09_Office 365 - Introduction to OneDrive for Business  
Duration  : 36 minutes

10_Preparing to Migrate to Office 365 
Duration  : 2 Hours 27 minutes

11_ Manage IT Projects With Office 365 
Duration  : 5 Hours 

12_Microsoft Office 365 70-346 
Duration : 5 Hours

13_Microsoft Office 365 Identities and Requirements 70-346 
Duration : 3.22 Hours

14_Migrating to Office 365 SharePoint Online 
Duration : 2.00 Hours

15_Enabling Office 365 [70-347] SharePoint Online Site Collections 
Duration : 2.43 Hours

16_Enabling Office 365 (70-347) Plan-Configure Skype for Business Online 
Duration : 1.10 Hours

Buy This Course DVD Now @







                                






Friday, September 21, 2018

Complete MS OFFICE 2016 Video Training Tutorial 20 Courses Combo Pack on 6 DVDs





Over all  MS OFFICE 2016 Course Duration : 70 Hours


01_Excel 2016  12 Course on 2 DVDs
Over all  Excell Course Duration : 37 Hours
01_Excel 2016 Essential Training
8 Hours 30 Minutes

02_Up and Running with Excel 2016
1 Hour 10 Minutes

03_Excel 2016  Advanced Formulas and Functions
6 Hours 18 Minutes

04_Excel 2016 - Financial Functions in Depth
2 Hours 30 Minutes

05_Process Modeling in Excel Using VBA
3 Hours 10 Minutes

06_ Excel 2016 for Windows and Mac Training
2 Hours 50 Minutes

DVD-02
07_ Excel 2016 - Pivot Tables in Depth

3 Hours 40 Minutes
08_Excel 2016 Intermediate & Advanced

09_Excel with Top Microsoft Excel Hacks
2 Hours

10_ Excel 2016 Tips and Tricks
5 Hours 50 Minutes

11_Essentials of Financial Analysis using MS Excel
1 Hour 30 Minutes

12_Viewing and Manipulating Data in Excel 2016
3 Hour 30 Minutes

02_MS WORD 2016 Essential Training
Duration:5h 41m 

03_MS Project 2016 Essential Training
Duration:5h 5m 58s

04_PowerPoint 2016 Essential Training
Duration:3h 1m 

05_Access 2016 Essential Training
Duration:6h 45m

06_OneNote 2016 Essential Training
Duration:3h 46m

07_Outlook 2016 Essential Training
Duration:2h 49m 26s

08_Publisher 2016 Essential Training
Duration:4h 18m 21s



Buy This Course DVD Now @







                        







Wednesday, September 12, 2018

MS Word 2016 Video Training Tutorials DVD



Duration 9 Hours

Word 2016 Essential Training 
Duration : 5:40

Introduction
Welcome
Using the exercise files

1. Getting Started with Word 2016
Launching Word and touring the interface
Opening, closing, and reading documents
Using the Tell Me tool
Creating new documents
Saving documents
Opening and editing PDF documents
Printing your documents

2. Editing Text
Inserting new text
the Selecting text with the mouse or keyboard
rearranging text with Cut, the Copy, and the Paste
Finding and Replacing text
Undoing and redoing the the actions

3. the formatting the text
Introduction to fonts directory
Changing font formatting
Changing text a case
Pizzazz with special Adding text effects

4. Using Paragraph Formatting
Changing paragraph alignment and justification
Adjusting line spacing
Keeping text together across page breaks
Applying paragraph shading and borders
Using tab stops and indents

5. Formatting Pages
Changing page size, margins, and orientation
Using headers, footers, and page numbering
Organizing a document with sections
Adding page backgrounds, borders, and watermarks

6. Formatting Efficiently with Styles and Themes
Applying themes and Quick Styles to a document
Creating styles and Quick Styles
The Navigation pane Using heading styles with
Creating your own themes and style sets
Restricting formatting to a selection of styles

7. Creating Bulleted Lists and Numbered
Creating bulleted lists and numbered
Editing and formatting lists
Creating a multilevel list styles with

8. Working with Columns and Tables
Putting text into columns
Creating new tables from scratch
Converting existing text to a table
Formatting table appearance
Adding and removing columns and rows
Merging, splitting, and sizing cells
Sorting data in a table
Converting a table to text
An Excel The table Inserting for the Calculations and charts

9. Illustrating Your the Documents
Illustrating with pictures and shapes
the Positioning, rotating, sizing and pictures
Wrapping text around graphics
Solution: Using a The table to Organize text and graphics
Applying special effects to graphics
Adjusting this photos in a document
Illustrating with the WordArt
a data chart Inserting
Diagramming with SmartArt
Inserting screenshots
Inserting online video into a document

10. Using Macros and building blocks
Creating and running a macro
Editing a macro
Using building blocks
Creating and saving Quick Parts

11.Your the Documents proofing
Setting proofing and autocorrect options
the Checking spelling and grammar
Solution: Using the thesaurus, research, and translation tools

12. Sharing the Documents Others Others with
the Getting the ready documents for sharing
Sending Software documents Via email
the Password Protecting a document
Saving and Collaborating on documents in the cloud is
Changing permissions access to files is and

13. reviewing the documents with Others Others
Inserting and reviewing comments The
Tracking changes and Showing markup
Accepting or Rejecting changes
Comparing and Combining documents

14. the Customizing a Word
Changing a Word default settings
The the Ribbon the Customizing
the Customizing the Toolbar the Access the Quick Conclusion the Next steps

Word 2016 Microsoft Office Expert (77-726) 
Duration : 2:13

00 - Introduction
the Welcome
for What to the know the before watching the this course the
Solution: Using the exercise Other files is
Preparing with Challenges

01 - the Microsoft of Office Specialist (the MOS) Expert Exam Overview Profile
the Types of the Microsoft of Office Specialist certifications
the Prepare for the test
Overview Profile: 2016 MOS Expert Exam format and learning objectives

02 - the Manage the document the options and the Settings
the Modify the existing the templates
the Copy styles, macros, and building blocks The documents or the templates to
the Compare and combine the multiple documents
Link to external content document
the Configure a Word options
the Track Changes and the manage comments The
Challenge: the Manage and this content share documents
Solution: the Manage and this content share documents

03 - Design the Advanced the Documents
the Find & the Replace using the special The characters, formatting, and styles
the Set advanced Page the Setup and the Layout options
Link text boxes
the Resolve style Conflicts using the paste options
the Create and modify paragraph and character styles
Challenge: the Advanced editing and formatting
Solution: the Advanced editing and formatting

04 - the Create the Advanced the References
the Mark, the create, and the update index entries
the Customize a The table of contents The
the Insert and modify the create a captions and figures The table of
the Add and modify custom The form fields and controls
The Create and the manage a mail The merge document
Challenge: the Advanced references
Solution: the Advanced references

05 - the Create the Custom a Word Elements
the Create and the manage the Quick Parts
the Create custom color sets, font sets, themes, and style sets
Utilize the global content standards
Challenge: the Advanced custom elements
Solution: Advanced custom elements

06 - Final Challenge
Challenge: Full-length MOS Expert sample for Word 2016
Solution: Full-length MOS Expert sample for Word 2016

07 - Conclusion
Next steps

Word 2016 Microsoft Office Specialist  (77-726) 
Duration : 3:48

00 - Introduction
Welcome
What to know before using this
exercise
Use the learning supports

01 - Microsoft Office Specialist (MOS)
Microsoft Office Specialist certifications
Prepare for the test and review learning objectives
Overview of the 2016 MOS exam format

02 - the Create and the Manage the Documents, Styles, and Properties has
the Create a new blank document and a new document from a: template
the Insert text from a file or external-source
the Modify page setup a
the Apply document themes and elements background Used
the Apply style and style sets
Insert hyperlinks and bookmarks
Use the Navigation pane
Customize Word options
Add document to the
document
Create a document
: Create a document

03 - Format Text, Paragraphs, and Sections
Cut, copy, and paste text
Replace text by using AutoCorrect
The characters special the Insert
the Format text with the Format Painter
the Set line and paragraph spacing property indentation and
the Format text in the multiple columns
the Insert page, section called, text wrapping, or column breaks
Challenge: the Insert text and the Paragraphs
Solution: the Insert text and the Paragraphs

04 - the Create the Tables and Lists
The Create a The table
the Modify a The table
the Create and modify a numbered or bulleted list
the Define a custom bullet The character
Challenge: the Create a The table
Solution: the Create a The table

05 - the Create and the Manage the References
the Insert and modify footnotes and Endnotes
the Insert and the update a standard The table of contents The
Challenge : the Create the reference and the manage the markers
Solution: the Create the reference and the manage the markers

06 - the Insert the Format and the Graphic Elements
the Insert shapes and pictures
the Format shapes and pictures and the add alt text
the Insert text boxes and the format
the Create and the format the SmartArt graphic The a
the Modify content of the SmartArt graphic The a
Challenge: the Insert graphic The elements and the add document objects
Solution: the Insert graphic The elements and the add document objects

07 - Practice Exam
Challenge: the length of Full-the MOS sample the exam for a Word 2016
Solution: Full-length MOS sample exam for Word 2016

08 - Conclusion
the Next Steps

Buy This Course DVD Now @







                    






Sunday, December 3, 2017

Master in MS Excel 2013 Video Training Tutorials on 3 DVDs





Duration 45 Hours

750 Video Lessons 

Project Files : Available

Excel Courses in DVDs

01_Learning Microsoft Excel 2013

02_Advanced MS Excel 2013 Training

03_Excel For Business Training Video

04_Advanced Formulas and Functions In Excel 2013

05_Excel - An Analytics Superhub

06_Excel 2013 Advanced Formatting Techniques

07_Excel 2013 Pivot Tables In Depth

08_Excel For Business Training Video

09_MS EXCEL 2013 MACROS IN DEPTH TUTORIAL

10_Excel Essential Training

11_Excel 2013 Power Shortcuts

12_Excel 2013 Tips and Tricks


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

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

Saturday, November 11, 2017

Learn MS PowerPoint 2016 Video Training Tutorial DVD



Overall Duration : 7:00 Hours
128 video Lessons
Exercise Files : Yes

PowerPoint 2016 Essential Training
Duration : 3:00 Hours
59 Video Lessons
01. Introduction
02. Navigating PowerPoint
03. Working with Presentations
04. Working with Slides
05. Adding Pictures to Slides
06. Adding Content to Slides
07. Adding Shapes, Diagrams, and Charts to Slides
08. Adding Video, Audio, and Animation to Slides
09. Preparing the Presentation
10. Delivering Your Presentation
11. Reusing and Sharing Presentations
12. Conclusion
Ex_Files_PowerPoint_2016_EssT

PowerPoint 2016 Power Shortcuts
Duration : 2:38 Hours
44 Video Lessons
1 - Introduction
2 - 1. Top Ten Tips
3 - 2. Manage Your PowerPoint Files
4 - 3. Customize the User Interface
5 - 4. Handy Keyboard and Mouse Shortcuts
6 - 5. Work with Text
7 - 6. Work with Media
8 - 7. Work with Objects and Animations
9 - 8. Share Presentations
10 - Conclusion
Ex_Files_PP_2016_Advanced_Tips.zip

PowerPoint 2016 Tips and Tricks
Duration : 1:30
25 Video Lessons
0. Introduction
1. Customize PowerPoint
2. Create and Edit Great Content
3. Work with Existing Content
4. Prepare for Your Presentation
5. Work with Excel Data in PowerPoint
6. Conclusion


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

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


Term

Saturday, September 16, 2017

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 
======================================================================

Term



Shipping Banner

Thursday, April 27, 2017

Advanced Microsoft Excel 2016 From Beginner 12 Course Tutorial Video Training on 2 DVDs Rs 650/-



Total Course : 12 on 2 DVDs
Over all Course Duration : 37 Hours

DVD-01

01_Excel 2016 Essential Training

8 Hours 30 Minutes

02_Up and Running with Excel 2016

1 Hour 10 Minutes

03_Excel 2016  Advanced Formulas and Functions

6 Hours 18 Minutes

04_Excel 2016 - Financial Functions in Depth

2 Hours 30 Minutes

05_Process Modeling in Excel Using VBA

3 Hours 10 Minutes

06_ Excel 2016 for Windows and Mac Training

2 Hours 50 Minutes

DVD-02

07_ Excel 2016 - Pivot Tables in Depth

3 Hours 40 Minutes

08_Excel 2016 Intermediate & Advanced

09_Excel with Top Microsoft Excel Hacks

2 Hours

10_ Excel 2016 Tips and Tricks

5 Hours 50 Minutes

11_Essentials of Financial Analysis using MS Excel

1 Hour 30 Minutes

12_Viewing and Manipulating Data in Excel 2016

3 Hour 30 Minutes


Buy Now 


   


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

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

Term


Shipping Banner