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.
Use concatenation to combine text and numbers in Excel formulas
If you want to combine text with the results of a formula in a cell, you can use concatenation. Suppose you have calculated the total of a range of cells using a formula in cell D2. Now, you want to have cell A2 display the text “Today’s sales are $12,000”, where $12,000 is the value calculated in D2. As the value in D2 changes, you want the value in A2 to update automatically.
Using the SUBTOTAL() function with the Autofilter feature
If you’re using the Autofilter feature, you’re probably wondering how to perform calculations on only those values that are being displayed by the filter. The SUBTOTAL() function is the answer.
Absolute and relative references in Excel
When you create a formula in Excel that refers to other cells in the worksheet, Excel will store the information about those cells as relative references. Relative references and their counterpart, absolute references, are one of the things that make spreadsheets such a powerful tool.
Copying formatting from one cell to another using Format Painter
If you have formatted a cell and want to use the same formatting for another cell or cells, you can easily copy the formatting from that cell to as many additional cells as you like.
Create a PDF from Word, Excel, PowerPoint or any Microsoft Office document
If you need a free option to create a PDF of a Microsoft Office document, your options will depend on which version of Microsoft Office you are using.
Adding up numbers in Microsoft Word
If you’re using Word to present a table of data that includes numbers, you can use Word’s built in formulas to add up those numbers rather than manually calculate them each time they change. This can also eliminate the possibility of error – particularly important if you’re producing a sales proposal or an important report.
Set banding colors in Word 2010 table styles
Word 2010 offers Table Styles to allow you to apply a style to a table in your document.
One of the challenges that can stump you the first time around is setting the color styles for odd/even banding of tables or columns. This lesson describes how to set these on an existing or custom table style.
What is the Bounce Rate in Google Analytics?
Bounce Rate refers to the number of visitors who come to your site and then leave again without visiting any other pages on your website.
Reducing the Bounce Rate on your website
A high bounce rate on a website indicates that your visitors are not engaging once they arrive on your website. That means your website isn’t as effective as it could be. Find out here how to reduce your bounce rate.
Configuring Ecommerce tracking in Google Analytics
If you have an ecommerce website, you can enable ecommerce tracking in Google Analytics. This gives you detailed (but aggregate) information about sales you make through your online store. Once you have that, you can then track back and examine the analytics data for visits with sales vs visits without sales.
There are two steps to enabling ecommerce tracking in Google Analytics.
Additional Info
Join our mailing list
