Home
Videos uploaded by user “Excel, Word and PowerPoint Tutorials from Howtech”
How to Create a Drop Down List in Word
 
01:10
In this video tutorial we will show you how to create a drop down list in Word. This tutorial is going to show you how to easily create a simple drop down list in Word. Step # 1 -- Accessing the Developer Tab First of all you are going to need to make the "Developer" tab visible. Click "File" and then "Options" and in the window that appears click "Customize Ribbon" from the tabs on the left. In the frame on the right check the box next to "Developer" and click "OK". You will now see that there is a "Developer" tab in the ribbon at the top of the program -- click on this. Step # 2 -- Creating the Drop Down Box One section of the developer tab reads "Controls" and within this there is an icon called "Drop-Down list Content Control", click this. Now click the "Properties" icon next to it and the "Content Control Properties" window will appear. Give a title to the drop down box. Step # 3 -- Adding Options to the Box Click the "Add" button further down the window and use this to enter an option for the drop down list. Click "OK" and repeat this procedure to add more options to the list, here we are just adding two more options. Finally click "OK" and the drop down box will have been completed and that is how to make a drop down list in Word. To test that it works, click on it and select one of the options.
How to Work with Excel Confidence Intervals
 
01:50
This tutorial will show you how to construct a confidence interval in Excel. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ A confidence interval is a useful data analysis tool in Excel, this tutorial will show you how to construct one. Step # 1 -- Accessing Data Analysis Start Excel and load the data that you want to create a confidence interval from. Here we have a column titled SMS, which indicates the number of text messages sent in a single day by a class of students. Click on the "Data" tab and on the right click on "Data Analysis". In the window select the "Descriptive Statistics" option and click "OK". Step # 2 -- Setting up the Data Analysis In the window that appears click on the "Input Range" box and click back to the spreadsheet and highlight all the data, including the column heading, here it contains 101 items, including the heading. Make sure "Columns" is selected and the "Labels in first row" box is checked. Click in the "Output Range" box and choose a cell on the spreadsheet where you want the analysed data to appear. Make sure "Summary Statistics" and "Confidence Level for Mean" are selected and set the percentage to whatever you want your confidence interval to be -- 95% works just fine for this example. Click "OK". Step # 3 -- Entering Additional Data New data will appear on the spreadsheet and widen the margins to make it easier to see. At the bottom you will see the "Confidence Level" which we can use to work out the upper and lower bounds of the confidence interval. Type "Lower Bound" and "Upper Bound" in two separate rows beneath the table. Step # 4 -- Completing the Process Next to "Lower Bound" enter an equation that subtracts the "Confidence Level" from the "Mean". Next to "Upper Bound" enter an equation to add the "Mean" to the "Confidence Level". The data indicates that we are 95% certain that the mean number of texts sent in a day by the class is between these two values and that is how to use excel confidence intervals.
How to Convert an Access Database to SQL Server
 
02:00
In this tutorial, we will learn how to convert an access database to SQL Server database. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this easy step by step tutorial, we will teach you how to convert Access database to SQL Server. SQL Server is a versatile database system being used world widely. Customers switching from their current database system to SQL Server face the issue of migrating data from existing system to the new database. Hence SQL Server facilitates this requirement to import data from several different sources. Step#1: SQL Server Migration Tool SQL Server provides a migration tool called SQL SERVER MIGRATION ASSISTANT to facilitate the customers to import data from different sources. You can download it from Microsoft's official website. Simply click on the download button and specify the location where you wish to save it. Next, extract and open up the setup file to begin the installation. Just follow the step by step procedure to install and the application. In case if it prompts you for the license key, you can easily download it for free by registering yourself to Microsoft. Step#2: Initializing Migration Process Once you open up the migration tool, a wizard will open up. Just hit next on the welcome screen and create a new project. Here you can name your project, specify the location and then choose the version of SQL SERVER you want to migrate the database to. In our case, we will convert Access to SQL Server 2008. Step#3: Adding Access Database To convert Access to SQL, we need to add the database here. Click the ADD DATABSE button and locate your database file. Press NEXT to continue. Step#4: Defining SQL Server Next, select the objects to migrate. For this tutorial, let's leave this to default and hit NEXT, since we will be migrating the whole database. In the next window, we will have to create a connection with the SQL SERVER. Provide the Server's name, which in this case will be local since it is installed on the same machine, and specify the database name. If you want to create a new database, just type its name over here and the wizard will automatically create it. Click on NEXT to continue. Step#5: Migrating Access Database The conversion process will begin, and it would take a few seconds for the processing to complete. Step#6: Verification of Data Migration Once completed, close the migration wizard and open up the SQL server. You will notice a new database has appeared over here. Expand the folder, right click on any of its table and choose the "select top 1000 rows" option to verify the contents of the database. Finally, we have successfully shown in this tutorial how to convert an access database to SQL Server database.
How to Create Drop Down List in Access
 
01:16
We will teach you how to set values for the drop down list. The users will be able to only choose between the options available in the list. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, we will teach you how to create drop-down list in Access. Drop down lists refer to drop down menus from which you can select one of the given options. In Access, you can create a dropdown list. Step 1 -- Open table in design view For the purpose of this tutorial, we will be using a pre-existing database. There are several tables in this database. Go to view and select the design view in order to view the back end of the table. Step 2 -- Lookup wizard Once the table opens up in design view, insert a new row. For the purpose of this tutorial, we will be creating a gender field. Here, we will select the lookup wizard as the data type for the field. Step 3 -- Type the values for the dropdown list As a result, the lookup wizard will appear on your screen. Select the second option that allows you to type in the values that you want in access' dropdown list. Click on the next button to proceed. Step 4 -- Complete the lookup wizard Now enter the items that you want in the drop down list. In this tutorial, we are creating a drop down list for gender, thus, we will type in male and female. Once you are done adding the list contents, click on the next button. Once you are done, click on the finish button to exit the wizard. Step 5 -- Save Changes Now go to the view drop down button and choose the datasheet view. You will be asked if you want to save the changes that you just made. Click on the yes button to save the changes. Step 6 -- Open table in datasheet view When the table will appear in datasheet view, you will see the gender field that you created. Click on it and you will be presented with a drop down list containing the male and female options that you have allowed for the respective field. In this manner, you can create a drop down lists in Access.
How to Create a Drop Down List in Excel 2016
 
01:15
In this HowTech written tutorial, we’re going to show you how to create a drop-down list in Excel 2016. Don't forget to check out our main channel https://www.youtube.com/c/HowTech for more free how-to videos! Join us on Facebook http://www.Facebook.com/howtechtv Our App http://bit.ly/how-tech We’ll first create a new Sheet by hitting the plus sign located in the bottom left of the screen. Within this second sheet, we’ll write out the list of options the user can choose within the drop-down list. The example will be numbered, so I will start by typing [Qtr 1] in the first cell. Then, move the cursor to the bottom right of the selected cell until the cursor changes and click and drag it down to however many you want. The list should automatically be numbered. Select the entire list and right-click it. Choose Define Name… Create a name for the list and remember it. Leave the Scope set to Workbook to allow the list to be used in different Sheets. Go back to Sheet 1 and select the first cell you want the drop-down list to be in. Go to the Data tab and click Data Validation. Open the drop-down Allow:, and choose List. In the Source area, type in the equals (=) sign followed by whatever you named your drop-down. Finally, hit OK. You should now have the option to open the drop-down list of the cell and choose one of the options. You can copy and paste this cell to other areas of the worksheet, and you can also move your cursor to the bottom right of the selected cell until it changes, and click and drag it to duplicate the contents to all selected cells. You should now have drop-down capabilities in affected cells. This is a HowTech tutorial, visit our website and watch our videos for more!
How to Create a Highlighting Search Box in Excel 2016
 
03:21
In this HowTech written tutorial, we’re going to show you how to create a highlighting search box in Excel 2016. Don't forget to check out our main channel https://www.youtube.com/c/HowTech for more free how-to videos! Join us on Facebook http://www.Facebook.com/howtechtv Our App http://bit.ly/how-tech Create the search box cell and optionally edit some characteristics. Under the Home tab, open the Conditional Formatting drop-down and click New Rule. Choose to use a formula to determine which cells to format. Use the SEARCH formula. The first argument will be a reference to the search box, then the columns of data. Use $A2 for example to start at A2 and down the column, and use & to concatenate another column on. “=SEARCH($J$3, $A2&B2&$C2)” for example. Click Format and choose a style. The search box should be working, but when it’s empty it triggers all the cells. To remedy this, go back to Conditional Formatting and click Manage Rules. Go under This Worksheet and click Edit Rule. Use an IF statement: “=IF(ISBLANK($J$3, 0, SEARCH(…)))”. This will return 0 if the cell is blank and return the SEARCH() formula if it isn’t. This is a HowTech tutorial, visit our website and watch our videos for more.
How to Insert Bookmark in Word
 
