Microsoft Excel
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…
How to use Date and Time Functions in Microsoft Excel 2013
The date and time functions in Excel enable for precise tracking of order creation dates as well as due dates for various business applications. When looking at invoice due dates, business owners can use Excel to automatically track and manage order due dates. This eliminates potential error when submitting invoices to clients. Excel tracks the…
Combine numbers and words in Excel 2013 using the VLOOKUP Function
For those who have used Excel to create invoices, the balance of text and numerical data inside of a workbook can be tricky. On the one hand, you want data to appear on an invoice along with the term that defines it. On the other hand, it is useful to be able to quickly assign…
The Ribbon Is Large and in Charge in Excel 2013
The Excel menu has been slowly transitioning over the years from the grid with drop-down menus towards the “ribbon.” In the latest version of Excel, the ribbon transition is complete, and users are now left with this smoother, seamless menu option. The ribbon is that rectangular bit at the top of Excel, with command options…
A Roomier Look in Microsoft Excel 2013
The all new layout of Microsoft Excel 2013 is less crowded than before, with much more open space than previous versions contained. The reason is both functional as well as having a secondary, aesthetic appeal that users are finding to their liking. This extra space facilitates easier access on mobile devices as well as makes…
How to use Flash Fill with Microsoft Excel 2013
If you have a large amount of data which needs to be entered, the new Flash Fill feature in Excel 2013 will help you. Learn how. Let’s demonstrate using Flash Fill with some examples. 1. You have a long list containing huge amounts of data. For example, let’s says it’s the names of your customers…
