How to Change Your Office 2013 Theme

Office 2013 has brought with it many changes including the new customizable background themes. These neat little designs can be found at the top right of Office programs and are customizable in design and color. You can choose from 15 different themes (Including the option of not having one at all) and 3 different colors.

theme

For step-by-step instructions on how to customize your theme, visit http://helpdesk.etown.edu/help/theme and background

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Excel – Autofill in Descending Order

S5If you perform a lot of data entry, then you probably use Excel’s AutoFill feature to save time and fill a series in your spreadsheet. By default, the Fill handle creates a series from lowest to highest, or ascending order. But, if you want a series to extend from highest to lowest, or descending order, it’s a snap to do. Using a similar process to the AutoFill ascending feature, the descending feature is a hidden gem in Excel feature.

For step-by-step instructions on how to use the AutoFill descending feature, visit http://helpdesk.etown.edu/help/autofill_a_series.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Excel – Filter a List

FilterList7

If you have a lengthy list in Excel and sort it to find records (rows), you can  instead use a Filter to omit any records (rows) that don’t meet your requirements. It’s easy and you won’t lose any data. If you want to only print specific data, filtering the data will only print the data you select. An easy and quick way to only display the information that you need at the time. It can easily be reverted back to display the original list with just the click of a button.

For step-by-step instructions on how to filter a list in Excel, visit http://helpdesk.etown.edu/help/filter_a_list.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Excel – Subtotal Feature

Subtotal1

When using Excel to keep track of invoices, payments, or anything pertaining to numbers, it can be complicated to add up all the different sections individually. Now it’s easy! You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. In only a few short steps, all the subtotals are done automatically for you. The grand total is also calculated with just the click of a button.

For step-by-step instructions on how to use Excel’s subtotal feature, visit http://helpdesk.etown.edu/help/subtotals.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Summer Travel with Tech

out of office picSummer is here and sunny adventures await! While you’re making travel plans, don’t forget to think of your technology. Have you decided what you’re going to bring with you? Do you know how to pack your electronics for airport travel?

For tips on traveling with tech, visit http://waytek.com/blog/summer-travel-tech-tips and enjoy your getaway!

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Web Tips

ITS Workshops – June 30 to July 11

ITS has scheduled several workshops for the Summer.  The workshops scheduled for the next two weeks are noted below.   If you would like to register or see all of the details for a session and also preview the classes that are scheduled for the remainder of the semester, the full schedule and all class descriptions are located here.

Mon
Jun 30

1:00 pm

to

2:00 pm

Publisher – Mail Merge
Nicarry 108
Use mail merge when you want to create a large number of documents that are mostly identical but include some unique information. For example, you can use mail merge to create individually cust…
Tue
July 1

10:00 am

to

11:00 am

Excel – Pivot Tables
Nicarry 108
Pivot tables use data from an existing sheet to summarize information in a meaningful way. If you don’t know about Excel’s pivot tables, summarizing large amounts of data can be a problem and take…
Wed
July 2

10:00 am

to

11:00 am

Word – Tables
Nicarry 108
Use a table to create custom tabs without the hassle. Use a repeating table header to identify the columns in a table that spans several pages. Draw a table to easily create the structure of a form. Cre…
Tue
July 8

9:00 am

to

10:00 am

Cisco Phone Introduction
Nicarry 108
The Cisco phone sitting on your office desk is a powerful tool. This workshop will cover the following features.Besides making and recei…
Wed
July 9

1:00 pm

to

2:00 pm

Word Press – Faculty & Staff Websites
Nicarry 108
Marketing and Communications has created a WordPress template that you can use to create a personal website hosted through the college. All you have to do is request a website a few days befo…
Thu
July 10

1:00 pm

to

3:00 pm

Word – Complex Documents & Styles
Nicarry 108
Learn Word’s capabilities for making long documents easier to read and edit by working with styles to easily apply consistent formatting and generate a table of contents. Create page references using Boo…
Fri
July 11

9:00 am

to

11:00 am

Word – Complex Documents
Nicarry 108
Learn Word’s capabilities for making long documents easier to read and edit by working with styles to easily apply consistent formatting and generate a table of contents. Then mark text to create an index. This…

 

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Training

Freezing Panes in Large Excel Files

Untitled picture

Working with long or wide Excel spreadsheets can cause problems when having to remember each row or column’s title. Using the Lock or Freeze Panes option, you can avoid having to scroll back to see what each section means.

For step-by-step instructions on how to freeze panes in Excel spreadsheets, visit http://helpdesk.etown.edu/help/freezing_panes.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

For Faculty: Encourage Metacognition with “Exam Wrappers”

