Home
Videos uploaded by user “TechTutorialVideo”
Excel Conditional Formating - Create your own rules - Complex Examples
 
07:14
Check my blog here: http://www.techtutorialvideo.com/ This is a tutorial about excel Conditional Formatting. In this tutorial I am going to show how to use your own formula to define Conditional Formatting. After watching this tutorial you should be able to apply special formatting to a single cell or to a range of cells based on condition/ values of other cells. Also you should be able to copy Conditional Formatting from one cell to others. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 649391 TechTutorialVideo
How to ZIP a File in Windows 7
 
03:59
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is about how to ZIP a file or Folder in Windows 7. We may need to ZIP a file/ folder in following situations: 1. Reduce size of a file or folder 2. Combine multiple files into one Check the video tutorial for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 60053 TechTutorialVideo
Samsung Galaxy Note 10.1 2014 Edition - MicroSDXC Memory Card - Install Remove and Format
 
04:36
Check my blog here: http://www.techtutorialvideo.com/ This is a demonstration of Samsung Galaxy Note 10.1 2014 Edition tablet to show you how to Install/ Insert, Format and Remove/ Unmount a 64GB SanDisk Ultra MicroSDXC UHS 1 memory card. In this video I also covered few more basic details of Secure Digital memory cards like: 1. Type of memory cards based on physical size - SD, MiniSD, MicroSD 2. Variants of memory cards based on capacity - SD, SDHC, SDXC. Explained the difference between SD, SDHC and SDXC. 3. Class of memory cards which drives speed of a memory card where speed indicates how quickly the memory card can perform read and write operation. 4. Ultra High Speed/ UHS technology. This is a complete guide for you if you are planning to purchase a memory card for your android JellyBean tablet Samsung Galaxy Note 10.1 2014 Edition. Hope this will help, check the video for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com) Some public domain images from http://en.wikipedia.org/wiki/ are used in this video. No copyright infringement intended. Links to various pictures are given below: http://en.wikipedia.org/wiki/File:Memory-card-comparison.jpg http://en.wikipedia.org/wiki/File:SD_Cards.svg http://en.wikipedia.org/wiki/File:SD-Logo.svg http://en.wikipedia.org/wiki/File:SDHC-Logo.svg http://en.wikipedia.org/wiki/File:SDXC.svg http://en.wikipedia.org/wiki/Sd_cards
Views: 59149 TechTutorialVideo
Windows 7 : Aero Shake and Aero Snap
 
03:34
Check my blog here: http://www.techtutorialvideo.com/ This video is about how to use Aero Shake and Aero Snap in Windows 7. Aero Shake is a Windows 7 feature to minimize open windows quickly to the task bar. The windows button and "D" on key board is used to minimize all open windows to the task bar where as Aero Shake is useful to minimize all windows except the one user wants to focus having a clean view to the window. On the other hand Aero Snap is useful to compare contents in 2 windows side by side easily. Using this feature, one window can be fixed nicely at the right half of the display and another one at the left half of the display for visual comparison. This tutorial will be helpful for someone who is new to Windows 7. These features can help you to save time while working with Windows 7. Check the video tutorial to find out details about Aero Shake and Aero Snap. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 7605 TechTutorialVideo
Excel Formula AVERAGE MAX MIN COUNT
 
05:40
Check my blog here: http://www.techtutorialvideo.com/ In this tutorial we will see how take average of a set of numbers, find out maximum number out of a set of numbers, find out minimum number out of a set of a numbers and count numbers. We can do these using some basic excel formula which are AVERAGE, MAX, MIN and COUNT. Check the video tutorial for more details about these formula. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 20394 TechTutorialVideo
Excel Formula SUBTRACT DIVIDE MULTIPLY
 
07:03
Check my blog here: http://www.techtutorialvideo.com/ In my last excel tutorial we talked about how to add numbers in excel; now in this tutorial we will see how subtract, divide and multiply in excel. These basic excel formulas are very simple but as usual they takes part in complex formulas. So it is important to know how these basic formulas works in excel. At high level these are topics covered in this tutorial: 1. Direct formula where operands are directly typed in the formula 2. Formula by reference, reference of cells are used with the formula to indicate operands 3. Subtraction 4. Division 5. Multiplication 6. How order of operation is used in excel Check the video tutorial for more details about above topics. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 144606 TechTutorialVideo
Excel - How to find cells having Conditional Formatting
 
