Step by Step Working with College Course Manager Template for Excel 2016

College Course Manager is the one of the solutions of many of the problems, faced by the typical college student during the academic tenure. College tenure and tedious educational process is so tiring for the students that it becomes troublesome for even a normal student to keep track of the educational process. Due to hectic schedule, many things may omit from the mind of students which may either cause huge damage to her / his studies or may force the student to abrupt the educational cycle, temporarily or sometimes permanently. Educational process for the college student involves many things, which must be cared about, involves following in addition to many other:

  1. Term Planning
  2. Credit Record Keeper
  3. Income & Expenses Record
  4. Book Record

Understanding the students concerns and issues, many apps and tools are available in the market, some of which can be applied with the help of the paper and pen while others can be applied with software tools. Being the student friendly organization, Microsoft has also provided many tools to help the student to solve typical problem of record keeping and record tracker. Some of the these tools, provided by the Microsoft are made available for the users of Microsoft Office software. These are in shape of the templates which may be downloaded, right from the site of the Microsoft, FREE, and applied to work upon.

One best tool for the college students, available as the template for the Microsoft Excel is ‘College Course Manager’. This is designed to solve almost all the above-mentioned problems of the students. Download it, free, from Microsoft site and start using it for record keeping and planning.

Download Process

1: Open the website of Microsoft Office and follow the command line.

Command Line: Microsoft > Office > Templates > College Tools – College Course Manager

2: Go to the ‘Templates’.

3: Click ‘College Tools’.

4: Here, select the template / tools, you want to download from the many available templates. Some of the templates are made for usage in the Microsoft Office Word while the others are available for Excel and Power Point.

As our currently sought template is made for the Excel, so search it in the Excel templates.

5: Click the ‘College Course Manager’ and visit its site. If it suits your needs and requirements, click ‘Edit in Browser’.

Note: Alternatively, you may click / tap the required template in the list of the ‘College Tools’, given below.

6: But, now, Microsoft will require you to sign in with your Microsoft account. If you already have Hotmail or Outlook account, sign in. If you don’t have such account, go through sign up process and have one Microsoft account.7: When you are signed in, click / press the ‘Continue’. 8: If you are just inspecting it for the purpose of usability, see it in ‘Online’ interface of Office 365. Or you may download it for ‘Offline’ application in your machine.

8: The destination for the download is ‘OneDrive’; the site, provided to all the Microsoft account holders, free of cost.

9: To download it to your machine, open up your ‘OneDrive’ account and download the template ‘College Course Manager’.

Note: The template, College Course Manager’ is designed for the latest Microsoft Office versions, as it is available as built-in in Microsoft Office 365. If you want to get maximum benefit from it, use the latest versions of Microsoft Excel versions. For this article, I used Microsoft Office 2016 version.

Now, Start Using ‘College Course Manager’ the Excel Template.

Step by Step Tutorial

1: Open up the “Microsoft Excel’ and press / click the downloaded template.

2: To visit different options of College Course Manager, see the 4 options, given at the bottom of the window, which are:

  1. TERM
  2. CREDITS
  3. BUDGET
  4. BOOKS

The current window is ‘TERM’.

TERM

2: The ‘Default’ screen of ‘College Curse Manager’ is about ‘My Class Schedule’ which is mentioned at the top-left corner of the template.

If you are willing to change the name of the screen, press or click the cell ‘My Class Schedule’. The cell will be highlighted.

Now, change the name of the screen with the help of the keyboard.

3: To change all of the following on the ‘TERM’ screen, click any cell and then change it as per your choice.

  • Term Name
  • YEAR

4: Start with Time – The Default start time is 9.00 AM. You may change it to 8.00 AM. Change and see the ‘TIME’ at the left side will also change.

TIME INTERVAL – Like start time, any change in the time interval will also change ‘TIME’ in left column.

5: If you are willing to change your first activity, you may change the same. For example, you may change the first activity from ‘Breakfast’ to ‘Exercise’, just click and change it.

6: You may add many course names or other daily activities, such as:

  • Lunch Time
  • Library
  • Extra-Curricular Activities
  • Union Meetings
  • Faculty counseling
  • Evening Tea
  • Evening Job time
  • Dinner Time
  • Club Activities
  • And so on.

7: See a changed template, as done for a typical student. Many other changes, as required, can be made by the user.

