Click the video camera icon. It’s at the bottom-center part of the window. You are no longer broadcasting video to the other person on the line. Start a video call. Start by clicking on 'Video Call' from the contact you want to call. The person you are talking to must also have a webcam and a Skype account. If the person does not have Skype account, you can call a landline or cell phone, but there will be a charge per minute. Sign into Skype. Check to make sure your camera is working properly. On a PC, from the Tools menu, select 'Options,' and then under General, choose 'Video Settings.' On a Mac, from the Skype menu, select 'Preferences', then click on the Audio/Video tab. How to turn on video camera on laptop.

Answer: To apply a sort in Excel, highlight the data that you wish to sort. Then select the Data tab from the toolbar at the top of the screen and click on the Sort button in the Sort & Filter group. When the Sort window appears, select the data that you wish to sort. Excel Tutorial Video – Excel Lists, Drop Downs and Data Validation Here is our 20 minute video with various techniques for Excel Lists, Drop Downs and Data Validation. Please note that the video was made using Excel 2010, hence the specific menu and look will be for Excel 2010. By Greg Harvey. In Excel 2010, you can use the AutoFill feature to create a custom list with names, locations, or other items and then use the AutoFill handle to fill these list items in order in a workbook. How to put data from multiple columns into one column in excel - How-To - Excel Published by jak58. Latest update on January 30, 2012 at 07:11 AM by jak58. The helper column tests each row in the data to see if the Department in column C matches the value in I3 and the Building in column D matches the value in J3. Both logical tests must return TRUE in order for AND to return TRUE.

Calculate values using data in table cells in a Numbers spreadsheet You can create formula or function cells that automatically perform calculations using the data in any cells you select. For example, you can compare values in two cells, calculate the sum or product of cells, and so on. The result of a formula or function appears in the cell where you entered it.

You can also use any of the predefined mathematical functions included with Numbers to create formulas. There are more than 250 functions for applications including statistics, engineering, and finance, some of which retrieve information remotely via the Internet. Detailed information about each function appears in online and in the, which appears when you type an equal sign (=) in a cell. You can quickly find the sum, average, minimum, maximum, count, or product of a range of cells. • Do one of the following: • the range of cells you want to include in your formula. Numbers chooses a result cell based on your selection.

• Select a cell to display the result of the formula. You can’t insert a formula in a header cell. • Click in the, then choose a formula. • If you want to change the range of cells, double-click the result cell. The cells used in the formula are highlighted, and the formula editor appears. Microsoft package for students.