Design Scorecard in Microsoft office Excel That Is Visually Pleasant | office.com/setup

Before you design scorecard in Excel, you should first have an image on your mind about what it should look like. This is particularly significant especially since your employees and the managers of the other departments will take a look at the finished product. Using this as their resource for performance appraisal, it should be pleasing to the eyes of the viewer. If not, they will find it difficult to understand or even to look at it. This is why it is important that you are able to create BSC in Microsoft Excel that has been formatted to help you present the data to your audience. So how do you do this?

In order for you to start the process to design scorecard in Excel, you should commence at the title, columns, rows and headers. You can also create a template that will help you format BSC spreadsheets in the future. By means of adjusting the font, style and color of the cells, you are able to customize the look and feel of the scorecard which will eventually aid the others in understanding the data that is in front of them.

Now, the first step that you should take when you design scorecard in Excel is to open a new workbook in Excel. If you already have an existing balanced scorecard format in Excel, you can open that. Under the File menu, go to Page Layout and select Landscape. Typically, the landscape orientation is more preferred by several businessmen and staff members alike. Then, select the columns and rows in your scorecard and then set the font style and size that you prefer along with the alignment of the text. Then, create the title for the BSC.

You can make the title bigger by selecting more cells and then merge them. Choose Merge and Center located at the Format toolbar. Bold the tile and fill the cells with the color of your choice. The next step is to format the columns after you have labeled them. The labels here include Objective, Target, Measures, Actual Number, Initiative Target Number, Target Percentage and Actual Percentage. Of course, the names of the columns will depend upon how you would like to categorize the items on your BSC. You can also fill the background of the cells and the font color to distinguish them easily.

After the columns, you can now modify the rows. In general, the designers alternate the formatting of the rows so that it will be easier to view the results given in the scorecard. The four perspectives should also have different color patterns. These perspectives are customer satisfaction, learning and growth, internal processes and financial data.

Before you publish your scorecard and let your employees see what you have created, take a good look at it first. Aside from the process involved when you design scorecard in Excel, you also have to make sure that the spelling of the words is correct. Remember that spelling errors are not attractive to the eyes of the viewers even though you have a very colorful presentation.

Robert Morris a Microsoft Office expert has been working in the technology industry from the last 5 year. As a technical expert, he has written technical blogs, manuals, white papers, and reviews for many websites such as www.office.com/setup

more info:http://office-office-com.com/blog/design-scorecard-in-microsoft-office-excel-that-is-visually-pleasant/

Office.Com/Setup – Apple’s Mac App Store Welcomes MS Office 365 | www.Office.com/setup

Fulfilling on its promise Apple has now welcomed Microsoft’s Office 365 to its Mac Store. This great news has made the New Year a happy one for those who are Apple loyalist, yet secretly wished for Microsoft Office. Microsoft is making its Office suite available on Apple’s Mac App Store after a short delay for the first time.

Until now, those who wished to use Microsoft Office and its popular products like Excel, Word, PowerPoint, and OneNote had to visit the Microsoft website and download it from there and apply. The software giant has specially designed this version of Office 365 for Mac to enhance the experience of its new users by supporting features unique to Mac like Dark Mode, Continuity Camera in macOS, as well as the MacBook Pro Touch Bar and Mac’s industry-leading Trackpad. Available now in the neat package in Mac App Store Word, Excel, Powerpoint, Outlook, OneNote, and OneDrive are all included as part of the Microsoft Office 365 App bundle. The user needs an Office 365 subscription to use tools like Word, Excel, PowerPoint, and Outlook. The apps, which earlier needed Microsoft’s separate AutoUpdate (MAU), will be now updated automatically.

Shaan Pruden, senior director of worldwide developer relation at Apple, told that the lack of bundling was the major roadblock while entering the partnership earlier, after coming to an agreement on it we are ready for this great collaboration.

Apple Inc., senior vice president of worldwide marketing Phil Schiller, also welcomed Microsoft to the Mac App Store. He congratulated the two companies, who have worked really hard in bringing the excellent Office productivity to the Mac owners, now with its availability in the Mac App Store, it will be possible to provide our iPad, iPhone and Mac users the most advanced and latest version of Office 365.

This step is the best example of an expansion that Microsoft under its CEO Satya Nadella. Microsoft, which powers nine out of 10 personal computers in the world with its monopoly-making software, is looking beyond its obsession with Windows and company is extending a friendly hand even towards its stiff rivals. Although the two tech giants disclose no specifics about the financial arrangements, one can only guess what this partnership would be worth cost.

For Mac and Apple users primarily in the IT industry, it is so far the best offering by the company in recent times.

Aric Wilson is a Microsoft Office expert and has been working in the technical industry since 2002. As a technical expert, Steve Rogers has written technical blogs, manuals, white papers, and reviews for many websites such as office.com/setup.