CREDITS

Similarly, you may make any change in the CREDITS screen, as required. Here, you may change the following as per your need and requirements:

  1. Specific name of the screen / window
  2. DEGREE TITLE
  3. YEAR
  4. TOTAL CREDITS – As per your program of studies.
  5. EARNED credits
  6. NEEDED credits to complete program
  7. Planning for the earned, needed and upcoming courses which include:
  • Grades
  • Completed
  • Credits
  • Program requirements
  • Course Number
  • Course Title
  • Terms in which achieved or required to be completed.

See; whenever you will change any figure in the TOTAL CREDITS, EARNED or NEEDED, the total subsequent figure(s) will also change in addition to the any subsequent resultant figure in the next column.

Note: This section has been left incomplete due to the reason that all college programs are different from others. Any changes / suggestion to change from my side may confuse you. So, this section is left, intentionally without any step by step instructions.

BUDGET

Now, look at the buttons, placed at the bottom of the College Course Manager and press / click the next button, i.e. BUDGET.

This screen is specifically important as this is directly related to your college program. If this section of College Course Manager is not planned, skillfully, whole your program of studies may suffer, damaging your whole the educational plan, your immediate future life and ultimately your whole the life. So, plan this carefully.

The BUDGET screen can help you about the future:

  1. To plan for your future financial restraints
  2. To keep track for your current college and personal financial burdens
  3. And to keep an eye on your near future financial position.

Some of the items which need your immediate attention and correction are:

  • Name of current screen (2)
  • Name of your financial plan (3)
  • Period for which you want to make planning and track record. (4).

How this screen items are interrelated:

In this section, you must keep a closer watch upon the 3 interrelated items:

1: PERCENTAGE OF INCOME SPENT – After calculation the NET MONTHLY INCOME and NET MONTHLY EXPENSES, the BALANCE will tell you about your saving or over-expenses. And this balance will be converted to percentage and will appear in the PERCENTAGE OF INCOME SPENT.

2: Currently, there are 4 items in the MONTHLY INCOME column but if you need to add information about any other source of income, such as, help from parents, etc. you may add more items by simply pressing / clicking the cell below the ‘Other Income’.

See, any change or addition of new item in the NET MONTHLY INCOME section will immediately change all the following items of BUDGET:

  • Addition of new item (1)
  • NET MONTHLY INCOME (2)
  • BALANCE (3)
  • PERCENTAGE OF INCOME SPENT (4)

3: Like NET MONTHLY INCOME section, NET MONTHLY EXPENSES will respond, immediately to any change in the items of expenses (1), mentioned under the NET MONTHLY EXPENSES. The 3 resulting items will change, immediately, are:

  • NET MONTHLY EXPENSES (2)
  • BALANCE (3)
  • PERCENTAGE OF INCOME SPENT (4)

6: Change a value in the MONTHLY EXPENSES and see the all the 3 values, mentioned in the previous section are changed.

5: In addition to the PERCENTAGE OF INCOME SPENT, a graphical image will also inform you about the income spent during the period.

BOOKS

Like other features of your college program, the books occupy prominent place. The next section / screen in the College Course Planner is about the books.

In this section, you may add all the books which are required for the term so that you may not feel the lack of the books at the time of need.

Download Source: College Course Manager

How to Collapse / Restore Ribbon of Microsoft Excel 2016 by Two Methods?

Normally, Excel users like to see and use all the tabs and ribbon so as to enjoy all the available Excel functions. While on the other hand, some of the professionals, who need maximum availability of the space, may like to collapse the ribbon as it would vacate the maximum space at top of the window for them to work on cells.

You may just collapse the ribbon for a few seconds or may collapse the ribbon for a longer time – depending upon your need of the use.

You may collapse / restore the ribbon at any moment, but if you need the help, just see the instructions.

Method 1

Instructions

1: If you want a little more available space, at the top of the window, just click any tab for once and when it becomes highlighted, double-click it and the ribbon will collapse, instantly, and the tab titles will be available only.RibbonCollapse-12: If you want to revert back or restore the ribbon of a single tab, just click the tab only once and the specific ribbon of that tab will reappear.RibbonCollapse-23: To revert to full ribbon, double-click any tab and the full ribbon will be restored.

Method 2

Instructions

