Monthly Archives: May 2017

Archive of posts published in the specified Month

Excel 2016: Track Changes and Comments


Introduction Let’s say someone asked you to proofread or collaborate on a workbook. If you had a printed copy, you might use a red pen to edit cell data, mark spelling errors, or add comments in the margins. Excel allows you to do…

Read more

Excel 2016: Conditional Formatting


Introduction Let’s say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines, conditional formatting provides another way to visualize data and…

Read more

Excel 2016: Charts


Introduction It can be difficult to interpret Excel workbooks that contain a lot of data. Charts allow you to illustrate your workbook data graphically, which makes it easy to visualize comparisons and trends. Optional: Download our practice workbook. Watch the video below to…

Read more

Excel 2016: Tables


Introduction Once you’ve entered information into your worksheet, you may want to format your data as a table. Just like regular formatting, tables can improve the look and feel of your workbook, and they’ll also help you organize your content and make your…

Read more

Excel 2016: Groups and Subtotals


Introduction Worksheets with a lot of content can sometimes feel overwhelming and even become difficult to read. Fortunately, Excel can organize data into groups, allowing you to easily show and hide different sections of your worksheet. You can also summarize different groups using…

Read more

Excel 2016: Filtering Data


Introduction If your worksheet contains a lot of content, it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need. Optional: Download our practice workbook.…

Read more

Excel 2016: Sorting Data


Introduction As you add more content to a worksheet, organizing this information becomes especially important. You can quickly reorganize a worksheet by sorting your data. For example, you could organize a list of contact information by last name. Content can be sorted alphabetically,…

Read more

Excel 2016: Freezing Panes and View Options


Introduction Whenever you’re working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, including the…

Read more

Excel 2016: Basic Tips for Working with Data


Introduction Excel workbooks are designed to store a lot of information. Whether you’re working with 20 cells or 20,000, Excel has several features to help you organize your data and find what you need. You can see some of the most useful features…

Read more

Excel 2016: Functions


Introduction A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.…

Read more