Ittechsavvy

Monday, 13 March 2017

Learn Microsoft Excel lesson #34

you may also want to see Learn Microsoft Excel lesson #33

Learn Microsoft Excel lesson #33

Use the CONCATENATE function to combine text

You may also be interested in Learn Microsoft Excel lesson #32

How Huawei thinks we should use android

Huawei quietly introduced a brand new feature that few individuals even noticed. It's abolished the Navigation Bar by integrating the three main functions into a sensor button, this is indeed a great news; since the Navigation Bar has barely been modified in the past decade.
This changes, I think influences how you use android quite considerably. To see why let's recap how people have grappled with android thus far.

Buttons.

Google's first version of Android was basically a BlackBerry clone, and it had been under development for three years, when in January 2007 Apple unveiled the iPhone. The Android team made a dramatic pivot to emulate Apple's new UI standard, a little too closely for Steve Jobs' liking.

Android's UI rapidly evolved from "mainly QWERTY with some touchscreen" to "mostly touchscreen" to "full touch" very quickly, but retained a few BlackBerry quirks. Blackberries had a back key and a menu key and so did the first full-touch Androids.

The devices retained these buttons for second-generation Android 2.0 devices, such as the HTC Hero, which had six hardware buttons (home, menu, back, search and two call keys: the old "send" and "receive").

Given the large pent-up demand for a modern phone experience (Apple was rationing its iPhone through territorial carrier exclusives, and neither Nokia nor BlackBerry may manufacture something competitive), android became a megahit. gradually the buttons began to fade.

Designers honed the keys right down to three or four: invariably some permutation of home, menu, back, and search. Samsung's runaway success with the S and S2 (menu – home – back – search) proved you didn't want quite so many.

Samsung's Galaxy S2 cut down the number of buttons

And since then there have only very been two changes. Android 4.0 appeared in 2012 permitting designers to dispense with dedicated offscreen buttons and replace them with an onscreen navigation bar, to avoid wasting money and scale back the dimensions of the bezel. and the menu key became mostly superfluous and replaced by a task switcher.

That brings us to the generic slab we have these days. only Samsung has persisted with a true hardware button. but the shift to onscreen navigation has had some downsides. It's rather more fiddly for the user and consumes up pixels that might somewhat be utilized by an application.

Huawei's plan is to feature swipe gestures to a front fingerprint sensor. The onscreen navigation bar is still there if you do not want to use the detector, and you'll be able to restore it, but it's turned off by default.

Sensor overload

Huawei had already experimented with loading gestures onto the fingerprint sensor in its Honour 7, a breakthrough device for the company here.

A down swipe would pull down the Notifications shade, that is one among the most common actions on a modern android phone.

The P10's fingerprint sensor understands three gestures when generally in use a long press returns you home. a tap takes you back.

