To add a query in a 2016 Excel spreadsheet, click the Data tab, then click the drop down for New Query command. This will open a display box that allows you to choose the workbook you want to run the
New in 2016 – Queries are coming to Excel! Read Post »
Microsoft PowerPoint allows you to make one color in a .jpg file transparent. This is useful when you want to remove solid color backgrounds from logos or other graphics. To set transparent color: From the Picture Tools Section, click the
Making One Color Transparent in a JPEG in Microsoft PowerPoint Read Post »
In some large Excel workbooks a dependent cell may refer to a precedent cell on another worksheet or many rows or columns away. The Excel Watch Window lets you see the dependent cell adjust as you make changes to the
Excel Watch Window Read Post »
You can quickly advance to any slide during a PowerPoint slide show by simply typing in the number of the slide you want to display, and pressing enter. PowerPoint will skip any slides between the current slide and the target
Advancing Slides in a PowerPoint Slide Show Read Post »
Use Excel patterns as another way to color code your cells in Microsoft Excel. Select the cells you want to edit. Click on the drop down arrow in the bottom right corner of the font group under the Home Tab.
Fill Patterns in Excel Read Post »
PowerPoint automatically applies Hyperlink color formatting to email addresses, URLs and hyperlinks in PowerPoint. To change this color:1. Select the Design Tab. 2. In the Themes Group, click on the drop down next to the Colors button.3. Scroll to the
Changing the Color of the Hyperlink Formatting In PowerPoint Read Post »
One of the most common questions we get about Excel is how to print spreadsheets. Spreadsheet content tends to be irregularly shaped and doesn’t fit on an 8.5 x 11 sheet well. Excel has a few tools for controlling how
Excel Printing Guide Read Post »
PowerPoint gives you the option of saving either an individual slide or your entire presentation in a JPEG file format. To save a slide as a .jpg: Click on the File Tab. Select Save As. Click the Drop Down arrow
PowerPoint: Saving Slide or Entire Presentation as a JPEG File Read Post »
PowerPoint 2007 and 2010 have powerful SmartArt and drawing tools for creating interesting graphics. The program also has a feature for saving these graphics as image files that can be imported into a variety of other programs or document types.
PowerPoint: Saving SmartArt Graphics as Image Files Feature Read Post »
Microsoft opened their Office suite to 3rd party development in 2013. In the same way that the functionality of a smart phone can be extended with an app, Microsoft Office apps can be downloaded to add new features. Microsoft itself
Excel People Chart Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
