Microsoft Excel
-
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…
-
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…
-
How to Use Microsoft Excel 2013 Functions – Part 1
One particularly useful element of Microsoft Excel 2013 Advanced is the Function, with this version containing numerous new Functions as well as improved existing Functions from prior Excel versions. The Results of Functions in Excel can vary depending upon the computer platform running Excel. A Help facility is included in Excel and is useful for…
-
Using Percentile Statistical Functions in Excel 2013
Statistical Functions in Excel 2013 can address various statistical problems pertaining to Averages and Measures of Spread. Excel 2013 retains some legacy Functions from prior versions but in many instances provides newer Statistical Functions which supersede the previous versions. Examples of this include Percentile, Percent Rank, Quartile and Rank Functions. Excel features pertaining to Measure…
