last posts

Recent Posts Widget

Thursday, April 28, 2016

Facebook Messenger's secret inbox you didn't even know existed

Facebook has many secrets, and we love nothing more than to tell you about them!

For example, did you know that there's a secret hidden inbox in your Messenger? This is the inbox where all the messages from people who aren't your friends on Facebook go to, and basically, sit undiscovered. The question is.... are you ready to read them?
Now, we warn you, this could either go one way or the other. On one hand, you may discover that some do-gooder back in Australia has found that wallet that you lost during your travels (might be a bit late though), on the other, it may bring back some bad memories you were quite happy living without until this moment. Either way - you're in for an interesting read!

Here's how to find your secret inbox on mobile!

1) Open the Messenger app
2) Click on "Settings"
3) Click on "People"
4) Click "Message Requests"
5) Now click on "See filtered requests".

Here's how to find your secret inbox on desktop!

1) Click on Messages (on the version for desktop)
2) Go to "See All"
3) Select "Filtered" from the "More" drop down menu

And there you have it! So, any unexpected surprises?

Warning! This security flaw in Windows could put your PC at risk!

A new serious security flaw has been detected on Windows that could put you at risk. It’s so sneaky, that it’s able to run any program without Administrator permission – this includes malicious apps that can have fatal consequences.

This bug, discovered by researcher Casey Smith, makes it possible to run any app remotely – even if the infected user is using AppLocker (a program that prevents programs starting up without permission from the Administrator). This security flaw takes advantage of the Regsvr32 tool.
But relax, we also didn’t know what Regsvr32 was before writing this article, so here’s a bit of a summary for you to chew on. It’s basically a tool within the Windows command line that handles log entries. By using it maliciously, and taking advantage of the flaw, a hacker is able to run any program on the PC, including malware or malicious software. Since the system doesn’t require the Administrator password nor does it alter the system registry, it’s almost impossible to trace where the attack is coming from.
The security flaw affects the business editions of Windows 7 onwards, so as you can imagine, this has the potential to be more of a problem for businesses rather than individual users.
Knowing Microsoft, we imagine that they’ll soon find a solution to this security breach, but it certainly never hurts to at least be aware of the current at this moment in time! Be careful!

Getting tired of Facebook Live videos? We’ve got the solution!

The live-broadcasting feature on Facebook is now available to everyone, and while sometimes it can be useful, notifications can get a bit overwhelming (and annoying). Luckily there’s an easy way to disable it!
Here's how you do it:
  1. Go to Facebook Settings
  2. Click on the Notifications tab on the left hand side
  3. Go to “On  Facebook
  4. Deactivate the Live Video option (see below)
As you can see above, this section of your Facebook configuration allows you to manage all notifications that you receive on your account. While here, it may be useful for you to explore it a little if you feel you’re receiving too many notifications you don’t think are necessary. You can always activate them if you feel you’re missing out!

How to recover an unsaved Word document on Windows 10

W’ve all been there. That moment when your PC just decides to shutdown spontaneously and you forgot to save that super-important document. Then you remember about Microsoft’s special feature that automatically recovers unsaved documents, but then you realized that it actually hasn’t saved at all.
Fear not! There is still a way to recover the ultimate version of the document, however you can’t do this in Word itself.

How to recover your document:

1)      Use the Windows key (on your keyboard) to open the Windows Start Menu
2)      Click on File Explorer
3)      Select This PC on the left-hand side
4)      Type .asd in the search bar and click Enter
Your most recent document will appear in the results! All you have to  do is simply click on it! The document will open in Word, giving you a second chance to save it!
Source: CNET

Monday, February 8, 2016

TWIGE EXCEL IGICE CYA1 Formulas and Functions

 Formulas and Functions

A formula is an expression which calculates the value of a cell.
 Functions are predefined formulas and are already available in Excel.

For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.
Formula Example

For example, cell A3 below contains the SUM function which calculates the sum of the range A1:A2.
Function Example

Enter a Formula

