Free Assignment Tracking Template for Google Sheets
- Last updated April 14, 2023
Are you looking for an assignment tracking template? When your tasks begin to pile up into several imaginary towers, it’s easy for you to be overwhelmed, not knowing where to start. Moreover, you might not even be able to keep track of all of them, resulting in missed assignments and potentially bad marks.
Having an assignment tracker to keep every task means you’ll be able to organize, stay on top, and complete all your assignments on time. All you need to do is open our Assignment Tracking Template , hit the “Make a copy” button and start sorting out your to-do list.
While it’s easy to navigate, make sure you read ahead to discover how to use our assignment tracking template to the fullest. We also have another assignment tracking template that lets you map out your assignments throughout the semester—a perfect fit for your syllabus.
Table of Contents
What Should a Good Homework Spreadsheet Have?
In general, you’ll want a few fields that will help describe your assigned tasks and some markers for better organization. Here are some essential components to look for:
- Assignment description: An efficient assignment tracking template will have space so you can jot down assignment notes. This avoids confusion and lets you anticipate the difficulty of your to-dos.
- Dates: Having dedicated fields for your due dates lets you plan your schedule better. This way, you know how much time you have to complete a task. Additionally, when paired with your assignment notes, you can sort them according to priority levels.
- Completion status: Keeping track of task statuses lets you know which tasks have started, are in progress, are accomplished, or need revision. Moreover, it’s also a great way to remember which tasks you need to return to.
- Subject and type: You also want to categorize your assignments into their respective subjects. Another way to group them is by assignment type, including papers, lab reports, collaborative work, and similar tasks.
The components above are only a few useful fields in an assignment tracking template. For example, some spreadsheets also include monthly views or trackers for semester-wide assignment lists. Templates such as these will undoubtedly have other categories you’d need to explore.
Basic Assignment Tracking Template
With all the considerations laid out above, we created a simple but effective assignment tracking template you can use for free. While it may only feature a single functional tab, it has nine named columns you can organize according to your tasks.
If you haven’t already, you can download our free assignment tracking template here:
Let’s discuss the template in more detail .
Column A—Days Remaining
This is self-explanatory, but you can refer to this column to see the number of days you have left to do or submit your assignment. Depending on the days remaining, you can also decide which tasks to prioritize according to their deadlines.
The cells under this column are automatically updated using our pre-loaded formulas , so avoid modifying them. Instead, you can change the values under the last two columns of this template.
Columns B to D—Tags for Status, Subject, and Task Type
Under these columns, you can set the categories of your assignments either by their completion status, class, or assignment type. You can select the values from the drop-down lists that come with the template based on the American curriculum.
Additionally, these statuses are associated with specific colors, making them more visual so that you can view and handle multiple ongoing tasks more efficiently. If the subjects listed differ from what you’re currently taking, you can modify the options.
To modify the subject options, follow the steps below:
- First, click on a cell’s drop-down list and locate the pen icon at the bottom.
- Click the pen icon to open the drop-down settings on the left-hand side of your screen.
- Change the values listed on the options, such as editing Math to Physics.
- Once you’ve set your preferred selection, click the “ Done” button.
- Upon clicking, a pop-out might appear on your screen asking whether to apply the changes to a wider cell range.
- Simply click “Apply to all” to replicate the changes to the other cells.
Another handy feature is the filter option in the “Status” column. You can use this to view your tasks based on their completion level. For example, you can choose to see only the in-progress tasks. Here’s how you do it.
- To get started, click on the filter icon next to the “Status” label.
- You should see a list of values with checkmarks on their left side once you scroll down.
- To deselect all of them, click on “ Clear.”
- Next, begin selecting the tasks you want to see per status, such as To start and In-progress.
- Finally, click “OK.”
- To revert the view, simply follow steps one to five, ensuring to select all the categories again.
Columns E to I—Assignment Details
You can start entering the information you know about the tasks at hand. The columns E to G are divided into three categories: Assignment Title, Description, and Files/Links. If your assignment has attachments and URLs, such as resources, you can keep them in the last column mentioned.
Meanwhile, columns H to I serve as fields where you can input the dates when your task is given and when you need to submit it. Take note that these are installed with data validation rules—you can’t enter values that aren’t valid dates. These values are also used to calculate the Days Remaining column.
Semester Assignment Spreadsheet
If you are looking to plan your entire semester ahead of time with your potential tasks, this is a helpful assignment tracking template. It’s much simpler than the previous spreadsheet discussed and gives you a semester-wide overview of your assignments.
Get the template here: Semester Assignment Spreadsheet
This assignment tracking template has only three fields that you can update. The first field is the (1) Date , which is located under the seven days of the week (with a total of fifteen weeks in the spreadsheet as per the American semester.)
The second is the (2) Tags field, which allows you to categorize your tasks according to the subject. As with the other template, these tags are color-coded for an easier view. Lastly, you can also populate the (3) Assignment Details , the blank spaces beside the tags.
Why Use Our Assignment Schedule Templates?
You can virtually make a never-ending list of benefits from using a homework spreadsheet, but to name a few, here are some reasons why they’re beneficial for managing your workload.
- Organization: As repeatedly emphasized, these assignment tracking templates help you categorize your tasks according to subject, type, and completion status, making it easier to organize your workload.
- Time Management: You can keep track of your due dates better with the automated counting of the days remaining for a task. You can manage your time better and learn to prioritize tasks according to deadlines.
- Easy Access: Our spreadsheets run on Google Sheets , which you can easily access anywhere, as long as you are connected to the internet. On top of that, they’re also ready to be filled out as soon as you make a copy for yourself.
Sticking to your deadlines and organizing your tasks doesn’t need to be complicated. You can easily do this with the help of our assignment tracking template on Google Sheets. Access more of these excellent templates by visiting our other blogs too!
If you want to learn about Google Sheets to the next level, consider checking out relevant courses at Udemy .
- 5 Useful Google Sheets Project Management Templates [Free]
- The Free Google Sheets Task List Template [Easy Guide]
- How to Assign a Task in Google Sheets [Easy Guide]
- Free Balance Sheet Template for Google Sheets
- The 9 Best Google Sheets Templates to Streamline Your Life
- Volleyball Statistics Spreadsheet: Free Template
Most Popular Posts
How To Highlight Duplicates in Google Sheets
How to Make Multiple Selection in Drop-down Lists in Google Sheets
Google Sheets Calendar Template for 2023 (Top 10 List)
Your Guide to IF CONTAINS Google Sheets Functions
2 Easy Ways To Change Google Sheets Cell Padding
- Chris Daniel
- November 23, 2023
- November 17, 2023
Using Google Sheets VLOOKUP from Another Sheet
- November 14, 2023
How to Delete Empty Rows in Google Sheets (3 Easy Ways)
- November 10, 2023
Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.
Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.
Like what we do? Share this article!
SpreadsheetPoint is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission.
2023 © Spreadsheet Point
Keep your college toolbox stocked with easy-to-use templates
Work smarter with higher-ed helpers from our college tools collection. Presentations are on point from start to finish when you start your project using a designer-created template; you'll be sure to catch and keep your professor's attention. Staying on track semester after semester takes work, but that work gets a little easier when you take control of your scheduling, list making, and planning by using trackers and planners that bring you joy. Learning good habits in college will serve you well into your professional life after graduation, so don't reinvent the wheel—use what is known to work!
WORD & 1DER
- Jul 26, 2022
5 Easy Steps to Do the Famous Excel Assignment Sheet
Updated: May 22
Keeping up with the college schedule can be hard, especially when your university, like mine, works on a quarter system.
At the beginning of my first year, I thought using a calendar/agenda and pen would work just as great as it did in high school, but I quickly realized that most professors give out all assignments at the beginning of the term and don't remind you before the deadline. I was overwhelmed with so many assignments that I barely had time to study; everything was pilling up.
One of my roommates said that she stayed organized with a color-coded excel sheet for all assignments of the term. I later noticed that it was a trend for people to use this method, however, when I asked my friends about it, most of them wanted to do it but didn't know how to.
I had to learn how to do it myself and ended up using it for my entire freshman year. So far, it has worked wonderfully, so I figured I would share how to do it so everyone can give it a try.
Step 1. Color Coding
In this 1st step, you will decide which colors you'll be using for each subject.
Here, for example, I have my six classes abbreviated, and I colored each one differently: Linguistics is orange, Techniques of Speaking is blue and so on...
Step 2. Writing Down the Assignments
Every university has their own system regarding how assignments are given out, for example, Drexel University uses a syllabus system. Each professor will hand out a syllabus for their class at the beginning of the year, where inside, the student can find all the deadlines and assignments for the term.
Write down all the details of each assignment in the excel sheet. Add the class name, the # of the week in which it is due, the complete due date, the name of the assignment, and the status (blank or done) **more on this later.
Repeat this step for each class.
Step 3. Adding Color
This step is very simple. Select all the cells for each subject and add the color you decided on for that class. Here is how mine looks so far:
Step 4. Organizing by Due Date
To organize our sheet by due date, we must sort *custom sort* the entire chart.
Select the entire chart, every column and every line. All the assignments, no matter the class.
Right click and select *sort* - *custom sort*.
Clicking on *custom sort* must have opened the sort window.
There, you'll see a list that says column, sort by. column A. You must click on the list and change the column to the column in which your due dates are listed on.
For example: my due dates are on column D, so I change the list that says "column A" to "column D."
Next, there's a list that says sort on, values. This will remain the same so leave it at "values."
The last list says order, oldest to newest. This will also remain the same. **If yours says something different, simply click on the list and a drop down menu will pop up where you can select the option "oldest to newest."
When your "sort" window looks like this, click on *ok* to make the changes. It will organize your assignments by due date and not by class.
Step 5. Using It
The final step is to use your excel sheet, and every time you have completed an assignment, on the column status write the word "done."
"done" means you have finished the assignment.
Then, once you have turned in the assignment, you can cross off the entire line.
How to cross something of:
Shortcut in Windows computer: select the cells you want to cross off, then click Ctrl + 5.
Shortcut in Mac computer: select the cells you want to cross off, then click Command + Shift + X.
Normal way in any computer: select the cells you want to cross off, then click on the bottom right corner of the "font" section.
Once the "format cells" window has opened on the "font" section, select the *strikethrough* option under "effects."
Then click on *ok* to make the changes.
After a while of using your chart, it will start looking like this.
Make sure to add any new assignments to the chart by simply inserting a new line, changing its color and organizing it by due date. Simply repeat the 5 steps.
I hope this was helpful to keep up with your college schedule. Thank me later ;)
I appreciate your feedback. If you have any questions, concerns, and/or comments, please write them below in the comments section and I will make sure to reply to as many as I can. Have a wonderful day.
From Mexico to The US for College
College Packing List-the one I used
Is There Such a Thing as an Uncomplicated College Abroad Application? With This Guide, There Is
- Link to facebook
- Link to linkedin
- Link to twitter
- Link to youtube
- Writing Tips
Assignment Tracker Template For Students (Google Sheets)
- 6-minute read
- 18th May 2023
If you’re a student searching for a way to keep your assignments organized, congratulate yourself for taking the time to set yourself up for success. Tracking your assignments is one of the most important steps you can take to help you stay on top of your schoolwork .
In this Writing Tips blog post, we’ll discuss why keeping an inventory of your assignments is important, go over a few popular ways to do so, and introduce you to our student assignment tracker, which is free for you to use.
Why Tracking Is Important
Keeping your assignments organized is essential for many reasons. First off, tracking your assignments enables you to keep abreast of deadlines. In addition to risking late submission penalties that may result in low grades, meeting deadlines can help develop your work ethic and increase productivity. Staying ahead of your deadlines also helps lower stress levels and promote a healthy study-life balance.
Second, keeping track of your assignments assists with time management by helping prioritize the order you complete your projects.
Third, keeping a list of your completed projects can help you stay motivated by recording your progress and seeing how far you’ve come.
Different Ways to Organize Your Assignments
There are many ways to organize your assignment, each with its pros and cons. Here are a few tried and true methods:
- Sticky notes
Whether they are online or in real life , sticky notes are one of the most popular ways to bring attention to an important reminder. Sticky notes are a quick, easy, and effective tool to highlight time-sensitive reminders. However, they work best when used temporarily and sparingly and, therefore, are likely better used for the occasional can’t-miss deadline rather than for comprehensive assignment organization.
- Phone calendar reminders
The use of cell phone calendar reminders is also a useful approach to alert you to an upcoming deadline. An advantage to this method is that reminders on your mobile device have a good chance of grabbing your attention no matter what activity you’re involved with.
On the downside, depending on how many assignments you’re juggling, too many notifications might be overwhelming and there won’t be as much space to log the details of the assignment (e.g., related textbook pages, length requirements) as you would have in a dedicated assignment tracking system.
There are a multitude of physical planners and organization apps for students to help manage assignments and deadlines. Although some vow that physical planners reign superior and even increase focus and concentration , there is almost always a financial cost involved and the added necessity to carry around a sometimes weighty object (as well as remembering to bring it along with you).
Mobile organization apps come with a variety of features, including notifications sent to your phone, but may also require a financial investment (at least for the premium features) and generally will not provide substantial space to add details about your assignments.
With spreadsheets, what you lose in bells and whistles, you gain in straightforwardness and customizability – and they’re often free! Spreadsheets are easy to access from your laptop or phone and can provide you with enough space to include whatever information you need to complete your assignments.
There are templates available online for several different spreadsheet programs, or you can use our student assignment tracker for Google Sheets . We’ll show you how to use it in the next section.
How to Use Our Free Writing Tips Student Assignment Tracker
Follow this step-by-step guide to use our student assignment tracker for Google Sheets :
- Click on this link to the student assignment tracker . After the prompt “Would you like to make a copy of Assignment Tracker Template ?”, click Make a copy .
Screenshot of the “Copy document” screen
Find this useful?
Subscribe to our newsletter and get writing tips from our editors straight to your inbox.
2. The first tab in the spreadsheet will display several premade assignment trackers for individual subjects with the name of the subject in the header (e.g., Subject 1, Subject 2). In each header, fill in the title of the subjects you would like to track assignments for. Copy and paste additional assignment tracker boxes for any other subjects you’d like to track, and color code the labels.
Screenshot of the blank assignment template
3. Under each subject header, there are columns labeled for each assignment (e.g., Assignment A, Assignment B). Fill in the title of each of your assignments in one of these columns, and add additional columns if need be. Directly under the assignment title is a cell for you to fill in the due date for the assignment. Below the due date, fill in each task that needs to be accomplished to complete the assignment. In the final row of the tracker, you should select whether the status of your assignment is Not Started , In Progress , or Complete . Please see the example of a template that has been filled in (which is also available for viewing in the Example tab of the spreadsheet):
Example of completed assignment tracker
4. Finally, for an overview of all the assignments you have for each subject throughout the semester, fill out the assignment tracker in the Study Schedule tab. In this tracker, list the title of the assignment for each subject under the Assignment column, and then color code the weeks you plan to be working on each one. Add any additional columns or rows that you need. This overview is particularly helpful for time management throughout the semester.
There you have it.
To help you take full advantage of this student assignment tracker let’s recap the steps:
1. Make a copy of the student assignment tracker .
2. Fill in the title of the subjects you would like to track assignments for in each header row in the Assignments tab.
3. Fill in the title of each of your assignments and all the required tasks underneath each assignment.
4. List the title of the assignment for each subject and color code the week that the assignment is due in the Study Schedule .
Now that your assignments are organized, you can rest easy . Happy studying! And remember, if you need help from a subject-matter expert to proofread your work before submission, we’ll happily proofread it for free .
Share this article:
Post A New Comment
Get help from a language expert. Try our proofreading services for free.
25 Topics for an Informative Speech
Have you been asked to give an informative speech, or do you simply want to...
How to Write an Executive Summary for a Business Plan
An executive summary is the part of a business plan that gives an outline of...
How To Start a Business Plan
The trick to starting any piece of writing is to just jump in and starting...
Scientific Notation: Definition and Examples
In the world of science, numbers reign supreme. Metrics, data, and statistics are used to...
What Is a Monograph?
A monograph is a comprehensive piece of writing that provides an intensive in-depth analysis of...
Book Proofreading Services: How to Ensure Your Self-Published Book Is Error-Free
Self-publishing is becoming increasingly popular with authors, but that also means that there’s increasing competition....
Make sure your writing is the best it can be with our expert English proofreading and editing.
How to Make a Spreadsheet in Excel, Word, Google Sheets, and Smartsheet for Beginners
By Andy Marker | June 13, 2017
Spreadsheets are grid-based files designed to organize information and perform calculations with scalable entries. People all around the world use spreadsheets to create tables for any personal or business need.
However, spreadsheets have grown from simple grids to powerful tools, functioning like databases or apps that perform numerous calculations on a single sheet. You can use a spreadsheet to determine your mortgage payments over time, or to help calculate the depreciation of assets and how it will affect your business’s taxes. You can also combine data between several sheets, and visualize it in color-coded tables for an at-a-glance understanding. With all the new functionality, using a spreadsheet program can be intimidating for new users.
In this article, you will learn how to create a spreadsheet in Excel with step-by-step instructions, details on what you can do with all its main functions , information on how to navigate the tools , and some free, easy-to-use templates . You’ll also learn how to do the same for spreadsheets you can create in Word, Google Sheets, and a powerful spreadsheet application, Smartsheet.
How to Create a Spreadsheet in Excel
The world’s most robust pure spreadsheet application, Excel, comes as part of both Microsoft Office and Office 365. There are two main differences between the two offerings: First, Microsoft Office is an on-premise application whereas Office 365 is a cloud-based app suite. Second, Office is a one-time payment, and Office 365 is a monthly subscription. Excel is available for both Mac and PC.
"Spreadsheets keep you organized. Rows and columns, formatting, formulas, filtering. That's the building blocks of structure and overview." - Kasper Langmann, Co-founder of Spreadsheeto
Unique Features of Excel
With over 400 functions, Excel is more or less the most comprehensive spreadsheet option when it comes to pure calculations. It also has strong visualization abilities, including conditional formatting, Pivot Tables, SmartArt, graphs, and charts. Home and business users alike can create powerful spreadsheets and reports to track data and inform their decisions.
One powerful Excel feature is Macro, little scripts and recordings you can create to make the program perform different actions automatically. While no other spreadsheet program has this type of feature, it is complex and can pose difficulty for beginners.
Excel also has close tie-ins with Microsoft Access, a database program, which can add power. In general, Excel integrates best with databases and any dataset requiring many calculations per workbook.
Understanding Your Main Screen
When you first open Excel in Office 365 or a newer version of Microsoft Office, you’ll see a basic screen. Here are the key features in this view:
A. Basic App Functions: From left to right along this top green banner you’ll find icons to: reopen the Create a Workbook page; save your work; undo the last action performed and display which actions were recorded; redo a step that’s been undone; select which tools appear below.
B. Ribbon: This grey area is called the Ribbon, and contains tools for entering, manipulating, and visualizing data. There are also tabs that focus on specific features. Home is selected by default; click on the Insert , Page Layout , Formulas , Data , Review , or View tab to reveal a set of tools unique to each tab. We’ll cover this more in the “Navigating the Ribbon” section later on.
C. Spreadsheet Work Area: By default the work area is a grid. Along the top are column headers A through Z (and beyond), and along the left side are numbered row headers. Each rectangle in the spreadsheet is called a cell, and they are each named according to their column letter and row number. For example, the cell selected here is A3.
D. Formula Bar: The Formula Bar displays the information contained within a highlighted single cell or range of cells. If in cell A1 you entered “1” as a value, “1” will appear in the Formula Bar . Plain text that you enter in a cell will also appear in the Formula Bar .
There are cases where what you see in the Formula Bar is different than what’s in the cell. For example, let’s say A1 = 1 and A2 = 2. If you create a formula in A3 that equals A1 + A2, then the A3 cell in your worksheet would show “3,” but the Formula Bar would show “=A1+A2.” This is important when you’re trying to move cells to other parts of your worksheet - remember that the display “value” of a cell isn’t necessarily what the cell contains.
That said, other formulas that reference a cell will take into account the current value of a cell. If A4 = A3 + 1, then it would be equal to 4, because it stacks the formula of A3 (A1 + A2) with A4 = A3 + 1. Formulas can reference other formulas multiple times.
E. Search Bar: Simply type the value you want to find to highlight all cells containing that value. It doesn’t have to be an exact match. For instance, if you searched for “o,” a cell labeled “Dogs” would appear among your search results.
F. Sheet Tabs: This is where the different sheets in your workbook can be found. Each sheet gets its own tab, which you can name yourself. These can be useful to separate out data so that one sheet doesn’t get too overwhelming. For example, you might have an annual budget, where each month is a column, and each row is a type of expense. Instead of keeping every single year you track on one sheet and scrolling horizontally, you can make each tab a different year containing 12 months only.
Note that data from different sheets in the same workbook can be referenced for formulas. For example, if you have two sheets, Sheet1 and Sheet2, you could bring Sheet2 data into Sheet1. If you wanted cell A1 in Sheet1 to equal the A1 in Sheet2, you’d enter this formula into A1: “=Sheet2!A1”. The exclamation mark calls on the previous sheet referenced before locating the data.
G. Viewability Options: The left icon is Normal which shows the worksheet as it appears in the image above, and the right icon is Page Layout , which divides your worksheet into pages resembling how it would look when printed, with the option to add headers. The slider with the “-” and “+” on it is for scale or zoom-level. Drag the slider left or right to zoom in or out.
Navigating the Ribbon
The Home tab is where you manage the formatting and appearance of your sheet, along with some simple formulas you’ll always need.
A. Copy and Paste Tools: Use these tools to quickly duplicate data and format styles in the spreadsheet. The Copy tool can either copy a selected cell or group of cells, or copy an area of the spreadsheet that you’ll use as a picture in another document. The Cut tool moves the selection of cells to a new destination rather than duplicating it.
The Paste tool can paste anything in your clipboard into the selected cell, and typically retains everything including the value, formula, and format. However, Excel has a wealth of pasting options: you can access these by clicking the down arrow next to the Paste icon. You can paste what you’ve copied as a picture. You can also paste what you’ve copied as values only, so that instead of duplicating the formula of a copied cell, you duplicate the final value shown in the cell.
The Format paintbrush copies everything related to the formatting of a selected cell. When you select a cell and click Format , you can then highlight a whole range of cells, and each one will take on the formatting of the original cell, without changing their values.
B. Visual Formatting Tools: Many of these tools are similar to those found in Microsoft Word. You can use the formatting tools to change the font, size, and color of typed words, and make them bold, italicized, or underlined. It also has a couple spreadsheet-specific formatting options. You can choose which sides of the cell get additional borders, and their style and thickness. You can also change the highlight color of the entire cell. This is useful for creating visually-appealing borders or differentiating rows or columns on large sheets, or for highlighting a particular cell that you want to accentuate.
C. Position Formatting Tools: Align cell data to the top, bottom, or middle of the cell. There is also an option for angling the values displayed, which can make it easier to read. The bottom row has familiar options for left, center, and right alignment. There are also indent right and left buttons.
D. Multi-cell Formatting Features: This section contains two very important features that solve common problems for new Excel users. The first is Wrap Text . Normally, when you enter text into a cell that extends beyond the size of the cell, it spills into the next cell. For example, if you type “Budgeted Items” into A1, some of the word “Items” spills into B1. Then, if you type into B1, you cover up any characters from A1 that extended into B1. The extra text from cell A1 still exists, but now it is hidden. If you don’t want to widen the cells, click the Wrap Text icon on A1 - this will split “Budgeted Items” into two stacked lines instead of one within A1. This makes the entire row taller to accommodate the content. Now, typing into B1 won’t cover up existing text.
The other tool in this section is Merge and Center . There are instances when you may want to combine several cells and have them act as one long cell. For example, you might want a header for an entire table to be clear and easy to read. Select all the cells you want combined, click Merge , and then type your header and format it. Though the default setting for headers is centered text, simply click the drop-down arrow to select different merging and unmerging options.
E. Numbers-based Format Settings: A drop-down menu has options for number formatting. For example, currency places everything you select into “$0.00” format, and percent turns .5 or ½ into “50%”, date options. These are the basic format options, but you can select More Number Formats from the drop-down menu to get more specialty use cases (different countries’ currencies, or adding the “(xxx)xxx-xxxx” formatting to phone number sequences). Often, you may use these tools on entire columns to make all data in one category behave the same way.
F. Table or Sheet Formatting: Format as Table and Cell Styles allow you to use presets or customize tables (for example, with alternating row colors and highlighted header bars). Select your data range and choose a style to standardize formatting.
Conditional formatting is a bit more complex. Use the drop-down menu to select from a range of options, like inserting helpful visual icons to represent status or completion, or changing the color of different rows. Most important are the conditional rules , which are created with a simple logic. For example, let’s say you have a column with data in A1 through A3, and A4 holds the sum of these three cells. You could place formatting on A4 with a rule that says “if A4 > 0, then highlight A4 green.” Then, you could add another rule that says “if A4 < 0, then highlight A4 red.” Now you have a quick visual reference where green = a positive number and red = a negative number, which will change based on what you enter into A1, A2, and A3.
G. Row and Column Formatting Tools: The Insert drop-down menu puts cells, rows, or columns before or after a selected area on the sheet, and Delete removes them. The Format drop-down lets you change the height of rows and the width of columns. It also has options for hiding and unhiding certain sections.
H. Miscellaneous Tools: Starting at the top left, there’s AutoSum , which allows you to select a swath of cells and place the sum in the cell located right below or directly to the right of the last selected data point. You can use the drop-down to change the function to calculate the average, display the maximum, minimum, or the count of numbers selected.
Use Fill to take a cell’s contents and extend them in any direction for as many cells as you want. If the cell contains a value, Fill will simply copy the value over and over again. If it contains a formula, it will recalculate its relative position for each new cell. If the first cell equals A1+B1, then the next would equal A2+B2, and so on.
The Clear button lets you either clear the value, or just clear cell formatting.
Sort & Filter tools let you choose what to display, and in what order. At the base level, this tool sorts cells containing text from A to Z, and cells containing numbers from lowest to highest. It can also sort by color or icon. Sorting and filtering helps surface only the data you need.
Use the Insert tab to add extra elements to your Excel workbook that go beyond text and colors.
A. These tools control PivotTables , an important Excel function. Think of PivotTables as “reports,” a quick way to view all your data, analyze trends, and draw conclusions. By selecting at least two rows of data and clicking on PivotTable , you can quickly generate a visually-appealing table. Going through this process launches the PivotTable Builder , which helps you select columns to include, sort them, and drag-and-drop them to quickly construct your table. They can include collapsible rows to make reports interactive and uncluttered. There is also a button for Recommended PivotTables, which can help when you don’t know where to start.
Table builds a simple table that includes any number of columns you select. Rather than placing the table elsewhere on the worksheet, it turns the data into a table on the spot, and applies customizable color formatting.
B. This section lets you insert visual elements, like picture files, pre-built shapes, and SmartArt. You can add shapes and resize, recolor, and reposition them to create intuitive data sets and reports. SmartArt objects are prebuilt diagrams that you can insert text and information into. They’re great for representing what the data says in another place on your workbook.
C. These tools are for inserting elements from other Microsoft products, like Bing Maps, pre-built information cards about People (from Microsoft accounts only), and add-ins from their store.
D. Use these tools to create charts and graphs. Most of them work only if you select one or more data sets (numbers only, with words for headers or categories). Charts and graphs function like you’d expect - just select the data you want to visualize, then select your desired type of visual (bar charts, scatter plots, pie charts, or line graphs). Creating one will bring up formatting options where you can change the color, labels, and more.
E. Sparklines are more simplistic graphs that can fit in as little as one cell. You can place them next to data for a small, quick visual representation.
F. Slicers are big lists of buttons that make your data more interactive. You can select a PivotTable you’ve created, and then create a slicer from it - this allows a viewer to click on buttons that correlate to the data they want to filter.
G. This hyperlink tool allows you to make a cell or table into a clickable link. Once a viewer clicks on the affected cell(s), they’ll be taken to whatever website or intranet site you select.
H. Recent versions of Excel allow for better collaboration - insert comments on any cell or range of cells to add more context. You can open or close the comments so the worksheet doesn’t get too cluttered.
I. A Text Box is useful when you’re creating a report and don’t want typed words to behave like cells. It makes it easy to move your text around, rather than cutting and pasting cells (which could potentially mess up the formatting of real data). The next area is for Headers & Footers , which will take you to the page layout view - here you can add headers and footers for the entire page. WordArt , on the other hand, lets you embellish text. Insert Object lets you place entire files (Word documents, PDFs, etc.) into the worksheet.
J. This section lets you insert Equations and Symbols . Use equations to write a math equation with fractions, variables, and more that you can place in your sheet like a Text Box . For instance, this can be helpful for explaining how a portion of a table was calculated in a report. Symbols , on the other hand, can be inserted directly into cells, and include all non-standard characters from most languages, as well as emojis. The Page Layout tab has everything you need to change the structural parts of your worksheet, especially for purposes of printing or presenting.
A. Use these buttons to quickly adjust the visual style of your entire sheet. You can regulate the fonts and colors, and use the Themes section to quickly apply it to every table, PivotTable , and SmartArt element for a clean, well-designed sheet.
B. These are print options. You can change the margin for printing, whether you want a vertical or horizontal print alignment, which cells in your sheet you want to print, where you’d like page breaks, and whether it has a background (to place your company name, for example). You can also start giving each page a heading using the Print Titles button, and the order to print each section.
C. This lets you choose how many pages across and how many pages down you’d like to print.
D. This section lets you toggle whether the automatic grids appear for working on the sheet and for printing it, along with the row and column headings (A, B, C, 1, 2, 3, etc).
The Formulas tab stores nearly everything related to Excel’s reputation as “complex.” Because this article is intended for beginners, we won’t cover every function is this section thoroughly.
A. The Insert Function button is useful for those who don’t know all the shorthand. This brings up a side Formula Builder section that describes each function, and you can select the one you want to use.
B. These buttons divide all the functions by category.
- AutoSum works the same as it does in the Home tab.
- Recently Used is helpful for bringing up frequently used formulas to save time looking through menus.
- Financial includes everything related to currency, values, depreciation, yield, rate, and more.
- Logical includes conditional functions, like “IF X THEN Y.”
- Text functions help clean, regulate, and analyze plain text cells, such as displaying the character count of a cell (helpful for Twitter posts), combining two different rows via Concatenate , or pulling out numerical values from text entries that aren’t formatted correctly.
- Date & Time functions help make meaning out of time-formatted cells, and include entries like “TODAY,” which enters the current date.
- Lookup & Reference functions help pull information from different parts of your workbook to save you the trouble of looking for them.
- Math & Trig functions are just what they sound like, involving every sort of math discipline you can imagine.
- More Functions includes Statistical and Engineering data.
C. This section contains tagging options. If there’s a range of cells or a table you frequently need to refer to in formulas, you can define its name and tag it here. For example, say you had a column that contained the entire list of products you sell. You could highlight the names in that list and Define Name as “ProductList.” Every time you want to refer to that column in a formula, you can simply type “ProductList” (rather than finding that collection of data again or memorizing their cell positions).
D. This contains error checking tools. With Trace Precedents and Trace Dependents , you can see which cells contain formulas that refer to a given cell and vice versa. Show Formulas reveals the formulas inside all cells, rather than their display values. Error Checking automatically finds broken links and other issues with your spreadsheet.
E. Should you have a large sheet with a massive series of interconnected formulas, tables and cells, you can use this section to trigger calculations, and also to choose which types of data don’t run. A good example is a mortgage or asset depreciation sheet .
The Data tab is for performing more complex data analysis than most beginners will need.
A. These are database import tools, allowing you to import data from any web, file, or server-based database.
B. This section helps you fix database connections, refresh data, and adjust properties.
C. These are Sort and Filter options similar to those for data you have within your sheet, applied to data feeds. They’re especially crucial here as a database is sure to have more data than you can or care to use.
D. These are data manipulation tools. You can take a single long string, like those separated by commas or spaces, and divide them into columns with Text to Columns . You can seek and remove duplicates, consolidate cells, and validate whether data meets certain criteria to assess its accuracy. What-if Analysis helps you fill in gaps with incomplete data using existing data and trends to determine likely outcomes for new scenarios.
E. These tools help you manage how much data you have to deal with at once and group them by whatever criteria you deem necessary. It’s similar to sorting, but you can choose any range of columns or rows and make them collapsible, each with their own label. Use Subtotal to create automatic calculations along a data set by different categories, which is helpful for financial sheets.
The Review tab is part of the Ribbon that helps with sharing and accuracy checks.
A. These are simple text-based checks (like in Word) that allow you to locate cells with spelling errors, or find more appropriate words via the Thesaurus.
B. Check Accessibility pulls up errors that can make it difficult to access the data in other programs, or just for reading purposes. It might find that your sheet is missing alt text, or that you’re using defaults for sheet names that can make navigation less intuitive.
C. The commenting tools allow collaborators to “talk” to each other within the sheet.
D. Protecting and sharing tools allow you to invite collaborators and restrict access to certain parts of the sheet. You can manually assign different levels of access - for example, you might allow a contractor to edit just the cells related to the hours they worked, but not the cells that calculate their pay. As with Word, sharing a sheet with Tracked Changes means you can see everything that’s been done to the sheet.
E. When you’ve shared a workbook, you can restrict permissions later on using this button and selecting individual contributors.
Use the tools in the View tab to change settings related to what you can see or do.
A. This is your basic view where you can see your default sheet view, how it’ll look when printing, and in custom ways you set yourself.
B. Use these buttons to choose whether you want to see the grids, headings, formula bar, and ruler.
C. This is another way to control zooming in and out of cells.
D. Freeze Pane controls are an important part of making a usable spreadsheet. Using these tools, you can freeze a number of rows and/or columns while you scroll around. For example, if the first row had all your column headings and remained frozen, you’ll always know which column you are looking at as you scroll down.
E. Macros are a way of automating processes in Excel. It is far beyond Excel 101, however.
How to Create a Simple Budget Spreadsheet in Excel
Now that you’ve learned about the tools in Excel, let’s practice making our own spreadsheet from scratch. This guide will cover basics, with a few intermediate techniques to get you more comfortable with spreadsheets.
Step 1: Create a Workbook
When you open Excel, you’ll be presented with a screen like this. Create a new workbook by clicking the New tab on the sidebar. The Recent tab below that will bring up any workbooks you’ve recently opened. Below that is the Shared tab, which shows workbooks that other Excel users have sent to you directly through the app (we won’t focus on that right now). The final tab is Open , which opens a file browser so you can select an existing workbook. On the New tab, you can see a number of templates available, which can help you jump straight into making specific types of spreadsheets, like budgets and task lists. In this example, however, we’re going to build a spreadsheet from scratch. Click Blank Workbook on the top left corner, then click Create .
Step 2: Plan Your Needed Data
Before you can create any kind of spreadsheet, you need to plan what it’ll include so you can structure and format it accordingly. While it is possible to change the spreadsheet structure later on, the more data you’ve added, the more inconvenient it becomes. Plus, moving around entire rows and columns increases the chances of accidentally changing formulas. In this example, we’re making a monthly budget, so we’ll use a monthly time stamp. As we explored above, we can use other sheets in this workbook to track other time increments, like weeks or years. Of course we want to add all of our different expenses together, but we should also think of categories for comparison. We could have one for necessities, and one for luxuries. We’ll need subtotal rows, along with a comparison of budget to actual spending. At the end, we’ll also want to easily compare the different parts of the budget together.
Now we know the elements we need, and can organize them accordingly.
Step 3: Create Headings
Since we know we want to compare month to month, we should use months as our column headings - horizontally is usually best for time comparison. Since we know we’ll also have categories of spending to label and sublabel, we should leave the A and B columns open, and start at cell C1. Here’s a useful trick: if you type a number or timestamp with a logical next entry, you can click the lower right corner of that cell and drag in any direction to autofill the rest of the sequence as far as you want. For this example, after typing “January” in C1, you can drag it across to N1 and watch it fill in the rest of the months. To create the diagonal names in the screenshot, navigate to the Home tab and find and click the formatting option with a diagonal rising appearance. This makes the headings stand out without changing the column width. We’ll also need an area on the sheet where we can get row totals for more useful data, so create the heading Total in cell O1.
Step 4: Label the Rows
Create three blocks of entries on column B. Name the first block Necessities , which will include everything you see, and end with a subtotal. Name the second block Luxuries and include a few categories; also end with a subtotal. The last block will have our Total , the budget to compare it to, and the difference between the two, which we’ll call Saved (this amount represents the difference between the expected and actual spent). To makes them stand out, use the Paint Bucket tool and select a color (grey in this example).
For column A, we’ll create labels that clearly line up with our grey blocks, and position the writing vertically so it doesn’t take too much space. To make the width of the column smaller, grab the right edge of the A column and drag it to the left. To combine all the cells for our category labels, highlight A2 through A7, and Merge & Center . To get the writing vertical, navigate to the Home tab, find the formatting option and click vertical writing . Finally, choose the height alignment as centered so the vertical text will appear in the middle. Repeat this with cells A9 through A13.
Step 5: Add Boundaries
Add boundaries to the spreadsheet using the icon in the above graphic. Select each collection of cells, and don’t adjust the spaces between the grey block groupings. Click All Borders to draw distinct grids. Now, make the outer boundary of each block thicker by selecting the entire area and choosing Thick Box Border . Finally, do the same around the inner row of each box labeled Subtotal , to make these visually distinct. Apply a Thick Box Border to Column O, Total, and leave spaces between each row grouping. All of this improves spreadsheet readability. Step 6: Create a Results Table
Use the side of your nicely-formatted spreadsheet to create the outlines of a simple table which will contain your main results. This information will assist you in creating a chart, later. Give it an appropriate label, and label its rows for the total from Necessities , the total from Luxuries , and the total Saved for the year.
Step 7: Format and Write Formulas
This is where the spreadsheet gets a lot more powerful. It involves a series of steps: A. First, select every cell that will contain a number, underneath columns C through O, and also in the table for Portion of Budget. Now click the “$” on the keyboard to format the cells with the standard dollar format with two decimals for cents.
B. Select cells C2 through C7 and click AutoSum . This creates a formula that adds everything in this column, and places the sum into C7 (the last selected cell).
C. Use your cursor to grab the bottom right corner of cell C7, and drag it to the right toward column O. This will duplicate your formula down the entire Subtotal row. This means that while C7 = sum of C2 through C6, D7 = sum of D2 through D6, and so on. Repeat the process for Luxuries.
D. For the Total, Budget , and Saved area, the process is a little different. Click cell C15, and enter this formula: =C7+C13. This totals the two subtotals. Like you did with the other formulas, drag and duplicate it across to column O.
F. Click cell C17, and input this formula: =C16-C15. This will make the Saved row equal to the difference between Budget and Total.
E. Finally, add formulas to each empty cell of your Portion of Budget table. Q3=O7, which will bring the yearly subtotal of all Necessities items to the Necessities part of this table. Do the same for the Luxuries table annual subtotal and the Saved annual total. Step 8: Script Conditional Formatting
Before entering data, there’s one more bit of set up: conditional formatting. To do this, click the drop down arrow on Conditional Formatting and click Manage Rules. Next, click + to add a rule, which takes you to a new popup menu. Click Style: Classic . Then choose Format only cells that contain , and click Cell Value greater than 0 . Format this with a standard option, green fill with dark green text. Now you’ll be returned to the Manage Rules section, where you can select which range of cells it applies to. Choose C17 through O17 to have it affect the Saved row only.
Now repeat the steps, but this time Format only cells that contain the Cell Value equal to or less than 0 . Use the standard option light red fill with dark red text , and apply it to the same range of cells.
Now you have a conditional format for all the final calculated Saved row entries. If it’s greater than 0, it gets marked green, and if it’s 0 or less, it gets marked red. When your data is entered, you can instantly see which months you saved money in, and which you didn’t. Step 9: Enter Data and Watch the Calculations
First, enter an assumed budget, and copy it across the Budget row by dragging it from its bottom right corner. In this case, the assumed budget is $3,000.00. Next, enter your data for each month of last year, totaled from receipts and bank statements, and categorized accordingly. Now for the magic of spreadsheets: as you enter each bit of data, you’ll see your Subtotals, Totals, Saved rows filling in, as well as the Portion of Budget t able - all calculating and updating in real-time.
Step 10: Create a Pie Chart
Create a simple visualization. Select the entire Portion of Budget table, and then click the Insert tab on the Ribbon , and choose Pie Chart . Because of how the table is set up, the chart will be titled Portion of Budget , and each dollar amount will appear as a percent of the pie chart with the necessary label. Don’t forget to click Save on the top left of the Excel app. Now you have an incredibly useful spreadsheet that tells you exactly how well you stuck to your budget each month while also getting a sense of where your money went last year overall. You can copy and use this spreadsheet year after year. If you want more help getting started creating a budget, check out Top Excel Budget Templates . Additionally, increase your speed with this complete list of keyboard shortcuts in Microsoft Excel.
How to Create a Spreadsheet in Word
Learn all the basics for making a spreadsheet with Microsoft Word. Word is the world’s most popular word processing application, featuring countless ways to format text-based documents, but also including simple tables and spreadsheets. Like Excel, the app comes as part of Microsoft Office and Office 365, and has versions for both PC and Mac. This tutorial uses the Microsoft Word version available in Office 365.
Unique Features of Word
In fact, Word isn’t really a spreadsheet app, but an app for typing and laying out text documents. It’s far easier to format sentences and paragraphs in Word than in the text boxes available in Excel, let alone inside cells. Because of this, Word can be used to create compelling reports or to insert semi-workable data into a text-heavy document, such as an article. Word has two modes of spreadsheet creation: creating simple tables in the program itself, or inserting sheets and charts from Excel.
Understanding the Word Interface
Unlike Excel, where everything in the Ribbon is vital to creating a spreadsheet, only a few items are relevant in Word. For starters, almost everything you need is in the Insert tab. Here are the relevant Insert tab tools:
A. Table: Click this button to create basic tables in a few ways. When you click Table , a grid appears that you can hover over and click to choose the number of vertical and horizontal cells you want for your spreadsheet. If you click Insert Table , you get a pop-up window that lets you specify the spreadsheet’s dimensions by typing the number of rows and columns for the table, as well as setting the width of cells. Lastly, you can select Draw Table to drag and create as many cells as you like. Despite how simple it seems, Draw Table isn’t actually the best or easiest way to create a spreadsheet in Word.
B. Chart: A drop-down menu appears when you click this button that has the same types and styles of charts - and even the same interface - as Excel. You’ll see scatter plots, pie charts, line graphs, and more.
C. Table Design and Layout: When you click on any table in your Word document, two additional tabs appear in the center of the Ribbon - Table Design and Layout . Both tabs work only for tables, and contain further Ribbon menus explained below.
D. Object: You can bring Excel elements directly into your Word document. Either insert a Microsoft Excel Chart or a Microsoft Excel Worksheet. Selecting either of these options will open Excel so you can create and edit a fully functional spreadsheet that will then appear as-is in the Word document. These spreadsheets and charts behave like images in Word, so you can move them around and resize them, and even double-click them to open up Excel and update their data.
You can also insert an existing Excel file. To do this, click From File , then navigate to the location of the Excel file and open it. Initially, only the primary sheet appears, but double-click it to allow anyone to access the whole workbook, unless you protect it.
Let’s focus on the Table Design tab. These options are only for tables created within Word, not those imported from Excel.
E. Use these toggles to choose certain table layout elements such as column, row, or header color.
F. These are style presents very similar to table styles in Excel, with a wide variety of colors and varieties. Plus, with the Paint Bucket icon, you can customize the shading rather than choosing one from the dropdown menu.
G. These tools let you design the borders of each individual cell, and the entire table. You can choose thickness, color, and type of line (dotted, straight, wavy, etc).
Next, let’s look at the Layout tab. Again, this only works for tables created in Word.
H. Use these tools to select rows, and choose whether or not to show the gridlines. You can also open up the Properties window and edit various elements, table alignment, or how the borders and shading appear.
I. This is another home for the Draw Table and Erase table tools. Use these tools to drag your mouse and draw each cell and erase them, one side at a time.
J. These are tools for deleting rows, columns, or entire tables. You can also do this by highlighting a cell, right-clicking, and selecting to delete these portions.
K. Insert rows or columns wherever you like in your table with these tools. Again, you can also access these tools by highlighting and right-clicking different parts of the table.
L. These tools let you change the organization of your table. You can merge and unmerge cells, like in Excel. This is a helpful feature for creating headers or spacing in your table. You can also split the table between any two rows.
M. Perform Autofit to automatically fit your table into the Word document’s space, or to make all columns the same width.
N. Adjust the height and width of rows and columns numerically, rather than using drag and drop.
O. Use these tools to select multiple rows or columns, and evenly distribute them across the page to make your table look clean and professional.
P. The alignment tools help you specify how to align the contents of each cell (top left, bottom right, center, etc.). can also choose if you want the text to be horizontal or vertical.
R. Here is where basic spreadsheet functions live, and they aren’t nearly as robust as what you’d find in Excel. Sort works the same way, allowing you to select several rows in a column and use them to alphabetize the table. Convert to Text lets you select any number of cells and put them in text value without a table, separated by commas or spaces. This can be helpful for editing contents in paragraph form later, or importing data into other applications.
Finally, there are the functions. Word tables have 18 core functions that are mostly math with a couple logical IF and THEN functions. Calling cells in formulas is also somewhat more difficult in Word. If you have a single row table, then every cell will be row 1 - A1, B1, C1, etc. However, these aren’t labeled, so you have to count over, or just memorize them. You can also call by position: if you want to know the sum of all cells in a column and put it in the last cell, select the last cell, and make the formula “=SUM (ABOVE).” Likewise, use RIGHT, LEFT, or BELOW to call everything in those directions.
The other relevant item to spreadsheets that can be created in Word is the chart function. In the Insert tab, click the insert Chart button to access this feature. Once you choose a style, it will open Excel so you can edit the chart data. The functionality works exactly the same as in the Excel tutorial above. However, once the chart is in Word, two new tabs in the Ribbon , in place of Table Design and Layout . They become Chart Design and Format .
A. Use these tools to add extra important elements to your chart, either individually with Add Chart Element , or all at once using the helpful presets with Quick Layout .
B. Use these tools to adjust the style of your chart without changing its layout too much. You can adjust colors, drop shadows, background, and more.
C. Manipulate data in the chart with this set of tools. Switch Row/Column lets you change the X-Y-axes of your chart. Select Data takes you back into your Excel session to choose data set you want represented in the chart. Edit Data in Excel allows you to change anything you like about the data in Excel. You can also go into Excel by double-clicking your chart. When you return to Word, click Refresh Data to update your chart to reflect any changes made to the data in Excel.
D. Change Chart Type allows you to switch from a pie chart to a line graph and so on, using the same set of data.
Now look at the Format tab.
E. The selector tool lets you choose which part of the chart you’d like to edit so you don’t accidentally click elsewhere. You can select the Plot Area where the graph is stored, the Chart Area where all the axis labels exist, or any other element.
F. Use this to insert shapes into your chart, just like inserting any other object into Word.
G. Use these tools to color every element on your chart, which can include how you want to fill in lines, the text color, and more.
H. These are all your style options for text in your charts that handle adding WordArt, a fill color, and more.
I. The positioning tools work similarly to positioning other objects in Word. You can make the text wrap around the chart with Wrap Text , and place it behind or in front of any other element on the page.
J. Use these tools to numerically change the height and width of the entire chart. You can also adjust the chart’s height and width by grabbing the corner or side and adjusting it with your mouse.
K. This opens the Format Pane , which has some of the same tools found in the Ribbon , but they are larger and easier for some to access.
How to Import a Spreadsheet and Chart into Word from Excel
Now that you’ve learned about the spreadsheet tools in Word, you can practice a few different ways to import an existing spreadsheet into Word.
Step 1: Create a Word Document
When you open Word, this screen appears. The New tab on the left side lets you create a new document, Recent surfaces recently opened documents, Shared shows documents that other Word users have sent to you, and Open opens a file browser for selecting an existing document. On the New tab, you can see a number of templates which you can use to jump straight into making different types of documents like resumes, blogs, and research papers. Most don’t relate to spreadsheets at all, so click Blank Document on the top left corner, then click Create .
Step 2: Save Your Document
Once your document is created, save it by clicking the save icon shown above, and select a location to save it. Give it a name relevant to its purpose, so it’s easy to find. Step 3: Import an Excel Workbook into Your Document
Go to the Insert tab, and click Object .
When the Insert Object popup window appears, click Microsoft Excel Worksheet , and then click From File . This opens a file browser window, where you can select the Simple Budget spreadsheet you created earlier, for instance. Open it. Step 4: Resize Spreadsheet to Fit
A spreadsheet as large as the one we created is too large for a standard Word document at its normal size. To shrink it, click once on the imported spreadsheet, and hold down the Shift key. While pressing Shift , select a corner of the spreadsheet and drag it towards the center of the object a few times. It’s important to note that spreadsheets behave like a regular picture or object in Word, so you can drag them around and change their size as you like. Feel free to add text below the spreadsheet, as well.
Regardless of the spreadsheet’s size, you cannot interact with the data within Word. However, all of your formulas and formatting will remain intact. You can still work with the rest of the document, typing words and inserting pictures around the spreadsheet.
Step 5: Edit the Data in Excel
To edit the data, double-click the spreadsheet to open the spreadsheet in a new Excel window. Here, you can edit any data. It updates in real-time, meaning that as soon as you make the change in Excel, the change will be reflected in Word. In this way, you can bring fully-functional spreadsheets straight into Word. Note: When you double-click on an inserted object like an Excel workbook, you have access to the entire workbook, not just the first sheet which appears as an object in Word. If you are sharing a document like this with someone and don’t want them to access other sheets, make sure to enable Protect Sheet in Excel.
How to Copy an Excel Spreadsheet and Chart Into Word
The newer version of Word lets you simply copy and paste cells and other Excel elements from an Excel workbook into a Word document. Here’s how to do it: Step 1: Open Your Excel File Open the Simple Budget workbook that contains your table, chart, and spreadsheet in Excel. Step 2: Select and Copy a Range of Cells, a Table, or a Chart
Highlight cells in the budget spreadsheet, then press Ctrl+C to copy the data. Alternatively, you can single-click the Portion of Budget chart, and press Ctrl+C to copy it. Step 3: Open Your Word Document and Paste the Selected Cells or Chart
In your Word document, right-click on your mouse and click Paste to paste your chart and your selected Excel worksheet content into your Word document, one at a time. (Note that for this example, we aren’t copying the entire spreadsheet.) You’ll notice that some cell formatting is lost; this is because the data comes into Word and behaves like a table created in Word, rather than as an Excel spreadsheet. Step 4: Format Your Data
Charts in Word behave a lot like charts in Excel. When you single-click a chart to select it, it opens the Chart Design and Format tabs so you can manipulate information (for example, the design and layout). If you need to change some of the chart’s data, click Edit Data in Excel on the Ribbon . You can also hover over areas of this pie chart to surface additional information such as how many dollars the blue portion represents.
By contrast, spreadsheets and tables don’t behave the same in Word, because Word’s table abilities are much more limited. A lot of the formatting as is kept intact, but you lose almost all the formulas. For example, notice the months in the header are no longer angled 45 degrees upward. If you click on the Formula button while keeping your cursor in any cell, the formula that cell contains should appear. The January subtotal for Necessities claims to have the formula =SUM(ABOVE) , meaning this cell is the sum of every cell with numbers above it. However, this isn’t true - editing the cells above won’t update the numbers. You can re-enter this formula, and it will insert the new sum, but it will treat the rest of the text inside this cell as just text, squeezing the new sum in with it.
The conclusion? Copying tables directly from Excel can be a quick way to get a visual table into Word. However, it is not useful if you need to update the data since it doesn’t retain formulas. Charts, however, are fine to copy and paste into Word, as they are still editable in Excel with their full functionality.
How to Create an Excel Spreadsheet and Chart Directly in Word
Step 1: Create and Save a Word Document Create a Word document in the same way as above, and remember to save it. Step 2: Insert New Excel Elements
This time, open the Insert tab and go to Insert Object , then click either Microsoft Excel Chart to insert a chart, or Microsoft Excel Worksheet to insert a full worksheet. Click OK . Either option will open Excel.
The Microsoft Excel Worksheet will open a blank Excel sheet. You can enter whatever information you want into it, following the same process as you used in the Excel tutorial above. Anything you change in Excel will immediately change in Word, as well, whether it’s spacing of cells, color and border formatting, or the formulas within them. You cannot change anything about the data in Word, and will again have to double-click the object to open Excel to make edits. If you find you have extraneous cells, you can also double-click to open Excel, select the data you want, then right-click and select Copy . When you go back to Word, right-click and select Paste Special in the Edit menu, then click Microsoft Excel Worksheet Object . Delete the original object.
Charts will work as described in the previous section on copying Excel charts. Adding a chart will open an Excel file that has one sheet with the chart, and one with the data. Once you save the chart in your Word document, the data will stay in Excel with only one sheet, and the chart will appear in the Word document. You can change the data in Excel at any time by double-clicking the chart, and changing the styling of the chart in Word.
The other way to insert a chart into Word is to click the Insert tab, then click Chart , and select the type of chart and design you want. Then, you will be taken to Excel to enter your data from scratch, which will update your chart in Word. Step 3: Change Alignment and Text Wrapping
Now you’re going to learn how to adjust these elements in Word to make a working document. First, shrink the size of the chart by clicking the corner of the object and moving it inward. This action creates a more manageable size.
You’ll notice that it’s not very easy to move the chart around the document. Word automatically tries to force alignment on objects so that they don’t slide out of place and confuse users. To move your chart or table more freely, single-click on your table or chart, and click the Layout tab on the Ribbon . Select Wrap Text , and click Tight to drag-and-drop the object anywhere on the page.
When you type words around the inserted chart, they won’t overlap or go behind the object, but instead neatly arrange around it (regardless of where you place it on the page).
How to Create a Pure Word Spreadsheet Table for Simple Scheduling
The final way to create spreadsheets in Word is to create a table from scratch. These tables are generally only capable of simple functions, so we’ll create a weekly schedule. Step 1: Create and Save Your Word Document Do this the same way as listed above. Step 2: Insert a Table
Click the Insert tab, and click Insert Table to see a grid. You can hover over the small squares to create a table of any height and width. Since we’re making a weekly schedule, we’ll do seven columns, and since we’ll have a header with three entries, four rows. Step 3: Create Headers
Now we have a blank table with a set amount of cells. The cursor appears in the first cell of top row. Start typing to create column headers. Don’t bother applying any styling yet. Also note that Word tables don’t have any of the Excel features that autofill data like days of the week, so you have to type each day manually. Step 4: Enter the Data
Enter your data for each day, consisting of your necessary tasks and the hours they require. For simplicity’s sake, our table will only include a few values. Sometimes text might be longer than a cell, causing it to split into two lines. Change the width of the cells with longer content by grabbing the left or right edge of a cell, and dragging it as you see fit. Step 5: Apply Styles
To make the schedule visually appealing, apply quick styling presets to it. Click the Home tab. Select your entire table, then choose a preset you like from the Ribbon . Since you have a heading row, make sure to choose a style that makes it visually distinct.
Now you have a simple, nicely-designed table you can use for day to day scheduling. To extend it and add more items to your to-do list, click a row and then right-click on your mouse and choose Insert: Rows Below . See a complete list of keyboard shortcuts in Microsoft Word.
How to Make a Spreadsheet in Google Sheets
This section will cover all the basics for working with Google Sheets. Google Sheets is a spreadsheet app that lives in the cloud, meaning you never have to download anything, and you can update Sheets from any computer or smartphone. Most notably, it’s free - anyone with a Google/Gmail account can access all of its features.
Unique Features of Google Sheets
Google Sheets is not quite as robust as Excel in terms of functionality. It has fewer formula functions, a less accessible toolset, and you can’t set up any automation macros. What Google Sheets does have, however, is quite good for basic users: real-time collaboration abilities. This means that you can share a Sheet with other Google users, collaborate with them on the same spreadsheet, and see each other’s changes and comments instantly. Google Sheet’s other unique feature is Explore, which lets you pull up instant insights about data, and also auto-generates charts, tables, and graphs to insert into a document. Sheets integrates with all other Google products, allowing you to insert Google Forms data automatically. Sheets you create will be saved to your Google Drive account, and you can quickly insert any images you have in Google Photos.
A. This takes you back to the Google Sheets hub page, which contains your most recent Google Sheets and a number of templates.
B. Use this area to name your Sheet. Click Untitled Spreadsheet and type a title for your sheet. Clicking the star lets you “favorite” this sheet so it’s easier to find. Clicking on the folder icon shows you where this file is located in your Google Drive, and allows you to move it.
C. All the icons along this grey section are your main toolbar. They include simple formatting options, alignment options, commenting, filtering, and some function tools. Below these tools is the Formula Bar , which works just like the Excel Formula Bar. You can enter and view different formulas for cells here.
D. The Comments button opens all comments and allows you to leave comments on the current cell or range of selected cells. It also lets you choose notifications settings: get notified every time you make a change made, every time any user makes a change, or never.
E. The Share button is essential to Google Sheet’s value proposition. When you click it, you can enter in the email addresses of everyone you want to receive the Sheet. Start typing the name of someone in your Google Contacts, and Sheets will recognize and autofill it. You can also choose the permission level of people you’re sharing with: either let them view it, let them view and comment, or let them view, comment on, and edit it. You can also lock down more permissions in Advanced Settings .
F. This is your workspace. It functions very similarly to Excel, with columns A-Z and beyond, and rows 1-any number you like. Each cross-section is a cell with a unique address, like A1 highlighted here. This is important for formulas.
G. Use these tabs to access the multiple sheets in one Google Sheets document. The tabs function exactly like Excel’s sheets, but you can color them to easily differentiate.
H. Hovering over this icon surfaces Explore . Clicking on this brings up a righthand pane that generates unique information about any selected group of cells, charts, or tables.
Navigating the Tools in Sheets
Unlike Microsoft products, Google doesn’t have a variable Ribbon of tools, just a series of drop-down menus with similar functions. This section will cover where to find all the spreadsheet tools in Google Sheets.
A. These are some basic functions, including the print tool, undo and redo, and the format paintbrush. Use these tools to take the color/style/attributes/formats of a selected cell and apply them to any other cells you highlight immediately afterwards.
B. Use these text formatting tools to turn number entries into percentages, or standard dollar formats like “$1.00.” Use the quick buttons in this area to add or remove a decimal place.
Click the drop down to see more currency, date and time formats, and other options hidden in another menu.
C. This is a standard font selector. Choose any built-in fonts to format the text in any cell.
D. A standard point-size selector for any characters you’re typing into a cell.
E. These are mostly standard style formatting tools for text, like bold, italics, and text color.
The text color selector is also where you’ll find the “conditional formatting” tools. These tools allow you to choose a range of cells and create if/then conditions to change their formatting (color, font, size, background color, cross-out, and more). You can add numerous rules to a single selection of cells so their format will reflect your chosen status at a glance.
F. This is where cell style formatting options live. You can also access conditional formatting tools in the paint bucket drop-down menu. Use these tools to either select or draw your cell borders, including thickness and style (dotted line, straight line, etc.). The last button here controls merge, and works just like it does in Excel and Word tables.
G. These are alignment tools. You can choose left, right, and center align, as well as top, bottom, and floating alignment in the cell. The third icon is Text Wrap , allowing text to either overflow into the next cell, wrap downwards and increase the height of your cell, or “clip” the text when it starts overflowing. (The text is still there, it’s just hidden.) The final button in this area lets you angle your text differently, like in Excel.
H. These are tools that work for higher-order purposes. The first lets you make a cell or range of cells link to a website or file. The second is your comment options - just highlight a range of cells and click it to comment. Others can reply to your comments, too.
Next is Insert Chart , which brings up a fairly robust popup window with numerous data visualization options. There are more types than found in Excel, but there are fewer styles of each. In addition to line, bar, and pie charts, there are maps that light up based on location data you include, org charts for companies, radar graphs, and Venn diagrams, to name a few.
The next icon is for sorting and filtering, which lets you insert filter menus on top of each column that you can update and change in real time.
The final icon is your primary formula drop-down menu. It only shows a few functions by default - SUM, AVERAGE, COUNT, MIN, MAX. The rest of the functions are hidden in More Functions, which brings up a new page that just has a list of functions. The Formula Bar also has an autocomplete feature: start typing “=” and a couple letters to reveal a list of functions with those letters for you to select and insert into the formula.
All the other tools are hidden in drop-down menus, which are covered below. File and Edit contain basic functions for downloading, sharing, undoing, and redoing. The Edit menu also has Find and Replace , which lets you scan the document for any cells containing your search criteria. View Menu:
- Freeze: This submenu contains everything you need to freeze panes. You can freeze any number of columns and rows you like, so that necessary information stays put while you scroll around the screen. For example, if your first row has heading names for all the columns, you can see those headings no matter how far you scroll.
- Gridlines: This controls whether or not you see the grids on your worksheet. It might be necessary to remove them when printing, for example.
- Show Formulas: When you enter a formula into a cell, it will display however that formula resolves as a value. For example, if A1=1 and B1=2, and you made C1 have the formula “=A1+B1”, then it would show the value of 3. However, what the cell actually contains is its formula. Show Formulas displays the formula for all cells, rather than their value.
The first few parts of the menu let you insert columns, rows, and cells where you like, or add another sheet to the workbook. You can also add comments, charts, and functions.
- Note: Use notes to explain data and guide users, rather than as comments to be responded to. You can add a note to any cell or range of cells can be given a note.
- Image: Import an image into your Google Sheet from Google Photos, Google Drive, a website, or your computer.
- Form: Insert a Google Form into your sheet. This allows data collected from the form to appear as new rows in the sheet.
- Drawing: Google Drawings is a tool that lets you drag and drop shapes and colors to create simple infographics and diagrams. You can bring them into a sheet straight from that app.
The Format menu consists of redundant tools that are also on the toolbar, but has two additional tools:
- Alternating Colors: A sidebar appears on the right side of the sheet that lets you build tables with alternating colors like in Excel. There are presets, some with a header color that is distinct from the rest, and it also allows you to build custom versions. Simply select your cells and apply it to them.
- Clear Formatting: Highlight cells and press this button to remove all formatting, leaving the cells bare with just their contents and/or values displayed.
- Sorting: The sorting options are redundant with the sorting tools on the main toolbar. These add ranges that you can sort within.
- Protected Sheets and Ranges: This lets you choose certain cells or sheets that you want to prevent people from editing.
- PivotTable: These PivotTables work like they do in Excel: select a group of data with at least two columns, and create reports. The report editor appears on the side, letting you choose what data you want grouped in rows, columns, and what values and filters to use.
- Data Validation: For more complex sheets, this feature can find errors and missing data for you to correct.
- Create a Form: This launches a Google Form creation window, automatically tied to your Google Sheet. When you embed this into websites or send through an email, all response data will feed into your sheet.
- Script Editor: This allows you to write custom functions and scripts to automate and extend the abilities of Google Sheets. This feature is for advanced users only.
- Enable Autocomplete: A useful setting that allows Google Sheets to use what it learns to fill-in information. It’s recommended to keep this on.
- Protect Sheet: This lets you password protect parts or all of your sheet so that only the right people you’ve shared it with can access it.
- Personal Dictionary: This is every word your Google Account has been told is a correctly-spelled word that doesn’t exist in its main dictionary.
Form Menu: This menu just has some redundant features about Google Forms. Add-Ons: This menu has links to Google Sheets add-on marketplace. These are mostly unofficial extensions that different developers have created to make Google Sheets more useful. They don’t always work properly, and aren’t recommended for elementary users.
How to Create a Product Sales Tracker in Google Sheets
Now that you know about all the tools in Google Sheets, practice making your own spreadsheet from scratch. This guide will cover basics and some of the app’s unique features to quickly produce a great spreadsheet. For this example, we’ll build a more complex spreadsheet than we did in the previous two examples. Step 1: Create a New Google Sheet
Start by opening Google Sheets. You can search for an existing sheet or open it within your Google or Gmail account, near your icon in the top right corner. The Grid Icon should list the Sheets app. Once you arrive on the main Google Sheets hub page, you’ll be able to see and search for any other spreadsheets you’ve created, and choose templates. Let’s start from scratch and click Blank. Step 2: Plan Your Data As with the Excel spreadsheet, you must plan out what data and analysis you need in order to correctly structure your spreadsheet. In this case, we’re making a spreadsheet that can track worldwide sales of different products with different prices and profitability. Since you have multiple products, you’ll need a reference table of pricing, cost, and profit. Then you’ll need a table where you can record every sale, including how many of each product the sale included, and the total profit from those sales. You also need to include calculations that remove different countries’ tax rates from your cost-based profit margin. To help plan out things like this for your own situation, consider analytical goals. In this case, what information would a company selling products worldwide want to gain from a spreadsheet?
- Which product sold the most units?
- Which country netted the greatest profit?
- Which country had the greatest quantity of items sold?
- What was the total profit from sales worldwide?
Step 3: Create a Reference Table
A. Start by naming your spreadsheet. It’s best to be descriptive and unique, so you can easily search for it later with Google Drive’s search tool.
B. Create names for each column of the reference table. We’ll use Product, Price/Unit, Cost/Unit , and Profit/Unit .
C. The products will be A, B, and C. Add those letters to the cells A2, A3, and AC, respectively. They have variable prices, but all cost the same to produce, so each will have a different profit margin. To create this, click cell D2. Enter “=B2-C2” in the formula bar to calculate the profit of each unit. Then click the bottom right corner of the cell and drag it down to D4 to duplicate the formula for rows 3 and 4. Now you have the profit margin calculation for each product.
D. Finally, to keep it easy to view, apply some styling to the table. Just highlight the whole range of cells, then click the Format menu. From the drop-down, select Alternating Colors , which opens the sidebar menu where you can apply table styles. Select a preset that makes the header distinct. Click the X in the top right corner of the Alternating Colors sidebar to close it.
E. Enter amounts for Price/Unit and Cost/Unit.
Step 4: Create a Sales Tracker Layout
Let’s start laying out the sales tracker table. A company will likely track orders by the order in which they arrive, so click cell A7 and type “Sales ID.” Add order numbers to cells A8 through A17 under the Sales ID header. It’s also important to know how many of each product were sold, so make the next three columns product quantities for A, B, and C. To do this, type “Quantity of A” in cell 7B, “Quantity of B” in cell 7C, “Quantity of C” in cell 7D. Obviously, the company wants to know the profit from this individual sale, so type “Profit from Sale” in cell 7E.
The country of the buyer is also important for our analysis because for a real company that would affect the cost of doing business in the form of taxes, which would also reduce the final profit. You’ll need dedicated columns to track this information, so type “Customer country” in cell 7F, “Income Tax” in cell 7G, and “Final Profit” in cell 7H.
Also note that after entering our column headers, column F wasn’t wide enough for Customer Country , so click on the right vertical line of cell F7 and drag the border to increase that column’s width. Step 5: Create a Profit Formula
This is one of the more complicated formulas in this article. To calculate the base profit from each sale, we have to multiply each product quantity by that product’s profit margin per unit, and add them all together. Click cell 7E and insert this initial formula: “=(B8*D2)+(C8*D3)+(D8*D4).” We include the parenthesis to maintain the order of operation in the formula. However, there’s a problem. If you drag that formula down to duplicate it for each sale, it will change the relative location of both the reference cell and its multiplier. For example, dragging it down one cell would result in the formula “=(B9*D3)+(C9*D4)+(D9*D5),” which would mean we’re not taking the same profit margin cells and multiplying them by new quantity levels. To fix this problem, you add “$” to the front of each part of the cell coordinate you want to remain constant. The final result will look like this: “=(B8*$D$2)+(C8*$D$3)+(D8*$D$4).” Now, when you drag the lower right corner of the cell down through all 10 orders, they will all reference the correct profit margin cells in the reference table. Don’t forget to highlight E8 through E18 and click the $ button on the toolbar. This will place everything into “$0.00” form. Step 6: Calculate a Final Profit and Column Totals
The Final Profit column needs to reflect profit after the customer’s country’s trade taxes. For starters, type “=E8*(1-G8)”. The reason for this is that the Income Tax column will be represented as percentages, where 1 = 100%. Therefore, to subtract the tax rate from the profit, the profit needs to be multiplied by the percentage left over, not the percentage taken out.
Format the Income Tax column by highlighting the cells and clicking the % button on the toolbar. Add the currency format to the Final Profit column by highlighting it’s cells and clicking the $ format button. Now, use the basic AutoSum formula to place totals counts for each of the quantity columns, for the Profit from Sale column, and the Final Profit column. Highlight B8 through B17, then click the Formula button on the toolbar, and click SUM . The total sum will appear in B18. Now drag this cell’s formula to C18 and D18, then copy and paste it into H18. Step 7: Add Styling
Add styling to your table to help make it more readable. Click and highlight all the cells in the table (excluding the totals). Then click the Format menu and click Alternating Colors in the drop-down menu. Then click a Formatting Style from the sidebar to apply a style to your table. Click the blue Done button. Next, click and highlight the cells containing totals totals, and click the Fill Color icon on the toolbar and choose a color. Quantity totals might have the same color as the product reference table above. Totals relating to money might be green. Adding color elements to help with quick visual reference is a plus. Step 8: Enter Data
Now enter data for all your table’s quantities sold for every product in every sale, and the buyer’s country. Feel free to use the data in the screenshot above. You’ll notice all the calculations are done automatically. Step 9: Sort by Country
Let’s learn about sorting. To create a table for map data, we have to have totals by country. It’ll be easier to gather this data if we sort it by that criteria. You want to be sure when sorting that you don’t cause any rows to become disassembled - data has to remain together to be useful. Select A7 through H17 (this is the entire table except the totals). Now open the Data menu, click Sort range , and then tick the Data has header row box. (It won’t rearrange the headers, just everything underneath them.) Then choose the column Customer Country from the sort by menu, going from A to Z. Now your data is arranged by country.
Now use the same steps described above to create a table with just the Customer Country and the Final Profit as headers. Each country only gets one cell, and the Final Profit is the added profit from that country using the formula “=SUM(start cell : end cell).” For the USA, click on cell K12 and type the formula “=SUM(H15:H217).” You’ll need to add each formula manually. You can add styling to it too, if you like. Step 10: Analyze Data with Explore Now that you have your data represented to answer all your questions, it’s time to start analyzing them. It’s important to remember that on a real sales sheet, you would likely have 100s of 1000s of sales, not 10, so computer-assisted analysis would be truly beneficial.
Click the Explore icon in the bottom right corner of your screen to open the Explore sidebar. As you can see from the gif, there are countless ways to analyze the data by selecting one table or another, and exploring the auto-created charts and graphs available. You can also highlight all the cells in a table and click Chart. Now you have a working sales tracker with helpful data analysis ready to go. Here’s a complete list of keyboard shortcuts in Google Sheets.
How to Make a Spreadsheet in Smartsheet: Step-by-Step Guide
This section will cover all the basics you need to know about working with Smartsheet, a spreadsheet-inspired work and process automation platform that you can use to create powerful, collaborative spreadsheets. It’s a cloud-based application, so you never have to download anything, and it can be updated from any computer or smartphone and stays synced across devices. It is available on any platform with a web browser and you can share spreadsheets with anyone.
Unique Features of Smartsheet
Smartsheet has many, though not all, of the functions that Excel has in a real-time collaborative environment. What makes Smartsheet unique is that spreadsheets, known as Grid View , are only the underlying basis for the app’s capabilities. With Smartsheet you can assign unique properties to each column that affect its behavior in different view-types. For example, if you have a Date column, you can view your data in Calendar View , where each row becomes an item on a calendar. If you give each row a Start Date and End Date column, you can use Gantt View to see where timelines overlap from item to item. If you give your rows a Dropdown List column, you can use Card View to see items as cards that you can drag and drop from one section to another, to denote category or status.
One other major unique feature of Smartsheet is that not everyone needs to purchase the app in order to access it. One paid user can invite internal and external collaborators to a sheet, who can all collaborate on the sheet in real time.
How to Create a Project Tracker Spreadsheet in Smartsheet
You can practice making your own project tracker spreadsheet from scratch in Smartsheet. This guide will cover basics and many of the app’s unique features to quickly produce a powerful, collaborative spreadsheet.
Step 1: Create a New Sheet and Name It
On the homepage of Smartsheet, Click Create and choose Grid to get started.
In the popup window, name your sheet “New Project Sheet.”
Step 2: Name Your Primary Column and Enter Data
Start by changing the name of your Primary Column to “Task Name.” Click the cell with the words Primary Column to rename it in the pop-up window that appears on the screen. Click the blue OK button.
Enter a couple tasks in the column related to whatever you like.
Step 3: Create a Contact List Column
Now change the name of Column2 to “Assigned To.” Click the cell with the words Column2 to rename it in the pop-up window that appears on the screen. Then, click the column property Contact List . Click OK .
Now you can start typing here in each row of this column, and Smartsheet will autofill names from your contacts to assign tasks to them.
Step 4: Create Start and End Date Columns
Click on the Column3 and Column4 cell to rename them “Start” and “Due,” respectively. Change both their column properties to Date. This will allow you to use both Calendar View and Gantt View , which are useful views when managing large spreadsheets or project data.
Step 5: Create a Drop Down List Column
Change the name of Column5 to “Stage,” and give it the Dropdown List property. Dropdown List lets you choose a few different options for collaborators to select. It also allows you to use Card View to organize information from grid view by task status (or another criteria of your choosing). You can select either Single Select or Multi-Select options, meaning users can either select only one option, or multiple options, respectively.
For this sheet, select Single Select , and make your status options “Not Started,” “In Progress,” “In Review,” and “Complete.”
Step 6: Create a Symbols Column
Change the name of Column6 to “Status,” and give it the Symbols column property. This is like a dropdown list, but uses different symbols to represent information about your row, at a glance. In this case, use the RYG balls, which are colored either Red, Yellow, or Green. Red means “late,” yellow means “almost late,” and green means “on time.”
Step 7: Look at Gantt View
Now you have a working project management sheet that’s easy to collaborate on and view multiple ways. Once you enter dates for each task in the Start and Due columns, select Gantt View from the top navigation bar, and to see how your tasks overlap based on start and end dates.
Step 8: Look at Card View
With Card View , you can view all of your task rows by Stage , because Stage is a criteria in your Dropdown List. This is a quick visual way to see how many tasks are outstanding, and where work is getting stuck. When you change from Not Started to In Progress , you can just click the card, and drag it over to the next column. When you go back to Grid View , the status change will be reflected there, too.
Step 9: Look at Calendar View
When you go to Calendar View with multiple date columns, it asks how you want to handle them. Click Display Date Ranges Using and set Start as the start date, and Due as the end date. Now you can view the stretch of time you’re supposed to work on each task.
Just like that, you have a basic, flexible project management sheet ready to go. There’s a lot more you can do with Smartsheet, including adding traditional formulas, but this example demonstrates many of its unique features.
Spreadsheet Use Cases and Templates
Now you know how to build a spreadsheet from scratch in Excel, Word, Google Sheets, and Smartsheet. However, all of these programs also have pre-built, use case-specific templates that will save you time. Here are a few popular templates for each of these programs, so you can start organizing and calculating anything you want. Budget Templates
- Monthly Budget for Google Sheets
- Expense Report for Google Sheets
- Balance Sheet for Smartsheet
- Calendar Template in Google Sheets
- Weekly Schedule in Microsoft Excel
- To Do List in Microsoft Excel
Work and Employee Management Templates
- Employee Timesheet in Microsoft Excel
- Work Schedule Template in Smartsheet
- Project Management Template in Smartsheet
These are just a sampling of the many personal, industry-specific, or project-specific templates that these programs have to offer.
Create a More Powerful, Collaborative Spreadsheet in Smartsheet
Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change.
The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed.
When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time. Try Smartsheet for free, today.
Discover why over 90% of Fortune 100 companies trust Smartsheet to get work done.
Homework To Do List
A spreadsheet can be a useful tool for tracking your homework assignments, due dates, and completion status. The homework list template on this page was designed based on my original To Do List Template for Excel. I simplified it a bit for and modified it specifically for tracking homework assignments. You can download the Excel file or the blank printable PDF version if all you need is a blank form to use for your student planner.
Homework To Do List Template
License : Private Use (not for distribution or resale)
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Drop-Down Lists for Status and Priority - The Status column lets you choose from "Not Started", "Incomplete", "In Progress", and "Complete." The Priority columns lets you choose between "High", "Medium", or "Low." If you want to edit the items in the drop-down lists, just select the cells you want to edit and go to Data > Data Validation and edit the comma-delimited lists.
Conditional Formatting for Priority and Due Date - I've set up the Priority column to show "High" as a bold red font and "Low" as a blue font. The Due Date uses icon sets to show when the date is past due. If you need or want to edit these rules, go to Home > Conditional Formatting > Manage Rules and select "This Worksheet" from the drop-down to see all the rules for the worksheet.
A Worksheet for Each Class - You can duplicate the main worksheet tab to create a homework list for each of your classes. Just right-click on the worksheet tab and select "Move or Copy" and check the "Create a copy" box. Then you can rename the tabs "ENG 101", "MATH 101" etc.
Completed Assignments - When you select "Complete" from the Status column, the font in that row will change to a gray strikethrough . You can edit the conditional format rule to change that if you want.
Printable Homework List
- Create a Drop Down List in Excel at vertex42.com - Explains how you can create a drop-down list like the one used in the Priority column.
Follow Us On ...
Custom Business Email
Video and voice conferencing
An integrated suit of secure, cloud-native collaboration and productivity apps powered by Google AI.
Make data-driven decisions, in Google Sheets
Create and collaborate on online spreadsheets in real-time and from any device.
- For my personal use
- For work or my business
T h e s e n u m b e r s l o o k v e r y s t r o n g !
Collaborate on data, from anywhere
Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.
Get to insights faster with built-in intelligence
Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors. And get insights quickly by asking questions about your data in simple language.
Seamlessly connect to other Google apps
Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.
Extend collaboration and intelligence to Excel files
Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill.
Build custom solutions
Speed up workflows by building business apps and automations. Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items, and macros with Apps Script.
Always work with fresh data
With Sheets, everyone’s always working on the latest version of a spreadsheet. And with edits automatically saved in version history, it’s easy to undo changes or even see edit history of an individual spreadsheet cell.
Seamlessly connect to critical data
Pull in and analyze data from the other tools you use, like customer data from Salesforce. Enterprise customers can also use Connected Sheets to analyze billions of rows of BigQuery data in Sheets – without writing any code.
Security, compliance, and privacy
Secure by default
We use industry-leading security measures to keep your data safe, including advanced malware protections. Sheets is also cloud-native, eliminating the need for local files and minimizing risk to your devices.
Encryption in transit and at rest
All files uploaded to Google Drive or created in Sheets are encrypted in transit and at rest.
Compliance to support regulatory requirements
Our products, including Sheets, regularly undergo independent verification of their security, privacy, and compliance controls .
Private by design
Sheets adheres to the same robust privacy commitments and data protections as the rest of Google Cloud’s enterprise services .
You control your data.
We never use your sheets content for ad purposes., we never sell your personal information to third parties., find the plan that’s right for you, google sheets is a part of google workspace.
Every plan includes
Collaborate from anywhere, on any device
Access, create, and edit your spreadsheets wherever you are — from any mobile device, tablet, or computer — even when offline.
Get a head start with templates
Choose from a variety of dashboards, project trackers, and other professionally-designed templates to kick things off quickly..
Visit the Sheets Template Gallery for more.
Ready to get started?
- Skip to primary navigation
- Skip to content
- Skip to primary sidebar
- Skip to footer
Southern Charm | Modern Flair
Organized Chaos: College Assignment Tracker
January 26, 2016 · College
Every student needs this college assignment tracker!
College assignments are such a headache! That’s why I made a college assignment tracker. This semester, though it feels late in the game as I will graduate this year, I decided to start the semester off right. To do this I created an assignment and readings spreadsheet to track the due dates of all my assignments and what I should be reading each day for each class. I’m going to share how I designed my assignment and reading tracker.
I got the idea for a college assignment tracker from Kirsten at Organized Charm and Dani at Dani Dearest . I think it’s amazing, however I changed it a little to fit my style and to include a reading tracker. As an English Major I read about 200 or more pages a week. Let me show and explain how I made and am using my assignment tracker.
NOTE: Set aside about 2 or 3 hours your first weekend back to school to go through your syllabuses and to set up the assignment spreadsheet.
Trying to find the best way to manage your readings and assignments for college? Learn how to make a college assignment tracker now! Click To Tweet
STEP ONE: Gather Your Syllabuses and Highlighters
The first step in making an assignment or reading tracker is to gather all of your class schedules and syllabuses. Go through each one, highlighting all big assignments like papers or tests. Once you’ve highlighted the important due dates and assignments then you’ve done one of the hardest parts.
STEP TWO: Create and Format your Spreadsheet
Create an Excel spreadsheet. Mine has four columns: Due Date, Class, Assignment and Points. This setup works best for me. I went through each syllabus and added the assignments. Once you made your spreadsheet begin to add your assignments. As I mentioned, I have a separate sheet for Assignments and another for Readings. With so many readings and assignments it felt to overwhelming the other way.
STEP THREE: Organize your Spreadsheet
I recommend adding your assignments or readings by date and then if you have another assignment on the same date or a previous date just click the insert row button. For me this was the easiest way to do it, though Kirsten and Dani both suggest the AZ Sort function. I organize my sheet by month, but you might find it easier to organize by class or even week. For my reading list I added an extra row between each week just so it felt more manageable.
STEP FOUR: Print & Staple
Once you’ve filled in your assignments check the print preview and make sure it all fits width wise on one sheet. You may have to play with font types or sized and the size of the columns until you get it just right. On my Readings sheet I deleted the Completed column because the readings are so long. In the end this worked out better as it is very easy to just highlight completed readings and the page doesn’t look super overwhelming.
You can also use it only on your computer or tablet. Microsoft makes an Excel for the iPad that I find easy to use and there is Google Sheets. These are both great options if you don’t want to print and keep track of your sheets as a hard copy or if you may have to add or change your sheets often.
Here are a few final tips:
- Make the time to setup your college assignment tracker. Sure, it is tedious, but 2 or 3 hours at the beginning of the semester is worth it when you think of all the studying, reading and assignments you have to do over the semester. Being prepared now will help you considerably later in the semester.
- Actually use your assignment tracker! This is a big point for me, because why go through the trouble of making a tracker if you don’t plan to keep up with it. I can tell you honestly that in the three weeks I’ve been in school this semester I have seen a major improvement in my stress level about assignments and readings.
- Don’t go crazy with highlighting or color coding. I considered coloring coding my spreadsheet, but decided it against it because with five classes and five colors the sheets would just become overwhelming and pointless in relieving stress about my assignments. Instead just make sure to mark what course each reading or assignment is for and then use a highlighter when completed or use the strikethrough option if you’re keeping a virtual copy.
- Adjust the format to fit your classes and style. There are many ways to set one of these up, just find what works for you. The only thing that matters is that you stick with it. This can’t work unless you make sure to use it. I’ve seeing a great improvement in my stress, time management and grades since creating and using my sheets.
- Only put the most necessary information on your tracker. Page numbers and due dates are important. School holidays like Spring or Fall break are important or if you’re on a quarter instead of semester schedule, those dates are important. Sorority, work, club or other types of events? Those are probably best left for your day planner.
Are you going to make a college assignment tracker? Share you experience with me!
- Click to share on Facebook (Opens in new window)
- Click to share on Twitter (Opens in new window)
- Click to share on Pinterest (Opens in new window)
- Click to share on Pocket (Opens in new window)
- How To Take Notes That Will Help You Pass
- Using OneNote: An Introduction for College Students
- Organized Chaos: Color Coding My Day Planner
- Back To School Tips From A College Senior
Twenty-six year old living in the Charleston, SC, also known as the Holy City.
I graduated from the College of Charleston in 2017 with a bachelor’s degree in English and I recently completed my master’s degree in Mass Communication specializing in Social Media at the University of Florida.
I spend my days on social media and handling the marketing for a local business. I’m also working to grow my own business offering social media and digital organization services.
Connect With Me
- PRO Courses Guides New Tech Help Pro Expert Videos About wikiHow Pro Upgrade Sign In
- EDIT Edit this Article
- EXPLORE Tech Help Pro About Us Random Article Quizzes Request a New Article Community Dashboard This Or That Game Popular Categories Arts and Entertainment Artwork Books Movies Computers and Electronics Computers Phone Skills Technology Hacks Health Men's Health Mental Health Women's Health Relationships Dating Love Relationship Issues Hobbies and Crafts Crafts Drawing Games Education & Communication Communication Skills Personal Development Studying Personal Care and Style Fashion Hair Care Personal Hygiene Youth Personal Care School Stuff Dating All Categories Arts and Entertainment Finance and Business Home and Garden Relationship Quizzes Cars & Other Vehicles Food and Entertaining Personal Care and Style Sports and Fitness Computers and Electronics Health Pets and Animals Travel Education & Communication Hobbies and Crafts Philosophy and Religion Work World Family Life Holidays and Traditions Relationships Youth
- Browse Articles
- Learn Something New
- Quizzes Hot
- This Or That Game New
- Train Your Brain
- Explore More
- Support wikiHow
- About wikiHow
- Log in / Sign up
- Computers and Electronics
- Microsoft Excel
Create a Gradebook on Microsoft Excel: Make a Weighted Points Grade Sheet
A simple way to record your students’ grades
Last Updated: September 27, 2023 Fact Checked
Create a New Workbook
Create the layout, calculate grades with formulas, assign letter grades, weight assignments, expert q&a, things you'll need.
This article was co-authored by wikiHow staff writer, Kyle Smith . Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo. This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources. This article has been viewed 216,934 times. Learn more...
Microsoft Excel is a great program for creating simple grade books! Using a spreadsheet (and a couple formulas) will reduce the time it takes to record and calculate grades. You don’t need to be familiar with Excel to follow our quickstart guide. This wikiHow article will walkthrough how to create a point-based grade book on Microsoft Excel.
Things You Should Know
- Create columns for student names, assignment grades, total points, possible points, numeric grade, and letter grade.
- Use the SUM function to add each student’s assignment points, then use the “/” division operator to divide their total earned points by the total possible points.
- Weight assignments by assigning more or less points.
- Alternatively, there are free templates for grade books online! Click More templates on the home page to search for “grade book” templates. You may see different templates depending on what version of Excel you’re using.
- The web app version of Excel has two grade book templates, one for points-based grading and another for percentage-based grading.
- For more general spreadsheet info, check out our guide on making a spreadsheet in Excel .
- Double click "Sheet1" at the bottom window. "Sheet1" should be highlighted.
- Type a name for the sheet. For example, “Section 1.”
- Press Enter .
- Click cell A1 to select it.
- Type the instructor’s name and press Enter . This will move your selection to A2.
- Type the class name in A3. For example, “World Geography.”
- Type the section number and meeting time in A4.
- Enter the term in A5. For example, “Fall 2022”
- This guide will cover one way to arrange your grade book. However, there are infinite ways to format an Excel spreadsheet . Try different templates and formats to find what works best for you!
- Select A7 and type “Student Number.” Row 7 will contain the column headers for each type of information you have in your grade book.
- Select A8 and type the number 1. Press Enter to enter the number in the cell and move down one.
- Type the number 2 in A9.
- Click and drag the cursor from A8 to A9. Both cells should be highlighted with a box around them.
- Hover your cursor over the lower right corner of the box until the cursor becomes a plus + (this is called the fill handle).
- Click and drag until you have a list of numbers for each student in your section.
- Select B7 and type the column header “First Name.”
- Select C7 and type the column header “Last Name.”
- Type in the students’ first and last names in columns B and C.
- You’ll insert the students’ assignment grades under each column.
- Note: For this guide, we’ll use a point-based grading structure, meaning each assignment is worth a certain amount of points.
- Note: Make sure to check your spreadsheet calculations by doing a few calculations by hand. This is a great way to catch any errors in your spreadsheet.
- Read more about the SUM function in our complete guide.
- Alternatively, you can type in the range instead.
- For example, if you have 5 assignments in columns D through H and the student names start on row 8, you’ll enter D8:H8
- Select the cell with the total summation formula. Click and drag the fill handle (the square in the bottom-right of the selection) down to the last student to automatically apply the sum formula to each row.
- Using our earlier five-assignment example, let’s say there are 10 students. The second student summation should now have a range of D9:H9, the third student D10:H10, down to the last student with D17:H17.
- Enter the possible points in each cell below the header.
- For example, if each assignment is out of 10 points, and there are five assignments, the possible points will be 50.
- The “/” symbol will divide the total cell by the possible points cell, giving you the student’s grade as a value under 1.
- For example, if a student earned 45 total points out of 50 possible points, their grade will be 0.90 (90 percent).
- You can change the grades to percentages by selecting the grade values and changing the data type to “percentage.” Find this by navigating to Fields tab > Properties group > Data Type .
- Compare the student’s grade to your grading structure.
- Insert the letter associated with that student’s grade.
- For example, if an “A” is 89 to 100 percent and a student scores a grade of 93, place an “A” in the “letter” column.
- For example, a 20-point assignments has double the weighting of a 10-point assignment.
- To weight entire categories, make their points add to the percentage of the total grade you want the category to represent.
- For example, if your course has 100 total points and you want five quizzes to represent 20 percent of the total grade, each quiz should be worth 4 points.
- Always give your grade-book a title, by clicking on the "file" tab, choose "Save As", in the Save As window, choose a location and type a name for your document. Press "Save" when ready to save. Thanks Helpful 0 Not Helpful 0
- Refer to Excel's extensive "Help" menu when in need. It offers tools on creating statistics of data. Thanks Helpful 0 Not Helpful 0
- To find out what operating system your PC has, press "Start", right click on "Computer", scroll down and click on "Properties", a system dialog box will appear with basic information about your computer. Thanks Helpful 0 Not Helpful 0
- Be sure to confirm that the equations you created for your grade book are calculating correctly. Thanks Helpful 4 Not Helpful 1
- Make sure you save your progress throughout to prevent losing information as you work. Thanks Helpful 2 Not Helpful 1
- Always save a backup of your grade book and maintain hard copies. Thanks Helpful 1 Not Helpful 2
- Computer with Windows 7, XP, or Vista
- Microsoft Office Excel 2010
You Might Also Like
About This Article
- Send fan mail to authors
Is this article up to date?
- Do Not Sell or Share My Info
- Not Selling Info
wikiHow Tech Help Pro:
Level up your tech skills and stay ahead of the curve
- Sign up — it's free
Student Schedule Template
Students can use this spreadsheet to track assignments and due dates along with related class information. Use views to see upcoming or overdue work, and automations to receive email reminders.
Basic tasks in Excel
Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.
Create a new workbook
Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets. You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.
Click File , and then click New .
Under New , click the Blank workbook .
Enter your data
Click an empty cell.
For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.
Type text or a number in the cell.
Press Enter or Tab to move to the next cell.
Apply cell borders
Select the cell or range of cells that you want to add a border to.
On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want.
For more information, see Apply or remove cell borders on a worksheet .
Apply cell shading
Select the cell or range of cells that you want to apply cell shading to.
For more information about how to apply formatting to a worksheet, see Format a worksheet .
Use AutoSum to add your data
When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.
Select the cell to the right or below the numbers you want to add.
Click the Home tab, and then click AutoSum in the Editing group.
AutoSum adds up the numbers and shows the result in the cell you selected.
For more information, see Use AutoSum to sum numbers
Create a simple formula
Adding numbers is just one of the things you can do, but Excel can do other math as well. Try some simple formulas to add, subtract, multiply, or divide your numbers.
Pick a cell, and then type an equal sign (=).
That tells Excel that this cell will contain a formula.
Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.
For example, enter =2+4 , =4-2 , =2*4 , or =4/2 .
This runs the calculation.
You can also press Ctrl+Enter if you want the cursor to stay on the active cell.
For more information, see Create a simple formula .
Apply a number format
To distinguish between different types of numbers, add a format, like currency, percentages, or dates.
Select the cells that have numbers you want to format.
Click the Home tab, and then click the arrow in the General box.
Pick a number format.
If you don’t see the number format you’re looking for, click More Number Formats . For more information, see Available number formats .
Put your data in a table
A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.
Select your data by clicking the first cell and dragging to the last cell in your data.
To use the keyboard, hold down Shift while you press the arrow keys to select your data.
Click Tables , move your cursor to the Table button to preview your data, and then click the Table button.
To filter the data, clear the Select All check box, and then select the data you want to show in your table.
To sort the data, click Sort A to Z or Sort Z to A .
For more information, see Create or delete an Excel table
Show totals for your numbers using Quick Analysis
The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Excel shows the calculation results right below or next to your numbers.
Select the cells that contain numbers you want to add or count.
Click Totals , move your cursor across the buttons to see the calculation results for your data, and then click the button to apply the totals.
Add meaning to your data using Quick Analysis
Conditional formatting or sparklines can highlight your most important data or show data trends. Use the Quick Analysis tool (available in Excel 2016 and Excel 2013 only) for a Live Preview to try it out.
Select the data you want to examine more closely.
Explore the options on the Formatting and Sparklines tabs to see how they affect your data.
For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.
When you like what you see, click that option.
Learn more about how to analyze trends in data using sparklines .
Show your data in a chart using Quick Analysis
The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) recommends the right chart for your data and gives you a visual presentation in just a few clicks.
Select the cells that contain the data you want to show in a chart.
Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want.
Note: Excel shows different charts in this gallery, depending on what’s recommended for your data.
Learn about other ways to create a chart .
Sort your data
To quickly sort your data
Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.
Select a single cell in the column on which you want to sort.
To sort by specific criteria
Select a single cell anywhere in the range that you want to sort.
On the Data tab, in the Sort & Filter group, choose Sort .
The Sort dialog box appears.
In the Sort by list, select the first column on which you want to sort.
In the Sort On list, select either Values , Cell Color , Font Color , or Cell Icon .
In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).
For more information about how to sort data, see Sort data in a range or table .
Filter your data
Select the data that you want to filter.
On the Data tab, in the Sort & Filter group, click Filter .
To select by values, in the list, clear the (Select All) check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results.
For more information about how to filter data, see Filter data in a range or table .
Save your work
Click the Save button on the Quick Access Toolbar , or press Ctrl+S.
If you’ve saved your work before, you’re done.
If this is the first time you've save this file:
Under Save As , pick where to save your workbook, and then browse to a folder.
In the File name box, enter a name for your workbook.
Click Save .
Print your work
Click File , and then click Print , or press Ctrl+P.
Preview the pages by clicking the Next Page and Previous Page arrows.
The preview window displays the pages in black and white or in color, depending on your printer settings.
If you don’t like how your pages will be printed, you can change page margins or add page breaks .
Click Print .
Activate and use an add-in
On the File tab, choose Options , and then choose the Add-Ins category.
Near the bottom of the Excel Options dialog box, make sure that Excel Add-ins is selected in the Manage box, and then click Go .
In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK .
If Excel displays a message that states it can't run this add-in and prompts you to install it, click Yes to install the add-ins.
For more information about how to use add-ins, see Add or remove add-ins .
Find and apply a template
Excel allows you to apply built-in templates, to apply your own custom templates, and to search from a variety of templates on Office.com. Office.com provides a wide selection of popular Excel templates, including budgets.
For more information about how to find and apply templates, see Download free, pre-built templates .
Need more help?
Want more options.
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Microsoft 365 subscription benefits
Microsoft 365 training
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Ask the Microsoft Community
Microsoft Tech Community
Microsoft 365 Insiders
Was this information helpful?
Thank you for your feedback.
This Assignment Planner is here to take the worry of forgetting a due date or a cancelled class off your plate and to help you stay organized in regards to every detail of the school year. Whether you’re a student or a busy parent, take control of the school year by staying on top of classes, days off, project due dates and other important events. This planner was set up to be user friendly, interactive and most importantly quick and easy to use so that you can spend more time on matters that are more precious and valuable to you.
How to use the Assignment Planner
Begin your journey of organization by simply downloading the Assignment Planner and saving it to your computer. Once you are inside this tool, change the Year in cell N2 to the current year, this will automatically update the entire workbook. Find the first month you wish to fill out with the schedule.
For a quick and easy visual reference use the Weekly Schedule calendar to input the name and time of each weekly class. Use the Assignments section on the right to keep a detailed log of all assigned homework dues dates, test days or cancelled classes. Simply pick the corresponding day of the week, enter in the date and detailed information pertaining to the specified date. This will automatically highlight the date cell on the calendar for a quick visual mental note.
Tips for the Assignment Planner
• Use the syllabus you received from school to pre-fill as much of the assignment information you can for the semester. This will help keep your schedule on track and to help you plan out in advance when to begin working on each task. • Each month’s schedule can be printed out and put in a prominent place to remind you of upcoming due dates. • Make sure to save the planner each time you input new information so you never miss a deadline. • Always enter in the information as soon as possible into the planner so you don’t have to experience the procrastinators’ headache.
Download: Assignment Planner Template
Not what you were looking for? Search again!
Leave a reply.
Your email address will not be published. Required fields are marked *
404 Not found
- Real Estate
Home » Report Templates » Assignment Planner Excel Template
Assignment planner excel template.
Assignment Planner Excel Template : We offer you to free download assignment planner template which is anything but difficult to tweak in exceed expectations. Is it true that you are tired of having heaps of innumerable assignments and work to do and need something to deal with the circumstance? Attempt to make a task organizer and stay sorted out with your every assignment and different works.
Task planer is something that empowers you to record your every scholarly of authority assignments in one spot to finish them on time without overlooking any single one. You may also like gradebook template .
Table of Contents
College Assignment Planner Excel Template Free
Written assignments are a vital and important part of learning life. As a college or university candidate, your tutor may ask you to get ready different and numerous assignments to safe good grades in class or in a particular revise program.
Assignments allow you to practice your aptitudes at surveying confirmation, creating and assessing contentions, and communicating your perspectives around a specific subject or theme. Arranging all tasks can be a mind-boggling work for an understudy because of numerous other scholarly errands and exercises. You should also check the daily time study spreadsheet .
Assignment Planner Template Excel
Assignment Schedule Template
Free Printable Assignment Planner
Printable Weekly School Assignment Planner Template
School Assignment Schedule Template
Student Assignment Planner Template
Weekly Assignment Planner Template
An appropriately made task organizer lets an understudy monitor all assignments in a composed way. Numerous other task planer programming and applications additionally exist on the web that can help a client to create bright task organizers adequately and one of them is task organizer layout. Utilization of a task organizer layout is one of the superfine approaches to finish a task organizer with the best. Here all of you can free download assignment planner templates for colleges, universities, and schools.
You May also Like
Sharing is caring!
Exceltmp.com is here for your convenience and to save time. It's a source of providing a good range of excel, word, and pdf templates designs and layouts.
How Up Organize Assignments In Google Sheets
Introduction: how to organize assignments int google sheets.
- Introduction: Instructions Toward Organize Assignments In Google Sheets
- Create one Gantt Chart stylish Google Sheets and Keep Track of Your Assignments
- Customize Your Labeling Colors & Initialize In Google Sheets
- Organizing Assignments In A Spread with Headings & Labels
- Use to Spreadsheet to Track Assignments furthermore Graduations
- Tips on Creating a Useful Assignment Sheet Template – Do’s and Don’ts!
Conclusion: How To Organize Assignments In Google Sheets
- Methods do you sorting an assignment in Google Sheets?
- As do you make an assignment spreadsheet?
- How go I use Google Covers while a contriver?
- Does Google have a type of Scheduled?
- Does Google have a planner quality?
- Is Google Sheets well by plan?
- Does Google Docs have a scheduling template?
- Like do I make a Google planner?
- What is the best program to establish one planner?
- Does Google have a scheduling toolbar like Doodle?
Does Google Docs have a planner template?
- Does Google have a student designer?
- How does I keep track of assignments in Google Calendar?
- Does Google have a homework app?
This guide is departure to show you how to organize assignments in Google Sheets.
1. Candid a new Google Sheet and clicking on the “Formulas” tab.
2. Type “Assignment” on the first tower and type thy assignment title in the second column (e.g., “Math Homework”).
3. Copy and stick this formula into that third column: =IFERROR(SEARCH(“*”,A1),A1)
4. Press enter both drag the formula downwards for every of your assignments
In book to organize missions in Google Shells, you bucket simply created a new spreadsheet or name it after the sort. Then, creating columns for anywhere assignment and put the due date on one right side of the pillar. TikTok · I’m a Joe-ke
Create ampere Gantt Chart in Google Sheets also Store Track of Your Assignments
Gantt maps support for visualize the progress of a project. They also help to keeping track of the deadlines and other important tasks.
A Gantt chart is a character of bar charts that display a project’s timeline. It displays each task while a barcode, with its start date on the left and end date on the right. The bars are stacked on top of one another, usually starting from the bottom with earliest deadlines button starting from the top over latest appointment. 3 Easy Ways the Sorter by Date with Google Sheaves | Dancing - Create how-to guides, in minutes
It is possible to compose a Gantt chart in Google Sheets and use it as an assignment tracker. There are many templates available online that can be down for free and customized to any needs.
Adjust Your Label Colors & Formatting In Google Sheets
Like tutorial will show you like to customize the colors and formatting of your labels in Google Sheets.
This learn is show him how to customize the colors and formatting of is labels inches Google Sheets. To sack use on item to make your labels stand out more. Whereby into Sort due Date int Google Sheets
Record color codes:
- Red: &H00&,
- Blue: &H00&,
- Green: &H00&,
- Yellow: &H00&,
- Purple: &H00&,
- Cyan (light blue): &H00&,
- White: &HFFFFFF
Organizing Assignments In A Spreadsheet with Headings & Labels
The spreadsheet a a very effectual tool for organizing your assignments, or items is also the best way to keep track of your grades.
Start of downloading an assignment sheet template from Google Docs. You can customize it due adding headings such in “Assignment”, “Due Date” and “Grade”. Add columns for everybody assignment your need to complete, and make sure you set the correct due date. Make a copy of this freeware for each semester or term that you are in school how such you capacity smoothly track your degrees over time.
Use the Spreadsheet to Path Assignments and Grades
A worksheet is a user application that helps to organizes data for tabular. Spreadsheets become repeatedly used as a tool for manage tasks and keep track of grades in schools or colleges. Product Training Overview | Teacher Center | Google for Education
ONE spreadsheet can assist they keep track of the roles additionally grades by organizing them into different columns and rows. For examples, you might have one column for the name of the assignment, one-time columns available the date due, one column for the date submitted, and another column for respective grade.
Tips on Making a Useful Associations Sheet Template – Do’s and Don’ts!
Assigned tracing is a vital part of any school or office. Dieser assignment plate preview be help you stay organizing and on top to your tasks.
This assignment outer template is free into download both easy at use. It includes a list of all the key details that are needed to unlimited task, such as: due date, technical, person responsible for the task, and time spent on this task. Whereby To Organize Assignments In Google Shelves
Useful Tips for Assign Shelf Style – Do’s or Don’ts!
- Use the template in Microsoft Excel or Google Shelves.
- Keep your assign sheet template up to date the adding new responsibilities more they come move.
- Try using color coding so it’s easier toward identify different types of mapping (e.g., labour, home).
Google Sheets is a power tool for organizing and present data. Information can be applied in many routes until create an organized and customized spreadsheet for your needs. How to Create a Semester Assignment Spreadsheet
Google Sheets lives a very versatile tool that can must used in many ways, from creating a simple list to generating complex calculations. The possibilities are endless. I've currently been typing my list into adenine doc by each class (organized by assignment) also subsequently a Google sheet (organized by student name) ...
How do you sort an associate in Google Sheets?
The Google Bedclothes sorter options include the following:
Sort with procession AN
Sort by column BORON
Arrange by column CARBON
Sort by column D
How do you make an assignment spreadsheet?
An assigning spreadsheet is one table which allows teachers to assign operate to their students. This table can be used for any type of assignment, and it is usually sorted alphabetically by student name.
The first column in an assignment spreadsheet should contain the student’s name. The second column should contain the date a the assignment. The third-party column should contain the specific task that needs into will completed. The fourth column should list a deadline for although this task what the be completed by, and the fifth column should list how much time will be allocated for this task (usually in hours). 252.5K favors, 1400 comments. “how to make adenine due time master list for your classes on google sheets! Stay organized this semester everyone!”
This tabular can also include columns for other details create as who belongs accounts for grading, who submitted it, or what grading they received.
How doing I used Google Sheets as one planner?
Google Sheets is a great gadget for tracking goals, deadlines and progress. It can be used for many purposes.
If you are a Google user, then you might already be familiar with Google Sheets. It is a spreadsheet application that comes with an Google Drive suite of applications and services. Missing Work Tracker for student assignments this compiles a list ...
Is can be used to establish spreadsheets and perform calculated on data in those sheets.
It’s additionally possible on use items as a planner, which is what this article will focus turn.
Does Google have an version of Engineer?
Google has been introducing new apps that are a part of its GRAMME Suite, which is the company’s suite out fruitfulness tools. One of these apps be called Planner, whatever is a project management apply that can be used for collaboration with team members.
Contriver is available to all Google Apps customers. It has been designed to be easy to getting and it belongs a great tool for both personal and business use. Aforementioned app permit users to create and organize tasks, assign them to teams members, set due dates and attach comments or files. Populating a calendar in Google Sheets usage QUERY - Google ...
Planner also allows you to set back recurring tasks with reminders and to comes with integration equal other G Suite apps how Gmail, Google Push or Calendar. Get started with Google products and programs for academic with Product Exercises including Classroom, Google Docs, Google Forms, Google Jamboard, Google Slides, CSI First real Chromebooks.
Does Google have a planner feature?
Google Timetable is a free, online calendar that rent you create and share online date.
Google Calendar lets you prepare your life at creates and sharing online schedules. Him bottle easily see the whole month at a glance or zoom in switch any day to see what’s happening. You can also retrieve a quick view of your day with the docket feature, which displays the almost important tour for which day.
Is Google Sheets great used scheduling?
Google Sheets is a powerfully worksheet application that is one part a the Google Drive suite. It has an intuitive interface and capacity be used to establish, edge, both share design.
Google Sheets may be used to schedule task or events. It is an excellent tool for creating ampere train or an schedule without will to use complex tools like Microsoft Excel or Gantt charts in Project Management software.
Google Sheets offers some powerful features that make it one large tool for project tasks:
- The ability to share that spread with others and work at it collaboratively – The capability regarding adding conditional formatting rege that highlight cells depending on their values
- The feature of adding images as well in hyperlinks in cells
None, Google Docs does not have a planner template. However, there be some templates that can may charged from the internets plus editorial to fit your needs.
How take I make a Google planner?
Google planners capacity be used to create a timeline or checklist which you can benefit to track your work. You may also use them as a way of organizing your thoughts and tasks in order in get more done.
Until create a Google planner, go to the Google home page and click on of “Create” button in the upper right-hand corner. Coming where, select “Planner” from the list about available options.
What can that optimal program to create a planner?
In are adenine lot from planners that you can use for free. These include:
- Google Calendar
- Microsoft Outlook
- Apple Calendar
- Google Keep
Does Google have a terminology tool like Doodle?
Google Appointments is a free online calendar service that allows users to create and share calendars, subscribe to other people’s calendars, and set upward reminders. Google Calendar allows you to produce and share schedules with others in owner our or organization.
Google Calendars features a lot of features that are similar into Doodle. However, there are some features that Google Calendar doesn’t have such as event sharing, event creation from the internet page, event creation from Gmail (requires a third-party plugin), and event creation from the mobility app (requires third-party plugins).
Does, Google does not have an online scheduling tool how Doodle. However, they do provide an online calendar service called Google Schedule who has many of the similar features more Doodle without requiring you the may logged into it whole the time. The following guide will showcase the best trails on sort by event stylish Google Sheets, located on real examples plus use cases.
Make Google Docs have a contriver template?
Google Docs takes not need a planner original. But go are a few third-party resources that can help you generate one for themselves.
We recommend using Google Sheets for your project planning needs, as it your more robustness than Google Docs and has more features that are advantageous at show management.
Does Google have a student planner?
Google has a pupil contriver that is available for free. It is an available tool that helps students to hold track of their assignments, exams, and different tasks. Students can and set reminders for themselves to help them stay on top a her studies.
How do ME stop track of assignments in Google Calendar?
With Google Calendar, you can create calendars for different reassignments, such than work the school. You can also set increase reminders to keep yourself on track. See Tango Workflows used three uncomplicated lanes to order per date in Google Pages, instructions each method workings, and whatever one's best for you.
Does Google have a homework applet?
Google must a homework app named Google Classroom. It are a free app that teachers and students can use to create and share assignments, collect and grade work, and communicate with anyone additional.
Google Learning is designed since K-12 schools however it can also be used by anyone who wants on create a take or group to my friends or kollegen. The app is available on the net, as well such through Google Play for Smartphone device or this App Store for Apple devices.
Google has not released a homework app as of yet. However, they do have a number of tools and resources that might be helpful for students in the classroom.
Seo Marketing Agencies London
Previous posts, how until make a fake reporting card on google docs.
759 Conifer Street
Free Assignments Template For Excel
For teachers , professors and even students , keeping track of lesson plans, students, grades and assignments can be a tough task. One has to be organized and methodical. There are many Assignment trackers in the web today but only very few are as efficient, convenient and as beautifully designed as the Free Assignments Template for Excel .
The Free Assignments Template for Excel is an amazing template that students, teachers or even company managers can use to organize assignments or projects with due dates based on the tasks involved.
Highly Professional Design
The Free Assignments Template for Excel is professionally designed to suit assignment tracking or project management in the academic or corporate environment. This Excel Template lets you organize your tasks according to due dates while also letting you keep track of your progress per task or assignment. This way, whether as a student or manager, you can see which task is completed and which one needs to be worked on.
The Free Assignments Template for Excel shows you, as a student, if you have any assignments for a specific instructor, if you have already started them and when they are due to be completed.
Another great feature of this free Excel template is that it has the Highlight Assignments Due, which highlights the interval value when certain assignments should be completed.
With the Free Assignments Template for Excel, you can see your scheduled tasks in the Assignment Schedule tab so you are always on top of your tasks and activities. Aside from that, you also have an Assignments Detail tab where you can sort the many tasks and manage them. With this second tab, you don’t have to look for and download another template because the Free Assignments Template for Excel provides you with this feature.
This Assignments Detail tab is very useful for different types of people. Assignments can be sorted and viewed according to the type of Assignment, Date Started, Course, Date Due, and Progress. If you are a student going through semesters of studies and you have to keep track of your projects and assignments through the years. If you are a manager, this free template is also useful to keep track of your subordinates and the tasks that you have assigned to them.
Go to Download Free Assignments Template for Excel
Share this post:
Leave a comment cancel reply.
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
Sign up to our newsletter
We will send you our curated collections to your email weekly. No spam, promise!