01:11
Learn how to insert multiple bookmarks in Word. Learn how to navigate from one bookmark to another and also how to delete them if need be. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, we will teach you how to insert a bookmark in Word. Bookmark in Word allows you to mark important headings. In a long document, you can make several bookmarks. For later review, you can simply go from one bookmark to another. This way you will never have to worry about which chapter you were on the last time you were reading. Step 1 -- Bookmark option Follow this step by step guide to learn how to insert a bookmark in Word. First of all, select the heading or the paragraph that you want to bookmark. Once you are done selecting, go to the insert tab and click on the bookmark option available under links.   Step 2 -- Add a bookmark As a result, the bookmark window will appear on your screen. Give the bookmark a name in this pop up window and then click on the add button.   Step 3 -- Show bookmarks Once you are done, click on the Microsoft office icon in the extreme top left corner of your screen. In the word options window, go to the advanced tab and scroll down to the show document content section. In this section, check the show bookmarks option and then click on the ok button to save the changes. You'd notice brackets will mark the area that you bookmarked.   Step 4 -- Add multiple bookmarks Bookmarks come in handy when you are working on a document that contains several pages. You can add several bookmarks so that you can identify these bookmarks easily for future reference. Step 5 -- Go-to another bookmark Once you have added several bookmarks, click on the bookmark option again and the window will show you all the bookmarks that you have. For the purpose of this tutorial, we only added three bookmarks. If you want to go to a particular bookmark, simply select it and then click on the go to button.   Step 6 -- Delete a bookmark If you want to delete a bookmark, simply select the bookmark and then click on the delete button. In this manner, you can insert a bookmark in Word.
How to Get Excel 2010 data analysis tool
 
01:03
Excel is a powerful tool but its usefulness can be expanded even further with the use of a data analysis tool Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial will show you how to get excel data analysis tool which can greatly expand the functionality of Excel. Step # 1 -- Open Options Start Excel and click on the "File" button in the top left hand corner. This will present you with a menu and you need to click on "Options". The "Excel Options" window will then load. Step # 2 -- Accessing Add-Ins Settings In this window you need to navigate to the "Add-Ins" option in the left hand menu. This will provide you with a list of all the available add ins for Excel. At the bottom there is a button called "Go...", click on this. This will open the "Add-Ins" window. Step # 3 -- Locating Data Analysis This window will give you several checkbox options. You need to click in the checkbox next to the "Analysis ToolPak" option then click "OK". That is essentially how to get excel data analysis tool and to access it you need to navigate to the "Data" tab and you will see a new box called "Analysis" and within it the "Data Analysis" option.
Table of Contents in PDF
 
02:04
In this video tutorial we will show you how to create an interactive table of contents for a PDF. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Creating a contents page for a PDF is not a default feature of Acrobat, but it is possible to create a table of contents in PDF using a few links. Step # 1 -- Creating the Non Interactive Table of Contents in Word Start Acrobat and open the document that you want to create a table of contents for. Now, open Microsoft Word and use this program to create a non-interactive version of the table of contents. Go through the PDF and make a note of all the headings in the Word document that you want to appear in your table of contents. Once you have done this save the Word document and make sure that you select the PDF option from the drop down box. Step # 2 -- Inserting the Contents Page to the Existing PDF Go to Acrobat and click the "Insert page from another file" icon at the top of the program. Locate the table we just created and click "Open". From the drop down box select "Before" then choose the first page and click "OK". You will now see that the table of contents has been added in front of the PDF document. Step # 3 -- Creating the Link Area Now we have to make the links on the contents page interactive. Click the "Tools" button in the top right of the program and then click the "Content Editing" tab that has appeared. Click the "Add or Edit Link" button and then draw a rectangle over the first title in the start menu you want to make a link. Set the "Link Type" to "Invisible Rectangle" and make sure that the "Link Action" is set to "Go to a page view". Click "Next". Step # 4 -- Completing the Links and Testing Them You now need to set the destination for the link. Visit the page you want it to link to and click "Set Link". You will need to repeat this process for all of the links in your contents page. In this example we'll just do the one and test it works. Save the PDF and close Acrobat, now, navigate to the file on your computer and open it. When you hover your mouse over the link you will notice that it is interactive, simply click to follow the link and that is how to create a table of contents in PDF.
How to Create Labels in Word 2013 Using an Excel Sheet
 
03:14
How to Create Labels in Word 2013 Using an Excel Sheet In this HowTech written tutorial, we’re going to show you how to create labels in Excel and print them out in Word. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ If you wanted name tags, IDs, or anything of the sort that can be made into labels, it’s handy to print them out at home onto special office sticker paper designed specifically for labels. To get started, open up Excel and in the column headers type in the categories of information to be shown In the following rows, type in the information that will differ from label to label When finished, save the Excel document in an easily accessible location Open up Word and go to the Mailings tab and hit Start Mail Merge, then click Labels Choose your product vendor and product number (they may be found on the packet in which the labels are enclosed in) Select Recipients, choose Use an Existing List, then select the Excel document you just made earlier, and finally hit OK Using the first label section, click Insert Merge Field and choose the field to show. Go ahead and finish inserting the last merge fields When finished, hit Update Labels. You may also Preview Results. When finished, hit Finish & Merge and choose the option that fits This is a HowTech tutorial, visit our website and see our videos for more!
How to Link Excel 2010 columns between worksheets
 
01:43
This tutorial will cover how to link a column in one worksheet to another in the same workbook in Excel Multiple worksheets in a single workbook is a useful feature of Excel, sometimes you need to link an entire column between worksheets. This tutorial will show you how to link excel columns between worksheets. Step # 1 -- Selecting the Column to be Linked Open the Excel workbook with the column that you want to transfer to another worksheet. You will need to highlight the entire column, do this by clicking the header of the column. Now you need to copy this, so right click and click "Copy". Step # 2 -- Choosing to Paste Special Now you need to navigate to the sheet where you will paste the column and link it to the original sheet. Here we are pasting it into "Sheet2". Highlight the column you want to link it to as before, here we are linking to column "A". Now right click and navigate to "Paste Special" then click on the "Paste Special" option. This will open a new window. Step # 3 -- Inserting the Data In the new window that has appeared click on the "Paste Link" button in the bottom left hand corner. This will insert the data into the new sheet and have it linked to the original. You will notice many zeros have appeared, to remove these highlight the column once again, right click on it and click "Format Cells", navigate to the "Custom" category and in the "Type" field enter "0;-0;;@", click "OK" and the window will disappear and so will the zeros. Step # 4 -- Confirming the Column Link Now, to check that the link has been successfully, change a value in the original sheet, "Cost Data". Here we are renaming "New Cup" to "Large Cactus", once done, navigate back to "Sheet2" and you will see that the data has been changed here as well and that is how to link excel columns between worksheets.
How to make Google Docs Questionnaire
 
01:39
This tutorial will show you how to create a questionnaire with Google Docs. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Google Docs (or Drive as it is now known) can be a powerful tool for getting opinions from people. This tutorial will show you how to make google docs questionnaire.   Step # 1 -- Creating a Form Make sure you are logged into your Google account and navigate to "www.drive.google.com". Click the "Create" button to the left of the page and in the menu that appears click the "Form" option. A new tab will open where you can create your form (which is essentially a questionnaire).   Step # 2 -- Naming the Form and Adding a Question Enter a name for the form and enter a description if you wish. Below this you can enter your first question in the "Question Title" box, you can select the type of answer required from the drop down box, such as "Text" or "Multiple choice". Click "Done" to add the question to your form.   Step # 3 -- Creating Additional Questions To add additional questions to the form click the "Add item" button in the top left of the window. In the drop down list, select the type of question you want to add, here we are adding a multiple choice question about age. You can enter some answer possibilities below -- in this case age ranges. Click "Done" to add the question.   Step # 4 -- Publishing the Form That is how to make google docs questionnaire and to get people to fill in the form you need to share the link that can be found at the bottom of the page in the black bar. To see the responses to the form, navigate back to the design page and click the "See responses" button in the top right, click "Summary" to get an overview of answers.
How to Create a PowerPoint 2010 Countdown Timer
 