To enter a formula, execute the following steps.
1. Select a cell.
2. To let Excel know that you want to enter a formula, type an equal sign (=).
3. For example, type the formula A1+A2.
Enter a Formula
Tip: instead of typing A1 and A2, simply select cell A1 and cell A2.
4. Change the value of cell A1 to 3.
Excel automatically recalculates the value of cell A3. This is one of Excel's most powerful features!

Edit a Formula

When you select a cell, Excel shows the value or formula of the cell in the formula bar.
Formula Bar
1. To edit a formula, click in the formula bar and change the formula.
Edit a Formula
2. Press Enter.
Edited Formula

Operator Precedence

Excel uses a default order in which calculations occur. If a part of the formula is in parentheses, that part will be calculated first. It then performs multiplication or division calculations. Once this is complete, Excel will add and subtract the remainder of your formula. See the example below.
Operator Precedence
First, Excel performs multiplication (A1 * A2). Next, Excel adds the value of cell A3 to this result.
Another example,
First, Excel calculates the part in parentheses (A2+A3). Next, it multiplies this result by the value of cell A1.

Copy/Paste a Formula

When you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to. To understand this, execute the following steps.
1. Enter the formula shown below into cell A4.
Copy a Formula Example
2a. Select cell A4, right click, and then click Copy (or press CTRL + c)...
Click on Copy, select cell B4, right click, and then click Paste under 'Paste Options:' (or press CTRL + v).
Click on Paste
2b. You can also drag the formula to cell B4. Select cell A4, click on the lower right corner of cell A4 and drag it across to cell B4. This is much easier and gives the exact same result!
Drag a Formula
Result. The formula in cell B4 references the values in column B.
Copy a Formula Result

Insert a Function

Every function has the same structure. For example, SUM(A1:A4). The name of this function is SUM. The part between the brackets (arguments) means we give Excel the range A1:A4 as input. This function adds the values in cells A1, A2, A3 and A4. It's not easy to remember which function and which arguments to use for each task. Fortunately, the Insert Function feature in Excel helps you with this.
To insert a function, execute the following steps.
1. Select a cell.
2. Click the Insert Function button.
Insert a Function
The 'Insert Function' dialog box appears.
3. Search for a function or select a function from a category. For example, choose COUNTIF from the Statistical category.
Insert Function Dialog Box
4. Click OK.
The 'Function Arguments' dialog box appears.
5. Click in the Range box and select the range A1:C2.
6. Click in the Criteria box and type >5.
7. Click OK.
Function Arguments Dialog Box
Result. Excel counts the number of cells that are higher than 5.
Note: instead of using the Insert Function feature, simply type =COUNTIF(A1:C2,">5"). When you arrive at: =COUNTIF( instead of typing A1:C2, simply select the range A1:C2.

How to Make a CD Cover in Microsoft Word Word

How to Make a CD Cover on Word

1. Open Word and choose 'New' from the 'File'

menu. Select the 'Template' option and click

on 'Labels.' In the 'Media' category, browse

the CD cover templates available. Select the

one that best suits the kind of cover you want

to make. Don't worry about the design on the

cover. You will be removing it and replacing it

with your own.

2. Click the template you want to use to open

it in Word for editing. The template will have

text and graphics in place. Leave any of the

images you want to use. To delete the text

and graphics on the template, select the

element you want to delete and press the

'Delete' key on you computer. This will get rid

of the template element.

3. Click the 'Insert' menu, select the 'Picture'

option and browse to the location on your

computer where the picture you want to

include on your CD cover is. The picture will

appear in the template. To resize it, click the

picture to select it, then point your mouse at

the selection and drag the selection lines to

size the image.

4. Insert text by going to the 'Insert' menu

and selecting either the 'WordArt' or the 'Text

Box' option. Type the text you want to appear

on your CD cover and format it using the

format toolbar. Set the font style, size and

color with this toolbar.

5. Save your CD cover under a unique name.

To print your CD cover, use CD cover paper

which you can purchase from an office supply

store, or print it on standard copy paper. To

print several of the covers, using template

paper is best. If you use standard paper,

you'll have to cut the CD covers out rather

than removing them by perforation.


Powered by Blog - Widget

share this