Here are some tips on how to pass your Microsoft Excel interview test

Here are some tips on how to pass your Microsoft Excel interview test

Microsoft Excel test interview

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.

Here is what you should know about Microsoft Build 2021 May digital event

Here is what you should know about Microsoft Build 2021 May digital event

Microsoft Build 2021 digital event keynote

Registration for Microsoft Build 2021 is opened and it will be a completely free digital-only event. It will be in the form of a 48 hour long virtual interactive experience available across all the time zones. Microsoft’s developer-focused event will start from 3 PM GMT, 6 PM EAT, 5 PM SAT, May 25th to 27th 2021.

Like last year, Microsoft notes registration for Build is free but to get access to the full interactive content you’ll need to register. However, sessions covered on the hero video such as the keynotes will not require you to be registered. Event attendees will be able to customize 48 hours of continuous content to get their digital event experience. The event will have both live segments such as the keynotes, live technical sessions and Q&A. As well as already recorded content sessions.

Whether you are a student or an experienced app developer, you will gain action-ready skills specific to what you do through immersive experiences, engaging with community, and one-on-one guidance from Microsoft engineers.

To enjoy a total conference experience Microsoft advises you to register as most sessions will require you to sign in. Registration will give you the ability to schedule your viewing events or sessions. And to access the connection zone, one-to-one consultations with an expert, and other community and networking sessions.

Featured speakers for Build include Satya Nadella, Microsoft CEO, Amanda Silver, CVP Products, Developer tools, Donovan Brown, and Scott Guthrie EVP, Cloud and AI Group. Others speakers are Scott Hanselman, Kayla Cinnamon, Rajesh Jha, Kevin Scott, Anna Hoffman, Dona Sarkar, Christina Warren and more.

Click here to register and visit the Microsoft Build 2021 digital event page for more details.

Imagine Cup finals @ Microsoft Build 2021

Build 2021 will also host the finals of the 2021 Microsoft Imagine Cup World Championship. Where Team REWEBA from Kenya alongside three other teams across the globe will present and showcase their solutions for a chance to win the competition.

What to expect?

  • Keynotes: Headlines and announcements delivered by executives
  • Technical/Breakout Sessions: More in-depth coverage of keynote content
  • Ask the Experts: Sessions with experts in cloud, desktop, mobile, and web development for guidance specific to your project or interests. 
  • Humans of IT: Discover the intersection between humanity and tech through inspirational stories about humans who use tech for good.
  • Table TopicsGather the community for live discussion on camera, and in chat! Get inspired by community experts, learn best practices, and discover helpful resources with other attendees.
  • Local Connections: Opportunity to engage with attendees on a local level. Dedicated time for local leadership to deliver an experience to help attendees find developers and experts with similar interests within their region.
  • Student Activities: Content covers key topics to help you get started across a variety of Microsoft technologies, job roles, and interests.
  • Learn Live: Guided online with a subject matter expert to walk and talk through Microsoft Learn modules​.
  • Partner Sessions: Connect with Microsoft Partners in either an Ask the Expert or Table Topics session
  • Product Roundtables: Two-way discussions between product teams and customers
  • Cloud Skills Challenge: Complete preset collections of online learning modules for a chance to win prizes.
  • One-on-One Consultations: One-on-One Consultations will provide Microsoft Build attendees a unique opportunity to connect with a Microsoft professional to discuss specific questions and solutions. Sessions are 45 minutes long and provide the only one-on-one setting at the conference.

Like previous Microsoft Build events stay tuned and we will bring you the keynote livestream and announcements from the event.