02:32
Learn how to create a countdown timer in Microsoft PowerPoint. How to create a PowerPoint countdown timer. Launch Powerpoint and create two additional slides. Type the "Start slide" caption on the first slide and the "End slide" on the last one. Click on the empty slide and delete all the labels from it. Use the "Oval" tool to draw a big circle and a smaller one. To draw a circle instead of the oval, hold the "Shift" key while drawing. Use the "Quick styles" drop-down list to select the desired visual style for the big circle. Select the big circle, then go to the "Animation" tab and select the "Wheel" animation in the "Exit" section of the "Add animation" drop-down list. Select the "With previous" option from the "Start" drop-down list. Then set the "Duration" to the 5 seconds. Select the smaller circle and select the needed visual style. Then use the Ctrl-C and Ctrl-V keyboard shortcuts to make copies of the circle. You need 5 small circles in total for the 5 second timer. Type the labels on them from 5 down to 1. You should now select the "Disappear" animation type in the "Exit" section of the "Add animation" drop-down list for each of the smaller circles and choose "With previous" option from the "Start" drop-down list. In addition it is vital to set the "Delay" time for each of them. Circle "5" should have 1 second delay, circle "4" should have 2 second delay, and so on. When you are done, move all small circles to the center of the big one. Then align the resulting timer on the slide. Select the "Slide Show" tab and click on the "From Beginning" button to check the final result.
How to Create a Pivot Chart in Microsoft Access
 
01:31
Learn how to create and use a pivot chart in Access. Graphical presentation in the form of pivot chart is the best way to present your data. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Creating graphs and charts will give your data a more presentable look. It will be easier for the end user to analyze data presented in graphical form. Sometimes merely looking at numbers is not enough. A graphical image conveys the message better. In this tutorial, we will teach you how to create a pivot chart in Access. Step # 1 -- Creating pivot chart To create a pivot chart, click once on the product table. Then go to the "create" tab and click on the "more forms" button. From there, select the "pivot charts" option. Click on the "field list" button in the "show and hide" panel until a chart field list appears. Now drag the "products" field and drop it where it says "drop category fields here". Then drag "profit" and drop it where it says "drop data fields here". A bar graph will appear, showing you the breakdown of the profits of each type of tire. Step # 2 -- Adding calculation function Right click on the "sum of profit" bring your cursor to "auto calc" and select "average". Now you will be viewing average profit of the products. Step # 3 -- Changing field position Now drag "size" from the bottom and drop it at the top of the page where it says "drop filter fields here". At first no chart will be displayed. In order to see it, click on the "view" button and switch to "design view". Click again on the "view" button to toggle back and the chart will then be redrawn itself. Step # 4 -- Removing data from analysis You can view chart of a certain size as well. Simply click on the size button and select the size you want to view. Step # 5 -- Analyzing data You can also switch the fields; for example, drag the "size" down and "product" up to the filter. This chart shows you the tire size details. Creating graphs and charts in access is a little different from creating them in excel. Follow this tutorial and make a pivot chart in Access to better present your data.
How to make Excel 2007 Gantt Chart
 
03:22
Learn to make a gantt chart in Microsoft Excel Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to make excel gantt chart. In order to create gantt chart in excel, open your document. Select your data in the excel document. Go to the "insert" tab. Click on "Bar" and select "2-D Bar". Adjust the position and size of your chart. Right-click on "C2" cell and choose "Format cells". In the appeared window, go to "number" tab and choose "general" category. Then go to your "G9" cell, right-click on it and choose "Format cells". In the appeared window, go to the "number" tab and choose "general" category. Now select the data under the chart, right-click and choose "Format Axis". Select "fixed" to minimum and set the value to your C2 cell, in our example "41183". Also, select "fixed" to maximum and set the value to your G9 cell, in our example "41209". Change the "Major unit" to "Fixed" and set the value to "1". Then set the "Axis value" to "41183" in "vertical axis crosses" and press "ok". Now go to your "G9" cell and set "date" category in the "number" tab. Then change your data in "C2" cell the same way. Now select the data under the chart, right-click and choose "Format Axis". Go to the "Alignment" tab and set "custom angle" value to "-45". Then, go to the "Number" tab and set "date" category. Close the window. Right-click on left axis title and choose "Format axis". In the appeared window, check "categories in reverse order" in the "axis options" tab. Also set "horizontal axis crosses" to "At maximum category". Now, select a part of a column chart by clicking a mouse on it. Then, right-click on it and choose "Format Data Series". In the opened window go to the "Fill" tab and select "no fill". Then go to the "Border color" tab and set "no line". Select another part of a column chart by clicking on it. Right-click on it and choose "Format Data Series". In the opened window, go to the "Fill" tab and select "no fill". Then go to the "Border color" tab and set "no line". You can also adjust text size. Now all you have to do is to remove legend text, except the column part that left. Right-click on your chart and choose "move chart". In the move chart window select "new sheet" and name it "Gantt chart". Now your gantt chart is ready.
How to do Excel 2007 Mail Merge
 
02:02
Learn how to do excel mail merge Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to do excel mail merge. In order to merge mail, open the Microsoft Word document. Go to the "Mailings" tab. Click on "Start Mail Merge" and choose a "Step by step mail merge Wizard". In the 1-st step, choose "Letters" as type of the document and press "Next: Starting document". to do excel mail merge. In this step select "use the current document" and click "Next: Select recipients". To make selections in 3-rd step, minimize the word document and open your excel document. Go back to the word document and choose "Browse". Select your excel document and press "Open". In the appeared window select the table with data. In the following window check or uncheck mail merge recipients and click "ok". Then press "Next: Write your letter". In Step 4 -- go to the "Mailings" tab, click on "Insert Merge Field" and choose needed values. Insert it in your document. Next step is "Preview your letters", click on it. Now you can see your letter with merges. Click on "recipients" to see the results. Then click "Complete the merge". In the following window press "Edit individual letters". In the new window select "all" and click "ok". Now all your letters are placed on separate pages.
How to Link Excel 2010 formulas between worksheets
 
01:16
This tutorial will show you how to link a formula between two Excel worksheets Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Each Excel workbook has the option to create several worksheets, this tutorial will show you how to link excel formulas between worksheets. Step # 1 -- Load the Data and Navigate to a Different Sheet Start Excel with a sheet that has some basic information in it. Here we have a short table containing information about some items and their costs. We want to create a sum of this information in another sheet, therefore you need to navigate to "Sheet2" to enter the formula. Step # 2 -- Entering the Formula Select the cell where you want to enter the formula, in this case the cell is "A1". As we are adding the figures together we want to use the SUM formula. Type "=SUM(". Step # 3 -- Selecting the Data Now you need to navigate back to the first sheet, called "Cost Data" here, and select the values that you want to add together. In this case we are selecting the costs of various items, click and drag the mouse to select the data. Now click in the formula box and type ")" -- you can see in the formula that it has chosen to select data specifically from the "Cost Data" sheet -- press return. You will be automatically returned to "Sheet2" and can see that the formula in this sheet has summed the data from the first sheet and that is how to link excel formulas between worksheets.
How to Export Outlook 2010 Contacts to Excel 2010
 
01:30
Learn how to export Microsoft Outlook contacts to Microsoft Excel 2010. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to export outlook contacts to excel 2010. Launch Microsoft Outlook. Go to the "File" menu, press "Open" and choose "Import". In the following window, select "Export to a file" and press "Next". In the next window select "Microsoft Excel 97-2003" and press "Next". In the following window choose "Contacts" and press "Next". In the next window press "Browse" and then choose the destination to export and type the file name for your file. In the "export to a file" window, press "Next". In the following window press "Finish" to complete the export. Double-click on the saved Excel file with contacts. All your Outlook contacts were successfully exported to Excel.
How to Create Client-Editable PDFs in Acrobat X
 
01:31
Follow this tutorial to learn how to make your PDF editable in Acrobat X by creating text fields wherever you want text to be entered. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ If you have to send your files to a client, you will have to be sure that the file can be edited by the client for to make it easy for the both of you. Since Adobe PDF does not have a lot of tools that can be used to type in text and to make PDF editable you will have to make text fields in there to create editable pdfs. Step # 1 -- Click on the "edit" button Here we have a document which we want to be used by the client. To make the PDF editable, go to the "tools pane", click on the "Forms" tab and then click on the "Edit" option. A notification box will open, click on the "no" button. Step # 2 -- Select Text field On the right side of the screen under the "tasks" tab click on the "add new field" button and from the drop down menu select "text field". Step # 3 -- Click on All properties button Take your mouse to the area where you want to add the text field. Click and drag it to the point till where you want the text field. When you will let go of the mouse a small box will appear, click on the "all properties" button. Step # 4 -- Make some changes From the "options" tab you will be able to change the alignment. Make sure the "multi line" option is check marked. Go to the" general" tab and from there you will be able to set the name of the text field. Step # 5 -- Save the file Click on the "ok" button to exit the properties box. Click on the "preview" button which will appear in the ribbon bar. When you press the "highlight existing fields" option the field is shown to you. Save the file. Step # 6 -- Click on the close form editing button Click on the "edit" button to go back and select the "close form editing" option. This is an easy way to create editable PDF to help you in your work. Step # 7 -- Click on the "enable additional features" option To make PDF editable, go to the "file" menu and drop down to the "save as" option. From there click on "reader extended pfd" and then choose the "enable additional features" option. When the box opens, click on the "save now" button and select a location to save it. Now switch your window to Adobe reader in order to test it. When the file opens you will be able to write in the field that you had created. Once you are done click on the "save as" button from the "file" menu and save the file in pdf.
How to Generate Excel in Java
 