05:06
Check my blog here: http://www.techtutorialvideo.com/ In my last excel tutorial we have seen how to use Conditional Formatting feature with some examples. Now in this one we are going to talk about how to find worksheets/ cells that are already having Conditional Formatting. For various reason, we may want to know if an excel worksheet or a range of cells having already defined Conditional Formatting. We may want to apply some basic formatting, want to add new Conditional Formatting or modify existing Conditional Formatting. One option is to use 'Find & Select' option another is to use 'Manage Rule' option from Conditional Formatting drop down. Check out the video tutorial for details of these two options. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 4854 TechTutorialVideo
How to UNZIP a File in Windows 7
 
02:38
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is about how to UNZIP a file or Folder in Windows 7. Check the video tutorial for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 73135 TechTutorialVideo
How to print screen on Windows 7
 
03:45
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is about how to print screen in Windows 7. These are the details covered in it: 1. When and why do we need to use print screen? 2. How to print an entire screen? 3. How to print an active window? Check the video tutorial for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 319231 TechTutorialVideo
Excel Formula IF and Nested IF
 
07:31
Check my blog here: http://www.techtutorialvideo.com/ This is a tutorial about excel function IF and nested IF. "IF" is one of the very commonly used important formula which can be used for simple calculation to very complex calculation. "IF" formula can be used within another "IF", which is called nested "IF". Also it can be used with other excel functions like AND, OR, MAX, MIN etc. Check the video tutorial for more details about "IF" formula in excel. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 28352 TechTutorialVideo
Windows 7 Recent Items ( How to delete history of recent documents )
 
04:57
Check my blog here: http://www.techtutorialvideo.com/ Recent Items are different files/ documents available from a quick list of the Start Menu. This is useful to locate a recently browsed file easily and we can avoid browsing the file through folder structure. Different topics that are covered in this tutorial are: 1. What is Recent Items? 2. Where is the Recent Items option located? 3. How to use Recent Item option? 4. Hide/ unhide the Recent Item option. 5. How to delete history of recent items in windows 7 Check this video tutorial for more details of Recent Items. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 245559 TechTutorialVideo
Temporary file folder in Windows 7 (disk cleanup/ delete temp files)
 
08:42
Check my blog here: http://www.techtutorialvideo.com/ If you are running out of disk space, your computer is running slow or responding late; first thing you may want to check is disk space used by different temporary folders. Sometime temporary folders grows up too much and takes multiple GB of size. So it is better to clean up temporary folders periodically. You can do this manually by your own or using different utilities. This tutorial will help you to understand what these temporary file folders are and how to clean them manually. Different topics that are covered in this tutorial are: 1. What is temporary file folder? 2. Why to delete Temporary files? 3. Is it safe to delete Temporary Files? 4. Different Temporary folders in Windows 7 5. Location of Windows Temporary folder 6. Location of Application Data Temporary folder 7. Location of Internet Temporary folder 8. How to delete temporary files 9. Other Options - utilities to delete temporary files like Disk Cleanup, CCleaner etc Check this video tutorial for more details of temporary file folder in Windows 7. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 385706 TechTutorialVideo
Excel - Alignment, Merge Unmerge & Wrap Text
 
10:27
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is to cover different commands available in the Alignment section under home tab of Microsoft Excel. Vertical alignment options top, center, bottom and horizontal alignment options left, center, rights are shown with example. Also use of wrap text, orientation, margin or indentation of data inside cell is covered. Another important thing that is covered in this tutorial in details is merge and unmerge cells. Difference between "Merge & Center", "Merge Across" and "Merge Cells" is explained clearly with easy example. Also at the end there is a "Tip Of The Session" showing how to quickly generate sequential numbers in Microsoft Excel. So check this video tutorial for details of Alignment, Merge Unmerge & Wrap Text in excel. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion.
Views: 196577 TechTutorialVideo
GIMP Tutorial - How to resize an image | Scale image
 
03:49
Check my blog here: http://www.techtutorialvideo.com/ This is a very basic photo editing tutorial covering how to resize/ scale an image using GIMP. Various options on the scale image window are explained. Check the video tutorial for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 24098 TechTutorialVideo
Excel Formula SUM ( How to add in Excel )
 
