If you are working with large tables of data in Excel, you can make your spreadsheet easier to read by formatting alternate rows to be shaded a different colour. There are a number of ways you can achieve this. This lesson shows you a quick and easy way to do it on Excel 2011 for Mac.
Welcome to Fiveminutelessons.com. Get free online courses where you can learn more about Google Analytics, Microsoft Excel, and Microsoft Word, and be more productive in just five minutes.
Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.
The SUM function in Excel allows you to add up the values in a range of cells. However, sometimes you only want to add up the cells that meet certain criteria. That's where the SUMIF function comes in handy, along with the more capable SUMIFS function.
This lesson shows you how to group data in your pivot table by date. You can group by day, week, month, quarter or year. If your date fields include a time value, you can also group by seconds, minutes or hours. You'll also learn how to collapse and expand data groups in your pivot table so you can quickly see a summary of your data.
If you have a spreadsheet with time values that have been added to the spreadsheet as text values, you need the TIMEVALUE function. This will allow you to convert the text values into valid time values. A common scenario where this might be useful is when you've been provided data to import into Excel, and the times in the imported data are not recognised by Excel as valid times.
Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you an even faster way to do it.
If you are using Google Adwords to drive traffic to your site, you absolutely should link your Google Adwords account with your Google Analytics account. If you don't, you are missing out on a lot of important analytics data, as well the opportunity to truly measure the ROI on your Google Adwords campaigns.
When printing in Excel, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page in Microsoft Excel 2011 for Mac. You will also learn how to print header columns on the left of every page in your printout.
This Pivot Table lesson shows you how to use the Pivot Table Field Layout to quickly change the layout of your pivot table. This allows you to try different pivot table layouts so you can be sure your data is being grouped, aggegated and displayed in the most useful way possible. It also allow you to generate multiple reports from the same underlying data without having to create multiple pivot tables.
When you're working in a web team, it can be useful for everyone in the team to have access to Google Analytics for the website(s) you're working on. This lesson shows you how to configure Google Analytics so that multiple users can access one or more profiles in your account, and shows you a quick way to allow a user to access multiple profiles in the same Google Analytics account.
The SUMPRODUCT function allows you to multiply two arrays of numbers together (e.g. Quantity Sold and Price Per Unit) and add the results each individual calculation together. Without the SUMPRODUCT function, you'll find yourself having to create a third column in which you multiply the Quantity by Price for each row, and then find the sum of all the individual formulas. This lesson shows you how to use SUMPRODUCT to do all that with just one formula.