01:50
In this video tutorial we will learn a part of Java and Excel integration and see how to generate Excel in Java. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Microsoft excel is a very powerful spreadsheet program created by Microsoft, and is very widely used. It provides numerous functions in addition to programming capability through which users can develop their own functions and procedures. Excel can also be integrated with other programming languages to build powerful software applications. Follow this step by step easy tutorial to learn how to integrate Java and Excel and see how to generate Excel file in Java. Step 1 - Creating a new Java Project First of all, let's create a java project with a class. Step 2 - Downloading API To generate excel in java, we need the Jxl library which does the I/O operation of the excel files. To do that, let's open up sourceforge.net/projects/jexcelapi/files/jexcelapi/2.6.12 On that page, click on jexcelapi and download it. Step 3 - Importing the Library Once downloaded, the next step is to import the library to our project. For that, go to eclipse, move over to the file menu and click on import. Step 4 - Giving Import Source Select the File system directory here and click on next. Step 5 - Giving the Library Path Now let us locate the JXL library which we have just downloaded After locating the file, we have to select the jxl.jar file. Step 6 - Inserting Library into the project After that done we have to browse and select our project where we want to import the library. Step 7 - Adding build Path The excel java api has now been imported in our library. After that we have to right click on the Library icon, hover over to Build Path and click on the Add to Build Path option. Step 8 - Code After that, write the code in editor Now let's quickly go through the code. On the headers, we included the JXL library and its write functions. In the main method, first we created a writable Workbook object and initialized it with the createWorkbook method using the filename and the path where we want to save our file. Next we created a sheet in the excel file by using the createSheet method. Label constructor gets the position of the cell and the content of the cell, same as the Number constructor. The addCell method over here adds a label or number in the cell. And finally the write method writes the contents to the file. Step 9 - Debug Now let's run it and open up the location specified in the code. Step 10 - File generated And we can see that a new file has been created. And this is how java and excel can be integrated.
How to Compare Two Columns in Excel 2013
 
03:25
Don't forget to check out our site http://howtech.tv/ for more free how-to videos! In this HowTech written tutorial, we’re going to show you how to compare two columns in Excel. Especially when working with extensive, unwieldy columns, it may be necessary to compare them. Another example would be when working in a team, and you’re not entirely sure what the other person wrote down; so you want to check to make sure that there aren’t any repeats in the columns. First click an empty cell and type in the following Function: =IF(ISERROR(MATCH(A3,$C$3:$C$12,0)), “”, A3) The first A3 refers to the name to be tested against the $C$3:$C$12 selection of names. The second A3 refers to the value to output if there is a MATCH error. Change these values according to the setup of your Excel spreadsheet   Select the cell that the Function was typed in then go ahead and click and hold the bottom right hand handle of the cell and drag it down as many cells as are in the columns that you are comparing If there are any errors, they will show up in the corresponding row and showing the value or name that created the error This is a HowTech tutorial, visit our website and see our videos for more! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+
How to Redirect Outlook 2010 Emails to Another Email Address
 
01:51
Learn how to redirect emails to another email address in Microsoft Outlook. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to redirect outlook emails to another email address. Launch Microsoft Outlook. In the "Home" tab, click on "Rules" and in the popup menu choose "Manage Rules & Alerts". In the following window, press "New rule". In the "Rules Wizard" window select "Apply rule on messages I receive" and press "Next". In the next window, check "sent only to me" and "where my name is in the To or Cc box" options, then press "Next". In the following window, check "forward it to people or public group". When it's done, click on "people or public group". In the next window, select the e-mail address where you want to redirect your messages and press "To -". If you need, you can add a few email addresses, and then press "Ok". In the "Rules Wizard" window, press "Next". In the next window, if you don't need any exceptions in your rule, press "next" again. In the following window, enter a name for your rule and then press "Finish". To launch the rule, press "Apply" and then press "Ok".
How to Create an Outlook 2010 Calendar Invite
 
01:22
Learn how to create calendar invite in the Microsoft Outlook. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to create an outlook calendar invite. Launch Microsoft Outlook. Click on the "New Items" in the main Outlook window, and in the popup menu select "Meeting". In the following window, enter a "Subject" you want and "Location". Select the meeting "Start time" and "end time" or check the "All day event" option, if it's planned to be an all-day event. Then, click "Scheduling". In the following window, click "Add others" and in the popup menu, choose "Add from Address Book". In the next window, select the "Required", "Optional" and "Resources" person emails. When it's done, press "Ok". To send the meeting invitations, go back to the "Appointment" window and then, press "Send". If the meeting is soon enough, a reminder will let you know about it.
How to Import Outlook 2010 Distribution List into Excel
 
01:34
Learn how to import Microsoft Outlook distribution list into Microsoft Excel. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to import outlook distribution list into excel. Launch the Microsoft Outlook. Go to "Contacts". Select the distribution list you want to export. Go to the "File" menu and choose "Save As". Choose the folder to save the file, then select "Text only" in "Save as type" and then press "Save". Close Outlook. Launch Microsoft Excel. Go to the "File" menu and choose "Open". In the following window, go to the folder where the imported file is, choose "All files" type, then select the file and press "Open". In the following "Text import Wizard" window, choose the "Delimited" file type. You can also choose the row to start at. When it's done, press "Next". In the step2 window, go with the defaults and press "next". In the step3 window, press "Finish" to complete the import. Now you can see the imported data.
How to Import Outlook 2010 Calendar to Google Calendar
 
02:09
Learn how to import Microsoft Outlook calendar to Google calendar. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to import outlook calendar to google calendar. Launch Microsoft Outlook. Go to the "File" menu, press "Open" and choose "Import". In the following window, select "Export to a file" and press "Next". In the next window select "Comma Separated Values (Windows)" and press "Next". In the following window choose "Calendar" and press "Next". In the next window press "Browse" and then choose the destination to export and type the file name for your file. In the "export to a file" window, press "Next". In the following window press "Finish" to complete the export. In appeared window set the data range of the calendar to export and press "Ok". Close Microsoft Outlook. Launch your web browser. Type "calendar.google.com". On the following web page sign in with your google email and password. On the next web page, press on the "gear" icon and choose "Settings". On the following web page, click on "Calendars". On the next web page, press "Import calendar". In appeared window, press "Browse" and select the file to import. When it's done, press "Import". In the following window press "Close". Press "Back to calendar". Now you can see your newly imported event in your google calendar.
How to Move the Outlook 2010 Data File
 
02:12
Learn how to find and move Microsoft Outlook data file. In this video tutorial we will show you how to move the outlook data file. Go to the Windows "Start" menu and choose "Control panel". In the following window, press "User Accounts and Family Safety". In the next window, choose "Mail". In the following window, press "Data Files". In the next window, select the account you wish to edit and press "Open File Location". In the following window, right-click on the data file that you want to move and choose "Cut". Then, paste the file where you want it. Close the window. Double-click on the account in the "account settings" window. In the appeared warning window you will see the message, "that data file cannot be found". Press "Ok". In the following window, choose the file location where you moved the data file and press "Open". In next window, press "Ok". You can also move your other data file, if you have a few accounts. Select another account and then press "Open File Location". In the following window, right-click on the data file that you want to move and choose "Cut". Paste the file where you want it. Double-click on the moved data file account. In the warning window, press "Ok". In the next window, go to the location of the moved data file, select it and press "Open". In the next window, press "Ok". Now you know how to move your Outlook data files.
How to Reset Microsoft Access Autonumber
 
01:19
In this tutorial, we will show you how to reset the Microsoft access auto number field. Follow this step by step guide to reset the autonumber field in ms access and type in the numbers manually. The Microsoft access can be accessed from the web for others to see and make alterations. Microsoft access is very handy database that provides you multiple options to customize your database. You can upload access database to web so that you can make changes from anywhere you are. Step 1 -- Removing auto-number field Consider the sample data shown in the table over here. This table contains an ID column which is an auto number field. If we remove any rows from here, you would notice that the autonumber fields will not be re-numbered. Furthermore, the autonumber assigned to that particular deleted record will not be utilized anywhere else. So, if we remove the recently added field here and add a new record, you can see that a new number has been assigned to the filed, and the ID column is completely out of order. Step 2 -- Removing the primary key To start with, we will first remove the primary key constraint from this particular field. Without doing this, the column cannot be removed from the database. For that, right click on the Table's tab and choose the Design View option. Step 3 -- Turning off primary key option Here you will observe a small key icon is being displayed against the ID column on the left side. Just click on it and choose the primary key option from the menu. Step 4 -- deleting the selected field With that done, let's delete the ID field for now. With that taken care of, let's insert a new row over here and set it's its Data type as Auto number. Once you switch back to the data sheet view, you will observe that the autonumber filed has been re-numbered.
How to Apply a Page Background in Word 2016
 
