Skip to Main Content

Archive for the 'Excel' Category

Using Office 365 at IU

IU students, faculty, and staff can now access Office 365 at no cost. Office 365 provides multiple options for accessing Office 2016 for Windows and OS X.  You can download the Office applications to your desktop and use cloud-based Office Online apps, and mobile apps for your smartphone or tablet.  You can install Office on up to five PCs or Macs, five tablets (Windows, iPad, and Android), and five phones.

Getting Started

To access Office 365,  go to https://office.iu.edu. Enter your username and passphrase when prompted. Click “Install now” to start the download. Notice that boxes are checked indicating that you will be making Bing your default search engine, and MSN your browser homepage. If you don’t want this to happen, deselect the boxes.

Screenshot of Office 2016 install page.

Screenshot of Office 2016 install page.

 

Run the download installation package and follow the on-screen directions. See the KB article “About Microsoft Office 365” for more information. Once you’ve installed Office, you will have to sign in to your Office 365 account at least once every 30 days to keep the software activated.

Features

Office 365 includes:

  • Office 2016 for Windows and OS X
  • Office Mobile apps for your smartphone or tablet
  • Office Online
  • OneDrive for Business (Learn more about OneDrive for Business here).

With the Office Online suite, you can create and edit files using lightweight versions of Office applications via your web browser. The Office Online apps include Word, Excel, PowerPoint, OneDrive, and OneNote. The Office Mobile apps are scaled-down versions of Word, Excel, PowerPoint, and OneNote. Learn how to access Office Mobile apps here.

More Software

IU students, faculty, and staff have access to numerous low and no-cost software titles. Read the KB article “At IU, how can I get university-licensed software?” to find out how to get it! And remember to check out the IT Training website when you’re ready to learn how to use your new software.

 

Which version of Office are you using?

While it may seem like a very basic question, knowing which version of an Office application you are using is becoming much more important. The core Office applications (Word, Excel, PowerPoint, and Outlook) are available on multiple platforms now, and an application’s feature set may vary now not just by version, but also by platform.

And the many ways you may be able to get to a particular application may make it seem like finding out would be even more complicated now. Luckily, that isn’t quite true.

Read the rest of “Which version of Office are you using?” »

Where did that {Office app} feature go?

As Microsoft Office applications are made available on more and more devices and platforms, some of the things you may actually do with them can vary. Sometimes wildly. It’s a good thing that Microsoft shows what we may be able to use (or not).

For their flagship Office applications, these Microsoft Support site articles provide an overview of feature comparison by application version:

As a bonus, for those of us who may use different operating systems to get our work done, they provide a much more detailed comparison of differences between Excel 2013 and Excel 2016 for Mac.

Earn a Certificate from IT Training

Illustration of ribbon on certificate.

Earning a certificate from IT Training is a great way to enhance your skills in areas like Microsoft Office, web development, and creating graphics.  You’ll take a series of related IT Training workshops designed to build your skills in applications or topics in a comprehensive way! After you’ve attended all of the workshops in a series (within a one-year period), you’ll earn your certificate.

We offer certificates in six different areas, so you’re bound to find something to meet your needs.

Office 2013 Productivity (6 workshops)

We’ll introduce you to a variety of Microsoft Office applications and demonstrate ways make them work together. You’ll learn the basic skills for day-to-day office activities from creating a spreadsheet in Excel to creating a PowerPoint presentation. The required workshops are:

1. Outlook 2013: Calendar Essentials
2. Outlook 2013: Managing Your Email
3. Word 2013: The Essentials
4. PowerPoint 2013: The Basics
5. Excel 2013: The Basics
6. Access 2013: The Basics

Read the rest of “Earn a Certificate from IT Training” »

“We need to remove some older apps” error during Office 2016 installation

So you’re very keen to install and use the new Office 2016 suite on your PC? Please be certain to take a few moments before you do that, so you won’t unexpectedly see the error “We need to remove some older apps”:
Subtle error message prompting removal of Office 2013 stand-alone apps

Are you running any of the following standalone Office 2013 applications?
Read the rest of ““We need to remove some older apps” error during Office 2016 installation” »

Presenting Data like a Pro: Excel

Title image that is tinted in purple and has three people in a meetings

So, you’ve put together some super interesting and wickedly compelling data in Excel that you want to share with your colleagues. While the data might be 100% clear to you, sometimes lots of numbers  can seem a little obscure to an outside party. What do you do in order to present the data and get the maximum impact you are hoping for?