[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.

Genesys partners with Microsoft to help enterprise contact centres improve employee and customer experiences

Genesys partners with Microsoft to help enterprise contact centres improve employee and customer experiences

contact centres New Genesys Microsoft Teams South Africa

Genesys a global leader in cloud customer experience and contact centre solutions is expanding its Microsoft partnership with a new, native integration.

Microsoft Teams and Genesys Cloud, are now fully integrated, giving employees a more connected, intuitive and productive experience.

As a result, contact centre agents can collaborate with any employee. Using Microsoft Teams so they can resolve customer issues faster and deliver better service.

Genesys Cloud and Teams make collaboration easy for contact centres

contact centres New Genesys Microsoft Teams South Africa enterprise

Today, employees of contact centres work in several different systems across multiple devices, constantly toggling back and forth. This adds inefficiency and friction, stifling collaboration efforts and making it more time consuming and cumbersome to serve customers. Together, the integrated solutions address these challenges and enable employees to call Teams users throughout their organisation, all from within Genesys Cloud.

Bridging the gap between the front and back office

When agents need to consult with a subject matter expert outside of the contact centre, they can use the integrated directory, search and presence features to find the Teams user with the right expertise from within their Genesys Cloud desktop. They can determine availability and collaborate in real time with a single click.

For example, if a customer asks a question about a loan for a new holiday home while on a support call, an agent can quickly find an available mortgage specialist to help address the issue during the interaction. This facilitates teamwork, knowledge sharing and results in faster resolution for customers.

We are thrilled to add yet another element to our long-standing partnership with Microsoft. Which marks an important step forward in helping our customers deliver on the promise of Experience as a Service“. Shares Olivier Jouve, executive vice president and general manager, Genesys Cloud.

With more than 75 million daily active users, Microsoft Teams is a predominant unified communications and productivity tool for thousands of enterprise organisations. By integrating our platform with Teams, employees can draw upon expertise from anywhere in the organisation so they can provide experiences tailored for every customer.”

Mike Ammerlaan, Director of Microsoft 365 Ecosystem marketing at Microsoft said, “More organisations recognize that employees throughout the business contribute to outstanding customer experiences – not just those in the contact centre. The Genesys Cloud and Microsoft Teams integration helps ensure employees are equipped with the right tools to collaborate with colleagues across the enterprise while benefitting from features like advanced routing, call recording and interaction analytics to deliver consistent service.”

[jetpack_subscription_form subscribe_placeholder=”Enter your email address” show_subscribers_total=”true” button_on_newline=”false” submit_button_text=”Sign Up” custom_background_emailfield_color=”undefined” custom_background_button_color=”undefined” custom_text_button_color=”undefined” custom_font_size=”16″ custom_border_radius=”0″ custom_border_weight=”1″ custom_border_color=”undefined” custom_padding=”15″ custom_spacing=”10″ submit_button_classes=”” email_field_classes=”” show_only_email_and_button=”true” ]

Check out other stories from MCGH.

Prepostseo announces Microsoft add-on after a successful launch of its chrome extension

Prepostseo announces Microsoft add-on after a successful launch of its chrome extension

Microsoft add-on prepostseo seo

Checking plagiarism and rewriting the article directly in Microsoft Office is a hot topic these days. Well, the wait is over! After successful production of the Prepostseo Chrome extension and Prepostseo WordPress plugin, Prepostseo.com is planning to launch Prepostseo Microsoft add-on.

Microsoft add-on for Prepostseo

Add in plays an important role when you want to add more functionality in Microsoft Office. It creates new, luxurious and interactive objectives that make your document more efficient. Prepostseo Microsoft add-on will be a free tool with extensive functionalities that can be used in the office. You can use this add-in to build resources that can extend the Microsoft office applications. It will provide the same features as in chrome extension and plugin.

Its basic features will be:

1.    Plagiarism Checker

Your content can be labelled as “Duplicate” if it has a high percentage of coincidence with another’s work. When this duplication occurs, in addition to being an academic problem, it may also have legal consequences. Plagiarism checker is one of the most amazing features provided by prepostseo.com.

Now you will be able to check the plagiarism of the content directly in Microsoft office tools. It will highlight the plagiarized lines in MS Word, so you don’t have to check them manually. The Prepostseo Microsoft add-on will check the plagiarism in your content with the effort of just one click. It will also tell you the percentage of uniqueness and plagiarism. The plagiarism checker feature will involve the following factors:

  • Check the content of the document in millions of web pages
  • Compare results with just one click
  • Check the sentence one by one
  • Display unique percentage
  • Check every word in your post
  • Real-time checking

This type of feature works with an online database that contains a considerable amount of work from sources like:

  • Documents from other participants
  • Academic articles and blogs already published
  • Databases from different publishers
  • Millions of web pages

2.    Check grammar and spelling mistakes

Readers always relate the quality of the content to the quality of the service. Even in a short text, the degree of professionalism and attention to detail is appreciated. Any kind of mistake, either spelling or grammar, causes a negative effect on the image you want to give. So, it is perfect if your content is free from grammar and spelling mistakes. Well, from now on, you don’t have to worry about these mistakes.

Prepostseo add-in will also provide the facility of grammar and spell checking through its efficient algorithms and extensive database. This feature consists of the following attributes:

  • Check spelling mistakes
  • Check grammatical errors
  • Give sentence styling suggestions
  • One-click operation
  • You can change any word with a suitable synonym

3.    Paraphrasing or rewriting

If your content is similar to someone else’s work, it will be necessary for you to make it unique. Paraphrasing is the technique through which you can make your article unique by:

  • Changing the structure of the sentence
  • Changing the appropriate synonym of a word
  • Reordering the words in a proper manner

But don’t worry, you do not have to do it by yourself. The paraphrasing feature of the prepostseo add-in will rewrite your article in such a way that the new version will look unique. Uses of this feature are listed below:

  • Rewrite full-length document
  • Reproduce sentences to achieve unique content
  • Achieve better synonyms for several words
  • Remove chances of plagiarism
  • Achieve the better meaning of the sentence

4.    Check SEO status of the article with Prepostseo Microsoft add-on

This feature calculates the total SEO score and gives suggestions to improve the SEO status of your article. It checks how you have used the headings in your article. It also checks the title, slug and Meta keywords. And testing all these attributes gives the overall SEO result of your article.

If the SEO score is not too good, you must make improvements to increase it. The reason is, SEO is essential to increase visibility in search engines. It provides the following facilities:

  • Check headings like H1, H2, H3 and H4
  • Count the words and characters in your article
  • Check the title of the article as well
  • Display total SEO score
  • Check keywords and links

5.    Keyword Density

This feature of the add-in will check what percentage of the total length of your article occupies the different keywords. It analyzes the keyword density consisting of one, two, or three words. This add-in will also have many more beneficial elements that can be very useful to make more improvements in your blog.

Add-on for Microsoft office can seriously change the functionality of the programs included in it, making them more suitable for solving routine user tasks.It is clear that these tasks are different for different categories of users, so every user chooses add-in according to his needs.

So, if you want to write content for your website, this [pre post seo, prepost seo, freepostseo] add-in is perfect for you.

[jetpack_subscription_form subscribe_placeholder=”Enter your email address” show_subscribers_total=”true” button_on_newline=”false” submit_button_text=”Sign Up” 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 posts from MCGH.

Microsoft Teams to accommodate up to 20,000 participants in a single meeting, Teams meetings to support up to 1,000 participants

Microsoft Teams to accommodate up to 20,000 participants in a single meeting, Teams meetings to support up to 1,000 participants

Microsoft Teams accommodate

Microsoft Teams is upgrading the virtual platform to accommodate larger groups for meetings and classes. As part of this new upgrade, meeting organisers who want to have more people watch a presentation or discussion will soon be able to bring together up to 20,000 participants at a go but for a view-only meeting experience.

And for more interactive meetings—where attendees can chat, unmute to talk, and turn on their videos for real-time collaboration, Teams meetings are growing to support up to 1,000 participants, up from a maximum of 250 participants currently.

These upgrades are part of new features in Microsoft Teams that will make virtual interactions more natural, more engaging, and ultimately, more human. These features offer three key benefits for people at work and in education. First, they help you feel more connected with your team and reduce meeting fatigue. Second, they make meetings more inclusive and engaging. And third, they help streamline your work and save time. It’s all about enabling people everywhere to collaborate, to stay connected, and to discover new ways to be productive from anywhere.

As the global response to COVID-19 evolves, communities around the world have moved from an era of “remote everything” into a more hybrid model of work, learning, and life. And as we all scramble to keep up, the future of work and education is being shaped before our eyes. At Microsoft, we have spent the last few months learning from our customers and studying how they use our tools,” Jared Spataro, Corporate Vice President for Microsoft 365.

Of the new features announced – the Together Modewhich will be available for users from next month, presents a new meeting experience in Teams that uses AI segmentation technology to digitally place participants in a shared background, making it feel like you’re sitting in the same room with everyone else in the meeting or class. Research has shown that since most people started doing work remotely, many people are feeling less connected and experience more fatigue during video meetings than during in-person collaboration. This mode makes meetings more engaging by helping you focus on other people’s faces and body language and making it easier to pick up on the non-verbal cues that are so important to human interaction.

It’s great for meetings in which multiple people will speak, such as brainstorms or roundtable discussions, because it makes it easier for participants to understand who is talking,” Spataro explains.

The second feature – the Dynamic viewoffers an extraordinary new meeting experience but it’s not intended for every meeting. We believe that traditional video meetings people use every day can also be more engaging and dynamic. A set of enhancements we call dynamic view gives you more control over how you see shared content and other participants in a meeting. Using AI, meetings dynamically optimize shared content and video participants. New controls—including the ability to show shared content and specific participants side-by-side—let you personalize the view to suit your preferences and needs.

The third feature is the Video filters which allows users to subtly adjust lighting levels and soften the focus of the camera to customize their appearance. Also introduced is the Reflect messaging extension which is based on research that shows that employee well-being is more important to productivity than ever. Creating an emotionally supportive environment is key to keeping people healthy, happy, and focused. The new Reflect messaging extension gives managers, leaders and teachers an easy way to check in with how their team or students are feeling — either in general, or about a specific topic like work-life balance, the status of a project, current events, or a change within the organization. IT administrators will be able to install the Reflect extension from GitHub, and then make it available to employees in their organization in the message extension menu.

In addition to the above, Teams users will soon be able to react during a meeting using emojis that will appear to all participants. Live reactions is a shared feature with PowerPoint Live Presentations, which allows audience members to provide instant feedback to the presenter.

Also, during meetings, chat has become a lively space for conversation and idea-sharing and offers an option for people to participate in the discussion without having to jump in verbally. But it can be challenging to pay attention to video feeds, presentations, and chats all at the same time. Currently, Teams users need to manually open a chat window to view the chat screen. Soon, however, chats sent during a Teams meeting will surface on the screens of all meeting participants, making the chat more central to the conversation. 

While Teams already provides live captions as a way to follow along with what is being said in a meeting, soon we will add speaker attribution to captions so that everyone knows who is speaking. Live transcripts, coming later this year, provide another way to follow along with what has been said and who said it. After a meeting, the transcript file is automatically saved in a tab as a part of the meeting. “Unless otherwise specified, all of these features will roll out later this year. And they all reflect our vision for the future of work: where everyone is able to contribute and do their best work; where they can move fluidly between experiences, apps, and devices; where AI lends a helping hand to streamline tasks, provide short cuts, and save you time; and where technology contributes to wellbeing and doesn’t detract from it,” explains Spataro.

New Microsoft Teams feature ‘Together Mode’ reduces fatigue, makes meetings more engaging

New Microsoft Teams feature ‘Together Mode’ reduces fatigue, makes meetings more engaging

Together Mode Microsoft Teams office 365 feature update

To help make virtual meetings look natural as well as encourage more engagements, Microsoft announces ‘Together Mode’ in Teams.

With Together Mode, Microsoft uses AI segmentation technology to digitally place meeting participants in a shared background. Making participants feel like they are in the same room. The feature tries to imitate a real environment so much that participants can lean over and tap each other or make eye contacts.

It doesn’t use the traditional grid boxes, instead, Microsoft is introducing new environments. Starting with an auditorium view now and hopes to roll out new views in the future.

“People can now practice some of the social signaling they would do in real life.”

Microsoft notes that focusing on other people’s faces and body language is important to human interaction. This, research shows reduces the chances of experiencing fatigue during video meetings and interactions.

Here is a video of how the feature works.

Introducing Together Mode in Microsoft Teams

Today we’re announcing a set of new features in Microsoft Teams that make virtual interactions more natural, more engaging, and ultimately, more human“, shares Jared Spataro, Corporate Vice President for Microsoft 365.

It’s all about enabling people everywhere to collaborate, to stay connected, and to discover new ways to be productive from anywhere“, he continues.

The feature comes in a set of updates that will be rolling out to the Microsoft Teams collaboration solution. Other new features are dynamic view, video filter, live reactions, Cortana in Teams, chat bubbles and suggested replies.

Check out some of the new features in action.

[jetpack_subscription_form subscribe_placeholder=”Enter your email address” show_subscribers_total=”true” button_on_newline=”false” submit_button_text=”Sign Up” custom_background_emailfield_color=”undefined” custom_background_button_color=”undefined” custom_text_button_color=”undefined” custom_font_size=”16″ custom_border_radius=”0″ custom_border_weight=”1″ custom_border_color=”undefined” custom_padding=”15″ custom_spacing=”10″ submit_button_classes=”” email_field_classes=”” show_only_email_and_button=”true” ]

Check out other stories from the Africa and Middle East ecosystem.