02:27
In this HowTech written tutorial, we’re going to show you how to apply a page background in Word 2016. Don't forget to check out our main channel https://www.youtube.com/c/HowTech for more free how-to videos! Join us on Facebook http://www.Facebook.com/howtechtv Our App http://bit.ly/how-tech We will first show you how to change the page background in the viewer (without applying it to the printed page). This method doesn’t allow for the background to be printed out. If you want to be able to print with the background, skip forward to look at our workaround using the Header. To change the color of the background, go under the Design tab on the ribbon and open the Page Color dropdown menu. If you want more options, click Fill Effects… to add a gradient, texture, or picture. To add a picture as the background, go under the Picture tab and hit Select Picture… Finally, hit OK. As you can see, even though the image was the proper aspect ratio and resolution for the background, Word tiles the image. Furthermore, this background will not print, as shown by the blank page in the Print Preview. To remove the page background, go back to the Page Color dropdown and click No Color. To actually print the background, we must use a workaround. First double-click on the Header area to edit it, or go to Insert - Header - Edit. Then hit Insert - Pictures. To make sure the image is the right size, right-click the image and select Size and Position… Type in the dimensions of your paper (default is 11”x8.5”) or set the Scale to 99% or 100%. Right-click the image again and mouse over Wrap Text and select Behind Text. Left-click and hold on the image, then move it until it is centered on the page as shown when the green guidelines show up. Under File - Print, or Ctrl+P, we can see a white border in the print preview. This is because printers simply cannot print that close to the edge of the page. This is a HowTech tutorial, visit our website for more!
How to Auto Forward Mails to Gmail from Outlook
 
01:50
In this video tutorial you are going learn how to auto forward outlook emails to Gmail. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial will show you how to forward emails from Outlook to Gmail. Step # 1 -- Accessing Rules & Alerts First, open Outlook. We are going to need to create a rule that will allow us to forward this mail to a Gmail account. Make sure you are in the "Home" tab then click on the "Rules" icon then "Manage Rules & Alerts". The "Rules & Alerts" window will open. Step # 2 -- Starting to Create the Forwarding Rule Click the "New Rule" button and in the new window that appears choose the "Apply rule on message I receive" option and click "Next". Check the "through the specified account" option and at the bottom of the window click the "specified" blue link. In the window select the account you want to forward emails from and click "OK". Step # 3 -- Entering the Address to Forward Mail To Click "Next". Now check the option "forward it to people or public group" and click the blue link at the bottom which reads "people or public group". In the new window at the bottom enter the Gmail address that you want to forward the email to and click "OK". Click "Next" twice. Step # 4 -- Testing the Forwarding Rule Enter a name for the rule, here we are just calling it "Forwarding rule". Click "Finish" then "OK". This sets up our auto forward outlook rule, all we need to do now is test it out. Let's go to a different email and send our Outlook email a message. To make things easy to see here we will send the message from the address we have set up Outlook to forward to. This means once we have sent the message it should appear back in our Gmail inbox here shortly. Send the message. Wait a couple of moments and hit the check email button and you should see the email you just sent appear in your inbox, forwarded from the Outlook email.
How to apply date controls in data validation in Excel
 
01:59
Follow this step by step tutorial to learn how to apply date, time or custom controls in Data Validation in Microsoft Excel Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. Data Validation in Excel can help create criteria for specific results. Date Data Validation is a way of bringing output as per your set rules. There are options of Time or Custom Data Validation too. Follow this step by step tutorial to learn how to apply date controls in Data Validation in Excel. Step # 1 -- Select 'Data Validation' First of all, select the entire column and move to the "Data Tools" section in the ribbon on top. From there, select the "Data Validation" in Excel. Step # 2 -- Enter Dates Once the "Data Validation" window opens up, choose "Date" for the "Allow" option. Now enter the "Start date" and the "End date" and click on the "OK" button to complete the Date Data Validation. Step # 3 -- Enter Reminder in 'Input Message' Open up the "Data Validation" button again and move over to the "Input Message" tab. Over here you can add a reminder so that a message is displayed every time you hover over the cell or column. Step # 4 -- Enter Time data Once again go to the "Data Validation" window and this time select "Time" instead of "Date" for the "Allow" option. Enter the "Start Time" and the "End time". We have entered 9 hours for the start time and 20 hours for the end time. What this means is that any time before nine am and any time after eight pm can't be entered in the sheet. Press the "OK" button and try entering random values in the column. Step # 5 -- Use the Custom data option In column "F" we have "Receiving Dates". Let's suppose it takes at least two days for the goods to be shipped so we want to enter a function which will only allow such values to be entered which are two days after the shipping date. The procedure is the same however this time instead of choosing "Date" or "Time" we will select "Custom" and then write in a "Formula". For that, type: =f1 more than e1+2 Once done, click on the "OK" button. Now if you try to enter a date which is less than two days from the shipping date, it won't be entered.
How to Share a Workbook and Track Changes in Excel
 
01:40
Learn how to share a workbook with other users and track the changes others make to it. Highlight the changes, accept or reject them accordingly. Many users avail the share features in Excel. In Excel, one can share workbook with other users. In this tutorial, we will teach you how to track changes these other users make in your Excel workbook. Highlight these changes, review them and then decide whether you want to accept or reject the changes. In this tutorial, we will teach you how to share workbook and track changes in Excel. Step # 1 -- Share Workbook Option First of all go to the "Review" tab and from the "changes" group select the "share workbook" button. When the "Share Workbook" box opens, click the checkbox which allows changes by more than one user and then click on "ok". You will notice that "Shared" will be written with your workbook's name and in this way, you can share excel workbooks with other users. If you want to revert to the old settings, click on the "share workbook" button again and this time uncheck the box and click "ok". Step # 2 -- Share with track changes When you share a workbook you basically allow people to make changes to it. In order to track the changes that people make to it, go to the "protect and share workbook" button and click it open. In the new window, click on the "sharing with track changes" check box and then press the "ok" button. Step # 3 -- Highlight the changes Now make some changes to the sheet. Once done, go to the "track changes" button and select the "highlight changes" option from the dropdown menu. From the "highlight changes" box, click on the checkbox of "Who" and press "ok". The cells in which changes were made will be highlighted. Step # 4 -- Accept or Reject the tracked changes Go back to the "track changes" button and this time click on the "accept/reject changes" option. When a small box opens, click on the "ok" button. When the other box opens, you will be able to see who made the change and at what time. A description regarding the change will also be provided. You can click on the "accept" button and accept the changes one by one or click on the "accept all" button to accept all the changes at once. If you want to unprotect the changes, simply click on the "Unprotect Shared Workbook" button located under the "Review" tab.
How to Make a Quiz in Excel 2013
 
03:20
In this HowTech written tutorial, we’re going to show you how to make a quiz in Excel. Creating a virtual test or quiz can allow for a great deal of freedom and ease-of-use. Or if you simply wanted to save paper, creating a virtual quiz is a good choice. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ To get started, you will need two sheets. One for the actual test and one for the score. To create a new sheet, click the (+) button near the bottom left-hand corner. To rename it, double-click the default text and type the name On the Test sheet, you will need designated areas to have the Score sheet check After doing so, head over to the Score sheet and type in the answers in one column. In the next column over, type in the following Function: =IF(Test!B15=Score!B2, “Correct”, “Incorrect”) Test! refers to the sheet that the test is on and Score! Is the score sheet. B15 refers to the cell that the student places the answer in on the Test sheet. B2 refers to the answer on the Score sheet. When finished, click and drag the bottom right handle of the cell with the Function to encompass all the rows in the Score sheet that have answers. You will probably notice that it is not referencing the correct cell anymore on the Test sheet. Simply change B15 to the next answer cell (in this case it is B26) To automatically create a score depending on how many answers are correct, use the following Function: =COUNTIF(C2:C6, “Correct”) * 5 & “ Pts”. C2:C6 refer to the cells with the =IF function. The output in this case will be “10 Pts” because each Correct is worth 1 point * 5 with the concatenated “ Pts”. Select the columns with elements on the Score sheet, right-click the letter axis at the top and click Hide (to Unhide, press [Ctrl+A] to select everything, then right-click the letter axis and click Unhide) Right-click the Score sheet and click Protect Sheet. Uncheck all boxes, then type in a password and retype the password (to Unprotect simply right-click the sheet, click Unprotect, then type in the password). This is a HowTech tutorial, visit our website and see our videos for more!
How to Insert Excel Charts and Spreadsheets in PowerPoint 2016
 
