Skip to Main Content

Archive for the 'Excel' Category

IT Training Certificate Series–Updated

Illustration of certificate ribbon.

Earning a certificate from IT Training is a great way to enhance your skills in areas like Microsoft Office, web development, and creating graphics.   Office 2016 is here, so we’ve updated some of the series workshops (note major changes to the Access series). The process is the same. You 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 five different areas, so you’re bound to find something to meet your needs.

Office 2016 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 2016: Managing Your Email
2. Outlook 2016: Calendar Essentials
3. Word 2016: The Basics
4. PowerPoint 2016: The Basics
5. Excel 2016: The Basics
6. Access 2016: The Basics

Read the rest of “IT Training Certificate Series–Updated” »

Cross-Platform Keyboard Shortcuts in Office 2016

The good news for MacOS users is that support for cross-platform keyboard shortcuts in Office 2016 has dramatically improved; potential downsides include the cross-platform shortcuts are PC-centric, and may interfere with some default Mac OS key assignments you may be accustomed to using (e.g., switching between desktops, or Show Desktop). You can also make the Ribbon appear more like the Windows one by enabling the Group Titles*, which can make finding a particular tool easier, particularly if you are using our workshop materials in self-study mode.

To enable the Control key shortcuts for Office 2016 for Mac, the process is simple, but the labeling is less-helpful than many might wish. To enable the cross-platform shortcuts, Click System Preferences… -> Click Keyboard -> Click the Shortcuts tab, and then Click the “All controls” radio button. Closing the window will keep your changes.

When enabling the cross-platform keyboard shortcuts, the dialog box will look like:
System Preferences Keyboard Shortcuts dialog box, with All controls radio button selected
Read the rest of “Cross-Platform Keyboard Shortcuts in Office 2016” »

Use Twitter as a Learning Tool

Twitter logo

Depending on how you use it, Twitter can be an incredible time-waster or a useful resource.  Because you’re reading this blog, I assume you’re interested in learning about technology. Why not use Twitter as a tool to further your learning?

In this post, you’ll find a curated list of Twitter accounts that regularly share links to technology news, tips, tricks, and tutorials. Once you’ve chosen some accounts to follow, it’s a good idea to create Twitter lists so you can easily find the type of information that you need. Here are a few tweeters organized by category.  Read the rest of “Use Twitter as a Learning Tool” »

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” »

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