Microsoft Office
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…
Publisher 2013 – How to Create a New Publication
The most basic functionality associated with Publisher 2013 involves opening the program and creating a new Publication. Windows 7 provides multiple ways to open Publisher 2013, such as Desktop Shortcuts and the Start Button’s Search Box. When Publisher 2013 opens, the user is presented with a Publisher Start Screen that allows for the creation of…
The Publisher 2013 Interface: Navigating the Ribbon
The interface to Microsoft Publisher 2013 features many sections and commands. The upper portion of the interface contains the Quick Access Toolbar and Ribbon functionality, the latter of which contains numerous commands organized into Groups which are themselves organized into Tabs. Common Tabs in the Ribbon include the Home, Insert, Page Design, Mailings, Review and…
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…
PowerPoint 2013: New Look, Better Function
Microsoft’s powerhouse presentation software PowerPoint has a bold new look and beautiful new interface. But sometimes with changes, comes a learning curve. Fortunately, with Microsoft PowerPoint 2013 none of the sweeping changes will leave you scratching your head. The basic structure of the PowerPoint 2013 Workspace has been altered to a different, but extremely user…
Microsoft Word 2013 Training – How to Open and Edit PDFs
One of the newest and most important features of Microsoft Word 2013 is the ability to Open and Edit PDF files. Available through the Backstage View’s Open command, Word can open PDF files by converting them into editable Word documents. Word provides a Protected View for working with PDF documents, which provides security protection against…
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…
3 Rules for Professional Slides in PowerPoint 2013
When creating a professional presentation in Microsoft PowerPoint 2013 there are three rules that should guide you. First Rule: Not too much on one slide. When you crowd your slide with unnecessary words your audience will spend the entire time trying to read instead of listening to you. Keep it to a few words that…
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…
How to do a Mail Merge in Microsoft Word 2013 – Part 2
Microsoft Word allows users to execute the Mail Merge function through a Mail Merge Wizard. Picking up from the previous video, the final two steps in the wizard process are Previewing and Completing the Merge. The wizard contains numerous templates for step 2 of the wizard process, which are available both locally and online via…
