Microsoft 77-420 MOS Excel 2013 - Microsoft Office 2013 suites

Microsoft Office 2013 suites | Microsoft 77-420 Real Exam Questions

Microsoft 77-420 Exam Topics

Create and manage worksheets and workbooks

• Create worksheets and workbooks
  • Creating new blank workbooks; creating new workbooks using templates; importing files; opening non-native files directly in Excel; adding worksheets to existing workbooks; copying and moving worksheets
• Navigate through worksheets and workbooks
  • Searching for data within a workbook; inserting hyperlinks; changing worksheet order; using Go To; using Name Box
• Format worksheets and workbooks
  • Changing worksheet tab colour; modifying page setup; inserting and deleting columns and rows; changing workbook themes; adjusting row height and column width; inserting watermarks; inserting headers and footers; setting data validation
• Customise options and views for worksheets and workbooks
  • Hiding worksheets; hiding columns and rows; customising the Quick Access toolbar; customising the Ribbon; managing macro security; changing workbook views; recording simple macros; adding values to workbook properties; using zoom; displaying formulas; freezing panes; assigning shortcut keys; splitting the window
• Configure worksheets and workbooks to print or save
• Setting a print area; saving workbooks in alternate file formats; printing individual worksheets; setting print scaling; repeating headers and footers; maintaining backward compatibility; configuring workbooks to print; saving files to remote locations
• 
  

Create cells and ranges

• Insert data in cells and ranges
  • Appending data to worksheets; finding and replacing data; copying and pasting data; using AutoFill tool; expanding data across columns; inserting and deleting cells
• Format cells and ranges
  • Merging cells; modifying cell alignment and indentation; changing font and font styles; using Format Painter; wrapping text within cells; applying Number format; applying highlighting; applying cell styles; changing text to WordArt
• Order and group cells and ranges
• Applying conditional formatting; inserting sparklines; transposing columns and rows; creating named ranges; creating outline; collapsing groups of data in outlines; inserting subtotals
• 
  

Create tables

• Create a table
  • Moving between tables and ranges; adding and removing cells within tables; defining titles
• Modify a table
  • Applying styles to tables; banding rows and columns; inserting total rows; removing styles from tables
• Filter and sort a table
• Filtering records; sorting data on multiple columns; changing sort order; removing duplicates
• 
  

Apply formulas and functions

• Utilise cell ranges and references in formulas and functions
  • Utilising references (relative, mixed, absolute); defining order of operations; referencing cell ranges in formulas
• Summarise data with functions
  • Utilising the SUM function; utilising the MIN and MAX functions; utilising the COUNT function; utilising the AVERAGE function
• Utilise conditional logic in functions
  • Utilising the SUMIF function; utilising the AVERAGEIF function; utilising the COUNTIF function
• Format and modify text with functions
• Utilising the RIGHT, LEFT and MID functions; utilising the TRIM function; utilising the UPPER and LOWER functions; utilising the CONCATENATE function
• 
  

Create charts and objects

• Create a chart
  • Creating charts and graphs; adding additional data series; switching between rows and columns in source data; using Quick Analysis
• Format a chart
  • Adding legends; resizing charts and graphs; modifying chart and graph parameters; applying chart layouts and styles; positioning charts and graphs
• Insert and format an object
  • Inserting text boxes; inserting SmartArt; inserting images; adding borders to objects; adding styles and effects to objects; changing object colours; modifying object properties; positioning objects

Microsoft 77-420 Exam Preparation Resource Guide

You're in luck, because VCEEXAMSTEST currently offering MOS 77-420 Exam Certification study material that will help you pass 77-420 exam in your first attempt. Our experts have compiled the real exam questions and answers which will help you pass Microsoft Office 2013 77-420 Exam. VCEEXAMTEST offering you two types of VCE products, PDF format and Practice Exam Software. Both these VCE products are different in their specifications but their features are shared. In VCE Exam Software you can practice your exam with real scenarios. Because Hands-on practice is the best way to cement what you learn from this study material. Get Microsoft Exam 77-420 braindumps with 100% accurate answers. Hence, you will just pick any of VCE products and begin preparing with best resource for Microsoft Office 2013 77-420 Exam preparation.

Microsoft Launches New AI and mixed Reality Business Applications for Microsoft Dynamics

Microsoft Announced New Artificial Intelligence and mixed Reality Business Applications for Microsoft Dynamics 365

Today, I had the opportunity to speak to press and analysts in San Francisco about our vision for business applications at Microsoft. In addition, I had the privilege to make two very important announcements: the upcoming availability of new Dynamics 365 AI applications, and our very first mixed reality business applications: Dynamics 365 Remote Assist and Dynamics 365 Layout.

Our vision for business applications at Microsoft

We live in a connected world where companies are challenged every day to innovate so they can stay ahead of emerging trends and re-pivot business models to take advantage of new opportunities to meet growing customer demands.

