This lesson shows you a way to calculate the number of times a single character occurs in a cell in Excel, and provides a real-life example where I needed to split a column of cells containing part numbers into individual components for each part number.

Creating a Table of Contents, or TOC, for a document in Microsoft Word 2011 for Mac is not difficult, but it can be tricky to make it look just like you want it. This lesson takes you through the process of creating a dynamic table of contents that can be easily updated to reflect the content in your document.

Sometimes you need to count the number of cells in a spreadsheet that contain a value or set of values. The COUNTIF function allows you to do this by counting only those cells in the range that meet the criteria you set. This lesson explains how to use COUNTIF, and provides an example of how you can use it.

Content Marketing is one of the best long-term strategies for sustainably increasing your website traffic.  As Google gets better at separating good quality content from bad , and penalising sites that don't follow its quality guidelines (Google Panda and Penguin), it has become ever more important to ensure that the content on your website is of good quality. This lesson will show you how to use Google Analytics to analyse which pages people are landing on, which keywords they used in the search that brought them to your website, and how to generate actionable insights that can help you improve your content and increase your traffic.

 When you create a large table in Microsoft Word that spans multiple pages, you'll find on the second and subsequent pages that the table headings don't repeat. In this lesson you'll learn how to configure one or more rows of your table to repeat at the top of the page for every page on which your table appears. This lesson applies to tables in Microsoft Word 2010 for Windows and Word 2011 for Mac (as well as Word 2007 for Windows).