And a swipe brings up the task switcher (note for pedants: per Google it's at the moment officially referred to as the "Overview" button, however, most phone OEMs ignore this).

There's no way to customise this in current software system builds: you get what you are given.

Coming straight from another Huawei phone, the Mate 9, I instantly missed its rear-mounted sensor. just like Tim Anderson, who wrote our Hands On with the P10 did. putting the fingerprint sensing element on the rear is not popular with everybody, and makes using a flip case a little awkward, however,

I would very quickly become familiar with picking it up unlocking and using the down swipe to check new notifications.

I suspect most people can discover the feature in P10 accidentally. they will accidentally tap or swipe the device and realize one thing unexpected has occurred. And this is what happened to me.

Programming my muscle memory to use the device for navigation took somewhat more than a day. very cautious initially, you find a tap sends you back. And it is so much faster than shifting focus to "find the rear key" and carefully pressing. Your brain is doing less. It's much less disruptive.

Using a swipe to task switch takes a little longer than tap-to-go-back as it's a kind of toggle. Swipe the sensor once to bring up the task switcher, and once more to dispense with it.

There are some downsides of the new approach, just as there downsides of any design decision.
On previous Huawei phones swiping the on-screen navigation bar was used for a "reachability" function, created to make the top of the device accessible in one-handed use. but with no on-screen navigation bar, this is often invoked using a diagonal swipe from one of the bottom corners of the screen.

which hardly ever works. and that notifications shade remains as hard to access one-handed as on different phones. could Huawei have overloaded the sensor with another up/down features, perhaps they did and users got confused, Or perhaps the sensor got confused.

Android dominates mobile with over 80 per cent of new devices shipping – but little changes from year to year. It's nice to see manufacturers trying something somewhat completely different.

Nokia's N9 abandoned all-gesture Harmattan UI dispensed with navigation buttons completely.

This user regrets that the chance to create a ground-up approach to design with all swipes, as expressed in the Nokia N9 and BlackBerry's BB10, never caught on.

Neither needed any onscreen buttons at all. android evolved so speedily between 2009 and 2011, there was no chance for a rethink. And "unused" gestures speedily become adopted by application developers.

you may also be interested in Alcatel unveils colourful A5, A3 Smartphones

Saturday, 11 March 2017

Learn Microsoft Excel lesson #32

Conditional logic functions

you may also be interested in Learn Microsoft Excel lesson #31

Learn Microsoft Excel lesson #31

Basic Summary Functions

You may also be interested in Learn Microsoft Excel lesson #30

Friday, 10 March 2017

Microsoft to release impressive upgrades for Microsoft (MSFT) Surface Pro 5

New Pro 5

Microsoft’s (MSFT) next flagship Surface Pro 5 would represent one of the most powerful hybrid devices ever released in the 2-in-1 market. The following is a review of the latest upgrades expected to arrive on the next Surface Pro.

Intel Kaby Lake

Intel’s latest and most all round iteration of its processing chipsets is supported to power the flagship Surface Pro 5.

The chip is specifically developed to be faster and more efficient at conserving power, which makes it a significant step up in comparison with Intel’s previous-generation processor.

Hence, users can expect that the upcoming Surface Pro will be both faster at processing and more efficient at battery consumption.

MSFT Pro 5

Windows 10 Creators Update

Speculations have steered that MSFT intends to roll out its next major update for Windows 10, with its next flagship Surface pro. interestingly, this forthcoming Creator’s Update for Windows 10 is supported to represent Windows OS’ biggest update since the release of Windows 7.

Recent speculation expects that future Windows 10 Creators update can offer improved gaming modes and protection for compatible devices.

Detachable Screen

Detachable 4K Screen

The next Surface pro might become an instant hit with huge multimedia fans, because the device would sport a 4K resolution visual display unit. Moreover, attributable to the look of Microsoft’s Surface pro line-up, expect this forthcoming 4K resolution display to be fully detachable.

Rechargeable Pen

Rechargeable Surface Pen

Microsoft could have developed a new and improved Surface Pen, according to recent leaked which has the capability of recharging from a port built into compatible devices. Moreover, this led to speculations that Microsoft has planned to introduce such a new and improved Surface Pen, along with its next Surface Pro.

you may also be interested in How to Fix windows 10 touchpad issues.

Thursday, 9 March 2017

Learn Microsoft Excel lesson #30

understanding the order of operations in formulas

Please leave your comments.

You may also be interested in Learn Microsoft Excel lesson #29

Microsoft Moves windows Server OS to Qualcomm Centriq

Qualcomm Processor

Microsoft has moved its Windows Server OS to the Qualcomm Centriq – a 64-bit ARM-compatible server-grade system-on-chip.

In a move which will pile more pressure on Intel that already dominates the data center market, but is already afraid by AMD's naples server processor – Qualcomm and Microsoft will today show off Windows Server running on a 10nm Centriq 2400 system at the Open compute Project Summit in California.

The Windows Server build is, so far, for internal use solely at Redmond. The software giant and its pal Qualcomm declined to comment on any plans to form the operating system accessible to the general public. Microsoft and Qualy are getting pretty close recently: the two are working on Snapdragon-powered Windows 10 laptops and mobile devices, due out later this year.

Windows Server on Qualcomm

Putting Windows Server on ARM may be a big deal. back then back in 2011, Microsoft said it had no interest in moving the Windows Server OS on ARM servers. Since then, rumors have surfaced that Windows Server 2016 was being ported to ARM, however, this is certainly the first time the OS is being shown running on the hardware.

Like with PCs, current editions of Windows Server only run on systems with x86 chips from Intel and AMD. however, Microsoft has been warming up to ARM on laptops and nowadays servers. The company's Windows 10 IoT Core and Windows 10 Mobile already work on ARM chips.

Motherboard

Microsoft and Qualcomm worked for several years to bring Windows Server to Centriq 2400. The collaboration is expected to continue for future generations of server hardware and software, the companies did say.

The goal with Windows Server on ARM is to run next-generation Microsoft cloud services on servers with Qualcomm's Centriq 2400 chips, the companies did say during a statement.

Windows Server.

Intel, that dominates the server chip market with over a 90 % share, can for sure notice of this announcement. Microsoft's support for Qualcomm is a robust statement that the software company is prepared to think about another design for Windows Server.

Qualcomm has developed special Windows Server hardware based on its Centriq 2400 processor. The Centriq Open cipher Motherboard server has 48 central processing unit cores and fits into a 1U server chassis. it's multiple I/O and networking interfaces and supports the newest storage protocols.

you may also be interested in How to disable Windows Shortcuts

Wednesday, 8 March 2017

Learn Microsoft Excel lesson #29

Relative and absolute references in formula

Leave a comment

You may also like Learn Microsoft Excel lesson #28

Learn Microsoft Excel lesson #28

Solution Create and modify tables

you may also be interested in Learn Microsoft Excel lesson #27

Monday, 6 March 2017

How to show hidden files caused by virus

I am very sure a lot of people have had this experience with their computers, for some it was an ugly experience. I will share 3 Steps to Show Hidden Files Caused by Virus Infections, these methods will help you who have difficulties showing hidden files because of virus infection

The method mentioned here will only work for Windows users, because most virus in the wild is targeting Windows operating system since they have the largest users in the world.

What we will be needing is only our windows Command prompt

There are 3 Steps to Show Hidden Files Caused by Virus Infections:

1. This is the screenshot of USB content after it had been plugged into an infected computer.

corrupt file

The virus hides all the files and folders, and change everything into a shortcut this shortcuts will call up documents.vbe when you try to execute.

2. The virus changes all the files and folders attribute by using system user, so when you try to change the attribute by right clicking it, you won’t be able to do so. See Below

doc attribute

3. Run command prompt and navigate to the USB drive. For instance, in this case, the USB is in E: drive.

attrib -H -S E:\* /S /D OR attrib -s -r -h /s /d E:\*.* either way will work just fine.

command prompt

Explanation

attrib : Displays or changes file attributes.

– : Clears an attribute.

H : Hidden file attribute.

S : System file attribute.

E:\* : Drive of the USB with * as wildcard that means process all files.

/S : Processes matching files in the current folder and all subfolders.

/D : Processes folders as well.

In Summary

1. Turn off Autorun for all of removable media.

2. Do not DoubleClick your USB folder to prevent the virus spreading into your system.

3. To delete the virus manually, you can open REGEDIT, choose EDIT tab and click Find (Ctrl + F).

regedit

In the search box type "documents.vbe". If your search result return nothing it's mean that you're not infected by this kind of virus, if your search result return some value like the picture below

reg file search

Right click and choose "End Task" to stop the Wscript.exe process and try again to delete the Documents.vbe. Don't forget to delete the registry containing Documents.vbe.

task manager

Hope this has been informative for you.

you may also be interested in How to disable Autoplay/Autorun on windows 7

How to disable Autoplay/Autorun on windows 7

Virus easily spreading using removable media such as CD, USB, Floppy, etc. Some people maybe still didn't know how to turn off autorun or autoplay in Windows.

How to Turn Off Autorun/Autoplay on Windows 7:

gp launch

1. Open Run Tasks (Click here to view the shortcut to launch Run)

2. Type : gpedit.msc (case insensitive)

3. Go down to Computer Configuration –> Administrative Templates –> Windows Components –> Autoplay Policies –> Double-click the Turn off Autoplay at the right side window.

4. There are 3 configurations available: Not Configured, Enabled, Disabled.

5. Choose Enabled/Disable as it suits you then click apply.

You may also be interested in How to show hidden files caused by virus

Saturday, 4 March 2017

Mercedes Recalls 75000 cars in UK 1 million cars globally.

trade mark

About 75,000 Mercedes cars in the Great Britain might be affected by a global recall of many models following reports of fires.

An issue with some starter parts in cars made between 2015 and 2017 is assumed to cause them to overheat. The fire risk has prompted Mercedes-owner Daimler to recall around 1m vehicles worldwide, covering certain A-Class, B-Class, C-Class, E-Class and CLA cars and GLA and GLC SUVs.

There are reports of 51 fires, with about 30 in the US.

No injuries or deaths have been reported yet and it's not yet known if any of the fires occurred in the UK.

show room

Daimler said the starting current limiter could overload under “unique” conditions where a driver repeatedly tries to start their car when the engine has seized up.

The recall has not yet been issued in the UK however a Mercedes spokesperson told dealer magazine: “There are probably 75,000 cars in the UK which will be affected by the recall.”

The magazine said owners would be contacted in March.

You may also be interested in BMW to Release Self-Driving 7 Series this Year