1: Click the ‘Ribbon Display Options’ at the top right corner of the Excel 2016. It will open up popup menu. Click the second option from top, i.e. ‘Show Tabs’. It will, instantly, collapse the ribbon to the tabs only format.RibbonCollapse-3

RibbonCollapse-3

RibbonCollapse-4

RibbonCollapse-5And see the ribbon has just collapsed.RibbonCollapse-62: If you want to revert the full ribbon, click any tab for once which you want to display. But, this will be just temporary restoration.RibbonCollapse-73: If you want to revert to full ribbon, double-click any tab and the full ribbon will be restored.RibbonCollapse-84: Alternatively, you may click the ‘Ribbon Display Options; and click the ‘Show Tabs and Commands’ and it will restore the ribbon.RibbonCollapse-9That’s all!

How to Set R1C1 Reference Style in Spread Sheet in Microsoft Excel 2016?

Traditionally, the spread sheet of the Excel is set by columns and rows. Columns in Microsoft Excel 2016 are denoted by capital Alphabets, starting with ‘A’ and ending with ‘XFD’. On the other hand, rows in Microsoft Excel 2016 are counted in numeric, commencing with ‘1’ and ending on ‘1,048,576’ So, technically, you may pinpoint the location of any cell on the spread sheet in ‘ColumnRow’ where columns are identified by alphabet and the row is identified by numeric. For example, the location of any cell in spread sheet is pinpointed by ‘G9’ when it is in column ‘G’ and row ‘9’.RICI-Style-1Alternatively, you may identify location of any cell in ‘R1C1’ style, i.e. row ‘1’ and column ‘1’, making it easier to search the cell location. RICI-Style-2For example, if the cell is in rows 9 while the cell is in column 7, RICI style would display ‘R9C7’. For some users, this may look easier to understand.

You may also convert the reference style into spread sheet to RICI style but if you need any help, just see the instructions.

Instructions

1: Click ‘File’ in the Tabs menu at the top of the window in Excel 2016. A popup menu will open down at the left of the window. RICI-Style-32: In the popup menu, click the ‘Options’ at the bottom of the popup menu. It will open up a popup window, named; ‘Excel Options’.RICI-Style-43: Click ‘Formula’ near the top of the left column of ‘Excel Options’ to set the options for the formula calculations. RICI-Style-54: In the right column, see the first option, ‘RICI reference style’ in the ‘Working with formulas’ is unchecked, i.e. not active currently.RICI-Style-65: Click the ‘RICI Reference style to activate and enable it.RICI-Style-6 6: Click ‘OK’ at right bottom of the popup window. It will take you instantly back to the main window. RICI-Style-7See, here, the reference style is change to ‘RICI’ style.

That’s all!

How to Expand Formula Bar of Spread Sheet in Microsoft Excel 2016?

When you have entered a lot of data in any cell of the spread sheet of Microsoft Excel 2016, it becomes almost difficult to edit that data. The better option is there to edit the same in formula bar. But, in default position, formula bar is just a slim horizontal cell with limited space to enter and edit data. Yet, you cannot edit the data or formula in it at one instance due to its default limited capacity of displaying the data.

In Microsoft Excel 2016, it is now easier to expand the formula bar so that you may display whole the data at a spot and may edit it at any point.

It is now easier but you feel any problem, just see the instructions, given below:

Instructions

1: Enter any data in any cell of the spread sheet of Microsoft Excel 2016. FormulaBarExpansion-12: Just click or tap the cell which you want to edit in Formula Bar and see the cell will be highlighted and the data will also be displayed in Formula Bar. But, see the total data will not be displayed in formula bar.FormulaBarExpansion-2 3: To see the tail of the entered data, click / tap the End key at keyboard. It will display the last point of the data. Though, here you may start to edit the data but whole the data is not displayed in formula bar. FormulaBarExpansion-34: To display whole the data, just move the cursor on the lower cell line of the formula bar. A double edged arrow will appear while cursor is on lower line. Now, drag line downward with the help of cursor, while the double-edged arrow is alive.FormulaBarExpansion-45: You may expand the formula bar to any extend till your purpose is solved, i.e. the complete data or formula is displayed and is available for editing or doing the needful. FormulaBarExpansion-5After completion of the editing, you may drag the formula bar upward at the default position or at any other position liked by you.

That’s all!