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.
Samsung announces the new Galaxy Book Pro and Galaxy Book Pro 360 computing devices at Galaxy Unpacked April event. The new Galaxy Book personal computers (PCs) are designed to be more like your smartphone. Giving you performance on the go, ultra-vivid display and seamless integration with your other devices.
Dr. TM Roh, President and Head of Mobile Communications Business, Samsung Electronics, says the Galaxy books are as thin as a smartphone and ultra-light. Well, not all that thin and light. The 13″ Galaxy Pro Book weighs 0.87kgs whilst the 13″ Galaxy Book Pro 360 with Wi-Fi weighs 1.04kg. He also notes you’ll get a flawless integration experience between Android and Windows.
Samsung says the new line of Galaxy Book will launch on May 14th in select markets. Galaxy Book Pro will start at $999 and the Galaxy Book Pro 360 at $1199.
Check out the device specifications as well as the device hands-on below.
LTE,Wi-Fi 6E Ready, Wi-Fi 6 (Gig+), 802.11 ax 2×2,Bluetooth v5.1
Wi-Fi 6E Ready, Wi-Fi 6 (Gig+), 802.11 ax 2×2,Bluetooth v5.1
Color
Mystic Blue, Mystic Silver, Mystic Pink Gold
Mystic Blue, Mystic Silver, Mystic Pink Gold
Memory
8GB, 16GB, 32GB (LPDDR4x)
8GB, 16GB, 32GB (LPDDR4x)
Storage
Up to 1TB (NVMe SSD)
Up to 1TB (NVMe SSD)
Camera/Mic
720p HD / Dual Array Mic
720p HD / Dual Array Mic
Audio
Sound by AKG, Dolby Atmos®
Sound by AKG, Dolby Atmos®
Keyboard
Pro Keyboard
Pro Keyboard
Battery
63Wh (Typical)
68Wh (Typical)
Adaptor
65W USB Type-C Fast Charger
65W USB Type-C Fast Charger
Authentication
Fingerprint on Power Key
Fingerprint on Power Key
Ports
Thunderbolt™ 4 (1), USB Type-C (1), USB 3.2 (1) 3.5pi Headphone/Mic, MicroSD, nano SIM
Thunderbolt™ 4 (1), USB Type-C (1), USB 3.2 (1), HDMI(1), 3.5pi Headphone/Mic, MicroSD
Here is a first look and hand-on of the newly announced Samsung devices.
[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.
Coursera is collaborating with Microsoft to bring opportunities for skilling in Azure to its 80 million learners. The partnership will see Coursera offer three Microsoft Azure Specialization courses on its platform.
Launching immediately is Azure Fundamentals which gives learners a foundational understanding of Azure cloud services. It also gives basic knowledge to build cloud solutions and helps prepare for the AZ-900 exam certification. This will be followed with Azure AI Fundamentals and Azure Data Fundamentals courses in May.
The AI Fundamentals will teach learners about artificial intelligence (AI) topics, like machine learning, computer vision, natural language processing, and conversational AI. While Data Fundamentals will dive deep into the roles and tasks involved in using Azure to store, process, manage and analyze data.
Leaners who complete and pass all courses in a specialization will receive a voucher for 50% off the certification exams. Microsoft is offering scholarships to 600 eligible Women in Cloud members to all three Specializations and their respective certifications.
[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.
Canon’s Miraisha Programme has selected 10 young storytellers from the Mathare community in Kenya to receive a scholarship at KCA University, helping them to develop skills for a sustainable livelihood.
Canon Central and North Africa (CCNA), together with Canon Miraisha, has chosen 10 young students for film and photography scholarships at the KCA University. Selected out of 200 Canon Miraisha participants taking part in the programme since 2018, the budding creatives will go on to develop their visual storytelling skills at the prestigious institution.
Canon Miraisha goes viral
CCNA has released a series of videos on social media to raise awareness of the importance of the Miraisha initiative and to celebrate the hard work and success of the scholars, which reached an incredible number of over 100,000 engagements. You can watch the full story on the @CanonCNA social channels.
One of the programme’s focal points is to provide employment opportunities to young people across Africa coming from low socio-economic background. Miraisha partnered with MindMe International Community Training Programme, based in a particularly disadvantaged community in Mathare which lacks employment prospects for young people.
The partnership empowers local young people to further develop their existing creative skills and helps them access or even create job opportunities, benefitting both their personal development and their local communities.
Future storytellers
The KCA University scholarships, which run across two 14-week semesters from May to December 2021, will enable the students to develop their visual communication skills as well as open up and prepare participants for creative and professional opportunities. This is particularly significant as currently there are young people entering into employment and entering creative professions.
The scholars will work towards a Certificate in Film Technology, studying 12 subjects including video camera operations, screenwriting, editing, photography and film production techniques. Their final project will be to produce a short film, which will allow them to showcase the development of their skills from their time involved in the programme.
The 10 students who have been granted scholarships are: Anthony Mugendi Mwaura, Cynthia Wanjiru Thige, Paul Mutisya Muindi, Brian Stephen Okwara, Saida Wangui Masudi, Maria Mumbi Muthoni, Irmale Zainabu Irmale, Mogaka Victor Gekara, Kevin Wanyoike Wanjiru, and Mercy Wangui Ndungu.
Partnerships for change
Professor Joshua G. Bagakas, Deputy Vice-Chancellor at KCA University said: “The overwhelming response to the current Miraisha campaign is a resounding vote of confidence in Canon’s training program. KCAU is especially delighted that the campaign will give 10 deserving young people the opportunity to realise their aspirations by studying film at the university. Visual storytelling is a powerful communication tool in today’s world, and we are excited to continue partnering with Canon to empower students and continue transforming lives.”
Somesh Adukia, Managing Director at Canon Central and North Africa added: “The Miraisha Programme is designed to give young people the tools and support to develop their skills and improve not only their own lives but also the lives of those in their communities. We look forward to seeing the scholars nurture their creative talents during their time at KCA University.”
These scholarships are the latest example of the direct support the Miraisha Programme offers to its participants to upskill. Across the African continent, Canon’s ‘train the trainer’ initiative, sees some participants in Miraisha programmes come back to help run future editions, it has already led to 3 local people becoming employed as Canon Miraisha Trainers. Now in its seventh year, Canon’s Miraisha Programme has educated more than 5,680 young storytellers across the continent since its launch in 2014.
[jetpack_subscription_form 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=”16″ 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.
TECNO mobile is introducing the TECNO Spark 7P a new addition to the Spark 7 family designed for Gen Z. The Spark 7P comes equipped with a 6.8-inch edge-to-edge display, 16MP AI Triple Camera and powered by a Helio G70 chipset.
Other features include Super Night Mode and a blazing-fast 90Hz. No release dates and prices have been announced, but the TECNO Spark 7P is expected to be available soon in retail stores.
TECNO SPARK 7P specifications
2.0GHz, Octa-core processor and dedicated 820MHz graphics 128/64GB ROM + 4GB RAM memory 5000mAh battery 16MP AI Triple main camera, 8MP front camera 6.8-inch IPS LCD edge-to-edge display Android 11
TECNO mobile brand has freshly launched the innovative Spark 7P smartphone for Gen Z. Packed with the dynamic 16MP AI Triple Camera and new Helio G70 chipset, the Spark 7P is expected to deliver the most captivating cinematic experience simulated through its 6.8-inch edge-to-edge display with an unprecedented Super Night mode. Enabled through its micro intelligence integrant which grants the rising generation access to an innovative tool, allowing them to streamline many imperative tasks, creating the most rewarding experience yet. The Spark 7P will be welcomed in the global market soon.
Stephen Ha, General Manager of TECNO Mobile, commented on the launch, “TECNO is always bearing the young generations’ demands in mind to provide them with the best of contemporary technologies in artistic designs. With popularity in over 60 markets, TECNO showcases its mastery of serving the youth-generation consumers who are “young at heart”, and inspires them to never stop pursuing excellence. TECNO SPARK 7 series are the ones that reflect our promise to the Gen-Z the most with the most advanced technologies like the BIGGER and BETTER display to bring them immersive cinema experience at the fingertips, and the ungraded 16MP AI Triple Camera for them to embrace a clearer world.”
The Spark 7P brings comprehensive updates on its exceeding visual performance. Users can enjoy the smooth, snappy, and refreshing experience with a 6.8-inch clear screen at a blazing-fast 90Hz refresh rate. The 6.8-inch edge to edge display is also equipped with ample room to navigate through multiple applications with prompt accessibility to different functions, that too within paramount time. Users also earn the privilege of experiencing the new technology of the 90Hz refresh rate at this accessible price.
Camera
Spark 7P’s ingenious 16MP AI Triple Camera is an additional compelling feature that will enable the new breed of innovational youth, to capture every minute detail of their busy lives through acute technological advances ensuring no occasion goes a miss be that day or night. The newly added AI lens enables users to take striking portraits even in the dimmest of surroundings. With its shallow depth of field, the super night mode helps capture exclusive moments most effortlessly with exemplified images, enabling the users to always see their world in the brightest of lights. The 16MP AI Triple Camera is also accompanied by Smile Snapshot, powered by the AI Portrait which incorporates facial recognition intelligence allowing the users to capture that perfect smile or a glimpsing moment in an instant. Meanwhile, Video Bokeh, natural Video Beautify and a Slow Motion shooting at 240fps provide the current, technologically savvy generation with the chance to channel their inner photographer through these intelligently adapted and enjoyable features.
An all-new 2.0GHz, Octa-core processor and dedicated 820MHz graphics unit, SPARK 7P benchmarks at twice the speed of the previous generation. Animations are smoother, Apps load quicker, and photos are sharper, helping connect with the world around Gen Z faster than ever before.
Storage & Battery
128/64GB ROM + 4GB RAM memory and 5000mAh battery enable the Spark 7P long-lasting storage and power. It promises fewer lags, fewer prompts about “Storage Almost Full” and more space for snapping as many photographs as you need. The 5000mAh battery holds the exceptional capability of retaining power on your phone for 14 days without any recharging. Gone are the days when the users have to run around the street panicking and trying to find a charging station because SPARK 7P just never goes off easily.
Other highlighted features packed the competitive smartphone including:
Bluetooth Audio Share 2.0: With the newly updated Bluetooth Audio Share 2.0, users will be able to share their music and get the party started whenever and wherever its convenient for their friends and family to join in the fun.
Dirac Stereo Sound Effect: Meticulous acoustic measurement allows users to play audios and video with acute clarity alongside providing them with a unified and much more enjoyable cinematic experience where both sound and picture are of optimal quality.
The new HiOS 7.5: the Auto Dark Theme peculiarity allows users to customize settings so as to transition from bright to dark theme once night falls. With the help from Instant Chat Bubble, users don’t need to switch between Apps. All one would do is, press the bubble to start a conversation with a friend and continue communicating with another. With App Twin, social media fans can run two social accounts simultaneously and switch between different platforms fast and smoothly.
[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.
