As written on nhlearninggroup.com
Definitely for the arithmophobic. Thanks to the Live Charts feature in Excel, you can give them an instant makeover with colorful charts. In older versions of Excel, charting was one of the more difficult tasks. It wasn’t only about the time it took, but also about the right chart type that fit the data. Excel 2013 makes it easy as a click with Live Charts. Excel uses a special algorithms to show the chart types you can use based on the data.
Select the data to chart and click Insert — Recommended Chart to see options such as line, bar, and pie charts that Excel feels is right for your data. Click each chart to preview what your data will look like. Pick the right chart and Excel inserts the chart with some page elements to work with styles, colors, and the chart data. Do note: Not every chart type is recommended. Specialized chart types are available from the Insert Chart button on the Ribbon..
From PDF to editable Word documents
One of the best features of PDFs are that they are not editable as a default. It’s also an irksome feature if you want to take information out of it. A whole industry of tools exist that help you be more productive with PDF files. Don’t disregard the new PDF Reflow feature in MS Word 2013. Making it uncomplicated – open a PDF with Word 2013 and it will behave like a normal Word document. You can reuse the content without too much effort. Now, all that rich data locked in PDF files is ripe for picking.
Word creates a copy and opens it as a normal document as you would any other from File – Open. Make any changes - the original PDF is left intact. The conversions are not always perfect, but this is a very handy feature.
Use Share Link As A Quick Presentation Tool
Microsoft Office 2013 brings new collaborative features for Word and PowerPoint which piggyback on a Microsoft Account. With the Office Presentation Service your collaborators do not even need the Office suite at their end. A web browser does the job with the help of the Office web app. Work on your document and begin sharing from File — Share — Present Online. From here, select Office Presentation Service and click Present Online. A share link is created. Send it via Skype, email, or any other online medium. Start your presentation and the recipients get to view it on their browsers when they click on the shared link. Share notes and your team members can follow you through the document. They can also watch the presentation independently. The presenter controls the presentation from this special menu bar.
Refer Wikipedia Within Word
The official Wikipedia app is a quick resource for general research. With the Wikipedia app inside Word. Go to Insert – Apps for Office– Wikipedia. You might have to search for it among the featured apps. The app also allows you to insert a section of a text or an image. Select the text or hover over the image. Click on the insert symbol to insert it into the body of your Word document. The source link is automatically included with the insert. The Wikipedia app can also be used to research something on the side-pane by simply selecting something in your document. Nice.
Use Your Ears with Assistive Technologies
With the Office suite, you can take advantage of the built-in screen reader (Narrator) to read and create Word documents, PowerPoint slides, Excel spreadsheets, OneNote notebooks, and Outlook email. Microsoft Support recommends that you become familiar with shortcut keys as well. For example, you can use voice to record your comments on PowerPoint slides or a Word document. If you are short on time, use the Narrator to have it read aloud Outlook emails or a Word doc. Microsoft Office 2013 also comes with an audio-enabled Mini Translator that can take a selected foreign phrase and read aloud its pronunciation. Select a foreign word. Click onReview – Translate – Mini Translator. Hit the Play button.
Go Easy on the Eyes with Read Mode
If you have a touch enabled computer, Office 2013 was designed for productivity with fingers. The Ribbon menu was restyled and made more functional. I will ask you to do one thing if you are still deciding to come aboard (c’mon, it’s been a year now!). Go to View – Read Mode. That’s a bonus point for a distraction free reading experience.
It auto-resizes the document to the full screen and is completely uncluttered. Click on View to see options for tweaking this mode. For instance, the color modes that make it easier on the eyes. You can get rid of the toolbar for a full-screen experience.
Save Time With a Copy
Don’t go hunting for the document to copy. The shortcut for creating a copy of an Office document is not very apparent but it is a huge time saver if you want to work on a copy while keeping the original intact. Click on File – Open – Recent Documents. If the document was opened recently, the filename will be displayed. Right-click on the filename and select Open a copy. Any changes that you make are saved to the copy. You can then save it at any location. This tiny step is a time saver because you are spared from browsing to its location and manually creating a copy to work on.
Work Anywhere With Documents Online
Save your Office documents online via the Microsoft account. Microsoft has the sister suite ofweb apps for Word, Excel, OneNote, and PowerPoint. Word, Excel, and PowerPoint save the last location where you left off work before saving– to the letter, cell, or slide. Pick up where you left off working on a different device while away from your main computer. You can also continue your work on Mobile apps for Office.
Don't Cut and Paste Anymore
There’s this quicker way that uses lesser key presses. Using Cut-Paste (Ctrl-x Ctrl-v) to move text from one place on the page to another within a Word document is fine. But try this. Select any block of text. Press F2. You will notice that the status bar (at the bottom of your screen) says Move to where. Place the cursor at the location where you wish to move the block of text. Press Enter and the selection will be moved.
Searching for Data in Excel
When you search for data, you can use ? to represent any single character or * to represent a series of characters. Example if your data has all the states, you could type “*Dakota” and it will pull up both North and South Dakota data.
Auto Filter in Excel
Too much data to go through? Use AutoFilter to find values, show or hide values, in one or more columns of data. You can filter based on choices you make from a list, search to find the data that you want to see. When you filter data, entire rows are hidden if values in one or more columns don't meet the filtering criteria. Click the Data Tab- Filter to activate.
Save and Auto Recover in Word 2013
It will happen! A computer crash, power goes out or you just close without saving. To avoid losing all your work when this happens, make sure AutoRecover and AutoSave are turned on. Simply click on the File Tab- Options- Save and make sure the SAVE AUTORECOVER INFORMATION IS SELECTED and you can select the number of minutes from 0-120.
Calendar Views in Outlook 2013
Managing and Viewing multiple calendars? By default, calendar groups appear side by side. To make the calendars overlap, click the View in Overlay Mode arrow on the tab of each calendar you want to overlap. In Microsoft 2013 there is a world of cool new things to discover. However, a favorite new feature in Outlook 2013 is located below the Navigation pane where you can have mail, calendar, contacts, tasks and notes.
Extended Clipboard in Microsoft Work 2013
Microsoft Word has a useful "Spike" feature that allows you to cut text and images from multiple locations in a document and paste them all at once to a different location. To use this feature, select the text, images or other objects in your document that would like to move and press "CTRL +F3" to move that selection to the Spike. You can to that same spike using the same key combo shortcut.
Adding Video to Microsoft PowerPoint 2013
Ask any teacher, and they'll tell you nothing captures your audience more than a movie. To add a movie to your PowerPoint Presentation, click "Insert" on the Ribbon. You will see a button for "Video" on the right side of the ribbon. Using the drop-down menu, you can insert a video from YouTube, Facebook or your OneDrive account, or any other video embedding website.
Refreshing the Same Query in Access 2013
You may use a report or query with the help of parameters as a filter tool. With this one report of query you filter different departments or dates you need to print multiple reports for different purposes. You may only need your mouse click to click the refresh button to prompt for a new parameter window. You can work much faster by staying on the keyboard and creating a smoother workflow. After running your first query or report stay in the same view (don't switch back to design). Press "SHIFT + F9" to run the report again with a new parameter.
Copy and Paste Tricks in Word 2013
When you copy a passage of text from the web to Word, styles and formatting are retained. However, there's an easy way to remove this styling from any block fo text in Word - just select the text you copied and press "Ctrl+Space Bar". The rich text will be transformed to plain text. Additionally, you can move text in Word without the traditional "Ctrl+X, Ctrl+V" shortcut. Highlight any block of text, press "F2", and place the cursor at the spot where you wish to move that text. Press "Enter" and the selection will be moved! Test it out with this paragraph!
PowerPoint Presentation Tricks
While you are conducting a PowerPoint presentation, if something comes up that you don't want to be seen at that point without having to stop the slideshow, hit the letter 'B' on your keyboard. This will blackout the screen without losing your place. Hit 'B' again, and you'll be back in business. Another cool trick... while in presentation mode, hold 'Ctrl+P' and you will change your pointer into a pen that can write or draw. Hit the 'Esc' key and you will change back to your pointer!
Custom Views in Outlook 2013
In Microsoft 2013 there is a world of cool new things to discover. However, a favorite new feature in Outlook 2013 is located below the Navigation pane where you can have mail, calendar, contacts, tasks and notes.
While working in your inbox, to view your calendar without leaving your inbox, right-click on the calendar and select open new window. You will now be able to stay in your inbox and open your calendar at the same time. You can now actively work in your calendar and read your emails. Tada!
Visually Represent Your Data in Excel
Here is a great Excel trick for all of us out there that like visual representations of our data. You can use this trick with Excel 97-2013. Whenever you have a table of data and want to create a chart, here is what you do. Click in a cell within the table you want to chart. Press the Key on the top row of your keyboard, and say "WOW"! Now you have a new chart of your data on a new worksheet named "Chart 1". Your original table is still on the original worksheet!
Navigate Excel Workbooks Easily
Here's a little-known trick that will allow you to quickly and easily navigate to a specific worksheet in Excel workbooks that contain more than one (Sheet1, Sheet2, etc.). You can display a pop-up list of all worksheet names in your workbook by right-clicking one of the navigation arrows to the left of the worksheet tabs that are located at the bottom of the screen. Simply select a sheet from the list, and you're there in a flash![/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
[/vc_column_text][/vc_column][/vc_row]
New year, new technologies. Track your heart rate, calories, elevation and more with a new running buddy - the Microsoft Band. You can purchase here.
Anyone, at any level, who aims to make an impact, buck the status quo, and define his or her industry can take a page from Fast Company cofounder Bill Taylor’s book. He addressed top-level IT professionals in his recent Microsoft Virtual North America CIO Summit keynote speech, but his advice is relevant to professionals across sectors. Like a true sage, Taylor asked attendees to consider a variety of questions and seek the answers within themselves to reach greatness. These three questions offer a roadmap for those looking to raise their game to the next level.
Instead of focusing on being the best player, how can you redefine the game you’re playing?
Changing the nature of the competition is a great way to get ahead. By “embracing one-of-a-kind ideas in a world filled with me-too copycat thinking,” innovators come out on top. “The job today is not to be the best at what lots of other people already do. It’s to be the only one who does what you do,” asserted Taylor. One example is Umpqua Bank, a regional institution that was smaller than small—just six branches—until Ray Davis took the helm in 1994. Now boasting nearly 400 locations, Umpqua is Oregon’s largest bank, and this change was driven in large part by a focus on culture: the tellers also act as baristas, each transaction concludes with a piece of chocolate, and the branches become community centers after business hours. Umpqua is winning because it dares to redefine a bank as a regional resource.
Changing the nature of the competition is a great way to get ahead. By "embracing one-of-a-kind ideas in a world filled with me-too copycat thinking."
What single sentence will describe you?
Taylor stressed the importance of simplification for both individuals and corporate entities. Inspired by the story of Clare Boothe Luce—who told President Kennedy that “a great man is one sentence” before she asked him what sentence would describe his presidency—Taylor stressed the importance of this kind of simplification for both individuals and corporate entities. This reductionist method forces leaders, companies, or job seekers to zero in on their goals, minus buzzwords and jargon. Once you know how you want to be described, you can make changes to bring that fantasy into reality.
It doesn’t matter what keeps you up at night. What gets you up in the morning?
Taylor was emphatic that success is rooted in caring more than anyone else, whether it’s about your customers, your colleagues, or the way your organization conducts itself in the marketplace. It’s up to companies to provide their employees and their leaders with this motivation.
One exemplar is USAA, the financial services company for active and retired military. Taylor said new employees are immersed in the world of their customers on day one, engaging in a deployment simulation (to develop empathy while learning about the financial issues service people face), eating MREs at training instead of a catered lunch, even volunteering to go through the brutal first day of basic training. USAA takes work that might seem passionless (such as selling renter’s insurance) and gives staff a reason to believe this work is valuable and necessary and important. This directly translates to better customer service and, of course, more revenue.
Taylor summarized his thesis with contributions from two unusual thought leaders: cognitive-psychology pioneer Jerome Bruner and acerbic comedian George Carlin. Bruner once wrote that learning (or as Taylor extrapolated, innovation) “is, most often, figuring out how to use what you already know in order to go beyond what you currently think.” Carlin famously cracked wise about “vuja de”—“the strange feeling that somehow none of this has ever happened before.” Taylor believes fostering this feeling is a way to inspire Bruner-style breakthroughs.
The questions Taylor poses are a few ways to intentionally make the familiar feel unfamiliar, to look at your profession or your career or your industry as you’ve never seen it before. The answers may be surprising.
The greatest science fiction relies on talented writers to leverage amazing imaginations based on real-world inventions, and we’ve got that covered.
Future Visions: Original Science Fiction Stories Inspired by Microsoft is an anthology of short stories written by some of today’s greatest science fiction authors. The contributing authors were inspired by inside access to leading-edge work, including in-person visits to Microsoft’s research labs.
These visionary stories explore prediction science, quantum computing, real-time translation, machine learning, and much more.
McClone Construction Company: Construction firm unites workforce, speeds pace of business with cloud services
McClone Construction builds concrete structures throughout the United States, which requires seamless work among dispersed teams. The company standardized on Microsoft Office 365 to support close collaboration through frequent video calls, easy access to email and calendars, and a consistent experience across devices. It has increased employee productivity and flexibility, so it can tackle more projects while maintaining its high standard of work.
A solid foundation for business success
From parking garages and reservoirs to hospitals and universities, McClone Construction knows concrete. The California-based company has spent 40 years building structures throughout the United States, gradually expanding its offices to Washington, Hawaii, Colorado, and Texas. Along the way, the company has fostered a tradition of excellence, not just in its projects but also in its culture of teamwork and continuous improvement.
McClone Construction recently moved from a divisional business model to an integrated operation so that it could take greater advantage of employees’ skill sets to form teams based on a project’s location and type of work. “Ours is a cyclical business, and when one office is slow, another is often too busy to handle all the projects coming its way,” says Rick Owens, Project/IT Manager at McClone Construction. “By connecting our offices, we can tackle projects more effectively and achieve greater success as a comprehensive organization.”
Merging resources meant that the company needed to unify business processes across its former divisions. “In the past, engineers in our divisions used different ways of designing form systems, project managers followed their own methodologies, and workflows varied among teams,” says Owens. “We knew that uniting processes throughout the company would demand a lot more collaboration across offices than we’d ever done before.”
A new collaboration paradigm
Fostering the collaboration now expected of employees required giving them common technology. The company’s divisions used a range of technology systems, so McClone Construction looked to simplify. It wanted a solution that would be easy to use and straightforward to administrate, one that included the videoconferencing, messaging, and productivity software needed for efficient collaboration among dispersed colleagues. “In the past, we didn’t have much need to work across our offices, but the change in our business model caused us to take a careful look at how we could collaborate,” says Owens.
As McClone Construction looked at the available technology choices, it also examined the solutions that it already had in place throughout its divisions. The company found that one division had adopted Microsoft Office 365 cloud-based services when the division replaced its aging in-house messaging infrastructure. “We already knew many of the ways in which Office 365 could help the company at large because our Northwest Division had experience with it,” says Owens. “For instance, we liked using Microsoft Exchange Online so that we could avoid all the time-consuming system management that we’d endured in the past. But the biggest draw for companywide adoption was Skype for Business Online. We saw how it would give us video-calling and screen-sharing capabilities that would make it easier to conduct effective virtual meetings, without a lot of hassle to set them up.”
Employees have embraced video calling to such an extent that McClone Construction has reduced costs. Says Owens, “We’ve already seen a savings of at least 10 percent in our mobile phone costs, plus a 5 percent reduction in travel between offices, especially among upper management.”
Greater productivity from anywhere
Using Office 365 helps McClone Construction be more agile as it juggles projects across the company. “It’s much easier to establish a Skype for Business online call than to track down team members on their mobile phones,” says Owens. “We use the presence indicator to see who’s available and then just click to talk. Quickly finding project superintendents in the field and getting information to and from them without delays accelerates our pace of business.”
The company has found that its virtual meetings to coordinate operations among its widespread offices are more effective now, due to the use of video calls rather than audio conference calls. “There’s just something about seeing the people you’re talking to,” says Owens. “It’s the closest you can get to an in-person meeting. Using Skype for Business Online, we see colleagues’ expressions and gain a better understanding of the issues. We can get more done in less time because we also share screens so we’re all looking at the same materials.”
McClone Construction and its partners use Microsoft SharePoint Online to share information between companies. Internally, employees use it to maintain project team calendars and a single, easily accessible repository for engineering documentation.
In addition, employees use Microsoft Office 365 ProPlus and therefore have the same Microsoft Office programs available for use on a range of devices, including Windows Phones and Microsoft Surface Pro 3 devices. Owens, for example, might work on project plans on his PC at the office, make changes to it from home on his Microsoft Surface Pro 3, and review colleagues’ subsequent revisions from his smartphone on the way into the office. “Our employees can install Office programs on up to five devices, which really helps them stay productive when mobile,” says Owens. “Our executives and managers in particular use programs such as Microsoft OneNote Online extensively.”
Overall, Owens believes that the Office 365 components’ built-in efficiencies have the greatest impact on the company’s increased productivity. “We’ve significantly broadened our communication channels due to the Office 365 capabilities that are now at our fingertips,” says Owens. “Plus, Microsoft constantly expands Office 365 functionality, and we get the immediate benefit from product improvements because we don’t have to wait for the next upgrade cycle to take advantage.”
Support for business growth
McClone Construction appreciates that using Office 365 makes it easier to add and remove employees as the company changes. “Right now we’re experiencing significant growth that creates daily IT challenges, but we’re able to onboard new employees right away, giving them what they need to immediately work together no matter where they’re located, rather than taking days to get set up,” says Owens. “And if we opt to open a new office, getting that new area up and running will take approximately half the time that it took before, from a technology perspective. We’re no longer limited by technology—instead, we’re using Office 365 to become a more flexible, adaptable, successful organization.”
Read customer success stories to learn how Managed Solution helps businesses implement technology productivity solutions.
Microsoft partners with Linux for Azure certification
Microsoft has shown how much it loves the Linux platform by offering a new certification for those who show they have the knowledge to run Linux servers in Microsoft’s cloud platform. With Microsoft’s new mobile first cloud first strategy, and with the software company embracing it’s competitors lately, this should come at no surprise.
Aptly titled Microsoft Certified Solutions Associate Linux on Azure certification, it requires you to pass the Linux Foundation Certified System Administrator exam and the Implementing Microsoft Azure Infrastructure Solutions exam first, and then you can apply for the new certification.
For those who have already taken one or both of the exams, there is no need to retake the exams, as they count towards this certification, so you need only apply.
“So now, to have half the Marketplace be Linux workloads, and to be doing work like this to get people certified, it really does represent a sea change in the engagement model [for Microsoft],” Shewchuk said in an interview. “And it’s clear that Satya has been at the core of much of this change.”
Astronauts receive Hololens in space today, uses revealed
Recently it was revealed that Microsoft teamed up with NASA to send it’s HoloLens wearable into space. Today that became a reality, with two lone astronauts receiving over 7,700 pounds of supplies, including food, science experiments, and two Microsoft HoloLens headsets.
Astronauts Scott Kelly and Mikhail Kornienko are spending over a year aboard the International Space Station in a scientific experiment detailing exactly how long missions in space can affect the human body.
In a live interview earlier today, the guys over at Popular Science got to ask exactly what uses the HoloLens could have for them as they finish their year long mission in space. According to Scott Kelly:
You know I actually got the opportunity to try that out before I launched, and it seems like there are certain capabilities that would be good for us onboard the space station. One would be, you know right now we look at the computer or an iPad to look at procedures. And if you could have a procedure right in your field-of-view, something that was command-able with your voice, you know where you could scroll through the different steps, that would be helpful. It also has this capability where somebody on the ground perhaps could be looking basically at what you’re looking at, and be able to write in your field of view. So let’s say we’re working on a piece of hardware, and we’re not that familiar with it, but we have an expert on the ground, you know that person could basically see what we’re seeing and make annotations, point to things, and kind of lead us through a particular activity. You know that’s one of the many capabilities of that, or similar hardware, that we’re excited about.
These are features that we know the HoloLens to have, in addition to many, many more. Now all we need is to get them to swap that iPad out for a Surface Pro 4 for a complete Microsoft experience.
The line that separates Microsoft’s cloud collaboration suite, Office 365, from its corporate communications services, marketed under Skype for Business, is getting blurrier.
On Dec. 1 the tech giant will officially unleash new conferencing, meeting, and cloud telephony options for Office 365 that are meant to consolidate and replace the separate services many businesses use to host audio and/or video conferences.
“Most of our customers have more than one of these [services], they’re putting a lot of money into them, but aren’t satisfied,” said John Case, corporate vice president for Microsoft Office. “This turns Office 365 into a modern communications platform.”
For example, the new capabilities will allow companies to set up and initiate all-hands meetings for up to 10,000 attendees—that can be attended via Web browser or mobile device—in a matter of minutes, Case told Fortune. Additionally, any questions that arise during the large broadcast can be submitted via the company’s Yammer messaging application.
The new services aren’t exclusionary: Teams can also create conferences that connect with traditional phones using the public switched telephone network (PSTN). “You can dial in from pretty much anywhere,” Case said. Meanwhile, Microsoft MSFT 0.81% is also pushing Skype for Business as nothing less than a replacement for existing corporate private branch exchange (PBX) systems—and it’s offering “Fast Track” funding to help businesses make the switch. The Office 365 pricing plan, which includes all of the above features, costs $35 per user per month, plus another $24 per user for international and domestic calling plans, according to a Microsoft pricing sheet.
Competitors Facebook FB 0.87% and Google GOOG -0.61% have also busy adding video-calling features to their platforms in recent years—to compete with both Skype and Apple’s FaceTime app—but Microsoft has been far more aggressive about embedding these options into its existing business applications. Over the coming months, you can expect Microsoft to forge relationships that embed conferencing and calling features into applications from other software companies.
For example, in the future, customer service agents using software from call-center company Genesys may be able to initiate support or telemarketing conversations by simply clicking on contact information within a customer’s record. Right now, that same person might be forced to jump back and forth between several systems to track the conversation and make changes, Case said.
The consumer-grade Skype service boasts almost 300 million registered users. Microsoft bought the company in May 2011 for $8.5 billion, and promptly began merging the cloud-delivered communications service with its existing Lync communications products.
Contact us Today!
Chat with an expert about your business’s technology needs.