05:46
Check my blog here: http://www.techtutorialvideo.com/ In this tutorial it is described how to add numbers in Excel. An excel formula SUM is used to add numbers. Also there are two other ways are shown for addition in Microsoft Excel. At the end I have shown a common issue while adding numbers and the resolution for the same with a good example. Check the video tutorial for more details of Excel basic formula SUM(). If you have any question I will be happy to assist you. Please use the comment section to share your question, comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 17012 TechTutorialVideo
Excel - Format Cells Font and Borders
 
10:16
Check my blog here: http://www.techtutorialvideo.com/ This is another Microsoft Excel basic tutorial. In this tutorial we can learn about formatting cells using fonts and cell borders. Also at the end of the tutorial there is a useful excel tip. Formatting cells in Microsoft Excel is very important in order to show data in meaningful way and to provide better presentation. This tutorial will give us idea about how to work with fonts and borders. It shows one of the cool features of Microsoft Excel 2007 and 2010 where we can preview data before applying a font. It also includes how to work with customized cell borders, border colors and border styles along with all predefined borders. Some hot keys: Bold : CTRL + B Italic : CTRL + I Underline : CTRL + U So check this video tutorial for the details of font and borders for formatting a cell. If you have any question/ comment/ suggestion; please use the comment section to reach me.
Views: 8530 TechTutorialVideo
Windows 7 Aero Peek
 
02:58
Check my blog here: http://www.techtutorialvideo.com/ This video is about how to use Aero Peek in Windows 7. Aero Peek is a Windows 7 feature designed to improve your experience with interface when there are multiple windows open. It can save your time if you know how to use it. Aero Peek helps you to get to a specific open window or running application quickly by providing better visibility to what you have open and running. Check the video tutorial to find out details about Aero Peek in Windows 7 which includes Show Desktop, Quick View from task bar and 3D view of all windows. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 61765 TechTutorialVideo
Photoshop Brush in GIMP - How to Download and Install
 
07:02
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is about how to download free Photoshop brushes or free GIMP brushes and install in GIMP. This also provides information about various types of brushes in GIMP, usage of brushes, importance of brushes in GIMP, Photoshop or any other similar kind of photo editing software. Check the video tutorial for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 3687 TechTutorialVideo
How to crop an image in GIMP - Tutorial
 
07:00
Check my blog here: http://www.techtutorialvideo.com/ This is a very basic photo editing tutorial -- how to crop an image using GIMP. GIMP is open source software; so it is free and considered to be great free alternative to Adobe Photoshop. In this tutorial I have explained various crop option options in details with simple example. Various aspects discussed are: How to get to the crop tool Basics of crop Accurately positioning and resizing the crop area Crop units Guides Highlights Current layer only Allow growing Expand from center Fixed cropping options Auto Shrink Check the video tutorial for more details. If you have any question I will be happy to assist you. Please use the comment section to share your questions, comments and suggestions. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 6353 TechTutorialVideo
Excel Conditional Formating - Simple Examples
 
11:43
Check my blog here: http://www.techtutorialvideo.com/ This is a tutorial about excel Conditional Formatting. We will talk about what is Conditional Formatting, when to use it and then we will see some simple examples. Microsoft Excel is great tool which can handle tons of data but where you have so many data it is difficult to find some specific data quickly. Conditional Formatting is a very useful feature of excel which can help you in such cases by making your specific data stand out visually for easy and quick identification. Check the video tutorial for more details about Conditional Formatting in excel. If you have any question I will be happy to assist you. Please use the comment section below to share your question, comment and suggestion. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 2342 TechTutorialVideo
Excel - Number Format (Number, Currency, Accounting, Date Time, Percentage etc)
 
10:19
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is to talk about Number Format in Microsoft Excel. Different number format discussed about are General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific and Text. In this video, the difference between Currency and Accounting formatting is explained with a good example. Also there is a tip about how to convert numbers in text format for arithmetic calculations. Check this video tutorial for details of Number Format in excel. If you have any question I will be happy to assist you. Please use the comment section to share your question comment and suggestion.
Views: 36217 TechTutorialVideo
Top 5 free photo editing softwares
 