Read the rest of “Presenting Data like a Pro: Excel” »

Access vs. Excel

Title image that says "Excel vs. Access" and shows the excel and access logos

Excel and Access are both very powerful applications. They are each special in their own way, however; there comes a time when the things you are trying to do can be completed in either work space. So, what do you choose? Neither of these applications are necessarily better than one another, but their features might be better suited for one action versus another action.

Read the rest of “Access vs. Excel” »

Going Paperless at IU: an Overview

Go Paperless! IT Training can help!

This is part of a series of articles that will appear over the next few months as part of the Go Paperless initiative at Indiana University.

Reducing paper consumption

Everyone at IU needs to know about how to reduce paper consumption.Paperless systems take up minimal space, they save energy and landfill space. Using digital documents allows easy collaboration with others and on-the-go access wherever you have Internet. In comparison to file cabinet systems, good paperless document organization can help you find the information you need at lighting speed. And there’s no need to worry about fires or floods; using digital documents, it is very easy to create back-ups of all your important data. Moreover, with the security available in backup and storage programs, your digitally stored information has stronger protection from theft. Finally, no need to shred when you are done; virtual documents can be easily  purged.

In keeping with that spirit, IT Training has developed a series of articles under the heading, “Go Paperless.” Read on for the  many reasons to leap into the modern method of document storage. Here are the articles in our “Go Paperless” Series:

About paperless, digital storage:

Using Box at IU for Storage and Sharing:

Collaborating with Others:

Going Paperless in the Classroom:

Easily Collaborate on Any File Type Using Box Apps

Go Paperless! IT Training can help!

This is part of a series of articles that will appear over the next few months as part of the Go Paperless initiative at Indiana University.

Two Box apps that can make your life easier

Using Box at IU along with two Box add-ins, you and your project group can work on a single file — without having to keep a local copy on your device and then sending your document around via hard copy or email.

In his article about Box, Tom Mason has extolled the merits of using Box Edit. Let’s talk about this Box App a little more. With Box Edit, you can simply open a file directly from the preview page on Box, make edits instantly, and save the new version back to Box automatically. Then, when you share your document with others, your collaborators can use Box Edit to work on the same document in the same way—without ever having to download and re-upload it! As long as you have the application on your computer, you don’t have to worry about the file type.  PSD files, presentations, images, CAD drawings, Illustrator files – any file you can edit on your computer’s desktop you can now edit without leaving Box. Install Box Edit once and it will work on all your browsers, including Chrome, Firefox, Internet Explorer (Windows) and Safari (Mac).

Another app,  Box for Office, allows you to start up an Office Document such as Word, PowerPoint, or Excel on your own computer–and when you choose Save As, you can save directly to your Box account without having to upload it. Once there, share it with others and they can use Box Edit to edit it.

Read the rest of “Easily Collaborate on Any File Type Using Box Apps” »

Real-time Collaborative Editing in Word, Excel and PowerPoint

Go Paperless! IT Training can help!

 

This is part of a series of articles that will appear over the next few months as part of the Go Paperless initiative at Indiana University.

When multiple individuals provide their separate contributions to a single document, this is termed as collaborative editing. Having the ability to allow more than one person to update the same document is often as essential as it is advantageous. Until recently, collaborative editing of Word, Excel or PowerPoint files had a major restriction in that only one person could work on a single file at a time; otherwise, it was necessary to keep multiple versions of the file and reconcile them all into a single file. This restriction can be a bottleneck since only one person may edit the file at a time, additional effort is needed for version control and coordination between contributors, and reconciling between multiple files requires additional effort and increases the risk for missed updates.

Collaborative editing technology, however, has matured significantly over the past few years through the use of cloud storage services. By leveraging cloud technologies, collaborators now have access to a number of tools that help streamline collaborative editing. Of specific interest to Office users, synchronous or real-time collaborative editing is now possible, which allows several people to work on a Word, Excel, or PowerPoint file at the same time. Let’s take a brief look at this real-time collaborative editing provided by Google and Microsoft. Before we start, please note that Google Drive and Microsoft’s OneDrive cloud storage services are not supported by IU and are not suitable for storing or sharing institutional data. However, this information may be of use for personal projects.

Read the rest of “Real-time Collaborative Editing in Word, Excel and PowerPoint” »

Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.