What’s New In Microsoft Word 2013?

With the recent launch of Office 15 at a media event, new trends have surely been set. The flurry of Windows 8, its metro user interface and a clean and resourceful look has brought in criticism from around the world, but the overall balance is being seen in Microsoft’s favor, as it embarks upon technology integration, cloud-connectivity, and modern, touch-friendly outlook. In what follows, we will inform you exactly where Microsoft Word 2013 from the Office 15 Suite aims to reform your experience with documents. It is surely time to embrace text-flow, PDFs, collaborations, and the world wide web through a resourceful Office App Library for the better. A cleaner discussion thread and Microsoft SkyDrive integration promise a unique experience for the novice as well as advanced users.

The overall Office experience has been revamped with a new logo, faster loading time and a landing page enhanced with user friendly themes and templates. To access features like document sharing and remote access, you are required to create a Microsoft Office account online, as it will be used as a default account for sharing and accessing documents from remote locations.

Integrated Account Management & Connected Services

The landing page provides you with a sleek interface organized into three sections: the navigation sidebar, account information and product information. The navigation bar allows you to access essential word processing functionalities including sharing, exporting and return buttons. The overall Word interface is highly responsive obeying the click, instantly. As illustrated below, Word 2013 comes with a customizable themes (that can be selected from the Office Background dropdown menu boasting multiple attractive themes). Moreover, understanding the power of social media and its penetration in generating viral content, Microsoft has decided to ride the wave by offering Connected Services that virtually allows you to access documents from any device on the go. Just use your Microsoft or SkyDrive account or connect using Youtube. Still not satisfied with the feature? Why not Add a service and connect your work to your favorite online hot spots. The Product Information on the left allows you to Manage account or analyze the overall subscription of the Office Suite with update details.

When adding a new service, Word 2013 allows you to link your existing Microsoft account with another online service like LinkedIn. If you don’t have a LinkedIn account, just click the Join Now button on the top right corner to create one. You can specify the access duration and upon approving the link, the new service will get connected to Word, successfully.

Object Placement beyond the right click

In all previous versions, placement options relevant to objects like pictures, figures, etc. were accessible from the right-click menu. You may have used the Wrap Text feature, placement and adjustment with text, re-sizing and rotation utilities. In Word 2013, a simple click reveals all relevant functionality with the layout options floating on the right, while re-sizing buttons on and around the object. Options can be easily expanded by clicking See more. Double click on the picture to zoom for a better view of the target. With live layout and alignment guides, you can drag your image wherever you want with the text adapting in real-time, accordingly.

Enhanced templates directory

A comprehensive template directory comes to view upon clicking New. It is advisable to load the Welcome to Word document for a quick tour of Word 2013. A large number of useful and popular templates are organized in the New tab as user-friendly tiles. Moreover, the search bar allows you to browse, view and select from hundreds of online templates in the Office Library.  Suggested searches enhance the searching experience by highlighting frequently used categories.

Office Apps: Redefining Creativity

Office Apps are a new way of adding creative and useful applications to Microsoft Office 2013 suite. The Merriam-Webster Dictionary and eFax app for Word 2013 are useful ways of increasing productivity while creating and managing documents. Moreover, there are loads of free featured apps and a huge collection in the Office Store awaiting your click. You can manage your apps and refresh to keep track of any updates.

Insert Pictures From the Web, Instantly

The Insert tab on the ribbon reveals some new and useful additions. One such feature is the option to insert online pictures. Microsoft has updated its Royalty Free Photos and Illustrations directory that can be accessed using the search bar in the Insert Pictures window. You can also browse your online SkyDrive storage for clipart stored in the cloud. Too often do we use our Image Search to identify relevant photos in the web browser to paste into Microsoft Word. Now, you can use the Bing Image Search and Flickr account to hunt and insert online pictures for good from within Word 2013.

Insert Online Videos And Interactive Content Easily

In an attempt to promote dynamic content in documents, Word 2013 presents to you the option to add online videos may it be from social media sites like Youtube, search engines like Bing Video search or videos from any other website (using embed code). To insert a video successfully, type a keyword in the relevant search bar to view results.

Word 2013 displays all results, mentioning the total number of links. Just click the result to preview the video before actually inserting it into the document. Similarly, multiple video results can be added by selecting, previewing and inserting, accordingly. Text Reflow allows you to fit the interactive content in the most appropriate manner.

