How to Write and Use Formulas in Microsoft Excel 2013

How to Write and Use Formulas in Microsoft Excel 2013: Video This video shows how to write and use formulas in Microsoft Excel 2013. Formulas in Microsoft Excel 2013: Overview You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax”
Read more
No Comments

Microsoft Access 2013: The Flat File Method of Data Storage

The Flat File Method of Data Storage: Video This video discusses the flat-file method of data storage popular in programs like Excel. This helps to contrast it with relation data storage models, like the ones used by Access. The Flat File Method of Data Storage: Overview Access is a relational database application. So what does
Read more
No Comments

Using Touch Mode in Microsoft Office 2013

Because of the increased use of tablets, the products within Microsoft Office 2013 have been redesigned with a new mode to allow for easier access to the buttons and other commands within the Ribbon and Quick Access toolbar. This mode is called touch mode. When you enter touch mode within any product interface in the
Read more
No Comments

How to Create an Index in Microsoft Word 2013

1.Mark the text to include in your index. To include a word or phrase, start by selecting the word or phrase to include from the text in your document. 2.Click the “Mark Entry” button in the “Index” button group on the “References” tab in the Ribbon to open the “Mark Index Entry” dialog box. If
Read more
No Comments

How to Add Shapes In Microsoft Publisher 2013

                1. To insert shapes into your page click the “Shapes” button in either the “Objects” button group on the “Home” tab or the “Illustrations” button group on the “Insert” tab within the Ribbon. 2. Roll your mouse pointer over the shape you want to insert and then click
Read more
No Comments

Pasting Links between Cells in Excel 2013

You can paste links between cells within Excel, so that the value of a cell within a workbook will simply be the value of another selected cell. For example, if you had a cell that added the cells above it within one worksheet and you wanted to paste a link to that cell into a
Read more
No Comments

How to Insert Bullets in Excel 2013- Microsoft Office Training

Unlike Microsoft Word, Excel does not contain a button to insert bullets into a cell. However, there are a few ways you can add bullets in Excel.   1. Click into the cell where you want to add a bullet. 2. Press Alt+7 on your numeric keyboard to enter a generic bullet. 3. To quickly
Read more
No Comments

Basic Tasks in Microsoft Publisher 2013

Creating a New Publication When you first open Publisher 2013, you will see a startup screen that allows you to create a new publication. Click the type of publication that you want to create within the listing of available templates that appears at the right side of the startup screen. If you already have opened
Read more
No Comments