TIPS AND STORIES Skip to main content

Posts

TEMPLATE TIPS AND TRICKS

TEMPLATE TIPS AND TRICKS For example, the values for the bold property of a text element Sorts Use native sorts whenever possible. When you are copying a query from a schema that has the same name in both templates, but contains different attributes, a second schema is created in the template you are pasting the content into. You can click Customize and deselect the PUB Reference Search or JavaScript Search tabs to remove them from the Search window. Locating a query or attribute in the Data Source View from the template content editor You can locate a query or attribute in the Data Source View from the element it is applied to by right-clicking an element and selecting Search > Go to schema. You can either continue by using this default setting and click the Select element to return to your cursor, or you can change the preference for this setting to disable it. You cannot copy from one template and paste the elements into a template opened in another instance of the Document Studi...
Post a Comment
Read more

EXCEL HOW TO USE

                      HOW TO USE EXCEL   If you want to sum up a column of numbers, you can use the formula =SUM(Cell1:Cell2). 9. That headache can be made even worse when you need to compare data across multiple spreadsheets. Remove duplicate data points or sets. Larger data sets tend to have duplicate content. You may be thinking that I don't have too much data, but for longer data sets, this will come in handy. To create the Pivot Table, I go to Data > Pivot Table. The syntax is: COUNT IF (range, criteria). Excel will automatically populate your Pivot Table, but you can always change around the order of the data. Your resulting list will have only unique names without any duplicates. 5. If you're working with large data sets that would require thousands of lookups, using the INDEX and MATCH function will significantly decrease load time in Excel. The INDEX and MATCH formulas work right-to-left, whereas VLOOKUP formulas on...
Post a Comment
Read more

MS WORD TIPS

                                         MS WORD If you keep holding the key, you can double-click other words or lines to select them, even if they're not connected. And in the future, you'll see the template appear under the "Personal" heading when you make a new document. Just click your custom template, and you'll be given a Word document formatted in the exact way you saved it. . It'll be a huge help to writers who are easily led off-track. To enter Focus mode, click "View" at the top of the screen, and then "Focus." 18 Microsoft Word tips and tricks You can change the background color if you find the black too stark. Navigate to "Review," then select "Resume Assistant" to get started. Emma Witman/Business Insider Add filler placeholder text anywhere Let's say that you want to check how a font looks, or how to format certain pages, but don't have any writing to test with. You ca...
Post a Comment
Read more