Do you wish students would pay more attention to the feedback provided on an assignment or test?  Do you want them to learn how to learn so they can be successful in your courses?  If so, “Exam Wrappers” is an assignment/activity that encourages students to reflect on their study habits and performance.

http://cgi.stanford.edu/~dept-ctl/tomprof/posting.php?ID=1340

 

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Tagged with:
Posted in Home Page, Teaching and Learning

Guest Wireless Access

 

laptopLooking for Wi-Fi on campus? Guests on campus are now able to self-register for wireless network access while on campus.  Once registered, guests will have 24 hours of wireless network access. If guests are visiting for longer than one day, they can re-register for a new connection. If guests are staying for conferences, camps, or events that are more long-term, they can be preregistered. Preregistered guests will receive a packet of information with instructions on how to access the wireless network. Instructions for how to register for network access can be found here.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, New Student Tips

Customizing Your Quick Access Toolbar

toolbar customizedLast week, you learned how to use the Save As… feature in Office 2013. This week you can find out how to add the Save As… command and many others to your Quick Access Toolbar in Office programs. This handy shortcut saves valuable time and confusion because you never have to search for a command again. It’s right there at the top of the program window.

To find out how to customize your Quick Access Toolbar, visit http://helpdesk.etown.edu/help/quick_access_toolbar for step-by-step instructions.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Out of Office Replies Using OWA

out of office pic
In a rush to get out the door for that long anticipated vacation, you forgot to let email correspondents know that you are away from the office. Now you’re not in the office and want to want to turn on “Set Automatic Replies”.

Use Outlook Web App for this task, using any computer with internet access. Directions on the link below.
Outlook Web App (OWA)

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Uncategorized

ITS Workshops – June 15 to June 28

ITS has scheduled several workshops for the Summer.  The workshops scheduled for the next two weeks are noted below.   If you would like to register or see all of the details for a session and also preview the classes that are scheduled for the remainder of the semester, the full schedule and all class descriptions are located here.

Tue
Jun 17

9:00 am

Word – Custom Tabs & Dot Leaders
Nicarry 108

Ends @
10:00

Word’s ruler and paragraph tools make it easy to create custom tabs and dot leaders. These tools are handy for creating programs or schedules. If you have ever used the space bar to align columns of…

Tue
Jun 24

1:00 pm

Excel – Charts
Nicarry 108

Ends @
2:00

Charts explain numbers in an easy to understand format. Use data in a spreadsheet to quickly create a chart. Learn about the different types of charts, how to format and change them, use clip art to g…

Thu
Jun 26

9:00 am

Publisher – Introduction
Nicarry 108

Ends @
11:00

Microsoft® Publisher 2010 has a host of features that can be used to create professional-looking publications quickly and easily. In this course, you will learn the essentials of Publisher. This cours…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Training

For Faculty: Flipped Classroom Model

Have you thought about flipped learning – the teaching and learning model that has students listening to lectures that are recorded for homework and then doing what used to be homework during class?

If you have tried this model, even just as a way to combat a snow day or illness, this post, from The Chronicle’s Casting Out Nines blog, is a must-read.  It contains a 20 minute video presentation and written notes that discusses four aspects of the flipped model of which everyone should be aware.  Check it out!

http://chronicle.com/blognetwork/castingoutnines/2014/06/05/four-things-i-wish-id-known-about-the-flipped-classroom/

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Home Page, Teaching and Learning

“Save as” Shortcut for Office 2013

Tech Tip Tuesday – Office 2013 Shortcut

Save As Button

As a new feature in Office 2013, the “Save As” function has an additional step. Unlike previous Office versions and virtually every other Windows program, File | Save As takes the user to an intermediate screen that helps advertise Microsoft’s OneDrive cloud storage feature. A user can easily make the “OneDrive” location go away by unchecking “Show Additional Places For Saving, Even If Sign-In May Be Required” under Options, but the intermediate step will remain.

Fortunately, there is a solution. Users can just hit F12 to do a Save As. F12 goes directly to the regular Save As screen that users are familiar with. Alternatively, in case users may not remember F12, you can add a “Save As” icon to the Quick Access Toolbar.

Adapted from New Horizons Computer Learning Centers Tips and Tricks

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

For Faculty: When Trying Something New…

This article, originally posted on Faculty Focus, helps us to think about trying out new teaching strategies that we read about in journals, see demonstrated by peers or at conferences.  It reminds us that change is hard, success or not is often dependent on many factors, and sometimes we learn the most from our “failures”.

http://www.facultyfocus.com/articles/teaching-professor-blog/tried-didnt-work/

 

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Tagged with:
Posted in Home Page, Teaching and Learning