01:32
In this HowTech tutorial, we’re going to show you how to insert Excel charts and spreadsheets in PowerPoint 2016. To get started, go under the Insert tab, open the Table drop-down, and select Excel Spreadsheet. This is how to insert a blank Excel spreadsheet interface. The spreadsheet should pop up. You can edit the handles to scale it. To insert a pre-made spreadsheet, click Object under the Insert tab, Create from file, and Browse for your file. When you have your file, click OK. To edit the newly inserted spreadsheet, double-click it. To insert a chart by itself, you can simply copy and paste it in from an Excel spreadsheet. Under the (Ctrl) menu, you can choose to insert it as a link, as a picture, etc.
How to Link Excel 2010 Worksheet to Another Workbook
 
01:32
This tutorial will show you how to link an Excel worksheet to a workbook Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ If you are managing a lot of data, linking a sheet from one workbook to another can be a valuable skill, this tutorial will show you how to link excel worksheet to another workbook. Step # 1 -- Copying the Desired Data Start Excel with the sheet loaded that contains the information that you want to link to a new workbook. Here you can see that we have some information about items prices. You need to copy this data, highlighting anything that you want to link to you new workbook and right click and choose "Copy". Step # 2 -- Choosing to Paste Special Now you need to create a new workbook. Click on "File" and then "New", double-click the "Blank workbook" option. This will open a new workbook in a new window, right now it has no links to the previous workbook. Right click where you want to paste the data, here in cell "A1", navigate to "Paste Special..." and click on the next "Paste Special..." button. Step # 3 -- Pasting the Data with a Link The "Paste Special" window will appear and in the bottom left hand corner you will see a "Paste Link" button, click this. The data from the other sheet will appear. To make sure that the link between the worksheet and the new workbook has been successful, navigate to the previous workbook and change the data. Here we will change the price of a cactus to $50. Navigate back to the new workbook and you can see that the data here has changed as well and that is how to link excel worksheet to another workbook.
How to Redact in Adobe Acrobat
 
01:30
Follow this step by step tutorial to learn how to Redact using different Redaction tools in Adobe Acrobat. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Adobe Acrobat provides with various tools for review and editing of documents, form, tables etc. as a Portable Document Format (PDF). It is an effective way of presenting information in a fixed form close to its publishing results. You can also hide text in Adobe by review this tutorial that tells you how to redact in Adobe. There are a series of tools available that are meant for Redaction in Adobe such as the Redaction properties and Search & Remove text. Follow this step by step tutorial to learn how to redact in Adobe. Step # 1 -- Select 'Mark for Redaction' In case you have to share a document that contains personal information, for example email addresses that you do not want to share. You can hide such content in the document by learning how to redact in Adobe. To do that, you will have to use the redact feature. To begin, open the "Tools" pane and click on the "Protection" tab. From the drop down menu, select "Mark for Redaction". Now move the cursor and select the content in the document which you want to protect. Step # 2 -- Apply Redaction Once done, the text will be covered with a border. If you hover over the text now, you can preview how the document will look like after you apply redaction. Step # 3 -- Change Redaction Area Fill Color Next, click on the "Redaction Properties" option. Here you can alter the settings according to your requirements. Let's change the "Redacted Area Fill Color" to white. Now when you hover over the redacted text, it will fill the selection with white color. Step # 4 -- Select Apply Redaction Redaction in Adobe also includes redaction of images and can be redacted in a similar way. Once the area is selected, you can click on the "Apply Redaction" button located towards the right side. Step # 5 -- Select 'Search & Remove Text' If you are working on a large document, you can click on the "Search & Remove Text" option in the "Properties" tab under the "Tools" task pane to search for the text. A window will open towards the left side of your screen and from there you can search for dates, email address, card numbers etc. After the search is complete, you can redact the text according to your requirements. Step # 6 -- Click 'Revert' If you want to reverse any changes made to the document, click on the "File" menu and select the "Revert" option.
How to add Excel 2007 Combo Box
 
01:07
Learn how to create a combo box in Microsoft Excel Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to add Excel combo box. In order to add excel combo box, open the Microsoft Excel. For example, select B5 cell and type "name". Go to the "Developer" tab, click "Insert" and choose "combo box". Select an area where you want place the "combo box". Go to "Sheet2" and type names. Go back to "sheet1" and click on "Properties" of the combo box. In the following window, choose the "Control" tab and click on "input range". Go to the "sheet2" and select cells with names. Then, choose "cell link" and press "ok". Now, when selecting names in combo box, numbers will be shown in chosen link.
How to Explore the Analysis Toolpak in Excel
 
01:39
Follow this tutorial and learn how to work with the options present under Analysis Toolpak such as correlation and moving average. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, we will teach you how to explore the analysis toolpak in Excel. First of all, we will show you how to enable Analysis toolpak. Once the toolpak has been enabled, we will show you how to work with it. Under data analysis, you will find several options. We will show you how to work with two of them in this video; correlation and moving average. We will show you how to apply both of the functions. Step # 1 -- Go to the Backstage View First of all you need to enable the analysis toolpak in Excel. Go to the "file" tab also known as the backstage view and click on "options". Step # 2 -- Enable Analysis Toolpak From the "excel options" window, go to the "add-ins" tab and select the "analysis toolpak" there. Click on the "go" button once you're done. A small window will open up; select the first option which is the analysis toolpak and click on the "ok" button. Step # 3 -- Use the Data Analysis Option Analysis ToolPak has various options but we will work with only two in this tutorial. The first one is how to find correlation. Go to the "data" tab and click on the "data analysis" button on the extreme right. From the small box, select the "correlation" option and click the "ok" button. Step # 4 -- Apply Correlation in Excel Now, the "correlation" box will appear on your screen. In the "input" range, select the cells which have data in them. If you include the first row which contains labels, then make sure the "labels in first row" box is checked. Lastly, select the "output" range. Click inside the box of the "output range" and then click on the cell where you want the output to be displayed. Click on the "ok" button to exit. The correlation result will be displayed to you. Step # 5 -- Apply Moving Average in Excel In the next sheet, we will take out the "moving average". Click on the "data analysis" button and then select "moving average". Click on the "ok" button and the "moving average" box will open up. Put in the range of input and since we are only going to select the "total" column without the labels so the "label" box should be unchecked. Specify the cell where you want the output to be displayed in the output range. Before clicking on the "ok" button, check the box of "chart output". Once done, the "moving average" will be displayed along with the chart.
How to Copy Excel 2010 sheet without formulas
 
01:21
This tutorial will show you how to copy an excel sheet without copying the formulas as well Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Sometimes you need to copy a sheet without the formulas being copied as well. This tutorial will teach you how to copy excel sheet without formulas. Step # 1 -- Choosing the Source Sheet and Selecting All Open the Excel sheet that you want to copy. In this example we have a sheet with some simple information. To select all of the data on the sheet click in the square box above row "1" and to the left of column "A". This will select all of the data in the sheet. Right click anywhere in the sheet and in the menu that appears click "Copy". Step # 2 -- Create a Destination Sheet In the bottom of the window you will see several tabs containing the different sheets. At the end of this is a smaller tab which allows you to create a new sheet, click this tab. A new sheet will appear, in this case "Sheet6". You will automatically be taken to this new sheet. Step # 3 -- Pasting Just the Values In the new sheet click the same square as before to select the whole sheet. Right click anywhere on the selected sheet and in the menu that appears look under the "Paste Options" option and click on the "Values" icon. This will paste the data into the sheet without the formulas included and that is how to copy excel sheet without formulas. We can see there are no formulas by clicking on cell "B6" where there was a formula previously.
How to Create a Digital Signature in Acrobat
 
