Monthly Archives: September 2012

New Microsoft Office 2013 Features information

8 Things to Know About the New Microsoft Office

Check out this rundown of all the new features you will find in Microsoft’s most ambitious Office upgrade to date.

Steve Ballmer unveiling Microsoft Office 2013

courtesy of company

On Monday in San Francisco, Microsoft CEO Steve Ballmer unveiled the latest edition of Microsoft Office–the most ambitious release in the productivity software’s history, he said.

Indeed, you might not recognize Word, PowerPoint, and other applications in the Office suite. That’s because they were redesigned to make the most of the Windows 8 operating system, work with mobile devices such as the new Surface tablets Microsoft recently unveiled, and operate in the cloud so you can get access to your files and information regardless of where you are or what machine you’re using.

Ballmer talked about how the company’s flagship product is now focused first on being a service. While Microsoft will continue to provide Office as software you can install on your computer, the new Office was designed primarily as a service in which the applications and most of your files sit in the cloud.

While the company won’t admit it, experts say Microsoft’s next-generation version of Office is one of many moves it is making to fend off the inroads Google is making on the business-software market with Google Apps.

According to The Wall Street Journal, even though Microsoft Office still has more than 90% market share for business-productivity software and more than an 80% share of corporate email, research firm Gartner recently reported that Google is bringing into its fold one-third to half of new corporate users who are paying for Web-based software.

The competition is great for business users–the new Office looks like an ultramodern and massive improvement over the current version. Several things you’ll notice:

Touch modernizes Office apps.

Touch makes using Office apps on your tablet seem markedly more intuitive and simple. Kirk Koenigsbauer, a corporate VP for Microsoft Office, used a tablet to show how swiping, pinching, zooming, and tapping works with applications such as PowerPoint and Word.

No more paper note taking.

The topic of “inking” came up several times during Microsoft’s demo. The new Office lets you use a stylus to do things like handwrite emails and convert them to text, or as a laser pointer when presenting.

PowerPoint on the tablet rocks.

Koenigsbauer said the tablet’s screen is now a “cockpit,” so when you’re giving a PowerPoint presentation, not only can you use your digital pen to mark up slides on the fly, you can also see upcoming slides and notes, as well as a new clock and timer so you don’t go overtime.

Drag and drop makes consuming data and collaborating simple.

Koenigsbauer showed off OneNote and Lync–Windows 8 style applications for Office that are optimized for touch.

OneNote, a digital note-taking app, organizes information such as text, pictures, notes, Web content, lists, and more. You can use the tablet’s camera to snap a picture of a paper advertisement, for example, then crop part of it and drag and drop it into OneNote.

Lync is Microsoft’s unified communications platform integrated into Office, and it includes instant messaging, audio, video, Web conferencing, and location information so you can see where your contacts are. In a multiperson video chat using Lync, you can drag and drop someone from your contact list into the live meeting, drop a PowerPoint presentation onto the shared canvas, draw on the presentation with a touchscreen device, and share OneNote notebooks with others in the call, as well as take and display notes.

Cloud storage is the default.

Although your documents will still be available offline, the new Office saves documents to SkyDrive by default, so you can get at your content regardless of what computer or device you’re using. And once signed in to Office, your personal settings, most recently used files, templates, and custom dictionary show up on whatever machine you’re using.

Microsoft acquired Yammer last month for $1.2 billion, proving that the software giant is serious about social. While Koenigsbauer talked about how people can use Yammer and SharePoint for business social networking, the “People Card” looks particularly useful. For each of your contacts, this card shows you the person’s location, photos, and contact information, as well as status updates from Facebook and LinkedIn.

You can create awesome presentations.

Microsoft’s acquisition of Perceptive Pixel now makes it possible for you to use 82-inch touch- and stylus-enabled displays for meetings and presentations. Koenigsbauer stood in front of a huge screen and used his hand to swipe across tiles of apps that he could access during a presentation. As an example, he tapped on a weather app to pull off an “Al Roker” weatherman-like imitation with the large digital backdrop.

Reference:

http://www.inc.com/christina-desmarais/8-things-you-need-to-know-about-the-new-microsoft-office.html

Student Name: Viviana Loza

Posted in Office 2013 | 1 Comment

New Features of Microsoft Office 2013

Some of the classmates’ posts had already pointed out the major new features of Microsoft 2013, here are a little more base on my research:

1. Touch And Stylus

Office 2013 ventures beyond the mouse and keyboard to embrace touch and pen input. While multi-touch laptops aren’t–and probably won’t be–a mainstream choice for business and home users anytime soon, touch is an essential component of smartphones and tablets, obviously. The pen may be making a comeback too, judging by the popularity of Samsung’s stylus-equipped Galaxy Note.

What kind of touch features does Office 2013 have? The same ones you’ve grown accustomed to using on your phone and tablet: Swipe a finger across the screen to turn a page; pinch and zoom to read documents; and write with a finger or stylus. And when you write an email by hand, Office 2013 automatically converts it to text.

2. A Social Suite

Office 2013’s strong social networking component appears to be targeted mostly at Microsoft’s huge installed base of enterprise users. In addition to Skype, Office now includes Yammer, a secure and private social network for businesses that Microsoft tentatively acquired just last month. Yammer integrates with SharePoint, Redmond’s Web application platform, and Microsoft Dynamics, the company’s line of CRM and enterprise resource planning apps.

Office 2013’s People Card tool provides detailed information about your contacts, including their status updates from Facebook and LinkedIn. Now you’ll know what your clients had for lunch–and perhaps whether they had lunch with your competitors.

3. Big Screen Bonanza

Huge touchscreen displays aren’t necessarily a feature of Office 2013, but the suite’s stylus- and multi-touch-oriented UI enables it to work quite well with enormous LCD panels, such as Perceptive Pixel’s 82-inch monster. PowerPoint presentations, particularly ones with embedded video, are a natural for large touch panels.

Educators may find large touchscreens useful too. A professor, for instance, could use OneNote in the classroom, jotting lecture notes and diagrams directly on a gigantic touchscreen; students could later access the notes via SkyDrive.

 

Reference:

http://www.informationweek.com/software/productivity-applications/microsoft-office-2013-10-best-features/240003864?pgno=11

 

Yuting Peng

Posted in Office 2013 | Comments Off on New Features of Microsoft Office 2013

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