Using Financial Functions in Microsoft Excel 2013

Microsoft Excel 2013 contains Functions that are useful in personal financial contexts pertaining to savings and loans, such as the PMT Function. This PMT Function calculates the periodic payments required to amortize a loan with a particular interest rate and a set number of payment periods. There are five Arguments associated with the PMT Function, namely Rate, Nper, Pv, Fv, and Type. Rate corresponds to the interest rate per pay period for a loan, Nper to the total number of payments, and

read more

How to Create Hyperlinks in Microsoft Word 2013

Microsoft Word 2013 includes Hyperlink functionality, which can be used in several ways. Cross-reference links can be created by selecting Cross-reference in the Links drop-down menu. These links allow users to connect objects within the document and move from one to the other by clicking on the link. Hyperlinks are created by selecting Hyperlink in the aforementioned Links drop-down menu. This link, when clicked, prompts the user’s web browser to navigate to the designated web

read more

Automate Incoming Email in Outlook 2013

Processing email in Microsoft Outlook 2013 involves a series of Email Actions available to the user. Deleting emails is available through the Delete Icon and the Home Tab’s Delete Button. Users can Forward emails either by double-clicking an email or right-clicking and selecting the Forward command. Emails can be filed away and Stored in both interior and external files, the latter option involving the Backstage View’s Save As option. Outlook also allows emails to be Printed, Flagged as

read more

How to Setup Calendar Options in Outlook 2013

Outlook 2013 provides various options for customizing the Calendar, and these options are found in the Backstage View’s Options section. The first set of options deal with Work Time, defining work days and the Calendar’s format. The Calendar Options section includes a Reminder option and Propose New Time option for event attendees. Another option is Add Holidays, allowing the user to import public holidays to the Calendar automatically. Display Options involve the appearance and layout of the

read more

How to Use Timed Slides for Your PowerPoint 2013 Presentation

There are many things to think of when presenting for an audience. You often need to be so aware of your diction and content that you forget useful things like timing. When using Microsoft PowerPoint 2013 you can make things easier on yourself when you present by using times slides. Timed slides are most effective for speakers on a strict schedule. If you absolutely cannot afford to go over time then you must use timed slides. They can serve as a reminder that you need to wind up your speech,

read more

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 As, Print, Share, Export, and Accounts. Additionally, the Backstage View contains an Info Area which allows users to set business

read more

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 the Fields Panel’s Drop Zone. Excel 2013 includes a Group Field option that enables the grouping of dates into weekly or monthly groups. Arranging and

read more

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 X and Y axes.  Various syntactical rules exist which allow data to be correctly imported into a Pivot Chart. The Quick Analysis tool is a new feature in

read more

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 position of a Legend. Formatting of the Legend is enabled through numerous functions and options, including the Format Legend option and

read more

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 is available for customizing the Chart Area in Excel. An Axis Titles button is available in the Labels Group, allowing users to create Horizontal

read more

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 attractive interfaces for data analysis. Numerous edits and customizations can be made to Slices, such as choosing style and color,

read more

"30-Day Money Back

Notify us within 30 days of subscribing and you will receive a full refund with no questions asked

Subscribe for 1 Year and Get VIP Access

Subscribe to our free newsletter for free videos and other tips: