Microsoft Excel
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…
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…
How to use Statistical Functions in Excel 2013
Excel 2013 includes numerous Statistical Functions which are useful to statisticians and can be grouped into three general groups: Description, Prediction and Inference. Many Statistical Functions in Excel supersede Functions from previous versions. Ranges in Excel can be defined through the Define Name command and are useful in Statistical Functions like Min and Max. Two…
How to Insert Comments in Excel 2013
Comments are notes that you can attach to a cell that may serve as reminders, explanation on something, or feedback to other users. The note is separate from the cell content so it does not get in the way of your data. When you are working on a complex worksheet, or perhaps even just a…