Simplified Markup View For Better Collaborations

Working with text had never been so interactive. Online Pictures and Videos already added color and dynamic content to the Word document ensuring fast track follow up on relevant topics. Now, with a simplified markup view meant to highlight changes in your document in a neat, effective manner encourages you to focus on collaborating work. The left sidebar indicates changes while a small cloud on the right indicates comments at the respective places. With Word 2013, you can instantly reply to comments in an organized manner to give rise to useful discussion threads. With Microsoft SkyDrive and SharePoint, working on projects and documents online as a collaborated effort could have never been simpler. These markers and comment threads allow you to highlight necessary details, corrections and pointers for the rest of your team to keep in mind. Similarly, keeping track of the activity around your workspace has thus, been made possible.

Say Goodbye to PDF Readers & Editors

All of us use PDF documents, but we often rely on third party tools to extract pictures or specific pages from the overall structure. Using Word 2013, you can easily open a PDF file like any other Word Document. Editing text, tables or lists, re-sizing pictures, adding, removing and highlighting information are all possible as well.By default, when you open PDF file in Word 2013, it shows you the protected view, preventing your system from getting infected by virus-injected PDF documents. However, you can click Enable Editing to open your PDF document in Word 2013 editor, and edit not only text, but also tables, images, margins and other elements.

Concentrate, in the improved Reading Mode

Special focus has been directed at improving the Reading Mode in a manner that all relevant utilities like the toolbar, ribbon, and scrollbar disappear from view unless they are needed. This cleans the interface, allowing the user to fully concentrate on reading. Double click on any picture and it will zoom to view, fading out everything else. To activate Reading mode, click the relevant option in the View tab and enjoy the experience.

Understand the impact, definitely

The Review tab has a new Define feature that presents definitions of words and phrases, instantly using the relevant Word Apps like the Merriam-Webster Dictionary. Results and displayed on the right sidebar as soon as you select the text. Say goodbye to right-click menu and dictionary access when your results are displayed at a single click. Now, you can truly understand the impact of your content.

Verdict

It is always beneficial to look at new features objectively. Microsoft Word 2013 has indeed come with new tidings for progress in the area of word processing. You are now in a position to present documents online to people who do not have the latest version of Microsoft Office, how? This can now be achieved using the cloud-based storage and synchronization of documents for access, wherever needed. Just provide your team members with the respective link that can be pasted in browsers for viewing. Thus, with a modern, polished and internet-friendly Word 2013, the new life spells out productivity for us all.

Link: http://www.addictivetips.com/microsoft-office/microsoft-word-2013-new-features/

Li Ding

Posted in Uncategorized | 1 Comment

How to use Excel in my work

Every time when I was looking for job, Excel is the basic and crucial skills under the job requirement. We can see how important it is in our work. Right now I am doing accounts payable internship in a marketing and advertising company. I am using Excel every day but only the basic function such as filter, sort and calculation. At the beginning of the day, I pulled out the report in Excel format and analyzed the data by utilizing the basic features. I don’t think it’s enough for me to master this tool in my future career path. That’s the main reason I took this class. I want to learn anything more related to Excel, such as V-lookup, how to create pivot table.

Li Ding

Posted in Uncategorized | 3 Comments

What’s New In Microsoft Excel 2013? [Review]

Land Onto The Future

Instead of opening a blank spreadsheet to set the field for extensive number crunching, Excel 2013 welcomes you with a unique landing page that allows you to grasp the relevance of this application in organizing every matter of your life, ranging from financial reports to personal budgeting, movie lists, trend analysis and more. These are laid out in front of you in a tiled format. Don’t forget to click the ‘Welcome to Excel’ template, to quickly understand the basics of this version. In addition, the search bar offers a powerful synchronization with the revamped online Office templates library. You can quickly open frequently used and last used documents from the Recent sidebar.

Time To Manage The Account & Services

As you may know, Excel 2013, like other tools in the Office suite, uses Live ID or Microsoft SkyDrive account to store content online for better accessibility, document sharing and collaboration. Therefore, the new Account tab presents the user information coupled with connected services organized into three sections: Images & Video (Flickr, YouTube), Storage (SharePoint, SkyDrive) and Sharing. Moreover, theProduct Information for the overall suite is presented on the right, with emphasis on subscription and update details. The new interface can be customized using the Office Background themes.

Documents Everywhere

