Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel - Instructions: A picture of an Excel worksheet with an outline applied.
Outline Excel Data in Microsoft Excel: Overview             You can outline Excel data to add an organizational quality to a long or wide worksheet. When you outline Excel data, you group worksheet data into different levels based on column and row headings. Lower level data is associated with the headings in the rows or columns.
Read more
No Comments

Format a PivotTable in Excel – Instructions and Video

Format a PivotTable in Excel: A picture showing the “Design” tab of the “PivotTable Tools” contextual tab in the Ribbon of Excel.
Format a PivotTable in Excel: Overview             You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
Read more
No Comments

Make Columns in Publisher – Instructions

Make Columns in Publisher - Instructions: A picture of the “Grid Guides” tab in the “Layout Guides” dialog box in Publisher.
Make Columns in Publisher: Overview             You can make columns in Publisher to aid in the layout of a publication page. You can then add text boxes over the column guides you create in the page to produce newsletter-style layouts. When you make columns in Publisher, you can also add rows to a publication page.
Read more
No Comments

Layout Guides in Publisher – Instructions

Layout Guides in Publisher - Instructions: A picture of the “Grid Guides” tab in the “Layout Guides” dialog box in Publisher.
Layout Guides in Publisher: Overview Layout Guides in Publisher: Types of Layout Guides             You use layout guides in Publisher to help with the layout of page content. There are many different types of layout guides in Publisher. For example, margin guides appear onscreen to help you stay within the printable page area. Margin guides
Read more
No Comments

Use a Top 10 AutoFilter in Excel – Instructions

Use a Top 10 AutoFilter in Excel - Instructions: A picture of the “Top 10 AutoFilter” dialog box in Excel.
Use a Top 10 AutoFilter in Excel: Overview             You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
Read more
No Comments

Sort a Table in Excel – Instructions and Video Lesson

Sort a Table in Excel - Instructions: A picture of the “Sort” dialog box within Excel for Office 365.
Sort a Table in Excel: Overview             You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Read more
No Comments

Create Columns in Word – Instructions and Video Lesson

Create Columns in Word - Instructions and Video Lesson: A picture of a user adding columns to a Word document by using the “Columns” dialog box.
Create Columns in Word: Overview             You may need to create columns in Word for documents that need them, like a newsletter. This is helpful for separating text vertically. When you create columns in Word, the text flows from one column to the next on the same page. Also note that you can add columns
Read more
No Comments

Add a Citation Placeholder in Word – Instructions

Add a Citation Placeholder in Word - Instructions: A picture of a citation placeholder in Word.
Add a Citation Placeholder in Word: Overview             You can add a citation placeholder in Word if you need to add a citation, but don’t have one yet. In this case, you can insert a “Citation Placeholder” to mark the location in the document for a future citation. You can then return to edit the
Read more
No Comments