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
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'.
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.
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.
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
52 Views · 1 year ago
How to use the LEN function in Microsoft Excel to count the number of characters in a cell
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.
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.
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'.
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.
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.
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.
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
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.