Microsoft Office
How to Use Backstage View in Microsoft Publisher 2013
The Backstage View is an important component of Publisher’s interface, available through the Ribbon’s File Tab and enabling file Management. It replaces the traditional Office button and also displays pertinent file data. The Backstage View features a menu on the left, populated by various Header options including: New, Open, Computer, Add a Place, Save, Save…
How to Create Pivot Tables in Microsoft Excel 2013 – Part 2
Excel 2013 contains numerous options and new features for the Pivot Table functionality. Pivot Tables can be created through the Create Pivot Table Dialogue, and the existing tables from which a Pivot Table emerges are created, likewise, through the Create Table Dialogue. Users build up Pivot Tables by selecting data fields and dropping them into…
How to Create Pivot Tables in Microsoft Excel 2013 – Part 1
Pivot Tables are one of Microsoft Excel’s greatest strengths and most useful tools, allowing for the management of transaction data. Pivot Tables allow different data properties like Date, Value and Location to be graphed onto an X-Y axis in various ways, allowing access to a multitude of Pivot Charts plotting different row properties along the…
Using the Layout Tab for Excel 2010 Charts and Graphs – Part 2
In Excel 2010 Legends are a useful functionality related to charts and graph data, and thus Excel includes various commands for positioning and formatting them. Methods for positioning Legends in Excel include the Overlay Legend command and the Legend button’s dropdown menu; these options provide the user with manual and automatic methods for determining the…
Using the Layout Tab for Excel 2010 Charts and Graphs – Part 1
Microsoft Excel 2010 features a contextual Layout Tab which is useful because of its various tools and commands for creating and editing Chart Areas, Plot Areas and Chart Titles. Formatting of Chart Titles involve commands like the Chart Title button, More Title Options button, and the Chart Title dialogue. Similarly, a Format Chart Area dialogue…
How to Use Excel 2010 Pivot Tables and Charts – Part 4
Slices are a new, particular type of Filter within Microsoft Excel 2010, and are useful when working with Pivot functionality. Slices function like Filters, are created through the Insert Slicers dialog, and correspond to particular data fields. Slices are a preferred type of Filter for presentation and meeting situations, due to their ability to establish…
How to Use Excel 2010 Pivot Tables and Charts – Part 3
Filters are a particularly useful tool in Excel 2010, especially when used with Pivot Tables and Charts. One method of Filtering data is through the use of Groups, elements applied to various rows and columns and which can be created through the Group Selection command. Additionally, Groupings also appear within the Field Lists area and…
How to Use Excel 2010 Pivot Tables and Charts – Part 2
Microsoft Excel 2010 contains numerous commands and options which are useful for customizing and analyzing Pivot Charts and Pivot Tables. The contextual Design, Layout, Format and Analyze tabs allow users to select chart types and styles as well as add data labels, while the Field List allows users to categorize fields and filtered sub-groups according…
How to Use Excel 2010 Pivot Tables and Charts – Part 1
Working with Pivot Tables and Pivot Charts in Excel 2010 involves numerous functionalities and commands. Prior to creating Pivot Charts users should create a Data Table in Excel containing the relevant information, and ensure that this data conforms to basic guidelines. Excel includes an Insert Pivot Table button and Pivot Chart dialog for creating and…
Working with Long Documents in Word 2013
Microsoft 2013 provides several tools for working with Long Documents, such as Styles, a Navigation Pane, Multi-level Lists, Tables of Contents, and Outline View. Styles are useful because they allow for the creation of various Headings and Sub-Headings that contain certain portions of the text. The Navigation Pane allows for easy movement between Headings and…
How to View and Navigate Pages in Publisher 2013
What is the important aspect of working with pages in Publisher? That is the ability to alter the interface View and Navigate between pages. Publisher 2013 contains multiple commands in the View Tab and elsewhere for Viewing and Navigation. The Zooming functionality, allows users to change the View. That is available through the Zoom Slider, Show Whole Page…
How to Use Microsoft Excel 2013 Functions – Part 2
Excel contains numerous specialized tools and features for managing Functions, such as the Functions Library group, the Insert Function Dialogue, a Search option, an AutoComplete facility, the Tool Tip feature, Help Links, and the Function Arguments Dialogue. The Functions Library group organizes Functions according to functionality and includes links to the Insert Function Dialogue, which…
