Category - Microsoft Office

Assigning a Password to an Excel File Passwords are used to protect a file. You can assign one password to open a file, and a different password to modify a file. If you assign both types of passwords to a file, only those users who know the open password can open the file, and only …

Did you know that you can use Excel IF statements along with VLOOKUPs? For example, if you wanted to enter a value from a table into a cell, based on what was in another cell, you could start with an IF statement and then enter the VLOOKUP in the “value if true” part of the …

Automatic Time Grouping, a new feature in Excel 2016, helps use time-related fields in a PivotTable by auto-detecting and grouping them on your behalf. The automatic grouping creates new Date/Time functionality and automatically populates the PivotTable in one action when you add a field to the ROWS or COLUMNS drop box in the PivotTable Task Pane. …

Here’s a nice tip on Excel FlashFill…when you need to combine fields or create a new format (e.g., telephone numbers with hyphens), Flash Fill can do the work for you. Type the first entry into the cell (e.g., telephone number with hyphens). Press Enter to see the completed entry. Begin to type the second entry. The Flash …

PivotTables and PivotCharts are fantastic Excel features that allow you to analyze data. Sometimes you need an easy way to manipulate only specific data and view it. This Trainer Tip will show you how to filter data in PivotTables and PivotCharts using Slicers. Though you can filter data in a PivotTable using filters and by using the drop zones …

Access gives you the easy to use query design grid interface for combining data from tables that share one or more related fields. It’s simple to use and generally effective. However, there are still some times when the query design grid isn’t enough to get the job done. Consider the situation where you have two …

You can use AutoCreate to quickly create new items from existing ones. With AutoCreate, you can drag and drop Outlook items from the view area to another folder on the Navigation Pane or Folder List. Say you’ve received an email from a colleague with details on an upcoming dinner meeting. It’s not set up as …

Thousands, Millions, etc. — Learn about number formats in Excel! If you use a number format like 0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the number format, like this: 0,. Two commas drop …

In Microsoft Word 2007 and 2010, you can save an individual document in Word 2003 version by clicking the Office button in 2007 or the File Menu in 2010, then Save As, and changing the Save As Type to Word 97 – 2003 as shown below.  If you’ve used Word 2007/2010 features that aren’t available …

This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table. In an Access database, there may be times when you’d like to make sure that there are no duplicate records in a table.  The Find Duplicates Query Wizardwill quickly find the duplicate records …

Sharing the Wonder of Excel PivotTables! The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and aggregate numeric data, summarize data by categories and subcategories, and create custom calculations and …

In all of the Microsoft Office products, Drawing Objects allow for the addition of graphics in the form of simple, basic shapes such as lines, arrows, rectangles, ellipses and even text boxes. These shapes can overlap on each other, much like a felt board allows various pieces of felt to lay on top of each …

Searching for a specific record in Microsoft Access You can search for a specific record in a table or form by using the Find tab in the Find and Replace dialog box. This is an effective choice for locating a specific record when the record that you want to locate satisfies specific criteria, such as …

Using the Report Wizard to Group and Summarize Data The Report Wizard provides options for grouping and summarizing report data. You can organize your report by selecting the fields into which you want to group data. If you create more than one group, you can prioritize the groups into levels.In addition to grouping data by …

Looking for another great time saver? Make the data entry job just a little bit easier! You can set a default value for a field — that value will automatically appear in the field for all new records. You can still modify the default field value as needed when entering a new record. For example, …

Use AutoFill to fill in data…With the AutoFill feature, you can have Excel automatically continue a series of numbers, number and text combinations, dates, or formulas, based on a pattern that you establish. Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value …

Excel Conditional Formatting helps you explore and analyze data visually, detect critical issues and identify patterns and trends. A conditional format changes the appearance of a cell range based on a condition or criteria. You can use Highlight Cells Rules, Top or Bottom Rules, Data Bars, Color Scales or Icon Sets to visualize data easily, …

You have control!! Access Form and Report Controls Did you ever notice that when you print an Access Report, some of the text is missing from variable-length fields (e.g., a text or memo field)? If there is too much text to display in the text box, the text is truncated (cut off). Instead of resizing …

Learn some new tricks in Microsoft Excel! To summarize your Excel data without using formulas: Sort the data by what you would like to subtotal Go to the Data tab On the right of the ribbon, click Subtotal in the Outline group. Choose the field you’d like to subtotal by (the Sorted Column) Select the …

Add in a Date Picker in Access! Open your Form in Design View. Press F4 to open the Property Sheet. Select the desired date field from the Selection Type dropdown list at the top of the Property Sheet. Select the Format tab on the Property Sheet. In the Show Date Picker field, select For dates. …

Text Alignment in Access… Here are a few keyboard formatting tips when viewing a form or report in Design View or Layout view: To align the text in a selected control to the left, press CTRL+L. To align the text in the selected control to the right, press CTRL+R. To center the text in the …