Search This Blog

Wednesday, September 11, 2013

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







No comments:

Post a Comment