Click here to download the NBA 2011-2012 Spreadsheet Schedule.xls
You can find all or our other sports schedules and other spreadsheet templates to download here.
Update: get the 2012-2013 NBA schedule here!
Are you wondering why your Excel file size is so huge? Is there a way to make large file sizes into smaller, more manageable sizes? As a matter of fact, there is! One method is to examine each separate object in your spreadsheet files so that you can see how it contributes to the objects' overall size. Here's how to do it:
This works best when you are dealing with multiple sheets. If you only have one sheet, the most likely cause is file formatting. My advice is to recreate the sheet with no formatting, then add the formatting to entire sections such as columns or large ranges.
Why does the file size get so huge? It could be due to a corrupt spreadsheet, which I will tell you how to fix in an upcoming post!
If your eyesight isn't what it used to be, you may want to increase the size of the sheet tabs displayed in your Excel workbooks.
This parameter is determined by a Windows system-wide setting. To change it, select Start, Settings, Control Panel and double-click Display. In the Display Properties dialog box, click the Appearance tab, and choose Scrollbar from the Item list. Adjust the sheet tabs until they're the size you want. Be aware that this setting affects the scroll bars in ALL OF YOUR APPLICATIONS.
YesNo = MsgBox("This macro will ... Do you want to continue?", vbYesNo + vbCritical, "Caution")
Select Case YesNo
'Insert your code here if Yes is clicked
'Insert your code here if No is clicked
I'm currently learning how to write apps for Android phones. However, I need a goal to work towards. I was wondering if any readers had any ideas or suggestions for an Excel Spreadsheets Help phone app (or any other related apps). I'm trying to think of something somewhat simple to start off with but could be added onto later or inspire new ideas. I think the ideal model is the have a basic version which is free to download but more advanced users could then download a "pro" version for a small fee.
Maybe I could do an app for my Apartment Search Spreadsheet where you could enter the info into your phone while you are touring an apartment complex and that info could then be used to easily complete the spreadsheet later. What do you think? Any suggestions?
Also, how many Android user vs. iPhone users are out that which use this site?
=AVERAGE(B5:J5)As you can see in the screenshot below, once you have added and deleted columns, this no longer works as a solution:
=AVERAGE(INDIRECT("B" & ROW() & ":J" & ROW()))
Today's post is all about pivot tables. I am going to answer the following questions: How do you use and create a pivot table in Microsoft Excel? What are the advantages of using a pivot table? What is a pivot table? How do you make a pivot chart? Let's begin with the definition of a pivot table.
What is a pivot table?
Pivot tables provide an interactive summary of data. You can quickly rearrange and sort the information in the pivot table. There's no need for any complicated formulas. A pivot table classifies numeric data in a list based on other fields in the list. Before creating your pivot table, you should organize your data in a nice and neat table. Do this by creating headers in the first row. Try not to have any blank cells, rows, or columns in your table.
What are the advantages of using a pivot table?
Pivot tables can easily be rearranged by moving, adding, or deleting unneeded fields. Pivot tables are also dynamic, which means that the results of the table are automatically recalculated and updated whenever something changes, like when fields are added or removed, or if categories are hidden or displayed. Pivot tables are also simple to update. It's also very easy to generate charts from your pivot table.
How do you create a pivot table in Excel?
First, under the "Data" menu, select "Pivot Table and Pivot Chart Report." This will bring up the Pivot Table Wizard, which consists of the following three steps.
Step 1: If your data resides in a worksheet, simply click "Next."
Step 2: Excel will automatically select the data we are currently working with. Click "Next" again.
Step 3: I usually open the pivot table in a new worksheet (again, this is the default). Note that you can save a few seconds simply by clicking "Finish" during step 1 if you don't plan to do anything unusual (which, in my experience, is almost every time).
How do you create a pivot chart?
To create a chart from your pivot table right click on a cell in the Pivot Table and select "Pivot Chart." A chart is automatically generated. Note that you can view the data by using the drop down menu at the top of the chart, and you can modify the chart by either of the other variables by using the filter menus on the bottom and side.
If you don't like the type of chart Excel chooses, you can modify it by right clicking anywhere on the chart and selecting "Chart Type."
Note that if you modify the pivot table in any way, the chart is automatically updated.
Now you know all about pivot tables and pivot charts! More examples and pivot table templates are coming soon. Stay tuned!