In an attempt to make documents relevant on the go, the Open window of Excel 2010 has been replaced with an entire page covering both online and offline storage places. You can either open files from your system or your personal SkyDrive. Furthermore, the Add a place option allows you to specify other SkyDrive and SharePoint location, so that documents are accessible from anywhere you like. As evident, the features of the previous Recent tab in Excel 2010 has been merged with the new Open page.

Privacy Guaranteed

The new Excel values the sensitivity of your data, especially due to the vulnerabilities resulting from cloud-based storage. These are overcome by user-defined settings like the Check Out function, which prevents others from viewing any changes or editing the document unless you give them the editing rights. Moreover, the sharing options further protect your data in obedience to your requirements.

The Journey From Saving To Sharing

In Excel 2010, the Save & Send menu was so rich with options that it blurred the view of novice users forcing them to stick to a few buttons for safety. Now, you can access these options in a much organized, user-friendly manner with the ShareSave As and Export tabs. The importance of teamwork and collaborations must never be ignored, especially when dealing with spreadsheets that are known to encompass a range of inputs from various sources. Sometimes, compatibility and rights issues present a hurdle in working on a document, together. For example, a co-worker may not be able to view the Excel document in its full zeal due to an old version of Microsoft Excel. You may not want others to edit the final document while the contrary should hold true for your supervisor. With these problems in mind, Excel 2013 presents multiple sharing options.

After signing in to your SkyDrive account, you can Invite People by specifying their names and email addresses for sharing purposes. You can further configure the interface by enable or disable sign-in process. Moreover, you can also generate unique sharing links that can be entered into your browser for complete document access independent of the Excel version installed at the other end. Sharing Links are categorized in the form of View Link (for general access) and Edit Link (for administrator access allowing modification rights). Public links can also be generated by activating the relevant option.

To specify intricate details regarding what the shared viewer should see in his/her browser, you can use the new Browser View Options in the Export tab. This allows you to customize the workbook for a relevant viewing experience, online.

The power of social media has been incorporated into Excel 2013 by allowing you to post to Social Networks in a much similar way as elaborated above. You can post view links or edit links on platforms like Facebook to generate interest in your worksheets.

Charting Your Way Out

The most impressive addition to Microsoft Excel is the new and interactive way of dealing with charts. The importance of Excel 2013 lies in its analytical and data organization capabilities. As soon as you select a chart, the chart elements button pop-ups on the top right corner. All you need to do now, is to select the elements that can add more value to the chart such as Data Table, Error Bars, Timeline, Titles and more.

Another useful button that pop-ups with the chart is the Chart Styles that equip you with new layout and colors. These styles and colors are bound to make your graphs, figures and charts more attractive to the viewer.

Another impressive feature is the Chart Filters option that lays out all variables (series) and categories for an interactive view. Just move your cursor over each item and the relevant content in the illustration will get highlighted. Now, you can focus on important data sets laid out over time for a more refined analysis.

Analyze Data In Real-Time Using Quick Analysis

When dealing with tables, the Quick Analysis button allows you to analyze data from a powerful set of formatting, charts, totals, tables and Sparklines tools that instantly show results over your table for instant analysis. Adding value to your table columns had never been this simple.

Follow The Excel Recommendations

The Insert tab is rich with new features from Recommended PivotTables to Recommended Charts, Excel 2013 aims at letting you achieve the most in the minimum possible time. For the best outcome, use these recommendations to identify and benefit from PivotTables (data summarization tool) and Charts that best suit your data overlay in the worksheet.

Search & Insert Online Pictures

Instead of searching images online using search engines, Excel 2013 offers you the option to achieve this while remaining relevant to the worksheet under progress. The royalty-free photo library, Bing Image Search, SkyDrive and Flickr accounts can be used to search, preview and insert relevant images into your workspace.

Office Apps: Reach To The Horizon

Just when you thought that you’ve got the hang of Excel 2013, Office Apps would take you one step ahead. With useful featured Apps and an extensive resource library in the Office Store, you can insert exciting features into your worksheet. Hence, it is not necessary to do everything yourself, just let the Office Apps take you beyond the horizon.

Comprehensive Data Sources

In comparison with Excel 2010, the new version offers an extensive list of data sources that multiplies the impact of your data relevance. Excel 2013 offers the option to import data as a Table or PivotTable Report from Windows Azure Marketplace and ODATA Data Feed. With comprehensive data sources, you can easily keep track of latest data relevant to your worksheets.