05:59
Check my blog here: http://www.techtutorialvideo.com/ Details of top 5 free photo editor software with features, pros and cons. Software covers in this video are GIMP, Paint.net, Picasa, Inkscape and Photoplus Starter Edition. Download Links: GIMP: http://www.gimp.org/downloads/ Paint.Net: http://www.getpaint.net/download.html Picasa: http://picasa.google.com/ Inkscape: http://inkscape.org/download/ Photoplus Starter Edition: http://www.serif.com/free-photo-editing-software/ (1) GIMP Features Customizable Interface like professional photo editors Layers and channels like Adobe Photoshop Capable of basic and advance photo editing, retouching, image creation and animations Plugin can be used to extend features All common image file formats supported Pros Free Adobe Photoshop alternative New features are added frequently GIMPshop is another version for Photoshop users Runs on Windows, Linux, Mac, Sun OpenSolaris, FreeBSD Cons Some features has bug (consider it's free!) A bit complicated for new users Less learning material (2) Paint.net Features Provides basic image editing features Provides reasonable range of effects Automatic update to fixes and new features Drawing tools available Layered editing Support popular file formats Pros Simple, intuitive, and innovative user interface Good performance Unlimited undo redo Cons No Dodge and Burn tools (3) Picasa Features Organize, search, manipulate and share picture in PC People recognition technology Provides most of basic image editing features and lots of effects Side by side editing Pros Simple and easy to use interface Cons Not for complex or professional image editing (4) Inkscape Features Free alternative for Adobe Illustrator Professional quality vector graphics software Drawing tools, node points, text tool Image creation with shape tool, 3d boxes, gradients, clones etc Image manipulation with transformations, path effects, styling, layers, filters etc Pros Good selection of drawing tools Runs on Windows, Mac, Linux Cons A bit complicated for new users (5) Photoplus Starter Edition Features Import and edit common image file formats Straighten photos and crop to common print sizes Repair old and damaged photos Remove red eye, smooth skin, whiten teeth and more Remove unwanted objects from pictures Adjust levels, curves, brightness, contrast and more Paint and blend with artistic brushes Pros User friendly interface Cons Very few effects are available with the free version Some other FREE photo editors Windows Live Photo Gallery PhotoScape PhotoFiltre CinePaint Pixia Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 293286 TechTutorialVideo
Excel - Cut Copy Paste Special Format Painter
 
12:26
Check my blog here: http://www.techtutorialvideo.com/ If you are following my tutorials then by now you have an idea about Microsoft Excel interface and templates. Now I am going to start with a series of tutorial to cover basic functions in Microsoft Excel. In this video I am talking about clipboard section under home tab on the ribbon which has functions like cut, copy, paste, paste special and format painter. I am sure that you already know about cut, copy and paste as this is a very common function of any kind of standard editor. In Microsoft Excel there some additional property of these functions. These additional properties could be useful and can save your time if you know how to use them. So check this video tutorial for the details of cut, copy, paste, paste special and format painter. If you have any question/ comment/ suggestion; please use the comment section.
Views: 9985 TechTutorialVideo
How to use Templates in Excel 2010
 
05:46
Check my blog here: http://www.techtutorialvideo.com/ Templates in Microsoft Excel can be used to eliminate repetitive work. Even if you use a template for one time only, it can save some of your time which you would have been spent on formatting tables, font, color, page set up for printing etc. So using templates you could be much more productive. Let's take an example: every month you need to take dump of your sales details and then you generate report of sales by product and by customer and then you take print of these reports. If you use a template which is preformatted for this job then only thing you have to do is take dump of sales details and put into the template. It will automatically generate all your report. Also the report is then ready for print also. So check the video tutorial below for details about how to use a template in Microsoft Excel. Use template, save time, be productive.
Views: 8384 TechTutorialVideo
What is Microsoft Excel and Use of Microsoft Excel
 
10:00
Check my blog here: http://www.techtutorialvideo.com/ This video is to provide an idea about Microsoft Excel to beginners. This will help people to understand capabilities of Microsoft Excel. The different way Microsoft Excel can be used is demonstrated with multiple examples.
Views: 7426 TechTutorialVideo
Excel - How to create Templates in Excel 2010
 
05:45
Check my blog here: http://www.techtutorialvideo.com/ In my last tutorial I talked about "how to use templates" in Microsoft Excel. Also I explained what is a template and why should we use templates. To recollect I would like to mention again that - templates in Microsoft Excel can be used to eliminate efforts for repetitive work and we should use templates to increase productivity of our excel work. In this tutorial I am going to show how to create an excel template. Once we have an excel work book ready to use as template, we have to save it as type "Excel Template (*.xltx)" or "Excel Macro-Enabled Template (*.xltm)". "Excel Macro-Enabled Template" is for a template having macros defined in it and for simple templates the option "Excel Template" can be used. Check the video tutorial for details about how to create a Template in Microsoft Excel. Use template, save time, be productive. http://techtutorialvideo.blogspot.com/
Views: 27005 TechTutorialVideo
Excel - Introduction to the Interface of Excel 2010
 
