Monthly Archives: May 2017

Archive of posts published in the specified Month

Excel 2016: Track Changes and Comments

track_comment_select

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

conditional_formatting_understanding

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

chart_type

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

tables_format_style

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

subtotals_create_select

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

filtering_date_dropdown_menu

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

sorting_range_select_options

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

freeze-rows-dropdown-menu

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

filtering_how_to_dropdown_menu_select

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

functions_basic_cell

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