01:28
Follow this step by step tutorial to learn how to create a digital signature using a password in Adobe Acrobat Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Adobe Acrobat provides with various tools for review and editing of documents, form, tables etc. as a Portable Document Format (PDF). It is an effective way of presenting information in a fixed form close to its publishing results. You can insert a digital signature using Acrobat and it can become an excellent way identifying the document as your own. Create a digital signature in Adobe and begin appending it on all official documentation by following this tutorial. Step # 1 -- Click on 'Edit' First of all, go to the "Tools" task pane and move over to the "Forms" panel. In the drop down menu that opens, click on the "Edit" button. Step # 2 -- Click 'Add New Field' On the top right side of the screen, under the "Tasks" panel, click on the "Add New Field" button and from the menu that appears select the "Digital Signature" option. Step # 3 -- Specify area for Digital Signature Now make a selection on the area where you want to add a Digital Signature, give the 'Field' a name and click on the "Close" form editing button. Step # 4 -- Select 'New ID' With that done, click on the field which you have just created. Once the new window opens up, click on the drop down menu next to "Sign As" and select the "New ID" option. Select the new digital ID option and click on 'Next' to move on to the next step. Step # 5 -- Provide personal information In the new window that opens, write your name and email address in their respective fields & click on 'Next' to move on to the next step. This step is the crux to create your digital signature in Adobe. Step # 6 -- Enter Password In this step, you will be required to enter a password for your signature and re-enter it for verification purposes. With that done, click on "Finish". Step # 7 -- Insert scanned signature Now you can preview what your digital signature will look like. If you have a scanned copy of your signature and want to add that instead of your name in the document, click on the drop down button next to "Appearance" and choose the "Create New Appearance" option from the menu. Step # 8 -- Select 'Imported Graphic' Select the "Imported Graphic" option in Configure Graphic and click on "File" to attach your scanned signature. Step # 9 -- Use your Digital Signature With that done, browse and select the image to be added in the signature. Before signing the document, you will be required to enter your password that you had given earlier. Once you have entered the correct password, click on the "Sign" button. And there you have it; your document with your digital signature in Acrobat.
How to Create a Table of Contents in Excel 2016
 
01:59
In this HowTech written tutorial, we’re going to show you how to create a table of contents in Excel 2016. Don't forget to check out our main channel https://www.youtube.com/c/HowTech for more free how-to videos! Join us on Facebook http://www.Facebook.com/howtechtv Our App http://bit.ly/how-tech The easiest way to do this especially if you only have a few worksheets is to select a cell and hit Ctrl+K to create a hyperlink to a selected worksheet. The next method uses VBA to automatically create the hyperlinks to all the worksheets. Go to Options. Click Customize Ribbon and check the Developer box. Under the Developer tab, click Visual Basic. Click Insert then click Module. Copy and paste the following code: Option Explicit Sub Create_ToC() Dim wbBook As Workbook Dim wsActive As Worksheet Dim wsSheet As Worksheet Dim lnRow As Long Set wbBook = ActiveWorkbook With Application .DisplayAlerts = False .ScreenUpdating = False End With On Error Resume Next With wbBook .Worksheets("ToC").Delete .Worksheets.Add Before:=.Worksheets(1) End With On Error GoTo 0 Set wsActive = wbBook.ActiveSheet With wsActive .Name = "ToC" With .Range("A1") .Value = VBA.Array("Table of Contents") .Font.Bold = True End With End With lnRow = 2 For Each wsSheet In wbBook.Worksheets If wsSheet.Name - wsActive.Name Then wsSheet.Activate With wsActive .Hyperlinks.Add .Cells(lnRow, 1), "", _ SubAddress:="'" & wsSheet.Name & "'!A1", _ TextToDisplay:=wsSheet.Name End With lnRow = lnRow + 1 End If Next wsSheet wsActive.Activate wsActive.Columns("A:B").EntireColumn.AutoFit With Application .DisplayAlerts = True .ScreenUpdating = True End With End Sub To use Visual Basic Macros, you will need to save the file as an Excel Macro Enabled Workbook. Click Macros under the Developer tab. Select the Create_ToC Macro and Run it. If your original worksheet is named differently, you may need to change all instances in the VBA script of ToC. A table of contents of all the worksheets should be created. This is a HowTech tutorial, visit our website and watch our videos for more.
How to Create an Update Query in Microsoft Access
 
01:14
In this tutorial, we will teach you how to create an update query in Access. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ To alter the existing values simply create an update query in Microsoft Access. This allows you to alter the math behind the values. You can make changes to your data in the table using the update query. In this tutorial, we will update the prices of all the products without opening the products table. Step 1 -- Go to the create tab To create an ms access update query, move to the create tab and then click on the query design button. Add the product tables and close the show table window. Step 2 -- Click the Update button From the products table, let's select the price field. Now click on the Update button from the query type group. You will notice a new update row will be added over here. In the update line, put in a square bracket and type in price. With that done, let's put another square bracket to close the keyword, followed by an asterisk sign for multiplication. After that, let's type in the percentage by which you want to increase the price. Over here we have multiplied the price by 1.2 indicating a 20% increase in the prices of all the products. Step 3 -- View the original list Now let's click on the view button and you will notice the present prices of all the products. Step 4 -- Select the run button To toggle back, click on the view button and now press the run button. A dialogue box will appear telling you that prices will be changed. Let's click on Yes to proceed and view the changes made through the ms Access update theory. Step 5 -- View the updated list To view the changed prices, open up the products table and you will notice that the prices are now 20% more than they were before. And that's it, by following these steps you can learn how to create an update query in Access.
How to generate random numbers in Excel
 
01:26
Learn how to enter keyboard commands so that Excel generates random numbers for you which you can then use as a sample data. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Random numbers/entries in Microsoft Excel can be generated by using keyboard commands. Through random generation you can create samples in Excel that can then be used for further use like research. This process is very useful and very easy. However, once you have taken out your sample your need to make sure that you freeze the data otherwise the entries in it will constantly keep on changing. To learn how to generate random numbers in Excel follow the tutorial below. Step # 1 -- Enter the "=rand(" command Suppose you want to randomize your data. In order to do that, you need to generate a random list and sort the data according to that list. Go to an empty column, type: "=rand(" and then press the "enter" key Use the "auto fill" function to fill in the rest of the column and then increase or decrease the decimal places to see the values properly. Alt= Use the "=rand(" command Step # 2 -- Generate random data Next, go to the "data" tab and click on the "sort" button. Under the "sort by" option, choose "random" and then choose the order from highest to lowest or lowest to highest. It doesn't make a difference as its going to be random anyway. Press the "ok" button and your data will be randomized. Step # 3 -- Create a sample data In order to create samples in Excel type: "=RANDBETWEEN(5000,30000) We want to generate sample data between these two values that's why we have used them. You can choose any two values of your choice. Use the "auto fill" function to fill in the rows and columns. Step # 4 -- Freeze the data You will have to freeze the data as it will change whenever you type something in the sheet. Select the data use your right mouse pointer at the edge of the selection and move it in any direction. Now come back to the original position and then release the mouse button. Choose the option of "copy here as values only". This way you can generate random numbers in Excel and create a sample data out of them.
How to Convert Powerpoint to JPG
 
01:32
Learn how to convert Powerpoint to jpg. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ How to convert Powerpoint in jpeg. Launch PowerPoint and open the previously prepared presentation file. If you want to make a jpg image for a single slide, move on to the slide which is to be saved. Click on the "File" tab and select the "Save As" tool button. After that the dialog window "Select as" appears. Select the directory where the picture will be saved. Type the file name of the picture in the "File Name" field. Select the "jpeg" file type in the "Save as type" drop-down list. In the appeared dialog box, click on the "Current slide only" button to save the single slide or on the "every slide" button to save the whole presentation. If you've saved a single picture, it will be located in selected directory. For saving the whole presentation, PowerPoint automatically creates a folder with the same filename.
How to Create a Pivot Table in Microsoft Access
 
01:29
Learn how to create a pivot table which is a data summarization tool found in Ms Access. It presents your data in a dynamic tabular form. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Pivot table in Access is a good way to group and summarize huge amounts of information like sales records pulled from a database. Pivot tables allow you to analyze your data in a more graphical manner. The best thing about pivot tables is that they are very customizable. For example, you can start with a sub grouped view that shows you all your sales grouped by customer's country. Let's say, you change your mind and want all the sales grouped according to the orders. This change can easily be brought about in the pivot table. Step # 1 -- Selecting pivot table To create a pivot table in Access, click once on the "products table" then go to the "create" tab. From there, click on the "more forms" button and select the "pivot table" option. Step # 2 -- Fields to be added Click on the" field list" button in the "show and hide" panel until you get a "pivot table" field list on the right hand side of the screen. Step # 3 -- Dragging fields You will notice that screen is divided into different zones. Drag the products table and drop it where it says "drop row fields here". This will group all the tires together. Now drag "size" and drop it where it says "drop column here". This shows the different sizes of the tires. Drag the "profit" field and drop it in the middle of the screen. It will show the profit margin for each type of tire. Drag "profit" one more time and this time drop it in the "grand total" column. This will show us our total profit but it will also show sub totals. This might make the table a little complicated. Step # 4 -- Hiding unwanted information Go to the hide details button and all the unwanted information will disappear from the pivot table. Step # 5 -- Changing the view Do the same with cost but drop it between profit and price. This will show you the cost of the product, its price and the profit made on each product.
How to Work with Batch Processing in Acrobat
 