10:30
Check my blog here: http://www.techtutorialvideo.com/ This video provides an introduction to Microsoft Excel 2010 interface. This will be helpful for people who only worked with 2003 or earlier version and not familiar with 2007 or 2010 version. Beginners anyway will get a good overview of the Microsoft Excel 2010 interface from this video.
Views: 668 TechTutorialVideo
Hidden files folders in Windows
 
04:20
Check my blog here: http://www.techtutorialvideo.com/ This tutorial is about how to hide your secret folders or files in Windows. This could be useful if you want to show your computer to someone or someone is using your computer temporarily and you do not want to share your secret folders or files. There are freeware available in the market to do this using different technique. If you do not like to install any of those as some of those freeware may not be safe; there are 2 easy ways you can do it by yourself in Windows: 1. Use hidden folder and hide hidden folders 2. Hide folder name and use blank icon Check the video tutorial for details of these 2 options. If you know about any other way to do this, please use the comment section and share with everyone. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 728 TechTutorialVideo
2013 New YouTube One Channel Design - Template Download and Review
 
07:01
Check my blog here: http://www.techtutorialvideo.com/ In this video I am going to talk about the 2013 new YouTube One Channel design. Here I will share my understanding of the new design and various dimensions of the channel art. Also I would like to share the GIMP template I have created; so that you don't have to spend much time figuring out various dimensions. You can just take the template, change colors based on your need, add custom logo and save as an image to use as your 2013 new One Channel banner art. Download the "One Channel" banner template here: http://www.techtutorialvideo.com/2013-new-youtube-one-channel-design-template-download-and-review/ Dimensions of the channel art: • Desktop Min & Mobile (Safe Area): 1546x423 • Tablet: 1855x423 • Desktop Max: 2560x423 • TV: 2560x1440 Introduction: YouTube has made lots of change on the overall interface or channel design in last couple of years. Every time it happened, mostly users and publishers initially used to express mixed reaction. People get used to one specific design, now when they are given a new design, they are not used to it and they do not find things in the same way they used to find earlier. In such cases people used to criticize changed or absence of features in new design rather than appreciating various advantages and improvements in it. The same thing happened this time in the beginning of 2013 when this new YouTube One Channel design has released and given option to try it. I see many videos, comments, blogs are talking about this design that it is not good, they don't like it. There are many well-known YouTubers are still using the old design whereas many already using it. I recently switched to this new design. It took me some time to switch; not because I don't like it, it is because I didn't find enough time to figure out all these details and getting a channel art prepared. Now that I am here, let me share what I find and what I think about this design. Understanding: This 2013 new YouTube One Channel design is mainly focusing on following various aspects: • Providing same look and feel of channels across various types of devices like computer, mobile, tablet, television etc. In recent days where internet is access from smart phone, tablet or even from Smart TV has increased enormously. So this step towards the new ages I guess is necessary. • A better integration of channels with the YouTube main page. • More professional look of channels. • Providing more control with various new options for publishers to arrange their content on the channel. Let me highlight various sections of this new one channel design: • Left and right widgets are same as YouTube home page, your channel is in the middle. • On top of the channel there is a space for channel art. I will explain more details about this new channel art below. • Then the next section is for a featured video. This section has a new feature where you can set different view for people that are already subscribed to your channel. You can play a trailer of your channel for people that are not subscribed to your channel. • Then down below you can add various sections with various details like -- Recent Uploads, Specific Playlists, Popular Uploads, List of Playlists, Likes, Recent Posts, Recent Activities, Tags etc. Also these sections can be arranged horizontally or vertically. So what do you think about this one channel design? Please use the comment section to share your experience. Check the video for more details. Music courtesy of Kevin MacLeod (http://www.incompetech.com)
Views: 4259 TechTutorialVideo

Summary of brutus essay 11
Essay format apa style examples
Music in education essay quotes
Anu sarkar ap biology essay
Research paper on christian leadership