Are you are about to take a Microsoft Excel interview test or assessment and want to make sure you have all the basics covered? Or do you need a quick refresher course to get you ready to ace your Microsoft Excel test? Here are a few videos below from some amazing teachers that will help you prove your functional knowledge of Excel.
Each video covers something unique or different so kindly check their descriptions to make sure you find what meets your needs. You can also check out excel practice online. A platform that allows you to learn and practice excel functions and tools at any level. All the best with your test and interview.
7 key questions asked as part of the Microsoft Excel interview test with Vadim Mikhailenko
Learn how to to make an entire row bold or italic in excel. Make rows with different background colours and calculate a total for either a quarter or year. Sort out data from smallest to largest and group data based on categories. Other things include inserting a chart into a worksheet and forecasting revenue.
Top frequently asked MS Excel interview questions and answers in any Excel Job Interview test with My E-Lesson
This video covers topics such as Vlookup Formula in Excel, making charts in Excel. Using Pivot Table in Excel, how to remove duplicates in Excel and Protecting Sheets in Excel. It also expounds on tracking, data and simple calculations.
5 Excel interview questions you need to get right with Leila Gharani
Leila is a Microsoft Most Valuable Professional (MVP). She explains Excel VLOOKUP function and limitations, how absolute reference in Excel differ from relative cell reference? Other topics covered are; What is a PivotTable and why should you use it? What is conditional formatting? When would you use the IF Function or a Nested IF in Excel?
[jetpack_subscription_form subscribe_placeholder=”Enter your email address” show_subscribers_total=”false” button_on_newline=”false” submit_button_text=”Hi, sign up so you can get the latest in breaking news, reviews, opinions, events, opportunities and community updates right in your inbox. ” custom_font_size=”16px” custom_border_radius=”0″ custom_border_weight=”1″ custom_padding=”15″ custom_spacing=”10″ submit_button_classes=”” email_field_classes=”” show_only_email_and_button=”true”]
Check out other stories making the news in the technology ecosystem in Africa and the Middle East.
What happened to Microsoft Virtual Academy(MVA)? Where is Microsoft Virtual Academy? I’ve seen a lot of search questions related to these and want to talk about it in this post. For starters the Microsoft Virtual Academy resources or content are no more. However it still exists but in a new improved and modern home; Microsoft Learn. The MVA page doesn’t exist and will redirect you to the new Microsoft learning page.
Microsoft announced in January 2019 it was retiring the MVA page. Stating three reason for this. One bring all its learning platforms into one hub. Two revising outdated knowledge and introducing modern and relevant skills for the next generation of creators. Three structuring the modules to be task-based achievements. Which the company believes can help you advance your technical skills in modern roles. Microsoft Learn is also free just like Microsoft MVA.
The new learning platform has an interactive learning environment. That combines short step by step tutorials with interactive coding and scripting environments in a sandbox.
Microsoft was also allowing anyone who was on a course to complete it and retain transcripts and certificates. I’m not sure how anyone can access the old certificates now. If you have been able to do this, kindly share this with us in the comments.
Got any other question about Microsoft Virtual Academy (MVA) i didn’t talk about? Ask in the comments and i’ll get you answers.
[jetpack_subscription_form subscribe_placeholder=”Email Address” show_subscribers_total=”true” button_on_newline=”true” submit_button_text=”Hi, kindly subscribe to get the latest news, events, offers, opportunities, etc. from the Microsoft and tech ecosystem in Africa and the Middle East region. ” custom_font_size=”16″ custom_border_radius=”0″ custom_border_weight=”1″ custom_padding=”15″ custom_spacing=”10″ submit_button_classes=”has-text-color has-background-color has-background has-primary-background-color” email_field_classes=”” show_only_email_and_button=”true”]
The ZEPTO UmiTab 10.1″ 2 in 1 device has seen some more interest from the public. So I received one and took it for a spin so I can answer properly questions asked.
I received the Cyan colored ZEPTO UmiTab 10 device running Windows 10. I decided to upgrade it to the Windows 10 Anniversary Update(AU) for better performance. The Windows 10 AU definitely has a lot of bug fixes and improvements to battery life etc., etc. seem only fair.
We earlier did a specifications post on the ZEPTO UmiTab and you can check it out if you want to know what powers it.
It sits in a class of its own. It’s not a high end nor is it a low-end device. I believe it’s just perfect for the kind of customers it’ll attract. I see students and workers who need a PC for browsing, taking notes, watching movies and playing music.
The ZEPTO UmiTab 10 surely has some pro’s and con’s and i’ll dig a bit into it.
DESIGN
It certainly has a nice feel to it. It’s a detachable two in one device. Good thing the soft keyboard which doubles as a cover comes included. It’s easy to attach and detach. It has the Microsoft Surface magnetic clip thing. only I think the Surface clicks in and holds more solidly and firmly. But so far as it sits on a steady surface like a table, you need not worry.
At 550 grams it doesn’t feel heavy. You can carry it in hand as you would your notepad or diary, only this ends up being more powerful.
Performance
Sporting a Quad-core Intel Baytrail T-Z3735 processor with 2GB RAM and 32GB ROM means light work can be done. If you are a video and photo editing person, these aren’t the specifications that excite you. It works well-browsing websites and having quite a number of tabs open. Video and Music play works well. Using the installed Office 365 Home package that comes preinstalled is hustle free and effective.
Hardware There are a number of helpful hardware features that comes in the device. There’s the SIM card slot on the side, that allows for data connections. The data connection is pretty straight forward and very easy to set up and use.
Folks have asked if it can be used for making calls? Well unfortunately it doesn’t. The device doesn’t fall in the Mobile classification 8″ and below. So if you search for the Microsoft Phone from the app store you won’t find it. or it’ll show and tell you non-compatible device.
A mini HDMI, USB, Headphone and MicroSD card slot can be found on the side of the ZEPTO UmiTab 10. The available MicroSD card slot can help with expanding your storage space. It’s on the side, as a result, it is easy to pull and plugin. I used a micro USB OTG in the USB slot to access the contents on my phone. There’s also the option of connecting any USB device via an OTG, don’t know if it comes in the box. Didn’t get one but i’ll check and update.
Sound, Mic, Camera, Speakers
Having a 2 or 5MP camera isn’t a luxury in today’s world where some phones have bigger and better. However, I think it’s enough to get the light things like a video call out of the way. Well unless of course, you want HD. But then you pay more for those than this :). The 2MP front camera has face detection and the back 5MP seems quite decent with autofocus.
The Microphone wasn’t very loud in my test playbacks. Speakers were just okay for music and video. I’ll say not the best compared to sophisticated devices on the market.
Battery Life
Battery life is estimated to be between 6 to 8 hours. I experienced something around 5 and 6 hours. But battery lives are always subject to use. I one time during a video playback had around 10 hours estimated.
What I think:
It’s great value for money.
The soft keyboard didn’t quite hit it for me. it’ll take some getting use to. Gestures on the trackpad aren’t great. Maybe a firmware fix might come in handy.
The internal memory of 32 GB is just too small. You’ll have about 7GB of storage left to use. This is where the MicroSD card slot comes in.
It’s not lappable. More of either detach and use as a tablet or dock it on a table for effective use
The PC’s come in red, cyan/blue, black, gray and pink colors.
If there’s something you’ll like to know that I didn’t touch on. Or have you used or owned one and experienced it differently? Kindly share with us in the comments.
Windows 10 Anniversary Update is rolling out to devices with loads of new features and fixes.
The Windows 10 anniversary update is officially now available for download. It comes with a lot of new features and some fixes to make your Device run better. But it is maybe in a trickling manner. It’s being rolled out in phases. To newer devices then the older ones. So it could take a while to show up automatically in your Windows Update Settings. If you are the type who likes to stay up to date and still don’t have it. Here’s how to get it right now.
First we show you how to use the Microsoft Upgrade Advisor and then how to download an ISO file of the OS.
UPGRADE USING MICROSOFT UPGRADE ADVISOR
Go to Settings > Updates & Security > Windows Update
In Windows Update simply click Check for Updates.
Technically it’ll show you have the latest update. But the idea is to trigger it manually. So click on the learn more link ( Learn more ) below the looking for info on the latest updates?
It’ll redirect you to the Windows 10 update history page. Under the About the Windows 10 Anniversary Update click on the get it now button.
It’ll download an executable file. Run it after it’s done and follow the steps. This should work like the Microsoft Upgrade Advisor (if you remember from the Windows 10 release).
2. UPGRADE BY DOWNLOADING THE DISC IMAGE (ISO FILES)
Visit the Microsoft ISO download page for windows 10 (click here). Choose your Windows 10 edition from the drop down menu and confirm selection.
Select the product language of the OS and confirm selection.
Choose the OS type. Check if it’s a 32 or 64 bit machine before choosing.
The file should begin downloading. Allow it to finish and run the installation or write it to a disc.
Voila this should get you up to date in no time if your internet speed is good. Go give it a try and let us know how it worked out.
HELP! Comes in very handy at one point as everyone needs it.
With every device comes the challenge of having some difficulty with using it at one point or the other. Either due to a physical damage, software failure or something else. There is real comfort in knowing someone’s got this and it doesn’t have to drive you literally crazy. You can also learn to troubleshoot issues before they become main problems.
Below you’ll find different go to solutions to try by yourself or if you are the very careful type; a number to contact for repairs.
When You Need to Repair your Microsoft Mobile Phone:
Microsoft (Nokia) Care Office – Kwame Nkrumah Circle, Kokomlemle Faanofa Street. – (020) 020 6500, 0302265210
Microsoft (Nokia) Care Office – Osu – (024) 026 2606 / 030 279 9028
Opposite Regal Chinese Restaurant, 1st floor, House No. 530/1, 5th Lane Osu, Accra
How to get Windows 10 Mobile OS running on your mobile device;
There are only two ways to get Windows 10 Mobile OS running on your device:
Or Check from the List of Upgradable Windows 8.1 devices.
If the upgrade is available for your existing Windows Phone 8.1 device, you can install the upgrade.
To check if the upgrade is available for your phone and install the upgrade, go to the Store, install the Upgrade Advisor app, run the app to see if the update is available, and then select Enable Windows 10 upgrade.
How to get an activation code for your mobile device:
Kindly Click —-> here or type out —> [ https://support.microsoft.com/en-us/contact/menu/hardware/wp/ ] in your web browser. You can either call, text chat a Microsoft Answer Desk person who’ll require your phones IMEI and model. (chat is usually a better option).
How to Add a Microsoft account to your phone:
On Start , swipe over to the All apps list, then select Settings > Accounts > Your email and accounts and your created Microsoft account. (You can now use any email account you have, Yahoo, Gmail, etc. Once you sign that up as your Microsoft Account).
How to Setup Windows Hello Login if you own a Lumia 950 or 950 XL (or supported device);
Windows Hello is another way to sign in to your Windows 10 mobile device. It uses your eyes to verify your identity. It needs special hardware and so this isn’t available with every windows mobile device.
To set it up; On Start , swipe over to the All apps list, and then select Settings > Accounts > Sign-in options to set up Windows Hello. (If you don’t see a sign-in option for Windows Hello, then your phone doesn’t support it.) Once you’re set up, you’ll be able to unlock your phone at a glance.
How to Setup and Use Continuum
Create and edit Office documents, send email, type text messages, watch videos, browse your photos, or surf the web on your connected screen. When you’re done, your work goes with you—it’s saved on your phone.
Continuum turns your phone into a big-screen projector and a big-time productivity tool. Use a dock or wireless adapter to connect to a TV or monitor, then use your apps and see your content on a larger screen. Want to do even more? Connect a keyboard and mouse and get productive.
*Use your Phone as a Phone during Continuum. Even when you’re connected to a display or monitor, you can still use your phone in all the usual ways. Make and receive calls, send texts, check your social media apps—it’s all still a tap away.
How you set up Continuum depends on what type of hardware you’ve got. Here’s what you’ll need to get started.
A TV or monitor with HDMI input.
A Windows 10 Mobile phone that’s compatible with Continuum.
A compatible accessory for connecting your phone to your TV or monitor.
A power outlet to plug in your dock or adapter.
*Use your Phone as a mouse during Continuum. To use your phone to control your connected screen, select Tap to control in the Continuum banner at the top of your screen. Then swipe your finger around the phone’s screen to move the cursor.
To connect using a wired dock:
Plug the dock into a power outlet.
If you’re connecting to a TV, make sure the TV’s input is set to HDMI.
Plug the dock into the HDMI port on your TV or monitor.
Plug your phone into the dock.
To connect using a wireless adapter:
Plug the adapter into a power outlet.
If you’re connecting to a TV, make sure the TV’s input is set to HDMI.
Plug the adapter into the HDMI port on your TV or monitor.
On your phone, swipe over to the All apps list, then select Continuum.
Select Set up. (You’ll only see this screen the first time you connect.)
Select Wireless, then select Connect.
On the Connect screen, select the name of the wireless adapter.
**** To get to more settings and options while you’re connected, tap the Continuum banner at the top of your phone screen, then tap More.
I hope these are helpful in a way. Send us a message in the contact page for any other help you need how to on. Or reply with a help or question in the comments page. Also return to this page as it’ll get updated with more help information.
WhatsApp Web is finally available to Microsoft Edge browser users.
Microsoft Edge is the official browser that comes pre-installed in Windows 10 and Windows 10 Mobile operating system. It’s also the browser that officially replaced Internet Explorer (still available in windows 10).
WhatsApp Web was introduced sometime in January 2015 as a web client that mirrors a persons chat account from your phone to your personal computer. This was introduced to provide a richer communication experience to users of WhatsApp. WhatsApp Web isn’t a different chat account or platform. It’s the same WhatsApp account setup on your phone that gets synchronized and mirrored to the PC, so you have the same information.
But up until now it wasn’t usable on Microsoft Edge browsers and still doesn’t support any Internet Explorer version.
How do you go about this?
Minimum requirements to enjoy WhatsApp Web
You need to have an active WhatsApp account on your phone.
You need to have a stable internet connection on both your phone and your computer.
You need to use the latest version of Microsoft Edge, Chrome, Firefox, Opera or Safari as your web browser on your computer.
On Windows Phone: under Chats go to Menu > WhatsApp Web.
On Android: in the Chats screen > Menu > WhatsApp Web.
On iPhone: go to Settings > WhatsApp Web.
On BlackBerry: go to Chats > Menu > WhatsApp Web. (On BlackBerry 10: Swipe down from top of the screen )
Scan the QR Code on your computer screen from your phone with your camera.
From your phone, navigate to WhatsApp Web to view your logged in computers or to logout from an active chat session.
Is this an added bonus to you?, because honestly I’ve been looking forward to this as I’ve decided to try out only Microsoft Edge and Internet Explorer on a PC as only browsers. There have been some limitations as expected but with more extensions expected to be available in the next major Update aka “RedStone”, I guess I wouldn’t have much to worry about.