01:42
Follow this step by step tutorial to learn how to manage batch processing while working in Adobe Acrobat. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Adobe Acrobat X allows you to create batch actions with hot folders. With this feature you can perform certain actions on your PDF files. The actions will be chosen by the user and this allows the user to save a lot of time and saves him from performing the same task over and over again. Let's assume it's your job to resize all the documents in the Adobe Acrobat batch at the end of the day for uploading on the internet. So here we have two files which have a file size of about 40 mb. We want to create an Acrobat action which will resize all the documents in one go without opening them and put them in a separate folder. Follow the step by step tutorial given below to learn how to manage batch processing in Adobe Acrobat. Step # 1 -- Create a new action In order to do create an action go to the "Tools" task pane and from the list select the "Action Wizard" panel. Click on "Create New Action" button and the dialog box will open. Step # 2 -- Give specific instructions Once the dialog box is opened click on the menu bar of "Start With" and choose "A Folder on my Computer" option. Browse the folder and click on the "OK" button. Step # 3 -- Change the Output Options After that go to the "Save To" settings button and press it. Over here make some changes like click on the radio button of "Add to Original File Names" option and in the "Insert After" section write anything which you want to add to the original name of the document. After that click on the "PDF optimizer" checkbox and then click on the "Settings" button. Step # 4 -- Change the Image settings When you open the PDF optimizer settings, a dialog box will appear in front of you. While you are in the "Images" tab change the "PPI" to 70 and the "Quality" to "Minimum". Click on the "OK" button and then save your current settings for Adobe Acrobat batch processing. Step # 5 -- Save your action After you click on the "OK" button a small box will appear, write a name for your action and then click on the "OK" button again and then go to the "Save To" section click on its drop down button to see the menu bar and choose the "A Folder on my Computer" option. This is because we have already created a folder where we want our resized documents to land. Browse the folder and click on the "Save" button. Write a name for the new action that you have created and click on the "Save" button. Step # 6 -- Execute the action After you are done click on the action button which is named as "Optimize the docs" and then press the "Next" button to begin the action and your documents will be resized and will be sent to the designated folder as per Acrobat action settings.
How to Sort Excel 2010 by Alphabetical Order
 
01:11
This tutorial will show you how to sort a list into alphabetical order in Excel Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to sort excel by alphabetical order. Step # 1 -- Selecting the Data to Sort Start Excel and open the sheet with the data that you want to sort alphabetically. Here we have an address list and we want to sort the data by "Last Name". To do this you need to start by selecting the entire column, click on the "B" letter in the bar above the first row. Step # 2 -- Opening the Sort Window Now the data has been selected navigate to the "Data" tab in the main menu bar. In the "Sort & Filter" section you will see a large icon with "Sort" written underneath it, click this. A window will appear called "Sort Warning", select the "Expand this selection" option and click "Sort...". Step # 3 -- Sorting the Data The "Sort" window will load and there are several drop down boxes available. As a default the sort window will want to sort the data by alphabetical order (A-Z). If you want to have it reversed you can select the "Z-A" option from the "Order" drop down list. Finally click "OK". You will be returned to the spreadsheet and that is how to sort excel by alphabetical order.
How to use macros in data in Microsoft Access
 
01:25
Learn how to work with data macros in Access to ensure accuracy and validity in the table. These macros automate your database and make it dynamic. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Microsoft Access is database application software that lets you create database of various sorts with ease. The best part about Microsoft access database is that it helps one to quickly track and report information. It provides the user with rich user interface and interactive design capabilities. It can also be used for web applications. Data macros in Access enable you to add logic to events that occur in tables such as adding, updating, or deleting data. Step # 1 -- Using after update In order to create a data macro, first open up the orders table. Over there, go up to the "tables" tab and then click on the "After update" button; a macro window will open as a result. Step # 2 -- Adding task In the first box, write down "if" and then start typing "order status" in a square bracket. You will get a drop down with the possible matches present in the database. Double click on order status and it puts it in the bracket. Insert the "equals to" sign and after that, in quotation marks type "complete". Step # 3 -- Fill in the information In the next box, select send email and a box of email options will open. In the "to" field, type "customers" in square brackets then add an exclamation mark and type "email address" in another square bracket to complete the expression. Now complete the form by typing in data in the subject and body field. Step # 4 -- Triggering macro Now go to your orders table and type in details for a new order. Select a customer from the drop down, choose a product and lastly type in the quantity. Leave the order status field on processed and move over to the next field. Now go back to the "order status" field and change it to "complete" and an email would be sent to the customer automatically. You can use data macros in Access to validate and ensure the accuracy of data in a table. There are two main types of data macros—those that are triggered by table events (also called "event-driven" data macros), and those that run in response to being called by name (also known as "named" data macros). One more thing about Microsoft access database it that it can be managed in an effective manner using macros.
How to Set Up Outlook 2010 for Gmail
 
03:33
Learn how to set up Microsoft Outlook 2010 for Google mail. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to set up outlook 2010 for gmail. Open your web browser. Type "gmail.com". Sign in to your email account. On the following web page, click on the "Gear" icon and choose "Settings". On the next web page, press the "Forwarding and POP/IMAP" tab. On the next web page, near "IMAP access", choose "Enable IMAP". Scroll down and press "Save changes". Sign out from your gmail profile and close the browser. Launch Microsoft Outlook. Go to the "File" menu and in the "Info" tab, choose "Account Settings". In the following window, press "New" to create a new email account. In the next window, choose "Manually configure server settings or additional server types" and press "Next". In the next window select "Internet E-mail" and press "Next". In the following window, fill in your user information. Then, choose the "IMAP" account type. In the "Incoming mail server" line, enter "imap.gmail.com". In the "Outgoing mail server", type "smtp.gmail.com". In the logon Information area enter your email address and the password. When it's done, go to "More settings". In the following window, click on the "Outgoing server" tab. Check "My outgoing server requires authentication" option, and be sure to check the "use same settings as my incoming mail server option". Then, go to the "Advanced" tab. In the "Incoming server(IMAP)", set value to "993" and in "Use the following type of encrypted connection" set the "SSL" option. In the "Outgoing server (SMTP)" set value to "465" and under it in "Use the following type of encrypted connection" select the "SSL" option too. If the "Outgoing server" value drops to default, set value to "465" again. Then press "Ok". In the "New account settings" window, press "Test account settings". If everything works, you'll see the message that all tests completed successfully and then press "Close". Then uncheck the option "Test account Settings by clicking the Next button" and press "Next". In the next window, press "Finish". Wait while your outlook mail box will be refreshed.
How to Make a Booklet in Word 2013
 
01:33
Don’t let booklet formatting hinder your creative processes or your work. In this HowTech written tutorial, we’re going to show you how to create and format a booklet in Word 2013. Going through the following steps is recommended before typing out the booklet, because margins will be changed and you will run into minor formatting issues if you write it out first. Go to Page Layout on the ribbon, and click the arrow in the bottom right of the Page Setup section Change the Gutter value to about .3” (depending on how much gutter you want, you can also take out a spare piece of paper and measure it out to see how much gutter you want). The papers will print out in landscape format, and then you will fold them in half. So the gutter is generally where the staples or glue is placed Change Multiple Pages from Normal to Book Fold, the Orientation should automatically change to Landscape To demonstrate, these two “pages” or sections here will actually print out on one single page. After that it is just a matter of folding it all in half and placing the staples, stitching, or glue in the gutter to hold it all together This is a HowTech tutorial, visit our website and see our videos for more!
How to Insert Footnote in Word
 
00:57
In this video tutorial we will show you how to insert a footnote into a Word document. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ If you are writing something that needs referencing then knowing how to insert footnote in Word is invaluable, this tutorial is going to show you how. Step # 1 -- Getting Ready to Place the Footnote Open Word with the document that you want to add a footnote to. From the tabs at the top click on the one that says "References". Now go to the place in the text where you want to insert the number that relates to the footnote. Here we are placing it at the end of a paragraph. Step # 2 -- Entering the Footnote Text Now, click the large "Insert Footnote" button in the toolbar. You will be taken to the bottom of the page and this is where you will be able to enter your footnote text. You will see a number to the left of this text, this is to guide the reader from the text to the correct footnote. When you have finished entering the footnote text, scroll up to the main body of text and you will be able to see the number referencing your footnote. That is how to insert footnote in Word and you can add as many as you want to a document.

Cover letter sample for nurses
Accenture internship cover letter
Online admission university of burdwan
What the best essay writing service
Internships cover letter samples