Get To The Bottom-Line With Power View

The Power View add-in allows you to define visually attractive summaries of your worksheet with special emphasis on the variables that truly matter for you. With a separate tab, you have the option to view data in the way that best suits you. After defining the relevant power fields, Power View extracts the information from the selected worksheet to give you a complete overview with respect to the viewing filters specified. Moreover, you can choose a new theme, background, transparency, pictures and other content with the freedom to insert, modify, arrange and analyze relationships, effectively.

Flash Fill: Intelligently Organize Your Data

An exciting new feature that promises to save your time and effort is Flash Fill. Excel 2013 intelligently follows data patterns and trends interpreting the relevant meaning, in order to assist you in carrying out the task. For example, after filling in email addresses with full names, you start entering the first names in a new column and before you know it, Excel 2013 auto-fills the entire column. Now, you can surely fill the worksheet in a flash!

Verdict

All in all, Microsoft Excel 2013 has improved the user experience by focusing on flash-filling, quick-analyzing and intelligent charts. Your data is, now, in a much better position to convince and convey meaning to the relevant avenues both offline and online. Raw data can now be converted using recommended data analysis and organization tools, effectively.

reference: http://www.addictivetips.com/microsoft-office/microsoft-excel-2013-new-features/

Keng(Janice) Yu

Posted in Office 2013 | 5 Comments

Excel at work

Being an accountant I use excel to run a lot of financial reports and double check transactions and entries entered into Quickbooks. It’s sort of a checks and balances system I’ve set up to make sure that all transactions for the month have been entered accurately and accounted for. Sometimes there are specific reports that cannot be run in Quickbooks because of certain restrictions. In those instances I download the raw data into an excel workbook and manipulate it from there with formulas and sorts until we get the specific information we need.

Amanda A. Hernandez

Posted in How Excel is used at Work | 2 Comments

Here is the link to my profile:http://blogs.baruch.cuny.edu/members/jl079983

Posted in Profiles, Uncategorized | Comments Off on Here is the link to my profile:http://blogs.baruch.cuny.edu/members/jl079983

How people use Excel at work (linda Argiro)

I used to work U.S. Census of payroll department. A lot of reports use Excel. However, the report formats made by someone else. We just used them. It was really so convenience. When we showed every reports for our boss, he was so happy and flet very useful. After that, he often to ask more reports to help him to make decision. I usually want to use Excel to make some reports by myself. Also, Excel can keep my job valuable.

-Lind Argiro

 

 

Posted in Uncategorized | Comments Off on How people use Excel at work (linda Argiro)

How People Use Excel At Work-(by William Cheng)

Continued interest with “Microsoft Excel” has spurred new ways of using the program that goes outside creating schedules and organizing data. At companies like Red Triangle, Excel spreadsheets provide excellent training for future pilots in learning to fly a jet or a plane. The company utilizes Excels comment feature to provide pop-up details of a planes operational schematics when one hovers one’s mouse over a particular picture. Excel can also be used on covert office activities. For example: a radio web player can be placed into a spreadsheet to play music. So if you have manager that does not appreciate personal entertainment in the office, just open up that special spreadsheet to play that funky music.

This is the link to the article:

http://www.pcworld.com/businesscenter/article/220782/use_microsoft_excel_for_nearly_everything.html

 

-William Cheng

Posted in How Excel is used at Work | Comments Off on How People Use Excel At Work-(by William Cheng)

How people use Excel to help them work

One benefit is saving time. Excel saves you time by offering an easy to use GUI (graphical user interface). A major feature of this interface is the Ribbon, which displays icons for the tools you’ll likely use most often.

Excel is great at data manipulation: sorting, filtering, tabulating and calculating data. Each of the tools to do these tasks are immediately available on the Home tab of the Ribbon, making it easy to use.

-Yuriy Senyut

Posted in How Excel is used at Work | Comments Off on How people use Excel to help them work

Here is the link to my profile

https://blogs.baruch.cuny.edu/members/vl106007/

Posted in Profiles | Comments Off on Here is the link to my profile

How I use Excel at work

My job description is a little bit complicated. I mainly use excel at work to keep count of inventory items. I also use it to keep record of checks and accounts payable.

I also use Excel for accounting and finance classes. It is a quick and efficient way to do homework.

-Yong Yi Dai

Posted in How Excel is used at Work | Comments Off on How I use Excel at work