DIGI SAKSHAM
DIGI SAKSHAM

DIGI SAKSHAM

      |      

Subscribers

   Latest videos

Benefits of Chia Seeds in different diseases
6:36
DIGI SAKSHAM
9 Views · 1 year ago

⁣According to the American Society for Nutrition, chia seeds provide insoluble fiber which helps keep you fuller longer and bulks up stool to prevent constipation. They also deliver healthy fats, protein, and cell-protecting antioxidants. Chia seeds are a good source of minerals, such as: calcium.
⁣#healthtips #chiaseeds #healthylifestyle #health

How to square root a number in Excel
0:48
DIGI SAKSHAM
64 Views · 1 year ago

⁣Using the function 'sqrt', Excel will calculate the square root of a number for you.

How to replace dots with commas in Excel
0:45
DIGI SAKSHAM
35 Views · 1 year ago

⁣Learn how to replace dots with commas in Microsoft Excel.

Convert selected decimal points (dots) in your spreadsheet to commas using the replace and find tool.

How to remove an email hyperlink in Excel
0:39
DIGI SAKSHAM
57 Views · 1 year ago

⁣Learn how to remove automatically generated hyperlinks in Microsoft Excel.

To remove a hyperlink simply select the cell which has the email or website attached to it. Right click the cell and a list of options will come up, select 'remove hyperlink'.

How to get to the last cell in Excel Spreadsheet
0:43
DIGI SAKSHAM
43 Views · 1 year ago

⁣Learn the shortcut on how to get to the last cell in your Excel Spreadsheet.

Using the hotkey Ctrl + down arrow key you can get to the last row of your spreadsheet. Likewise to get to the last column use the hotkey Ctrl + right arrow key.

For Excel 2010 there is 1,048,576 rows and the last column is XFD.

How to create, rename and delete worksheets in Excel
0:43
DIGI SAKSHAM
55 Views · 1 year ago

⁣Learn how to create new worksheets in Microsoft Excel, this tutorial also covers how to rename, move and delete worksheets.

How to create a drop down list with different options Excel 2010
1:10
DIGI SAKSHAM
33 Views · 1 year ago

⁣Steps to create a drop down list:

1. Select the cell or cells you want the drop down list to appear on
2. Go to the Data tab and select 'Data Validation'
3. Select 'list' for validation criteria
4. For the option source, select the range of options you have entered on your spreadsheet
5. Click ok and apply changes, you now have a drop down list

How to count the number of letters in a word Excel
0:48
DIGI SAKSHAM
52 Views · 1 year ago

⁣How to use the LEN function in Microsoft Excel to count the number of characters in a cell
containing text.

The function 'LEN' requires a cell containing text, for example LEN(A1) where A1 has text. One
thing to note about the LEN function is that any character will be counted this includes spaces between words and periods.

How to corrupt an Excel file permanently
1:10
DIGI SAKSHAM
164 Views · 1 year ago

⁣Corrupting an Excel file is useful for handing in documents to teachers or employees which are incomplete but nearing their due date. This will give you more time to hand in your non corrupted document when they request a resend.

How to copy and paste only the result of a cell in Excel
0:46
DIGI SAKSHAM
27 Views · 1 year ago

⁣How to copy and paste only the result from a cell that has a formula in it in Microsoft Excel.

Pasting only the resultant cell can be done by using the hotkey 'ctrl + shift + v' after copying a cell, this will bring up a special paste menu, then select the option called 'values'.

How to calculate cube root in Excel
0:54
DIGI SAKSHAM
41 Views · 1 year ago

⁣The cube root of a number can be found using the function 'Power', for example, the cube root of 125 would be power(125,1/3). This method can be extended to find the nth root of any number

How to calculate age from date of birth Excel
0:51
DIGI SAKSHAM
12 Views · 1 year ago

⁣Learn how to calculate a person's age from their date of birth and the current date in Microsoft Excel.

How do you alphabetize a column in Excel
0:32
DIGI SAKSHAM
12 Views · 1 year ago

⁣Learn how to sort a column by alphabetical order in Microsoft Excel.

Steps to sorting data by alphabetical order:

1. Select the range of data that requires alphabetization
2. Go to Data tab
3. Select 'Sort'
4. Click 'ok'

Formula to count if two criteria are matching in Excel
0:55
DIGI SAKSHAM
23 Views · 1 year ago

⁣Create a formula to count
Excel cells if two criteria are matching using the function 'COUNTIFS'

The COUNTIFS function checks the criteria in multiple ranges of cells are met and counts them as an integer.

For example, COUNTIFS can be handy in the following case: if cells in Column A is True or False, and cells Column B are 0 or 1. The COUNTIFS function can be used to count when both column A and B have True and equal to 1.

Formula to count how many cells have any sort of data Excel
0:45
DIGI SAKSHAM
23 Views · 1 year ago

⁣How to count the number of cells in Excel that contain any type of information.

Using the function 'COUNTA', Excel is able to count the number of cells in a specified range that has any type of information, this includes errors, letters, numbers, symbols etc.

How to unhide columns in Microsoft Excel
0:46
DIGI SAKSHAM
15 Views · 1 year ago

⁣To unhide a column, drag and hold your cursor over the two adjacent cells to the hidden cell, so that they are under your selection and then right click the selection and press
'unhide'

How to type checkmark symbol in Excel
0:56
DIGI SAKSHAM
34 Views · 1 year ago

⁣There is two methods for typing the checkmark symbol:

1. Navigate to the insert tab on the toolbar, select symbols and search for the font 'Wingdings', the checkmark symbol will be on the bottom right

2. Alternatively the checkmark symbol can be typed out with a keyboard shortcut by selecting the font 'Wingdings' in the home tab and holding alt + 0252 on the numpad.

How to switch two columns in Excel
0:42
DIGI SAKSHAM
25 Views · 1 year ago

⁣Learn how switch columns around in Microsoft Excel using drag and drop.

Steps to switch columns:

1. Select the column by clicking your mouse on the letter denoting that column

2. Place your cursor on the very edge of the column

3. Hold shift and drag the column to where you want to swap it

How to save Excel file as csv Windows 10
0:53
DIGI SAKSHAM
28 Views · 1 year ago

⁣learn how to save your Excel file as csv (comma separated values) format in this quick tutorial on Windows 10

How to Round up Numbers in Excel
1:10
DIGI SAKSHAM
28 Views · 1 year ago

⁣Learn how to round up numbers in Microsoft Excel to the nearest integer or nearest decimal.

To round a number in Excel use the function 'ROUND' or 'ROUNDUP' to round a number up.

The format of the 'ROUND' function requests what cell to round and what decimal point to round to.

Show more