To innovate, organizations need to re-imagine their processes. They need solutions that are modern, enabling new experiences for how they can engage their customers while making their people more productive. They need unified systems that break data silos, so they have a holistic view of their business, customers and employees. They need pervasive intelligence threaded throughout the platform, giving them the ability to reason over data, to predict trends and drive proactive intelligent action. And with adaptable applications, they can be nimble, allowing them to take advantage of the next opportunity that comes their way.

Two years ago, when we introduced Dynamics 365 we started a journey to tear down the traditional silos of customer relationship management (CRM) and enterprise resource planning (ERP). We set out to re-imagine business applications as modern, unified, intelligent and adaptable solutions that are integrated with Office 365 and natively built on Microsoft Azure.

With the release of our new AI and mixed reality applications we are taking another step forward on our journey to help empower every organization on the planet to achieve more through the accelerant of business applications. Specifically, today we are making the following announcements:

Dynamics 365 + AI

First, I am happy to announce the coming availability of a new Dynamics 365 AI offering — a new class of AI applications that will deliver out-of-the-box insights by unifying data and infusing it with advanced intelligence to guide decisions and empower organizations to take informed actions. And because these insights are easily extensible through the power of Microsoft Power BI, Azure and the Common Data Service, organizations will be able to address even the most complex scenarios specific to their business.

Dynamics 365 AI for Sales: AI can help salespeople prioritize their time to focus on deals that matter most, provide answers to the most common questions regarding the performance of sales teams, offer a detailed analysis of the sales pipeline, and surface insights that enable smarter coaching of sales teams.

Dynamics 365 AI for Customer Service: With Microsoft’s AI and natural language understanding, customer service data can surface automated insights that help guide employees to take action and can even leverage virtual agents to help lower support costs and enable delightful customer experiences, all without needing in-house AI experts and without writing any code.

Dynamics 365 AI for Market Insights: Helps empower your marketing, social media and market research teams to make better decisions with market insights. Marketers can improve customer relationships with actionable web and social insights to engage in relevant conversations and respond faster to trends.

To help bring this to life, today we released a video with our CEO, Satya Nadella, and Navrina Singh, a member of our Dynamics 365 engineering team, showing examples of ways we’re bringing the power of AI to customer service organizations.

Dynamics 365 + Mixed Reality

Our second announcement of the day centers on the work we are doing to bring mixed reality and business applications together.

Since the release of Microsoft HoloLens over two years ago, the team has learned a lot from customers and partners. The momentum that HoloLens has received within the commercial space has been overwhelmingly positive. This has been supported by increased demand and deployment from some of the world’s most innovative companies.

We recognize that many employees need information in context to apply their knowledge and craft. Not only on a 2-D screen — but information and data in context, at the right place, and at the right time, so employees can produce even greater impact for their organizations. Mixed reality is a technology uniquely suited to do exactly that.

Today, we also showcased for the first time how Chevron is deploying HoloLens to take advantage of Dynamics 365 mixed reality business applications.

Chevron is already achieving real, measurable results with its global HoloLens deployment. Previously it was required to fly in an inspector from Houston to a facility in Singapore once a month to inspect equipment. Now it has in-time inspection using Dynamics 365 Remote Assist and can identify issues or provide approvals immediately.

In addition, remote collaboration and assistance have helped the company operate more safely in a better work environment, serving as a connection point between firstline workers and remote experts, as well as cutting down on travel and eliminating risks associated with employee travel.

Unlock what’s next with the Dynamics 365 October 2018 release

Next week at Microsoft Ignite and Microsoft Envision we’ll be in Orlando talking with thousands of customers, partners, developers, and IT and business leaders about our October 2018 release for Dynamics 365 and the Power platform that will be generally available Oct. 1. The wave of innovation this represents across the entire product family is significant, with hundreds of new capabilities and features.

Learn the Benefits of Microsoft Certifications and Exam Preparation Material For Best Result:

There are countless exams, certifications, guides and books are available to being successful, however, as success is personal and unique to each individual. All of these are perfectly valid, indeed success is a concept that means different things to different people. Though no matter what success is to you, it almost certainly isn’t something will come easily. If you want to learn how to be successful Microsoft Certified, you have to do something, and maybe the actions you take aren't getting you the results you want, so here we provide Microsoft exam study material. You should start doing for yourself today because they will give the success you want tomorrow.  Wondering what's on a Microsoft Certifications exam? and what I learn? You're in luck, because we provide you different types of Microsoft Certifications study material that will help you pass Microsoft certification exams in your first attempt. We have compiled real exam questions with their answers so that you can prepare and pass Microsoft certification exam in your first attempt. Get most updated Microsoft braindumps with 100% accurate answers. VCEEXAMTEST offering you two types of VCE products, PDF format and Practice Exam Software. Both these VCE products are different in their specifications but their features are shared. VCEEXAMTEST is considered one of the best website where you can practice or prepare your exam with real scenarios and save extra money by getting three-Months of free updates after buying the VCE exam products. Hence, you will just pick any of VCE products and begin preparing with best resource for Microsoft exam preparation. Download the real exam questions and answers for the Microsoft certification that matches your experience level.

Video for Your help Understand better How to Prepare Exam & Become a Microsoft Certified?